[04/19/2024 10:00:00], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/19_04_2024/request_availability_Astra_Test_1225_1713520799_55.json', 'e1p/19_04_2024/response_availability_Astra_Test_1225_1713520799_55.json', 'e1p/19_04_2024/response_header_availability_Astra_Test_1225_1713520799_55.json', 'expediapackage', '2024-04-19 10:00:00', '', '15d6c23de87cee6f5ec4e054a78509f42e455a26d6e7f131a2953a63efe80ea3', '1225');
[04/19/2024 10:00:00], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=15d6c23de87cee6f5ec4e054a78509f42e455a26d6e7f131a2953a63efe80ea3&xml_user_id=7860&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-04-19 09:59:59.870'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.225'
        , error_description = ''
        , memory_used = '2857632'
        WHERE id = '118360';
[04/19/2024 10:00:00], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/19_04_2024/request_availability_Astra_Test_1225_1713520799_70.json', 'e1/19_04_2024/response_availability_Astra_Test_1225_1713520799_70.json', 'e1/19_04_2024/response_header_availability_Astra_Test_1225_1713520799_70.json', 'expedia', '2024-04-19 10:00:00', '', '15d6c23de87cee6f5ec4e054a78509f42e455a26d6e7f131a2953a63efe80ea3', '1225');
[04/19/2024 10:00:00], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=15d6c23de87cee6f5ec4e054a78509f42e455a26d6e7f131a2953a63efe80ea3&xml_user_id=7860&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-04-19 09:59:59.870'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.420'
        , error_description = ''
        , memory_used = '2857064'
        WHERE id = '118361';
[04/19/2024 10:00:00], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/19_04_2024/request_availability_Astra_Test_1225_1713520799_10.json', 'e1/19_04_2024/response_availability_Astra_Test_1225_1713520799_10.json', 'e1/19_04_2024/response_header_availability_Astra_Test_1225_1713520799_10.json', 'expedia', '2024-04-19 10:00:00', '', '15d6c23de87cee6f5ec4e054a78509f42e455a26d6e7f131a2953a63efe80ea3', '1225');
[04/19/2024 10:00:00], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/19_04_2024/request_availability_Astra_Test_1225_1713520799_57.json', 'e1p/19_04_2024/response_availability_Astra_Test_1225_1713520799_57.json', 'e1p/19_04_2024/response_header_availability_Astra_Test_1225_1713520799_57.json', 'expediapackage', '2024-04-19 10:00:00', '', '15d6c23de87cee6f5ec4e054a78509f42e455a26d6e7f131a2953a63efe80ea3', '1225');
[04/19/2024 10:00:01], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/19_04_2024/request_availability_Astra_Test_1225_1713520799_82.json', 'e1p/19_04_2024/response_availability_Astra_Test_1225_1713520799_82.json', 'e1p/19_04_2024/response_header_availability_Astra_Test_1225_1713520799_82.json', 'expediapackage', '2024-04-19 10:00:01', '', '15d6c23de87cee6f5ec4e054a78509f42e455a26d6e7f131a2953a63efe80ea3', '1225');
[04/19/2024 10:00:01], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/19_04_2024/request_availability_Astra_Test_1225_1713520799_64.json', 'e1/19_04_2024/response_availability_Astra_Test_1225_1713520799_64.json', 'e1/19_04_2024/response_header_availability_Astra_Test_1225_1713520799_64.json', 'expedia', '2024-04-19 10:00:01', '', '15d6c23de87cee6f5ec4e054a78509f42e455a26d6e7f131a2953a63efe80ea3', '1225');
[04/19/2024 10:00:01], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=15d6c23de87cee6f5ec4e054a78509f42e455a26d6e7f131a2953a63efe80ea3&xml_user_id=7860&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-04-19 09:59:59.870'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '1.643'
        , error_description = ''
        , memory_used = '94759736'
        WHERE id = '118362';
[04/19/2024 10:00:01], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=15d6c23de87cee6f5ec4e054a78509f42e455a26d6e7f131a2953a63efe80ea3&xml_user_id=7860&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-04-19 09:59:59.870'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '2.038'
        , error_description = ''
        , memory_used = '104148712'
        WHERE id = '118363';
[04/19/2024 10:00:02], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=15d6c23de87cee6f5ec4e054a78509f42e455a26d6e7f131a2953a63efe80ea3&xml_user_id=7860&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-04-19 09:59:59.870'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '2.243'
        , error_description = ''
        , memory_used = '127156872'
        WHERE id = '118364';
[04/19/2024 10:00:02], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=15d6c23de87cee6f5ec4e054a78509f42e455a26d6e7f131a2953a63efe80ea3&xml_user_id=7860&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-04-19 09:59:59.870'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '2.400'
        , error_description = ''
        , memory_used = '116374848'
        WHERE id = '118365';
[04/19/2024 10:00:02], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7860&sessionid=15d6c23de87cee6f5ec4e054a78509f42e455a26d6e7f131a2953a63efe80ea3',
        duration = '3.157',
        merge_duration = '0.572',
        assigned_supplier_count = '2',
        searched_supplier_count = '2',
        system_load_1_min = '9.54',
        system_load_5_min = '6.81',
        system_load_15_min = '6.40',
        system_memory_usage = '77.09',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1225') + '25022792',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1225';
[04/19/2024 10:00:03], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:00:03' WHERE id= '798';
[04/19/2024 10:00:04], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:00:04' WHERE id= '798';
[04/19/2024 10:02:20], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:02:20' WHERE id= '732';
[04/19/2024 10:05:27], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:05:27' WHERE id= '732';
[04/19/2024 10:08:07], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:08:07' WHERE id= '798';
[04/19/2024 10:08:20], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:08:20' WHERE id= '798';
[04/19/2024 10:08:22], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:08:22' WHERE id= '798';
[04/19/2024 10:08:31], [file name :-/home/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[04/19/2024 10:08:31], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7860',supplier_id = '67' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/19/2024 10:08:31], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7860',supplier_id = '52' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/19/2024 10:08:31], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7860',supplier_id = '76' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/19/2024 10:08:31], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7860',supplier_id = '24' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/19/2024 10:08:31], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7860',supplier_id = '77' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/19/2024 10:08:31], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7860',supplier_id = '64' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/19/2024 10:08:31], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7860',supplier_id = '65' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/19/2024 10:08:31], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7860',supplier_id = '34' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/19/2024 10:08:31], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7860',supplier_id = '20' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/19/2024 10:08:31], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7860',supplier_id = '55' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/19/2024 10:08:31], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7860',supplier_id = '62' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/19/2024 10:08:31], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7860',supplier_id = '53' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/19/2024 10:08:31], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7860',supplier_id = '16' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/19/2024 10:08:31], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7860',supplier_id = '78' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/19/2024 10:08:31], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7860',supplier_id = '75' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/19/2024 10:08:31], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7860',supplier_id = '60' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/19/2024 10:08:31], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7860',supplier_id = '18' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/19/2024 10:08:31], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7860',supplier_id = '19' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/19/2024 10:08:31], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7860',supplier_id = '73' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/19/2024 10:08:31], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7860',supplier_id = '71' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/19/2024 10:08:31], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7860',supplier_id = '69' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/19/2024 10:08:31], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7860',supplier_id = '68' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/19/2024 10:08:31], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7860',supplier_id = '74' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/19/2024 10:08:31], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7860',supplier_id = '35' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/19/2024 10:08:31], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7860',supplier_id = '70' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/19/2024 10:08:31], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7860',supplier_id = '59' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/19/2024 10:08:31], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7860',supplier_id = '32' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/19/2024 10:08:31], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7860',supplier_id = '58' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/19/2024 10:08:31], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7860',supplier_id = '56' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/19/2024 10:08:31], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7860',supplier_id = '57' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/19/2024 10:08:31], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7860',supplier_id = '61' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/19/2024 10:08:31], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7860',supplier_id = '63' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/19/2024 10:08:31], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7860',supplier_id = '54' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/19/2024 10:08:31], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7860',supplier_id = '66' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/19/2024 10:08:31], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7860',supplier_id = '45' ,status = '' ,priority = '' ,lead_time = '',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/19/2024 10:08:31], [file name :-/home/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'v3alpha',`create_date`= '2024-04-19 10:08:31',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7860\&#039;,supplier_id = 67 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7860\&#039;,supplier_id = 52 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7860\&#039;,supplier_id = 76 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7860\&#039;,supplier_id = 24 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7860\&#039;,supplier_id = 77 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7860\&#039;,supplier_id = 64 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7860\&#039;,supplier_id = 65 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7860\&#039;,supplier_id = 34 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7860\&#039;,supplier_id = 20 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7860\&#039;,supplier_id = 55 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7860\&#039;,supplier_id = 62 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7860\&#039;,supplier_id = 53 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7860\&#039;,supplier_id = 16 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7860\&#039;,supplier_id = 78 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7860\&#039;,supplier_id = 75 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7860\&#039;,supplier_id = 60 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7860\&#039;,supplier_id = 18 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7860\&#039;,supplier_id = 19 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7860\&#039;,supplier_id = 73 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7860\&#039;,supplier_id = 71 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7860\&#039;,supplier_id = 69 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7860\&#039;,supplier_id = 68 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7860\&#039;,supplier_id = 74 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7860\&#039;,supplier_id = 35 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7860\&#039;,supplier_id = 70 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7860\&#039;,supplier_id = 59 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7860\&#039;,supplier_id = 32 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7860\&#039;,supplier_id = 58 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7860\&#039;,supplier_id = 56 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7860\&#039;,supplier_id = 57 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7860\&#039;,supplier_id = 61 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7860\&#039;,supplier_id = 63 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7860\&#039;,supplier_id = 54 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7860\&#039;,supplier_id = 66 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7860\&#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-7860 ## supplier_id- 64 ## company_name - Expedia ## supplier_code-expedia  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-7860 ## supplier_id- 65 ## company_name - Expedia Package ## supplier_code-expediapackage  ## percentage - 0.00 ## lead_time - 0 ',`ip`= '43.239.53.130';
[04/19/2024 10:08:35], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:08:35' WHERE id= '798';
[04/19/2024 10:08:35], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-04-19 10:08:35',login_attempt=0 where id = '7860';
[04/19/2024 10:08:35], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Astra_Test', user_type = 'A', branch_id = '28', login_datetime = '2024-04-19 10:08:35', ip = '43.239.53.130', action = 'Login' ;
[04/19/2024 10:08:35], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:08:35' WHERE id= '798';
[04/19/2024 10:08:44], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:08:44' WHERE id= '798';
[04/19/2024 10:08:53], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:08:53' WHERE id= '798';
[04/19/2024 10:08:53], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7860' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '28' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/04/26' , departure_date = '2024/04/27' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-04-19 10:08:53' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'INR' , currency_code = 'INR' , web_service = '' ;
[04/19/2024 10:08:54], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:08:54' WHERE id= '798';
[04/19/2024 10:08:54], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/19_04_2024/request_availability_Astra_Test_1226_1713521334_63.json', 'e1/19_04_2024/response_availability_Astra_Test_1226_1713521334_63.json', 'e1/19_04_2024/response_header_availability_Astra_Test_1226_1713521334_63.json', 'expedia', '2024-04-19 10:08:54', '', '15d6c23de87cee6f5ec4e054a78509f42e455a26d6e7f131a2953a63efe80ea3', '1226');
[04/19/2024 10:08:54], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=15d6c23de87cee6f5ec4e054a78509f42e455a26d6e7f131a2953a63efe80ea3&xml_user_id=7860&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-04-19 10:08:54.445'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.234'
        , error_description = ''
        , memory_used = '2858576'
        WHERE id = '118366';
[04/19/2024 10:08:54], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/19_04_2024/request_availability_Astra_Test_1226_1713521334_2.json', 'e1p/19_04_2024/response_availability_Astra_Test_1226_1713521334_2.json', 'e1p/19_04_2024/response_header_availability_Astra_Test_1226_1713521334_2.json', 'expediapackage', '2024-04-19 10:08:54', '', '15d6c23de87cee6f5ec4e054a78509f42e455a26d6e7f131a2953a63efe80ea3', '1226');
[04/19/2024 10:08:54], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=15d6c23de87cee6f5ec4e054a78509f42e455a26d6e7f131a2953a63efe80ea3&xml_user_id=7860&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-04-19 10:08:54.445'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.292'
        , error_description = ''
        , memory_used = '2857704'
        WHERE id = '118367';
[04/19/2024 10:08:55], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/19_04_2024/request_availability_Astra_Test_1226_1713521334_27.json', 'e1/19_04_2024/response_availability_Astra_Test_1226_1713521334_27.json', 'e1/19_04_2024/response_header_availability_Astra_Test_1226_1713521334_27.json', 'expedia', '2024-04-19 10:08:55', '', '15d6c23de87cee6f5ec4e054a78509f42e455a26d6e7f131a2953a63efe80ea3', '1226');
[04/19/2024 10:08:55], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/19_04_2024/request_availability_Astra_Test_1226_1713521334_11.json', 'e1/19_04_2024/response_availability_Astra_Test_1226_1713521334_11.json', 'e1/19_04_2024/response_header_availability_Astra_Test_1226_1713521334_11.json', 'expedia', '2024-04-19 10:08:55', '', '15d6c23de87cee6f5ec4e054a78509f42e455a26d6e7f131a2953a63efe80ea3', '1226');
[04/19/2024 10:08:55], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/19_04_2024/request_availability_Astra_Test_1226_1713521334_3.json', 'e1p/19_04_2024/response_availability_Astra_Test_1226_1713521334_3.json', 'e1p/19_04_2024/response_header_availability_Astra_Test_1226_1713521334_3.json', 'expediapackage', '2024-04-19 10:08:55', '', '15d6c23de87cee6f5ec4e054a78509f42e455a26d6e7f131a2953a63efe80ea3', '1226');
[04/19/2024 10:08:56], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/19_04_2024/request_availability_Astra_Test_1226_1713521334_2.json', 'e1p/19_04_2024/response_availability_Astra_Test_1226_1713521334_2.json', 'e1p/19_04_2024/response_header_availability_Astra_Test_1226_1713521334_2.json', 'expediapackage', '2024-04-19 10:08:56', '', '15d6c23de87cee6f5ec4e054a78509f42e455a26d6e7f131a2953a63efe80ea3', '1226');
[04/19/2024 10:08:57], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=15d6c23de87cee6f5ec4e054a78509f42e455a26d6e7f131a2953a63efe80ea3&xml_user_id=7860&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-04-19 10:08:54.445'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '3.472'
        , error_description = ''
        , memory_used = '253839120'
        WHERE id = '118369';
[04/19/2024 10:08:58], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=15d6c23de87cee6f5ec4e054a78509f42e455a26d6e7f131a2953a63efe80ea3&xml_user_id=7860&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-04-19 10:08:54.444'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '3.686'
        , error_description = ''
        , memory_used = '284085112'
        WHERE id = '118368';
[04/19/2024 10:08:58], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=15d6c23de87cee6f5ec4e054a78509f42e455a26d6e7f131a2953a63efe80ea3&xml_user_id=7860&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-04-19 10:08:54.445'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '4.094'
        , error_description = ''
        , memory_used = '269588664'
        WHERE id = '118370';
[04/19/2024 10:08:59], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=15d6c23de87cee6f5ec4e054a78509f42e455a26d6e7f131a2953a63efe80ea3&xml_user_id=7860&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-04-19 10:08:54.444'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '4.885'
        , error_description = ''
        , memory_used = '303345976'
        WHERE id = '118371';
[04/19/2024 10:08:59], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7860&sessionid=15d6c23de87cee6f5ec4e054a78509f42e455a26d6e7f131a2953a63efe80ea3',
        duration = '5.176',
        merge_duration = '0.158',
        assigned_supplier_count = '2',
        searched_supplier_count = '2',
        system_load_1_min = '2.19',
        system_load_5_min = '5.66',
        system_load_15_min = '6.12',
        system_memory_usage = '78.14',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1226') + '16875920',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1226';
[04/19/2024 10:08:59], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:08:59' WHERE id= '798';
[04/19/2024 10:08:59], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:08:59' WHERE id= '798';
[04/19/2024 10:09:00], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:09:00' WHERE id= '798';
[04/19/2024 10:09:02], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:09:02' WHERE id= '798';
[04/19/2024 10:12:49], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:12:49' WHERE id= '798';
[04/19/2024 10:12:51], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:12:51' WHERE id= '798';
[04/19/2024 10:18:39], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:18:39' WHERE id= '798';
[04/19/2024 10:18:41], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:18:41' WHERE id= '798';
[04/19/2024 10:20:35], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:20:35' WHERE id= '798';
[04/19/2024 10:20:36], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:20:36' WHERE id= '798';
[04/19/2024 10:22:07], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:22:07' WHERE id= '798';
[04/19/2024 10:22:09], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:22:09' WHERE id= '798';
[04/19/2024 10:23:53], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:23:53' WHERE id= '798';
[04/19/2024 10:23:56], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:23:56' WHERE id= '798';
[04/19/2024 10:24:39], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:24:39' WHERE id= '732';
[04/19/2024 10:25:54], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:25:54' WHERE id= '732';
[04/19/2024 10:26:24], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:26:24' WHERE id= '732';
[04/19/2024 10:27:24], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:27:24' WHERE id= '732';
[04/19/2024 10:27:44], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:27:44' WHERE id= '732';
[04/19/2024 10:28:14], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:28:14' WHERE id= '732';
[04/19/2024 10:29:01], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:29:01' WHERE id= '799';
[04/19/2024 10:29:01], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-04-19 10:29:01',login_attempt=0 where id = '7851';
[04/19/2024 10:29:01], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Viator_test', user_type = 'A', branch_id = '27', login_datetime = '2024-04-19 10:29:01', ip = '43.239.53.130', action = 'Login' ;
[04/19/2024 10:29:01], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:29:01' WHERE id= '799';
[04/19/2024 10:29:46], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:29:46' WHERE id= '732';
[04/19/2024 10:30:06], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:30:06' WHERE id= '732';
[04/19/2024 10:31:00], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:31:00' WHERE id= '732';
[04/19/2024 10:31:07], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:31:07' WHERE id= '732';
[04/19/2024 10:31:07], [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/04/25' , departure_date = '2024/04/26' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-04-19 10:31:07' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[04/19/2024 10:31:08], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:31:08' WHERE id= '732';
[04/19/2024 10:31:08], [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/19_04_2024/request_availability_Gajendra_1227_1713522668_39.json', 'e1/19_04_2024/response_availability_Gajendra_1227_1713522668_39.json', 'e1/19_04_2024/response_header_availability_Gajendra_1227_1713522668_39.json', 'expedia', '2024-04-19 10:31:08', '', 'e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f', '1227');
[04/19/2024 10:31:08], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f&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=MozillaFirefox%2F124.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-19 10:31:08.306'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.347'
        , error_description = ''
        , memory_used = '3654128'
        WHERE id = '118372';
[04/19/2024 10:31:08], [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/19_04_2024/request_availability_Gajendra_1227_1713522668_34.json', 'e1p/19_04_2024/response_availability_Gajendra_1227_1713522668_34.json', 'e1p/19_04_2024/response_header_availability_Gajendra_1227_1713522668_34.json', 'expediapackage', '2024-04-19 10:31:08', '', 'e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f', '1227');
[04/19/2024 10:31:08], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f&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=MozillaFirefox%2F124.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-19 10:31:08.301'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.468'
        , error_description = ''
        , memory_used = '3655632'
        WHERE id = '118373';
[04/19/2024 10:31:09], [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/19_04_2024/request_availability_Gajendra_1227_1713522668_68.json', 'e1/19_04_2024/response_availability_Gajendra_1227_1713522668_68.json', 'e1/19_04_2024/response_header_availability_Gajendra_1227_1713522668_68.json', 'expedia', '2024-04-19 10:31:09', '', 'e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f', '1227');
[04/19/2024 10:31:09], [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/19_04_2024/request_availability_Gajendra_1227_1713522668_89.json', 'e1/19_04_2024/response_availability_Gajendra_1227_1713522668_89.json', 'e1/19_04_2024/response_header_availability_Gajendra_1227_1713522668_89.json', 'expedia', '2024-04-19 10:31:09', '', 'e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f', '1227');
[04/19/2024 10:31:10], [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/19_04_2024/request_availability_Gajendra_1227_1713522668_18.json', 'e1p/19_04_2024/response_availability_Gajendra_1227_1713522668_18.json', 'e1p/19_04_2024/response_header_availability_Gajendra_1227_1713522668_18.json', 'expediapackage', '2024-04-19 10:31:10', '', 'e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f', '1227');
[04/19/2024 10:31:10], [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/19_04_2024/request_availability_Gajendra_1227_1713522668_23.json', 'e1p/19_04_2024/response_availability_Gajendra_1227_1713522668_23.json', 'e1p/19_04_2024/response_header_availability_Gajendra_1227_1713522668_23.json', 'expediapackage', '2024-04-19 10:31:10', '', 'e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f', '1227');
[04/19/2024 10:31:11], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f&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=MozillaFirefox%2F124.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-19 10:31:08.299'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '3.358'
        , error_description = ''
        , memory_used = '143022272'
        WHERE id = '118375';
[04/19/2024 10:31:11], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f&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=MozillaFirefox%2F124.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-19 10:31:08.302'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '3.665'
        , error_description = ''
        , memory_used = '158915760'
        WHERE id = '118374';
[04/19/2024 10:31:12], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f&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=MozillaFirefox%2F124.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-19 10:31:08.299'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '3.964'
        , error_description = ''
        , memory_used = '151899032'
        WHERE id = '118377';
[04/19/2024 10:31:12], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f&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=MozillaFirefox%2F124.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-19 10:31:08.309'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '4.042'
        , error_description = ''
        , memory_used = '170441416'
        WHERE id = '118376';
[04/19/2024 10:31:13], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7873&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f',
        duration = '5.226',
        merge_duration = '0.987',
        assigned_supplier_count = '2',
        searched_supplier_count = '2',
        system_load_1_min = '19.41',
        system_load_5_min = '16.76',
        system_load_15_min = '13.79',
        system_memory_usage = '82.10',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1227') + '31900848',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1227';
[04/19/2024 10:31:13], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:31:13' WHERE id= '732';
[04/19/2024 10:31:13], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:31:13' WHERE id= '732';
[04/19/2024 10:31:15], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:31:15' WHERE id= '732';
[04/19/2024 10:31:24], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:31:24' WHERE id= '732';
[04/19/2024 10:31:30], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:31:30' WHERE id= '732';
[04/19/2024 10:31:30], [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/04/25' , departure_date = '2024/04/26' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-04-19 10:31:30' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[04/19/2024 10:31:31], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:31:31' WHERE id= '732';
[04/19/2024 10:31:31], [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/19_04_2024/request_availability_Gajendra_1228_1713522691_31.json', 'e1/19_04_2024/response_availability_Gajendra_1228_1713522691_31.json', 'e1/19_04_2024/response_header_availability_Gajendra_1228_1713522691_31.json', 'expedia', '2024-04-19 10:31:31', '', 'e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f', '1228');
[04/19/2024 10:31:31], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f&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=MozillaFirefox%2F124.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-19 10:31:31.343'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.230'
        , error_description = ''
        , memory_used = '3654216'
        WHERE id = '118378';
[04/19/2024 10:31:31], [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/19_04_2024/request_availability_Gajendra_1228_1713522691_7.json', 'e1p/19_04_2024/response_availability_Gajendra_1228_1713522691_7.json', 'e1p/19_04_2024/response_header_availability_Gajendra_1228_1713522691_7.json', 'expediapackage', '2024-04-19 10:31:31', '', 'e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f', '1228');
[04/19/2024 10:31:31], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f&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=MozillaFirefox%2F124.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-19 10:31:31.343'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.300'
        , error_description = ''
        , memory_used = '3655376'
        WHERE id = '118379';
[04/19/2024 10:31:32], [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/19_04_2024/request_availability_Gajendra_1228_1713522691_43.json', 'e1/19_04_2024/response_availability_Gajendra_1228_1713522691_43.json', 'e1/19_04_2024/response_header_availability_Gajendra_1228_1713522691_43.json', 'expedia', '2024-04-19 10:31:32', '', 'e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f', '1228');
[04/19/2024 10:31:32], [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/19_04_2024/request_availability_Gajendra_1228_1713522691_27.json', 'e1p/19_04_2024/response_availability_Gajendra_1228_1713522691_27.json', 'e1p/19_04_2024/response_header_availability_Gajendra_1228_1713522691_27.json', 'expediapackage', '2024-04-19 10:31:32', '', 'e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f', '1228');
[04/19/2024 10:31:33], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/19_04_2024/request_availability_Gajendra_1228_1713522691_48.json', 'e1p/19_04_2024/response_availability_Gajendra_1228_1713522691_48.json', 'e1p/19_04_2024/response_header_availability_Gajendra_1228_1713522691_48.json', 'expediapackage', '2024-04-19 10:31:33', '', 'e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f', '1228');
[04/19/2024 10:31:33], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/19_04_2024/request_availability_Gajendra_1228_1713522691_10.json', 'e1/19_04_2024/response_availability_Gajendra_1228_1713522691_10.json', 'e1/19_04_2024/response_header_availability_Gajendra_1228_1713522691_10.json', 'expedia', '2024-04-19 10:31:33', '', 'e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f', '1228');
[04/19/2024 10:31:33], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f&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=MozillaFirefox%2F124.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-19 10:31:31.343'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '2.348'
        , error_description = ''
        , memory_used = '159179016'
        WHERE id = '118380';
[04/19/2024 10:31:34], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f&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=MozillaFirefox%2F124.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-19 10:31:31.343'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '3.010'
        , error_description = ''
        , memory_used = '151713576'
        WHERE id = '118382';
[04/19/2024 10:31:34], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f&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=MozillaFirefox%2F124.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-19 10:31:31.343'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '3.144'
        , error_description = ''
        , memory_used = '170490608'
        WHERE id = '118381';
[04/19/2024 10:31:34], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f&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=MozillaFirefox%2F124.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-19 10:31:31.343'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '3.379'
        , error_description = ''
        , memory_used = '142992376'
        WHERE id = '118383';
[04/19/2024 10:31:35], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7873&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f',
        duration = '4.350',
        merge_duration = '0.813',
        assigned_supplier_count = '2',
        searched_supplier_count = '2',
        system_load_1_min = '15.73',
        system_load_5_min = '16.17',
        system_load_15_min = '13.67',
        system_memory_usage = '77.77',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1228') + '29844152',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1228';
[04/19/2024 10:31:35], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:31:35' WHERE id= '732';
[04/19/2024 10:31:36], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:31:36' WHERE id= '732';
[04/19/2024 10:31:38], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:31:38' WHERE id= '732';
[04/19/2024 10:33:21], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:33:21' WHERE id= '732';
[04/19/2024 10:33:25], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:33:25' WHERE id= '732';
[04/19/2024 10:33:25], [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/04/25' , departure_date = '2024/04/26' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-04-19 10:33:25' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[04/19/2024 10:33:25], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:33:25' WHERE id= '732';
[04/19/2024 10:33:26], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/19_04_2024/request_availability_Gajendra_1229_1713522805_4.json', 'e1/19_04_2024/response_availability_Gajendra_1229_1713522805_4.json', 'e1/19_04_2024/response_header_availability_Gajendra_1229_1713522805_4.json', 'expedia', '2024-04-19 10:33:26', '', 'e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f', '1229');
[04/19/2024 10:33:26], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f&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=MozillaFirefox%2F124.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-19 10:33:25.789'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.220'
        , error_description = ''
        , memory_used = '3654360'
        WHERE id = '118384';
[04/19/2024 10:33:26], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/19_04_2024/request_availability_Gajendra_1229_1713522805_95.json', 'e1p/19_04_2024/response_availability_Gajendra_1229_1713522805_95.json', 'e1p/19_04_2024/response_header_availability_Gajendra_1229_1713522805_95.json', 'expediapackage', '2024-04-19 10:33:26', '', 'e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f', '1229');
[04/19/2024 10:33:26], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f&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=MozillaFirefox%2F124.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-19 10:33:25.788'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.257'
        , error_description = ''
        , memory_used = '3655632'
        WHERE id = '118385';
[04/19/2024 10:33:26], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/19_04_2024/request_availability_Gajendra_1229_1713522805_80.json', 'e1/19_04_2024/response_availability_Gajendra_1229_1713522805_80.json', 'e1/19_04_2024/response_header_availability_Gajendra_1229_1713522805_80.json', 'expedia', '2024-04-19 10:33:26', '', 'e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f', '1229');
[04/19/2024 10:33:27], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/19_04_2024/request_availability_Gajendra_1229_1713522805_36.json', 'e1p/19_04_2024/response_availability_Gajendra_1229_1713522805_36.json', 'e1p/19_04_2024/response_header_availability_Gajendra_1229_1713522805_36.json', 'expediapackage', '2024-04-19 10:33:27', '', 'e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f', '1229');
[04/19/2024 10:33:27], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/19_04_2024/request_availability_Gajendra_1229_1713522805_73.json', 'e1p/19_04_2024/response_availability_Gajendra_1229_1713522805_73.json', 'e1p/19_04_2024/response_header_availability_Gajendra_1229_1713522805_73.json', 'expediapackage', '2024-04-19 10:33:27', '', 'e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f', '1229');
[04/19/2024 10:33:27], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/19_04_2024/request_availability_Gajendra_1229_1713522805_42.json', 'e1/19_04_2024/response_availability_Gajendra_1229_1713522805_42.json', 'e1/19_04_2024/response_header_availability_Gajendra_1229_1713522805_42.json', 'expedia', '2024-04-19 10:33:27', '', 'e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f', '1229');
[04/19/2024 10:33:28], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f&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=MozillaFirefox%2F124.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-19 10:33:25.788'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '2.266'
        , error_description = ''
        , memory_used = '159025408'
        WHERE id = '118386';
[04/19/2024 10:33:28], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f&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=MozillaFirefox%2F124.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-19 10:33:25.788'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '2.742'
        , error_description = ''
        , memory_used = '151608008'
        WHERE id = '118388';
[04/19/2024 10:33:28], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f&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=MozillaFirefox%2F124.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-19 10:33:25.789'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '2.761'
        , error_description = ''
        , memory_used = '170643200'
        WHERE id = '118387';
[04/19/2024 10:33:28], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f&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=MozillaFirefox%2F124.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-19 10:33:25.789'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '2.923'
        , error_description = ''
        , memory_used = '142910248'
        WHERE id = '118389';
[04/19/2024 10:33:29], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7873&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f',
        duration = '3.837',
        merge_duration = '0.745',
        assigned_supplier_count = '2',
        searched_supplier_count = '2',
        system_load_1_min = '4.26',
        system_load_5_min = '11.74',
        system_load_15_min = '12.34',
        system_memory_usage = '78.24',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1229') + '29842248',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1229';
[04/19/2024 10:33:29], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:33:29' WHERE id= '732';
[04/19/2024 10:33:31], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:33:31' WHERE id= '732';
[04/19/2024 10:33:37], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:33:37' WHERE id= '732';
[04/19/2024 10:33:37], [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/04/25' , departure_date = '2024/04/26' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-04-19 10:33:37' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[04/19/2024 10:33:38], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:33:38' WHERE id= '732';
[04/19/2024 10:33:38], [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/19_04_2024/request_availability_Gajendra_1230_1713522818_76.json', 'e1/19_04_2024/response_availability_Gajendra_1230_1713522818_76.json', 'e1/19_04_2024/response_header_availability_Gajendra_1230_1713522818_76.json', 'expedia', '2024-04-19 10:33:38', '', 'e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f', '1230');
[04/19/2024 10:33:38], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f&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=MozillaFirefox%2F124.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-19 10:33:38.484'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.268'
        , error_description = ''
        , memory_used = '3655488'
        WHERE id = '118390';
[04/19/2024 10:33: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/19_04_2024/request_availability_Gajendra_1230_1713522818_42.json', 'e1p/19_04_2024/response_availability_Gajendra_1230_1713522818_42.json', 'e1p/19_04_2024/response_header_availability_Gajendra_1230_1713522818_42.json', 'expediapackage', '2024-04-19 10:33:39', '', 'e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f', '1230');
[04/19/2024 10:33:39], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f&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=MozillaFirefox%2F124.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-19 10:33:38.485'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.675'
        , error_description = ''
        , memory_used = '3655560'
        WHERE id = '118391';
[04/19/2024 10:33: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', 'e1/19_04_2024/request_availability_Gajendra_1230_1713522818_14.json', 'e1/19_04_2024/response_availability_Gajendra_1230_1713522818_14.json', 'e1/19_04_2024/response_header_availability_Gajendra_1230_1713522818_14.json', 'expedia', '2024-04-19 10:33:39', '', 'e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f', '1230');
[04/19/2024 10:33: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/19_04_2024/request_availability_Gajendra_1230_1713522818_79.json', 'e1p/19_04_2024/response_availability_Gajendra_1230_1713522818_79.json', 'e1p/19_04_2024/response_header_availability_Gajendra_1230_1713522818_79.json', 'expediapackage', '2024-04-19 10:33:39', '', 'e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f', '1230');
[04/19/2024 10:33: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', 'e1p/19_04_2024/request_availability_Gajendra_1230_1713522818_97.json', 'e1p/19_04_2024/response_availability_Gajendra_1230_1713522818_97.json', 'e1p/19_04_2024/response_header_availability_Gajendra_1230_1713522818_97.json', 'expediapackage', '2024-04-19 10:33:40', '', 'e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f', '1230');
[04/19/2024 10:33: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/19_04_2024/request_availability_Gajendra_1230_1713522818_85.json', 'e1/19_04_2024/response_availability_Gajendra_1230_1713522818_85.json', 'e1/19_04_2024/response_header_availability_Gajendra_1230_1713522818_85.json', 'expedia', '2024-04-19 10:33:40', '', 'e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f', '1230');
[04/19/2024 10:33:42], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f&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=MozillaFirefox%2F124.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-19 10:33:38.484'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '3.882'
        , error_description = ''
        , memory_used = '260056112'
        WHERE id = '118393';
[04/19/2024 10:33:42], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f&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=MozillaFirefox%2F124.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-19 10:33:38.484'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '3.908'
        , error_description = ''
        , memory_used = '272147792'
        WHERE id = '118392';
[04/19/2024 10:33:42], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f&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=MozillaFirefox%2F124.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-19 10:33:38.484'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '4.196'
        , error_description = ''
        , memory_used = '242950600'
        WHERE id = '118395';
[04/19/2024 10:33:43], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f&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=MozillaFirefox%2F124.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-19 10:33:38.484'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '4.668'
        , error_description = ''
        , memory_used = '294909520'
        WHERE id = '118394';
[04/19/2024 10:33:43], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7873&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f',
        duration = '4.928',
        merge_duration = '0.111',
        assigned_supplier_count = '2',
        searched_supplier_count = '2',
        system_load_1_min = '3.45',
        system_load_5_min = '11.20',
        system_load_15_min = '12.15',
        system_memory_usage = '77.96',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1230') + '17319360',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1230';
[04/19/2024 10:33:43], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:33:43' WHERE id= '732';
[04/19/2024 10:33:43], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:33:43' WHERE id= '732';
[04/19/2024 10:33:45], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:33:45' WHERE id= '732';
[04/19/2024 10:34:00], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:34:00' WHERE id= '732';
[04/19/2024 10:34:00], [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/04/25' , departure_date = '2024/04/26' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-04-19 10:34:00' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[04/19/2024 10:34:01], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:34:01' WHERE id= '732';
[04/19/2024 10:34:01], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/19_04_2024/request_availability_Gajendra_1231_1713522841_78.json', 'e1/19_04_2024/response_availability_Gajendra_1231_1713522841_78.json', 'e1/19_04_2024/response_header_availability_Gajendra_1231_1713522841_78.json', 'expedia', '2024-04-19 10:34:01', '', 'e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f', '1231');
[04/19/2024 10:34:01], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f&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=MozillaFirefox%2F124.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-19 10:34:01.312'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.217'
        , error_description = ''
        , memory_used = '3654520'
        WHERE id = '118396';
[04/19/2024 10:34:01], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/19_04_2024/request_availability_Gajendra_1231_1713522841_43.json', 'e1p/19_04_2024/response_availability_Gajendra_1231_1713522841_43.json', 'e1p/19_04_2024/response_header_availability_Gajendra_1231_1713522841_43.json', 'expediapackage', '2024-04-19 10:34:01', '', 'e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f', '1231');
[04/19/2024 10:34:01], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f&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=MozillaFirefox%2F124.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-19 10:34:01.312'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.222'
        , error_description = ''
        , memory_used = '3655560'
        WHERE id = '118397';
[04/19/2024 10:34:02], [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/19_04_2024/request_availability_Gajendra_1231_1713522841_34.json', 'e1/19_04_2024/response_availability_Gajendra_1231_1713522841_34.json', 'e1/19_04_2024/response_header_availability_Gajendra_1231_1713522841_34.json', 'expedia', '2024-04-19 10:34:02', '', 'e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f', '1231');
[04/19/2024 10:34:02], [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/19_04_2024/request_availability_Gajendra_1231_1713522841_38.json', 'e1/19_04_2024/response_availability_Gajendra_1231_1713522841_38.json', 'e1/19_04_2024/response_header_availability_Gajendra_1231_1713522841_38.json', 'expedia', '2024-04-19 10:34:02', '', 'e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f', '1231');
[04/19/2024 10:34:03], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/19_04_2024/request_availability_Gajendra_1231_1713522841_94.json', 'e1p/19_04_2024/response_availability_Gajendra_1231_1713522841_94.json', 'e1p/19_04_2024/response_header_availability_Gajendra_1231_1713522841_94.json', 'expediapackage', '2024-04-19 10:34:03', '', 'e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f', '1231');
[04/19/2024 10:34:04], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/19_04_2024/request_availability_Gajendra_1231_1713522841_92.json', 'e1p/19_04_2024/response_availability_Gajendra_1231_1713522841_92.json', 'e1p/19_04_2024/response_header_availability_Gajendra_1231_1713522841_92.json', 'expediapackage', '2024-04-19 10:34:04', '', 'e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f', '1231');
[04/19/2024 10:34:04], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f&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=MozillaFirefox%2F124.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-19 10:34:01.312'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '3.329'
        , error_description = ''
        , memory_used = '243011256'
        WHERE id = '118398';
[04/19/2024 10:34:04], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f&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=MozillaFirefox%2F124.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-19 10:34:01.312'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '3.606'
        , error_description = ''
        , memory_used = '272354000'
        WHERE id = '118399';
[04/19/2024 10:34:05], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f&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=MozillaFirefox%2F124.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-19 10:34:01.312'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '4.590'
        , error_description = ''
        , memory_used = '295140200'
        WHERE id = '118400';
[04/19/2024 10:34:06], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f&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=MozillaFirefox%2F124.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-19 10:34:01.312'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '5.147'
        , error_description = ''
        , memory_used = '252987688'
        WHERE id = '118401';
[04/19/2024 10:34:06], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7873&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f',
        duration = '5.420',
        merge_duration = '0.119',
        assigned_supplier_count = '2',
        searched_supplier_count = '2',
        system_load_1_min = '2.52',
        system_load_5_min = '10.37',
        system_load_15_min = '11.85',
        system_memory_usage = '78.11',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1231') + '17927304',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1231';
[04/19/2024 10:34:06], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:34:06' WHERE id= '732';
[04/19/2024 10:34:06], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:34:06' WHERE id= '732';
[04/19/2024 10:34:09], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:34:09' WHERE id= '732';
[04/19/2024 10:34:21], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:34:21' WHERE id= '732';
[04/19/2024 10:34:28], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:34:28' WHERE id= '732';
[04/19/2024 10:34:28], [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/04/25' , departure_date = '2024/04/26' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-04-19 10:34: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 = '' ;
[04/19/2024 10:34:30], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:34:30' WHERE id= '732';
[04/19/2024 10:34:31], [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/19_04_2024/request_availability_Gajendra_1232_1713522871_89.json', 'e1/19_04_2024/response_availability_Gajendra_1232_1713522871_89.json', 'e1/19_04_2024/response_header_availability_Gajendra_1232_1713522871_89.json', 'expedia', '2024-04-19 10:34:31', '', 'e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f', '1232');
[04/19/2024 10:34:31], [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/19_04_2024/request_availability_Gajendra_1232_1713522871_94.json', 'e1p/19_04_2024/response_availability_Gajendra_1232_1713522871_94.json', 'e1p/19_04_2024/response_header_availability_Gajendra_1232_1713522871_94.json', 'expediapackage', '2024-04-19 10:34:31', '', 'e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f', '1232');
[04/19/2024 10:34:31], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f&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=MozillaFirefox%2F124.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-19 10:34:31.24'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.535'
        , error_description = ''
        , memory_used = '3656952'
        WHERE id = '118403';
[04/19/2024 10:34:31], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f&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=MozillaFirefox%2F124.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-19 10:34:31.21'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.556'
        , error_description = ''
        , memory_used = '3655192'
        WHERE id = '118402';
[04/19/2024 10:34:32], [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/19_04_2024/request_availability_Gajendra_1232_1713522871_60.json', 'e1/19_04_2024/response_availability_Gajendra_1232_1713522871_60.json', 'e1/19_04_2024/response_header_availability_Gajendra_1232_1713522871_60.json', 'expedia', '2024-04-19 10:34:32', '', 'e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f', '1232');
[04/19/2024 10:34:32], [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/19_04_2024/request_availability_Gajendra_1232_1713522871_37.json', 'e1/19_04_2024/response_availability_Gajendra_1232_1713522871_37.json', 'e1/19_04_2024/response_header_availability_Gajendra_1232_1713522871_37.json', 'expedia', '2024-04-19 10:34:32', '', 'e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f', '1232');
[04/19/2024 10:34:33], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/19_04_2024/request_availability_Gajendra_1232_1713522871_80.json', 'e1p/19_04_2024/response_availability_Gajendra_1232_1713522871_80.json', 'e1p/19_04_2024/response_header_availability_Gajendra_1232_1713522871_80.json', 'expediapackage', '2024-04-19 10:34:33', '', 'e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f', '1232');
[04/19/2024 10:34:33], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/19_04_2024/request_availability_Gajendra_1232_1713522871_10.json', 'e1p/19_04_2024/response_availability_Gajendra_1232_1713522871_10.json', 'e1p/19_04_2024/response_header_availability_Gajendra_1232_1713522871_10.json', 'expediapackage', '2024-04-19 10:34:33', '', 'e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f', '1232');
[04/19/2024 10:34:36], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f&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=MozillaFirefox%2F124.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-19 10:34:31.43'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '5.756'
        , error_description = ''
        , memory_used = '142914656'
        WHERE id = '118405';
[04/19/2024 10:34:37], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f&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=MozillaFirefox%2F124.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-19 10:34:31.28'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '6.177'
        , error_description = ''
        , memory_used = '159271736'
        WHERE id = '118404';
[04/19/2024 10:34:37], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f&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=MozillaFirefox%2F124.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-19 10:34:31.33'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '6.752'
        , error_description = ''
        , memory_used = '151718496'
        WHERE id = '118406';
[04/19/2024 10:34:38], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f&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=MozillaFirefox%2F124.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-19 10:34:31.35'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '7.570'
        , error_description = ''
        , memory_used = '170544224'
        WHERE id = '118407';
[04/19/2024 10:34:39], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7873&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f',
        duration = '9.277',
        merge_duration = '0.972',
        assigned_supplier_count = '2',
        searched_supplier_count = '2',
        system_load_1_min = '4.44',
        system_load_5_min = '10.11',
        system_load_15_min = '11.73',
        system_memory_usage = '82.96',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1232') + '29872560',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1232';
[04/19/2024 10:34:39], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:34:39' WHERE id= '732';
[04/19/2024 10:34:39], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:34:39' WHERE id= '732';
[04/19/2024 10:34:40], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:34:40' WHERE id= '732';
[04/19/2024 10:34:42], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:34:42' WHERE id= '732';
[04/19/2024 10:35:11], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:35:11' WHERE id= '732';
[04/19/2024 10:35:17], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:35:17' WHERE id= '732';
[04/19/2024 10:35:17], [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/04/25' , departure_date = '2024/04/26' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-04-19 10:35:17' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[04/19/2024 10:35:18], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:35:18' WHERE id= '732';
[04/19/2024 10:35:19], [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/19_04_2024/request_availability_Gajendra_1233_1713522919_52.json', 'e1/19_04_2024/response_availability_Gajendra_1233_1713522919_52.json', 'e1/19_04_2024/response_header_availability_Gajendra_1233_1713522919_52.json', 'expedia', '2024-04-19 10:35:19', '', 'e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f', '1233');
[04/19/2024 10:35:19], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f&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=MozillaFirefox%2F124.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-19 10:35:18.984'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.426'
        , error_description = ''
        , memory_used = '3654464'
        WHERE id = '118408';
[04/19/2024 10:35:19], [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/19_04_2024/request_availability_Gajendra_1233_1713522919_48.json', 'e1p/19_04_2024/response_availability_Gajendra_1233_1713522919_48.json', 'e1p/19_04_2024/response_header_availability_Gajendra_1233_1713522919_48.json', 'expediapackage', '2024-04-19 10:35:19', '', 'e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f', '1233');
[04/19/2024 10:35:19], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f&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=MozillaFirefox%2F124.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-19 10:35:19.3'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.460'
        , error_description = ''
        , memory_used = '3655440'
        WHERE id = '118409';
[04/19/2024 10:35:20], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/19_04_2024/request_availability_Gajendra_1233_1713522919_7.json', 'e1/19_04_2024/response_availability_Gajendra_1233_1713522919_7.json', 'e1/19_04_2024/response_header_availability_Gajendra_1233_1713522919_7.json', 'expedia', '2024-04-19 10:35:20', '', 'e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f', '1233');
[04/19/2024 10:35:20], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/19_04_2024/request_availability_Gajendra_1233_1713522919_99.json', 'e1/19_04_2024/response_availability_Gajendra_1233_1713522919_99.json', 'e1/19_04_2024/response_header_availability_Gajendra_1233_1713522919_99.json', 'expedia', '2024-04-19 10:35:20', '', 'e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f', '1233');
[04/19/2024 10:35:20], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/19_04_2024/request_availability_Gajendra_1233_1713522919_77.json', 'e1p/19_04_2024/response_availability_Gajendra_1233_1713522919_77.json', 'e1p/19_04_2024/response_header_availability_Gajendra_1233_1713522919_77.json', 'expediapackage', '2024-04-19 10:35:20', '', 'e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f', '1233');
[04/19/2024 10:35:20], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/19_04_2024/request_availability_Gajendra_1233_1713522919_55.json', 'e1p/19_04_2024/response_availability_Gajendra_1233_1713522919_55.json', 'e1p/19_04_2024/response_header_availability_Gajendra_1233_1713522919_55.json', 'expediapackage', '2024-04-19 10:35:20', '', 'e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f', '1233');
[04/19/2024 10:35:25], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f&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=MozillaFirefox%2F124.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-19 10:35:18.987'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '6.218'
        , error_description = ''
        , memory_used = '143009288'
        WHERE id = '118410';
[04/19/2024 10:35:26], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f&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=MozillaFirefox%2F124.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-19 10:35:18.982'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '7.166'
        , error_description = ''
        , memory_used = '159014960'
        WHERE id = '118411';
[04/19/2024 10:35:26], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f&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=MozillaFirefox%2F124.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-19 10:35:18.982'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '7.279'
        , error_description = ''
        , memory_used = '170524904'
        WHERE id = '118413';
[04/19/2024 10:35:26], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f&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=MozillaFirefox%2F124.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-19 10:35:18.982'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '7.494'
        , error_description = ''
        , memory_used = '151813104'
        WHERE id = '118412';
[04/19/2024 10:35:28], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7873&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f',
        duration = '9.866',
        merge_duration = '1.530',
        assigned_supplier_count = '2',
        searched_supplier_count = '2',
        system_load_1_min = '16.98',
        system_load_5_min = '12.64',
        system_load_15_min = '12.50',
        system_memory_usage = '86.08',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1233') + '28844920',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1233';
[04/19/2024 10:35:28], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:35:28' WHERE id= '732';
[04/19/2024 10:35:28], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:35:28' WHERE id= '732';
[04/19/2024 10:35:31], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:35:31' WHERE id= '732';
[04/19/2024 10:40:56], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:40:56' WHERE id= '798';
[04/19/2024 10:40:58], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:40:58' WHERE id= '798';
[04/19/2024 10:41:08], [file name :-/home/otrams/public_html/beta/shiv_test.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:41:08' WHERE id= '799';
[04/19/2024 10:44:23], [file name :-/home/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[04/19/2024 10:44: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';
[04/19/2024 10:44: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';
[04/19/2024 10:44: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';
[04/19/2024 10:44: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';
[04/19/2024 10:44: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';
[04/19/2024 10:44: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';
[04/19/2024 10:44: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';
[04/19/2024 10:44: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';
[04/19/2024 10:44: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';
[04/19/2024 10:44: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';
[04/19/2024 10:44: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';
[04/19/2024 10:44: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';
[04/19/2024 10:44: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';
[04/19/2024 10:44: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';
[04/19/2024 10:44: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';
[04/19/2024 10:44: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';
[04/19/2024 10:44: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';
[04/19/2024 10:44: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';
[04/19/2024 10:44: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';
[04/19/2024 10:44: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';
[04/19/2024 10:44: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';
[04/19/2024 10:44: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';
[04/19/2024 10:44: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';
[04/19/2024 10:44: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';
[04/19/2024 10:44: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';
[04/19/2024 10:44: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';
[04/19/2024 10:44: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';
[04/19/2024 10:44: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';
[04/19/2024 10:44: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';
[04/19/2024 10:44: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';
[04/19/2024 10:44: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';
[04/19/2024 10:44: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';
[04/19/2024 10:44: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';
[04/19/2024 10:44:23], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '66' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[04/19/2024 10:44: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 = '';
[04/19/2024 10:44:23], [file name :-/home/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'v3alpha',`create_date`= '2024-04-19 10:44: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 = 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 = 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 = 66 ,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- 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';
[04/19/2024 10:44:31], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:44:31' WHERE id= '798';
[04/19/2024 10:44:31], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-04-19 10:44:31',login_attempt=0 where id = '7873';
[04/19/2024 10:44:31], [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-04-19 10:44:31', ip = '43.239.53.130', action = 'Login' ;
[04/19/2024 10:44:32], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:44:32' WHERE id= '798';
[04/19/2024 10:44:43], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:44:43' WHERE id= '798';
[04/19/2024 10:44:48], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:44:48' WHERE id= '798';
[04/19/2024 10:44:48], [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/04/24' , departure_date = '2024/04/25' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-04-19 10:44:48' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[04/19/2024 10:44:48], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:44:48' WHERE id= '798';
[04/19/2024 10:44:49], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/19_04_2024/request_availability_Gajendra_1234_1713523489_90.json', 'e1/19_04_2024/response_availability_Gajendra_1234_1713523489_90.json', 'e1/19_04_2024/response_header_availability_Gajendra_1234_1713523489_90.json', 'expedia', '2024-04-19 10:44:49', '', '15d6c23de87cee6f5ec4e054a78509f42e455a26d6e7f131a2953a63efe80ea3', '1234');
[04/19/2024 10:44:49], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=15d6c23de87cee6f5ec4e054a78509f42e455a26d6e7f131a2953a63efe80ea3&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-04-19 10:44:49.31'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.248'
        , error_description = ''
        , memory_used = '3654312'
        WHERE id = '118414';
[04/19/2024 10:44:49], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/19_04_2024/request_availability_Gajendra_1234_1713523489_86.json', 'e1p/19_04_2024/response_availability_Gajendra_1234_1713523489_86.json', 'e1p/19_04_2024/response_header_availability_Gajendra_1234_1713523489_86.json', 'expediapackage', '2024-04-19 10:44:49', '', '15d6c23de87cee6f5ec4e054a78509f42e455a26d6e7f131a2953a63efe80ea3', '1234');
[04/19/2024 10:44:49], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=15d6c23de87cee6f5ec4e054a78509f42e455a26d6e7f131a2953a63efe80ea3&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-04-19 10:44:49.31'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.311'
        , error_description = ''
        , memory_used = '3655320'
        WHERE id = '118415';
[04/19/2024 10:44:50], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/19_04_2024/request_availability_Gajendra_1234_1713523489_82.json', 'e1/19_04_2024/response_availability_Gajendra_1234_1713523489_82.json', 'e1/19_04_2024/response_header_availability_Gajendra_1234_1713523489_82.json', 'expedia', '2024-04-19 10:44:50', '', '15d6c23de87cee6f5ec4e054a78509f42e455a26d6e7f131a2953a63efe80ea3', '1234');
[04/19/2024 10:44:50], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/19_04_2024/request_availability_Gajendra_1234_1713523489_26.json', 'e1/19_04_2024/response_availability_Gajendra_1234_1713523489_26.json', 'e1/19_04_2024/response_header_availability_Gajendra_1234_1713523489_26.json', 'expedia', '2024-04-19 10:44:50', '', '15d6c23de87cee6f5ec4e054a78509f42e455a26d6e7f131a2953a63efe80ea3', '1234');
[04/19/2024 10:44:50], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/19_04_2024/request_availability_Gajendra_1234_1713523489_32.json', 'e1p/19_04_2024/response_availability_Gajendra_1234_1713523489_32.json', 'e1p/19_04_2024/response_header_availability_Gajendra_1234_1713523489_32.json', 'expediapackage', '2024-04-19 10:44:50', '', '15d6c23de87cee6f5ec4e054a78509f42e455a26d6e7f131a2953a63efe80ea3', '1234');
[04/19/2024 10:44:50], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/19_04_2024/request_availability_Gajendra_1234_1713523489_52.json', 'e1p/19_04_2024/response_availability_Gajendra_1234_1713523489_52.json', 'e1p/19_04_2024/response_header_availability_Gajendra_1234_1713523489_52.json', 'expediapackage', '2024-04-19 10:44:50', '', '15d6c23de87cee6f5ec4e054a78509f42e455a26d6e7f131a2953a63efe80ea3', '1234');
[04/19/2024 10:44:52], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=15d6c23de87cee6f5ec4e054a78509f42e455a26d6e7f131a2953a63efe80ea3&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-04-19 10:44:49.31'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '3.259'
        , error_description = ''
        , memory_used = '231809784'
        WHERE id = '118416';
[04/19/2024 10:44:53], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=15d6c23de87cee6f5ec4e054a78509f42e455a26d6e7f131a2953a63efe80ea3&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-04-19 10:44:49.31'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '4.028'
        , error_description = ''
        , memory_used = '269666680'
        WHERE id = '118417';
[04/19/2024 10:44:53], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=15d6c23de87cee6f5ec4e054a78509f42e455a26d6e7f131a2953a63efe80ea3&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-04-19 10:44:49.31'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '4.232'
        , error_description = ''
        , memory_used = '248006120'
        WHERE id = '118419';
[04/19/2024 10:44:53], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=15d6c23de87cee6f5ec4e054a78509f42e455a26d6e7f131a2953a63efe80ea3&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-04-19 10:44:49.31'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '4.398'
        , error_description = ''
        , memory_used = '291617912'
        WHERE id = '118418';
[04/19/2024 10:44:53], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7873&sessionid=15d6c23de87cee6f5ec4e054a78509f42e455a26d6e7f131a2953a63efe80ea3',
        duration = '4.650',
        merge_duration = '0.109',
        assigned_supplier_count = '2',
        searched_supplier_count = '2',
        system_load_1_min = '14.99',
        system_load_5_min = '10.30',
        system_load_15_min = '11.26',
        system_memory_usage = '79.15',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1234') + '17088688',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1234';
[04/19/2024 10:44:53], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:44:53' WHERE id= '798';
[04/19/2024 10:44:54], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:44:54' WHERE id= '798';
[04/19/2024 10:44:55], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:44:55' WHERE id= '798';
[04/19/2024 10:48:56], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:48:56' WHERE id= '732';
[04/19/2024 10:49:00], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:49:00' WHERE id= '732';
[04/19/2024 10:49:00], [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/04/25' , departure_date = '2024/04/26' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-04-19 10:49:00' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[04/19/2024 10:49:00], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:49:00' WHERE id= '732';
[04/19/2024 10:49:01], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/19_04_2024/request_availability_Gajendra_1235_1713523741_94.json', 'e1p/19_04_2024/response_availability_Gajendra_1235_1713523741_94.json', 'e1p/19_04_2024/response_header_availability_Gajendra_1235_1713523741_94.json', 'expediapackage', '2024-04-19 10:49:01', '', 'e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f', '1235');
[04/19/2024 10:49:01], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f&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=MozillaFirefox%2F124.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-19 10:49:01.87'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.237'
        , error_description = ''
        , memory_used = '3656792'
        WHERE id = '118420';
[04/19/2024 10:49:01], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/19_04_2024/request_availability_Gajendra_1235_1713523741_95.json', 'e1/19_04_2024/response_availability_Gajendra_1235_1713523741_95.json', 'e1/19_04_2024/response_header_availability_Gajendra_1235_1713523741_95.json', 'expedia', '2024-04-19 10:49:01', '', 'e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f', '1235');
[04/19/2024 10:49:01], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f&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=MozillaFirefox%2F124.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-19 10:49:01.87'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.253'
        , error_description = ''
        , memory_used = '3654424'
        WHERE id = '118421';
[04/19/2024 10:49:02], [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/19_04_2024/request_availability_Gajendra_1235_1713523741_75.json', 'e1/19_04_2024/response_availability_Gajendra_1235_1713523741_75.json', 'e1/19_04_2024/response_header_availability_Gajendra_1235_1713523741_75.json', 'expedia', '2024-04-19 10:49:02', '', 'e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f', '1235');
[04/19/2024 10:49:02], [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/19_04_2024/request_availability_Gajendra_1235_1713523741_50.json', 'e1p/19_04_2024/response_availability_Gajendra_1235_1713523741_50.json', 'e1p/19_04_2024/response_header_availability_Gajendra_1235_1713523741_50.json', 'expediapackage', '2024-04-19 10:49:02', '', 'e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f', '1235');
[04/19/2024 10:49:02], [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/19_04_2024/request_availability_Gajendra_1235_1713523741_76.json', 'e1p/19_04_2024/response_availability_Gajendra_1235_1713523741_76.json', 'e1p/19_04_2024/response_header_availability_Gajendra_1235_1713523741_76.json', 'expediapackage', '2024-04-19 10:49:02', '', 'e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f', '1235');
[04/19/2024 10:49:03], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/19_04_2024/request_availability_Gajendra_1235_1713523741_14.json', 'e1/19_04_2024/response_availability_Gajendra_1235_1713523741_14.json', 'e1/19_04_2024/response_header_availability_Gajendra_1235_1713523741_14.json', 'expedia', '2024-04-19 10:49:03', '', 'e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f', '1235');
[04/19/2024 10:49:05], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f&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=MozillaFirefox%2F124.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-19 10:49:01.86'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '4.407'
        , error_description = ''
        , memory_used = '272118232'
        WHERE id = '118422';
[04/19/2024 10:49:05], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f&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=MozillaFirefox%2F124.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-19 10:49:01.87'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '4.476'
        , error_description = ''
        , memory_used = '260153248'
        WHERE id = '118424';
[04/19/2024 10:49:05], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f&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=MozillaFirefox%2F124.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-19 10:49:01.87'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '4.631'
        , error_description = ''
        , memory_used = '242956416'
        WHERE id = '118425';
[04/19/2024 10:49:05], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f&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=MozillaFirefox%2F124.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-19 10:49:01.87'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '4.855'
        , error_description = ''
        , memory_used = '294973896'
        WHERE id = '118423';
[04/19/2024 10:49:06], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7873&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f',
        duration = '5.143',
        merge_duration = '0.119',
        assigned_supplier_count = '2',
        searched_supplier_count = '2',
        system_load_1_min = '6.54',
        system_load_5_min = '8.03',
        system_load_15_min = '10.10',
        system_memory_usage = '79.10',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1235') + '17317616',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1235';
[04/19/2024 10:49:06], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:49:06' WHERE id= '732';
[04/19/2024 10:49:06], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:49:06' WHERE id= '732';
[04/19/2024 10:49:07], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:49:07' WHERE id= '732';
[04/19/2024 10:49:36], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:49:36' WHERE id= '732';
[04/19/2024 10:49:40], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:49:40' WHERE id= '732';
[04/19/2024 10:49:40], [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/04/25' , departure_date = '2024/04/26' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-04-19 10:49:40' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[04/19/2024 10:49:40], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:49:40' WHERE id= '732';
[04/19/2024 10:49: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', 'e1/19_04_2024/request_availability_Gajendra_1236_1713523780_77.json', 'e1/19_04_2024/response_availability_Gajendra_1236_1713523780_77.json', 'e1/19_04_2024/response_header_availability_Gajendra_1236_1713523780_77.json', 'expedia', '2024-04-19 10:49:41', '', 'e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f', '1236');
[04/19/2024 10:49:41], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f&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=MozillaFirefox%2F124.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-19 10:49:40.926'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.228'
        , error_description = ''
        , memory_used = '3654216'
        WHERE id = '118426';
[04/19/2024 10:49: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/19_04_2024/request_availability_Gajendra_1236_1713523780_23.json', 'e1p/19_04_2024/response_availability_Gajendra_1236_1713523780_23.json', 'e1p/19_04_2024/response_header_availability_Gajendra_1236_1713523780_23.json', 'expediapackage', '2024-04-19 10:49:41', '', 'e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f', '1236');
[04/19/2024 10:49:41], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f&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=MozillaFirefox%2F124.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-19 10:49:40.926'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.323'
        , error_description = ''
        , memory_used = '3655080'
        WHERE id = '118427';
[04/19/2024 10:49: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', 'e1/19_04_2024/request_availability_Gajendra_1236_1713523780_32.json', 'e1/19_04_2024/response_availability_Gajendra_1236_1713523780_32.json', 'e1/19_04_2024/response_header_availability_Gajendra_1236_1713523780_32.json', 'expedia', '2024-04-19 10:49:41', '', 'e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f', '1236');
[04/19/2024 10:49:42], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/19_04_2024/request_availability_Gajendra_1236_1713523780_33.json', 'e1p/19_04_2024/response_availability_Gajendra_1236_1713523780_33.json', 'e1p/19_04_2024/response_header_availability_Gajendra_1236_1713523780_33.json', 'expediapackage', '2024-04-19 10:49:42', '', 'e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f', '1236');
[04/19/2024 10:49:42], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/19_04_2024/request_availability_Gajendra_1236_1713523780_35.json', 'e1/19_04_2024/response_availability_Gajendra_1236_1713523780_35.json', 'e1/19_04_2024/response_header_availability_Gajendra_1236_1713523780_35.json', 'expedia', '2024-04-19 10:49:42', '', 'e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f', '1236');
[04/19/2024 10:49:42], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/19_04_2024/request_availability_Gajendra_1236_1713523780_78.json', 'e1p/19_04_2024/response_availability_Gajendra_1236_1713523780_78.json', 'e1p/19_04_2024/response_header_availability_Gajendra_1236_1713523780_78.json', 'expediapackage', '2024-04-19 10:49:42', '', 'e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f', '1236');
[04/19/2024 10:49:43], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f&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=MozillaFirefox%2F124.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-19 10:49:40.926'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '2.175'
        , error_description = ''
        , memory_used = '142919504'
        WHERE id = '118428';
[04/19/2024 10:49:43], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f&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=MozillaFirefox%2F124.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-19 10:49:40.926'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '2.789'
        , error_description = ''
        , memory_used = '151558832'
        WHERE id = '118429';
[04/19/2024 10:49:43], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f&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=MozillaFirefox%2F124.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-19 10:49:40.926'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '2.894'
        , error_description = ''
        , memory_used = '158917712'
        WHERE id = '118430';
[04/19/2024 10:49:43], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f&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=MozillaFirefox%2F124.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-19 10:49:40.926'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '3.062'
        , error_description = ''
        , memory_used = '170485616'
        WHERE id = '118431';
[04/19/2024 10:49:44], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7873&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f',
        duration = '4.138',
        merge_duration = '0.918',
        assigned_supplier_count = '2',
        searched_supplier_count = '2',
        system_load_1_min = '24.35',
        system_load_5_min = '12.07',
        system_load_15_min = '11.37',
        system_memory_usage = '79.42',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1236') + '28926472',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1236';
[04/19/2024 10:49:45], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:49:45' WHERE id= '732';
[04/19/2024 10:49:45], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:49:45' WHERE id= '732';
[04/19/2024 10:49:46], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:49:46' WHERE id= '732';
[04/19/2024 10:50:10], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:50:10' WHERE id= '732';
[04/19/2024 10:51:45], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:51:45' WHERE id= '732';
[04/19/2024 10:51:45], [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/04/25' , departure_date = '2024/04/26' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-04-19 10:51:45' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[04/19/2024 10:51:46], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:51:46' WHERE id= '732';
[04/19/2024 10:51:47], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/19_04_2024/request_availability_Gajendra_1237_1713523907_40.json', 'e1p/19_04_2024/response_availability_Gajendra_1237_1713523907_40.json', 'e1p/19_04_2024/response_header_availability_Gajendra_1237_1713523907_40.json', 'expediapackage', '2024-04-19 10:51:47', '', 'e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f', '1237');
[04/19/2024 10:51:47], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f&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=MozillaFirefox%2F124.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-19 10:51:46.934'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.279'
        , error_description = ''
        , memory_used = '3655632'
        WHERE id = '118432';
[04/19/2024 10:51:47], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/19_04_2024/request_availability_Gajendra_1237_1713523907_79.json', 'e1/19_04_2024/response_availability_Gajendra_1237_1713523907_79.json', 'e1/19_04_2024/response_header_availability_Gajendra_1237_1713523907_79.json', 'expedia', '2024-04-19 10:51:47', '', 'e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f', '1237');
[04/19/2024 10:51:47], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f&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=MozillaFirefox%2F124.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-19 10:51:46.934'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.449'
        , error_description = ''
        , memory_used = '3654216'
        WHERE id = '118433';
[04/19/2024 10:51:47], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/19_04_2024/request_availability_Gajendra_1237_1713523906_1.json', 'e1/19_04_2024/response_availability_Gajendra_1237_1713523906_1.json', 'e1/19_04_2024/response_header_availability_Gajendra_1237_1713523906_1.json', 'expedia', '2024-04-19 10:51:47', '', 'e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f', '1237');
[04/19/2024 10:51:49], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/19_04_2024/request_availability_Gajendra_1237_1713523907_84.json', 'e1/19_04_2024/response_availability_Gajendra_1237_1713523907_84.json', 'e1/19_04_2024/response_header_availability_Gajendra_1237_1713523907_84.json', 'expedia', '2024-04-19 10:51:49', '', 'e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f', '1237');
[04/19/2024 10:51:49], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/19_04_2024/request_availability_Gajendra_1237_1713523906_12.json', 'e1p/19_04_2024/response_availability_Gajendra_1237_1713523906_12.json', 'e1p/19_04_2024/response_header_availability_Gajendra_1237_1713523906_12.json', 'expediapackage', '2024-04-19 10:51:49', '', 'e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f', '1237');
[04/19/2024 10:51:49], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f&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=MozillaFirefox%2F124.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-19 10:51:46.934'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '2.282'
        , error_description = ''
        , memory_used = '159312856'
        WHERE id = '118434';
[04/19/2024 10:51:49], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/19_04_2024/request_availability_Gajendra_1237_1713523907_19.json', 'e1p/19_04_2024/response_availability_Gajendra_1237_1713523907_19.json', 'e1p/19_04_2024/response_header_availability_Gajendra_1237_1713523907_19.json', 'expediapackage', '2024-04-19 10:51:49', '', 'e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f', '1237');
[04/19/2024 10:51:50], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f&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=MozillaFirefox%2F124.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-19 10:51:46.934'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '3.321'
        , error_description = ''
        , memory_used = '142981624'
        WHERE id = '118435';
[04/19/2024 10:51:50], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f&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=MozillaFirefox%2F124.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-19 10:51:46.934'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '3.569'
        , error_description = ''
        , memory_used = '170441032'
        WHERE id = '118436';
[04/19/2024 10:51:50], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f&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=MozillaFirefox%2F124.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-19 10:51:46.934'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '3.796'
        , error_description = ''
        , memory_used = '151817008'
        WHERE id = '118437';
[04/19/2024 10:51:51], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7873&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f',
        duration = '4.815',
        merge_duration = '0.895',
        assigned_supplier_count = '2',
        searched_supplier_count = '2',
        system_load_1_min = '10.16',
        system_load_5_min = '10.73',
        system_load_15_min = '10.96',
        system_memory_usage = '79.88',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1237') + '29842296',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1237';
[04/19/2024 10:51:51], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:51:51' WHERE id= '732';
[04/19/2024 10:51:51], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:51:51' WHERE id= '732';
[04/19/2024 10:51:54], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:51:54' WHERE id= '732';
[04/19/2024 10:52:25], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:52:25' WHERE id= '732';
[04/19/2024 10:52:27], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:52:27' WHERE id= '732';
[04/19/2024 10:58:02], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:58:02' WHERE id= '732';
[04/19/2024 10:58:03], [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/04/25' , departure_date = '2024/04/26' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-04-19 10:58:03' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[04/19/2024 10:58:03], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:58:03' WHERE id= '732';
[04/19/2024 10:58:04], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/19_04_2024/request_availability_Gajendra_1238_1713524284_68.json', 'e1/19_04_2024/response_availability_Gajendra_1238_1713524284_68.json', 'e1/19_04_2024/response_header_availability_Gajendra_1238_1713524284_68.json', 'expedia', '2024-04-19 10:58:04', '', 'e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f', '1238');
[04/19/2024 10:58:04], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f&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=MozillaFirefox%2F124.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-19 10:58:04.101'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.372'
        , error_description = ''
        , memory_used = '3654120'
        WHERE id = '118438';
[04/19/2024 10:58:04], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/19_04_2024/request_availability_Gajendra_1238_1713524284_34.json', 'e1p/19_04_2024/response_availability_Gajendra_1238_1713524284_34.json', 'e1p/19_04_2024/response_header_availability_Gajendra_1238_1713524284_34.json', 'expediapackage', '2024-04-19 10:58:04', '', 'e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f', '1238');
[04/19/2024 10:58:04], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f&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=MozillaFirefox%2F124.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-19 10:58:04.101'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.435'
        , error_description = ''
        , memory_used = '3655520'
        WHERE id = '118439';
[04/19/2024 10:58:05], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/19_04_2024/request_availability_Gajendra_1238_1713524284_3.json', 'e1/19_04_2024/response_availability_Gajendra_1238_1713524284_3.json', 'e1/19_04_2024/response_header_availability_Gajendra_1238_1713524284_3.json', 'expedia', '2024-04-19 10:58:05', '', 'e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f', '1238');
[04/19/2024 10:58:05], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/19_04_2024/request_availability_Gajendra_1238_1713524284_79.json', 'e1/19_04_2024/response_availability_Gajendra_1238_1713524284_79.json', 'e1/19_04_2024/response_header_availability_Gajendra_1238_1713524284_79.json', 'expedia', '2024-04-19 10:58:05', '', 'e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f', '1238');
[04/19/2024 10:58:05], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/19_04_2024/request_availability_Gajendra_1238_1713524284_22.json', 'e1p/19_04_2024/response_availability_Gajendra_1238_1713524284_22.json', 'e1p/19_04_2024/response_header_availability_Gajendra_1238_1713524284_22.json', 'expediapackage', '2024-04-19 10:58:05', '', 'e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f', '1238');
[04/19/2024 10:58:05], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/19_04_2024/request_availability_Gajendra_1238_1713524284_6.json', 'e1p/19_04_2024/response_availability_Gajendra_1238_1713524284_6.json', 'e1p/19_04_2024/response_header_availability_Gajendra_1238_1713524284_6.json', 'expediapackage', '2024-04-19 10:58:05', '', 'e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f', '1238');
[04/19/2024 10:58:07], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f&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=MozillaFirefox%2F124.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-19 10:58:04.100'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '3.611'
        , error_description = ''
        , memory_used = '242870416'
        WHERE id = '118440';
[04/19/2024 10:58:08], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f&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=MozillaFirefox%2F124.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-19 10:58:04.101'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '4.172'
        , error_description = ''
        , memory_used = '272209576'
        WHERE id = '118441';
[04/19/2024 10:58:08], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f&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=MozillaFirefox%2F124.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-19 10:58:04.101'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '4.305'
        , error_description = ''
        , memory_used = '259874128'
        WHERE id = '118442';
[04/19/2024 10:58:09], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f&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=MozillaFirefox%2F124.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-19 10:58:04.101'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '4.991'
        , error_description = ''
        , memory_used = '295081368'
        WHERE id = '118443';
[04/19/2024 10:58:09], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7873&sessionid=e00a49836f073f9ebbe40e2d43c010be3237edf8d96009e8e7dfab34701f5a7f',
        duration = '5.271',
        merge_duration = '0.114',
        assigned_supplier_count = '2',
        searched_supplier_count = '2',
        system_load_1_min = '9.35',
        system_load_5_min = '10.69',
        system_load_15_min = '10.93',
        system_memory_usage = '79.82',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1238') + '17261952',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1238';
[04/19/2024 10:58:09], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:58:09' WHERE id= '732';
[04/19/2024 10:58:09], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:58:09' WHERE id= '732';
[04/19/2024 10:58:11], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-19 10:58:11' WHERE id= '732';
