[04/12/2024 05:00:08], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:00:08' WHERE id= '768';
[04/12/2024 05:00:12], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:00:12' WHERE id= '768';
[04/12/2024 05:00:12], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7856' , 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-12 05:00:12' , 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/12/2024 05:00:13], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:00:13' WHERE id= '768';
[04/12/2024 05:00:13], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-04-12 05:00:13', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '892');
[04/12/2024 05:00:13], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=localsystem&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&request_no=0&local_hotel_code=5&#039;,&#039;6&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-04-12 05:00:13.186'
        , 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.112'
        , error_description = ''
        , memory_used = '1840792'
        WHERE id = '107898';
[04/12/2024 05:00:13], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/12_04_2024/request_availability_future_destination_892_1712898013_16.json', 'e1p/12_04_2024/response_availability_future_destination_892_1712898013_16.json', 'e1p/12_04_2024/response_header_availability_future_destination_892_1712898013_16.json', 'expediapackage', '2024-04-12 05:00:13', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '892');
[04/12/2024 05:00:13], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&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-12 05:00:13.186'
        , 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.242'
        , error_description = ''
        , memory_used = '1560760'
        WHERE id = '107899';
[04/12/2024 05:00:13], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/12_04_2024/request_availability_future_destination_892_1712898013_80.json', 'e1/12_04_2024/response_availability_future_destination_892_1712898013_80.json', 'e1/12_04_2024/response_header_availability_future_destination_892_1712898013_80.json', 'expedia', '2024-04-12 05:00:13', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '892');
[04/12/2024 05:00:13], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&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-12 05:00:13.186'
        , 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.256'
        , error_description = ''
        , memory_used = '1559208'
        WHERE id = '107900';
[04/12/2024 05:00:14], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/12_04_2024/request_availability_future_destination_892_1712898013_95.json', 'e1/12_04_2024/response_availability_future_destination_892_1712898013_95.json', 'e1/12_04_2024/response_header_availability_future_destination_892_1712898013_95.json', 'expedia', '2024-04-12 05:00:14', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '892');
[04/12/2024 05:00:14], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/12_04_2024/request_availability_future_destination_892_1712898013_97.json', 'e1/12_04_2024/response_availability_future_destination_892_1712898013_97.json', 'e1/12_04_2024/response_header_availability_future_destination_892_1712898013_97.json', 'expedia', '2024-04-12 05:00:14', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '892');
[04/12/2024 05:00:14], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/12_04_2024/request_availability_future_destination_892_1712898013_55.json', 'e1p/12_04_2024/response_availability_future_destination_892_1712898013_55.json', 'e1p/12_04_2024/response_header_availability_future_destination_892_1712898013_55.json', 'expediapackage', '2024-04-12 05:00:14', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '892');
[04/12/2024 05:00:14], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/12_04_2024/request_availability_future_destination_892_1712898013_87.json', 'e1p/12_04_2024/response_availability_future_destination_892_1712898013_87.json', 'e1p/12_04_2024/response_header_availability_future_destination_892_1712898013_87.json', 'expediapackage', '2024-04-12 05:00:14', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '892');
[04/12/2024 05:00:15], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&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-12 05:00:13.186'
        , 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.112'
        , error_description = ''
        , memory_used = '148505200'
        WHERE id = '107901';
[04/12/2024 05:00:15], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&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-12 05:00:13.186'
        , 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.571'
        , error_description = ''
        , memory_used = '182162728'
        WHERE id = '107902';
[04/12/2024 05:00:16], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&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-12 05:00:13.186'
        , 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.936'
        , error_description = ''
        , memory_used = '155892072'
        WHERE id = '107903';
[04/12/2024 05:00:16], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&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-12 05:00:13.186'
        , 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.318'
        , error_description = ''
        , memory_used = '192038328'
        WHERE id = '107904';
[04/12/2024 05:00:16], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '707',
        request_path = '/xml_all.php?userid=7856&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9',
        duration = '3.438',
        merge_duration = '0.003',
        assigned_supplier_count = '3',
        searched_supplier_count = '3',
        system_load_1_min = '0.35',
        system_load_5_min = '0.34',
        system_load_15_min = '0.38',
        system_memory_usage = '47.17',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '892') + '1955728',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '892';
[04/12/2024 05:00:16], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:00:16' WHERE id= '768';
[04/12/2024 05:00:49], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:00:49' WHERE id= '768';
[04/12/2024 05:00:51], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:00:51' WHERE id= '768';
[04/12/2024 05:01:09], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:01:09' WHERE id= '768';
[04/12/2024 05:01:14], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:01:14' WHERE id= '768';
[04/12/2024 05:01:14], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7856' , 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-12 05:01:14' , 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/12/2024 05:01:15], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:01:15' WHERE id= '768';
[04/12/2024 05:01:15], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-04-12 05:01:15', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '893');
[04/12/2024 05:01:15], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=localsystem&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&request_no=0&local_hotel_code=5&#039;,&#039;6&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-04-12 05:01:15.474'
        , 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.092'
        , error_description = ''
        , memory_used = '1592200'
        WHERE id = '107905';
[04/12/2024 05:01:15], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/12_04_2024/request_availability_future_destination_893_1712898075_96.json', 'e1/12_04_2024/response_availability_future_destination_893_1712898075_96.json', 'e1/12_04_2024/response_header_availability_future_destination_893_1712898075_96.json', 'expedia', '2024-04-12 05:01:15', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '893');
[04/12/2024 05:01:15], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&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-12 05:01:15.474'
        , 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.246'
        , error_description = ''
        , memory_used = '1560280'
        WHERE id = '107906';
[04/12/2024 05:01:15], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/12_04_2024/request_availability_future_destination_893_1712898075_82.json', 'e1p/12_04_2024/response_availability_future_destination_893_1712898075_82.json', 'e1p/12_04_2024/response_header_availability_future_destination_893_1712898075_82.json', 'expediapackage', '2024-04-12 05:01:15', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '893');
[04/12/2024 05:01:15], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&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-12 05:01:15.474'
        , 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 = '1560760'
        WHERE id = '107907';
[04/12/2024 05:01:16], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/12_04_2024/request_availability_future_destination_893_1712898075_12.json', 'e1/12_04_2024/response_availability_future_destination_893_1712898075_12.json', 'e1/12_04_2024/response_header_availability_future_destination_893_1712898075_12.json', 'expedia', '2024-04-12 05:01:16', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '893');
[04/12/2024 05:01:16], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/12_04_2024/request_availability_future_destination_893_1712898075_26.json', 'e1/12_04_2024/response_availability_future_destination_893_1712898075_26.json', 'e1/12_04_2024/response_header_availability_future_destination_893_1712898075_26.json', 'expedia', '2024-04-12 05:01:16', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '893');
[04/12/2024 05:01:17], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/12_04_2024/request_availability_future_destination_893_1712898075_3.json', 'e1p/12_04_2024/response_availability_future_destination_893_1712898075_3.json', 'e1p/12_04_2024/response_header_availability_future_destination_893_1712898075_3.json', 'expediapackage', '2024-04-12 05:01:17', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '893');
[04/12/2024 05:01:17], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/12_04_2024/request_availability_future_destination_893_1712898075_12.json', 'e1p/12_04_2024/response_availability_future_destination_893_1712898075_12.json', 'e1p/12_04_2024/response_header_availability_future_destination_893_1712898075_12.json', 'expediapackage', '2024-04-12 05:01:17', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '893');
[04/12/2024 05:01:17], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&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-12 05:01:15.474'
        , 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.059'
        , error_description = ''
        , memory_used = '148514048'
        WHERE id = '107908';
[04/12/2024 05:01:17], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&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-12 05:01:15.474'
        , 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.351'
        , error_description = ''
        , memory_used = '182086864'
        WHERE id = '107909';
[04/12/2024 05:01:18], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&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-12 05:01:15.474'
        , 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.899'
        , error_description = ''
        , memory_used = '156327504'
        WHERE id = '107911';
[04/12/2024 05:01:18], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&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-12 05:01:15.474'
        , 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.108'
        , error_description = ''
        , memory_used = '192141152'
        WHERE id = '107910';
[04/12/2024 05:01:18], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '707',
        request_path = '/xml_all.php?userid=7856&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9',
        duration = '3.265',
        merge_duration = '0.003',
        assigned_supplier_count = '3',
        searched_supplier_count = '3',
        system_load_1_min = '0.53',
        system_load_5_min = '0.41',
        system_load_15_min = '0.41',
        system_memory_usage = '46.92',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '893') + '1955728',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '893';
[04/12/2024 05:01:19], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:01:19' WHERE id= '768';
[04/12/2024 05:01:21], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:01:21' WHERE id= '768';
[04/12/2024 05:01:31], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:01:31' WHERE id= '769';
[04/12/2024 05:01:37], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:01:37' WHERE id= '769';
[04/12/2024 05:01:39], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:01:39' WHERE id= '769';
[04/12/2024 05:01:49], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:01:49' WHERE id= '768';
[04/12/2024 05:01:49], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-04-12 05:01:49',login_attempt=0 where id = '7856';
[04/12/2024 05:01:49], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'future_destination', user_type = 'A', branch_id = '1', login_datetime = '2024-04-12 05:01:49', ip = '43.239.53.130', action = 'Login' ;
[04/12/2024 05:01:50], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:01:50' WHERE id= '768';
[04/12/2024 05:01:54], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:01:54' WHERE id= '768';
[04/12/2024 05:01:56], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:01:56' WHERE id= '768';
[04/12/2024 05:01:57], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:01:57' WHERE id= '768';
[04/12/2024 05:01:58], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:01:58' WHERE id= '768';
[04/12/2024 05:02:06], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:02:06' WHERE id= '768';
[04/12/2024 05:02:06], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7856' , 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-12 05:02:06' , 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/12/2024 05:02:07], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:02:07' WHERE id= '768';
[04/12/2024 05:02:07], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-04-12 05:02:07', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '894');
[04/12/2024 05:02:07], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=localsystem&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&request_no=0&local_hotel_code=5&#039;,&#039;6&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-04-12 05:02:07.282'
        , 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.098'
        , error_description = ''
        , memory_used = '1592168'
        WHERE id = '107912';
[04/12/2024 05:02:07], [file name :-/home/otrams/public_html/beta/call.php],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/12_04_2024/request_availability_future_destination_894_1712898127_14.json', 'e1p/12_04_2024/response_availability_future_destination_894_1712898127_14.json', 'e1p/12_04_2024/response_header_availability_future_destination_894_1712898127_14.json', 'expediapackage', '2024-04-12 05:02:07', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '894');
[04/12/2024 05:02:07], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&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-12 05:02:07.282'
        , 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.240'
        , error_description = ''
        , memory_used = '1560760'
        WHERE id = '107913';
[04/12/2024 05:02:07], [file name :-/home/otrams/public_html/beta/call.php],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/12_04_2024/request_availability_future_destination_894_1712898127_33.json', 'e1/12_04_2024/response_availability_future_destination_894_1712898127_33.json', 'e1/12_04_2024/response_header_availability_future_destination_894_1712898127_33.json', 'expedia', '2024-04-12 05:02:07', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '894');
[04/12/2024 05:02:07], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&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-12 05:02:07.282'
        , 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.251'
        , error_description = ''
        , memory_used = '1560280'
        WHERE id = '107914';
[04/12/2024 05:02: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/12_04_2024/request_availability_future_destination_894_1712898127_10.json', 'e1/12_04_2024/response_availability_future_destination_894_1712898127_10.json', 'e1/12_04_2024/response_header_availability_future_destination_894_1712898127_10.json', 'expedia', '2024-04-12 05:02:08', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '894');
[04/12/2024 05:02: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/12_04_2024/request_availability_future_destination_894_1712898127_29.json', 'e1/12_04_2024/response_availability_future_destination_894_1712898127_29.json', 'e1/12_04_2024/response_header_availability_future_destination_894_1712898127_29.json', 'expedia', '2024-04-12 05:02:08', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '894');
[04/12/2024 05:02: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/12_04_2024/request_availability_future_destination_894_1712898127_69.json', 'e1p/12_04_2024/response_availability_future_destination_894_1712898127_69.json', 'e1p/12_04_2024/response_header_availability_future_destination_894_1712898127_69.json', 'expediapackage', '2024-04-12 05:02:08', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '894');
[04/12/2024 05:02: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/12_04_2024/request_availability_future_destination_894_1712898127_41.json', 'e1p/12_04_2024/response_availability_future_destination_894_1712898127_41.json', 'e1p/12_04_2024/response_header_availability_future_destination_894_1712898127_41.json', 'expediapackage', '2024-04-12 05:02:08', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '894');
[04/12/2024 05:02:09], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&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-12 05:02:07.282'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '2.224'
        , error_description = ''
        , memory_used = '151670112'
        WHERE id = '107915';
[04/12/2024 05:02:09], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&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-12 05:02:07.282'
        , 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.668'
        , error_description = ''
        , memory_used = '183251056'
        WHERE id = '107916';
[04/12/2024 05:02:10], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&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-12 05:02:07.282'
        , 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.917'
        , error_description = ''
        , memory_used = '159812704'
        WHERE id = '107918';
[04/12/2024 05:02:10], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&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-12 05:02:07.282'
        , 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.600'
        , error_description = ''
        , memory_used = '193541440'
        WHERE id = '107917';
[04/12/2024 05:02:10], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '709',
        request_path = '/xml_all.php?userid=7856&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9',
        duration = '3.752',
        merge_duration = '0.003',
        assigned_supplier_count = '3',
        searched_supplier_count = '3',
        system_load_1_min = '0.56',
        system_load_5_min = '0.46',
        system_load_15_min = '0.42',
        system_memory_usage = '46.80',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '894') + '1955616',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '894';
[04/12/2024 05:02:11], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:02:11' WHERE id= '768';
[04/12/2024 05:02:13], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:02:13' WHERE id= '768';
[04/12/2024 05:08:57], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:08:57' WHERE id= '768';
[04/12/2024 05:08:57], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-04-12 05:08:57',login_attempt=0 where id = '7856';
[04/12/2024 05:08:57], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'future_destination', user_type = 'A', branch_id = '1', login_datetime = '2024-04-12 05:08:57', ip = '43.239.53.130', action = 'Login' ;
[04/12/2024 05:08:58], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:08:58' WHERE id= '768';
[04/12/2024 05:09:03], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:09:03' WHERE id= '768';
[04/12/2024 05:09:04], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:09:04' WHERE id= '768';
[04/12/2024 05:09:05], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:09:05' WHERE id= '768';
[04/12/2024 05:09:11], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:09:11' WHERE id= '768';
[04/12/2024 05:09:11], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7856' , 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-12 05:09:11' , 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/12/2024 05:09:12], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:09:12' WHERE id= '768';
[04/12/2024 05:09:12], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-04-12 05:09:12', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '895');
[04/12/2024 05:09:12], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=localsystem&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&request_no=0&local_hotel_code=5&#039;,&#039;6&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-04-12 05:09:12.460'
        , 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.094'
        , error_description = ''
        , memory_used = '1839320'
        WHERE id = '107919';
[04/12/2024 05:09:12], [file name :-/home/otrams/public_html/beta/call.php],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/12_04_2024/request_availability_future_destination_895_1712898552_34.json', 'e1p/12_04_2024/response_availability_future_destination_895_1712898552_34.json', 'e1p/12_04_2024/response_header_availability_future_destination_895_1712898552_34.json', 'expediapackage', '2024-04-12 05:09:12', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '895');
[04/12/2024 05:09:12], [file name :-/home/otrams/public_html/beta/call.php],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/12_04_2024/request_availability_future_destination_895_1712898552_11.json', 'e1/12_04_2024/response_availability_future_destination_895_1712898552_11.json', 'e1/12_04_2024/response_header_availability_future_destination_895_1712898552_11.json', 'expedia', '2024-04-12 05:09:12', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '895');
[04/12/2024 05:09:12], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&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-12 05:09:12.460'
        , 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.262'
        , error_description = ''
        , memory_used = '1560760'
        WHERE id = '107920';
[04/12/2024 05:09:12], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&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-12 05:09:12.460'
        , 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.267'
        , error_description = ''
        , memory_used = '1560280'
        WHERE id = '107921';
[04/12/2024 05:09:13], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/12_04_2024/request_availability_future_destination_895_1712898552_36.json', 'e1/12_04_2024/response_availability_future_destination_895_1712898552_36.json', 'e1/12_04_2024/response_header_availability_future_destination_895_1712898552_36.json', 'expedia', '2024-04-12 05:09:13', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '895');
[04/12/2024 05:09:13], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/12_04_2024/request_availability_future_destination_895_1712898552_32.json', 'e1/12_04_2024/response_availability_future_destination_895_1712898552_32.json', 'e1/12_04_2024/response_header_availability_future_destination_895_1712898552_32.json', 'expedia', '2024-04-12 05:09:13', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '895');
[04/12/2024 05:09:13], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/12_04_2024/request_availability_future_destination_895_1712898552_60.json', 'e1p/12_04_2024/response_availability_future_destination_895_1712898552_60.json', 'e1p/12_04_2024/response_header_availability_future_destination_895_1712898552_60.json', 'expediapackage', '2024-04-12 05:09:13', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '895');
[04/12/2024 05:09:14], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/12_04_2024/request_availability_future_destination_895_1712898552_100.json', 'e1p/12_04_2024/response_availability_future_destination_895_1712898552_100.json', 'e1p/12_04_2024/response_header_availability_future_destination_895_1712898552_100.json', 'expediapackage', '2024-04-12 05:09:14', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '895');
[04/12/2024 05:09:14], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&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-12 05:09:12.460'
        , 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.193'
        , error_description = ''
        , memory_used = '151591072'
        WHERE id = '107923';
[04/12/2024 05:09:14], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&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-12 05:09:12.460'
        , 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.399'
        , error_description = ''
        , memory_used = '183082392'
        WHERE id = '107922';
[04/12/2024 05:09:15], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&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-12 05:09:12.460'
        , 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.744'
        , error_description = ''
        , memory_used = '159777184'
        WHERE id = '107925';
[04/12/2024 05:09:15], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&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-12 05:09:12.460'
        , 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.968'
        , error_description = ''
        , memory_used = '193241752'
        WHERE id = '107924';
[04/12/2024 05:09:15], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '709',
        request_path = '/xml_all.php?userid=7856&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9',
        duration = '3.130',
        merge_duration = '0.003',
        assigned_supplier_count = '3',
        searched_supplier_count = '3',
        system_load_1_min = '0.13',
        system_load_5_min = '0.26',
        system_load_15_min = '0.35',
        system_memory_usage = '49.03',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '895') + '1955616',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '895';
[04/12/2024 05:09:15], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:09:15' WHERE id= '768';
[04/12/2024 05:09:18], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:09:18' WHERE id= '768';
[04/12/2024 05:13:40], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:13:40' WHERE id= '768';
[04/12/2024 05:21:55], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:21:55' WHERE id= '769';
[04/12/2024 05:21:57], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:21:57' WHERE id= '769';
[04/12/2024 05:23:33], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:23:33' WHERE id= '769';
[04/12/2024 05:23:35], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:23:35' WHERE id= '769';
[04/12/2024 05:24:54], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:24:54' WHERE id= '769';
[04/12/2024 05:24:54], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '27' , 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-12 05:24:54' , 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/12/2024 05:24:54], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:24:54' WHERE id= '769';
[04/12/2024 05:24:54], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-04-12 05:24:54.941'
            , total_duration = '0.017'
            , hotel_count = 0
            , source_type = 'hotelbeds'
            , create_date = '2024-04-12 05:24:54'
            , session_id = 'f0b7acf331c136916ee0f73f410c87c69f0ea5d9e53b45f3c6afe54d5d9279a8'
            , agent_logs_id = '896'
            , error_description = ''
            , memory_used = '1811216';
[04/12/2024 05:24:54], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-04-12 05:24:54.941'
            , total_duration = '0.018'
            , hotel_count = 0
            , source_type = 'hotelbeds'
            , create_date = '2024-04-12 05:24:54'
            , session_id = 'f0b7acf331c136916ee0f73f410c87c69f0ea5d9e53b45f3c6afe54d5d9279a8'
            , agent_logs_id = '896'
            , error_description = ''
            , memory_used = '1811216';
[04/12/2024 05:24:54], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-04-12 05:24:54.941'
            , total_duration = '0.018'
            , hotel_count = 0
            , source_type = 'hotelbeds'
            , create_date = '2024-04-12 05:24:54'
            , session_id = 'f0b7acf331c136916ee0f73f410c87c69f0ea5d9e53b45f3c6afe54d5d9279a8'
            , agent_logs_id = '896'
            , error_description = ''
            , memory_used = '1811216';
[04/12/2024 05:24:54], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-04-12 05:24:54.941'
            , total_duration = '0.019'
            , hotel_count = 0
            , source_type = 'hotelbeds'
            , create_date = '2024-04-12 05:24:54'
            , session_id = 'f0b7acf331c136916ee0f73f410c87c69f0ea5d9e53b45f3c6afe54d5d9279a8'
            , agent_logs_id = '896'
            , error_description = ''
            , memory_used = '1811216';
[04/12/2024 05:24:54], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-04-12 05:24:54.941'
            , total_duration = '0.018'
            , hotel_count = 0
            , source_type = 'hotelbeds'
            , create_date = '2024-04-12 05:24:54'
            , session_id = 'f0b7acf331c136916ee0f73f410c87c69f0ea5d9e53b45f3c6afe54d5d9279a8'
            , agent_logs_id = '896'
            , error_description = ''
            , memory_used = '1811216';
[04/12/2024 05:24:54], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-04-12 05:24:54.941'
            , total_duration = '0.018'
            , hotel_count = 0
            , source_type = 'hotelbeds'
            , create_date = '2024-04-12 05:24:54'
            , session_id = 'f0b7acf331c136916ee0f73f410c87c69f0ea5d9e53b45f3c6afe54d5d9279a8'
            , agent_logs_id = '896'
            , error_description = ''
            , memory_used = '1811248';
[04/12/2024 05:24: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/12_04_2024/request_availability_Viator_test_896_1712899494_2.json', 'e1/12_04_2024/response_availability_Viator_test_896_1712899494_2.json', 'e1/12_04_2024/response_header_availability_Viator_test_896_1712899494_2.json', 'expedia', '2024-04-12 05:24:55', '', 'f0b7acf331c136916ee0f73f410c87c69f0ea5d9e53b45f3c6afe54d5d9279a8', '896');
[04/12/2024 05:24:55], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=f0b7acf331c136916ee0f73f410c87c69f0ea5d9e53b45f3c6afe54d5d9279a8&xml_user_id=7851&db_caching=1&erequest=2&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-12 05:24:54.941'
        , 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.370'
        , error_description = ''
        , memory_used = '1560328'
        WHERE id = '107932';
[04/12/2024 05:24: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', 'e1/12_04_2024/request_availability_Viator_test_896_1712899494_41.json', 'e1/12_04_2024/response_availability_Viator_test_896_1712899494_41.json', 'e1/12_04_2024/response_header_availability_Viator_test_896_1712899494_41.json', 'expedia', '2024-04-12 05:24:56', '', 'f0b7acf331c136916ee0f73f410c87c69f0ea5d9e53b45f3c6afe54d5d9279a8', '896');
[04/12/2024 05:24:57], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/12_04_2024/request_availability_Viator_test_896_1712899494_53.json', 'e1/12_04_2024/response_availability_Viator_test_896_1712899494_53.json', 'e1/12_04_2024/response_header_availability_Viator_test_896_1712899494_53.json', 'expedia', '2024-04-12 05:24:57', '', 'f0b7acf331c136916ee0f73f410c87c69f0ea5d9e53b45f3c6afe54d5d9279a8', '896');
[04/12/2024 05:24:57], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=f0b7acf331c136916ee0f73f410c87c69f0ea5d9e53b45f3c6afe54d5d9279a8&xml_user_id=7851&db_caching=1&erequest=0&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-12 05:24:54.941'
        , 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.494'
        , error_description = ''
        , memory_used = '182137248'
        WHERE id = '107933';
[04/12/2024 05:24:58], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=f0b7acf331c136916ee0f73f410c87c69f0ea5d9e53b45f3c6afe54d5d9279a8&xml_user_id=7851&db_caching=1&erequest=1&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-12 05:24:54.941'
        , 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.505'
        , error_description = ''
        , memory_used = '148591280'
        WHERE id = '107934';
[04/12/2024 05:24:58], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '353',
        request_path = '/xml_all.php?userid=7851&sessionid=f0b7acf331c136916ee0f73f410c87c69f0ea5d9e53b45f3c6afe54d5d9279a8',
        duration = '3.652',
        merge_duration = '0.002',
        assigned_supplier_count = '2',
        searched_supplier_count = '2',
        system_load_1_min = '0.40',
        system_load_5_min = '1.18',
        system_load_15_min = '0.92',
        system_memory_usage = '54.43',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '896') + '1949120',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '896';
[04/12/2024 05:24:58], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:24:58' WHERE id= '769';
[04/12/2024 05:25:00], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:25:00' WHERE id= '769';
[04/12/2024 05:36:35], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:36:34' WHERE id= '768';
[04/12/2024 05:36:44], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:36:44' WHERE id= '768';
[04/12/2024 05:36:44], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-04-12 05:36:44',login_attempt=0 where id = '7856';
[04/12/2024 05:36:44], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'future_destination', user_type = 'A', branch_id = '1', login_datetime = '2024-04-12 05:36:44', ip = '43.239.53.130', action = 'Login' ;
[04/12/2024 05:36:44], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:36:44' WHERE id= '768';
[04/12/2024 05:36:50], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:36:50' WHERE id= '768';
[04/12/2024 05:37:00], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:37:00' WHERE id= '768';
[04/12/2024 05:37:00], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7856' , 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/23' , departure_date = '2024/04/24' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-04-12 05:37:00' , 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/12/2024 05:37:00], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:37:00' WHERE id= '768';
[04/12/2024 05:37: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', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-04-12 05:37:01', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '897');
[04/12/2024 05:37:01], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=localsystem&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&request_no=0&local_hotel_code=5&#039;,&#039;6&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-04-12 05:37:01.106'
        , 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.094'
        , error_description = ''
        , memory_used = '1840784'
        WHERE id = '107935';
[04/12/2024 05:37: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/12_04_2024/request_availability_future_destination_897_1712900221_23.json', 'e1/12_04_2024/response_availability_future_destination_897_1712900221_23.json', 'e1/12_04_2024/response_header_availability_future_destination_897_1712900221_23.json', 'expedia', '2024-04-12 05:37:01', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '897');
[04/12/2024 05:37:01], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&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-12 05:37:01.106'
        , 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.387'
        , error_description = ''
        , memory_used = '1560280'
        WHERE id = '107936';
[04/12/2024 05:37: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/12_04_2024/request_availability_future_destination_897_1712900221_42.json', 'e1p/12_04_2024/response_availability_future_destination_897_1712900221_42.json', 'e1p/12_04_2024/response_header_availability_future_destination_897_1712900221_42.json', 'expediapackage', '2024-04-12 05:37:01', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '897');
[04/12/2024 05:37:01], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&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-12 05:37:01.106'
        , 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.513'
        , error_description = ''
        , memory_used = '1560680'
        WHERE id = '107937';
[04/12/2024 05:37: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/12_04_2024/request_availability_future_destination_897_1712900221_63.json', 'e1/12_04_2024/response_availability_future_destination_897_1712900221_63.json', 'e1/12_04_2024/response_header_availability_future_destination_897_1712900221_63.json', 'expedia', '2024-04-12 05:37:02', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '897');
[04/12/2024 05:37: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/12_04_2024/request_availability_future_destination_897_1712900221_94.json', 'e1/12_04_2024/response_availability_future_destination_897_1712900221_94.json', 'e1/12_04_2024/response_header_availability_future_destination_897_1712900221_94.json', 'expedia', '2024-04-12 05:37:02', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '897');
[04/12/2024 05:37: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/12_04_2024/request_availability_future_destination_897_1712900221_38.json', 'e1p/12_04_2024/response_availability_future_destination_897_1712900221_38.json', 'e1p/12_04_2024/response_header_availability_future_destination_897_1712900221_38.json', 'expediapackage', '2024-04-12 05:37:02', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '897');
[04/12/2024 05:37: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/12_04_2024/request_availability_future_destination_897_1712900221_73.json', 'e1p/12_04_2024/response_availability_future_destination_897_1712900221_73.json', 'e1p/12_04_2024/response_header_availability_future_destination_897_1712900221_73.json', 'expediapackage', '2024-04-12 05:37:02', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '897');
[04/12/2024 05:37:03], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&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-12 05:37:01.106'
        , 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.163'
        , error_description = ''
        , memory_used = '145477904'
        WHERE id = '107938';
[04/12/2024 05:37:03], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&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-12 05:37:01.106'
        , 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.445'
        , error_description = ''
        , memory_used = '178284056'
        WHERE id = '107939';
[04/12/2024 05:37:03], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&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-12 05:37:01.106'
        , 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.812'
        , error_description = ''
        , memory_used = '153073576'
        WHERE id = '107940';
[04/12/2024 05:37:04], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&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-12 05:37:01.106'
        , 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.191'
        , error_description = ''
        , memory_used = '187173592'
        WHERE id = '107941';
[04/12/2024 05:37:04], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '701',
        request_path = '/xml_all.php?userid=7856&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9',
        duration = '3.369',
        merge_duration = '0.003',
        assigned_supplier_count = '3',
        searched_supplier_count = '3',
        system_load_1_min = '0.38',
        system_load_5_min = '0.54',
        system_load_15_min = '0.68',
        system_memory_usage = '56.10',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '897') + '1955616',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '897';
[04/12/2024 05:37:04], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:37:04' WHERE id= '768';
[04/12/2024 05:37:07], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:37:07' WHERE id= '768';
[04/12/2024 05:37:15], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:37:15' WHERE id= '768';
[04/12/2024 05:37:15], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7856' , 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/23' , departure_date = '2024/04/24' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-04-12 05:37:15' , 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/12/2024 05:37:16], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:37:16' WHERE id= '768';
[04/12/2024 05:37:16], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-04-12 05:37:16', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '898');
[04/12/2024 05:37:16], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=localsystem&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&request_no=0&local_hotel_code=5&#039;,&#039;6&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-04-12 05:37:16.688'
        , 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.096'
        , error_description = ''
        , memory_used = '1592112'
        WHERE id = '107942';
[04/12/2024 05:37:16], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/12_04_2024/request_availability_future_destination_898_1712900236_19.json', 'e1/12_04_2024/response_availability_future_destination_898_1712900236_19.json', 'e1/12_04_2024/response_header_availability_future_destination_898_1712900236_19.json', 'expedia', '2024-04-12 05:37:16', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '898');
[04/12/2024 05:37:16], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&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-12 05:37:16.688'
        , 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.238'
        , error_description = ''
        , memory_used = '1559144'
        WHERE id = '107943';
[04/12/2024 05:37:16], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/12_04_2024/request_availability_future_destination_898_1712900236_38.json', 'e1p/12_04_2024/response_availability_future_destination_898_1712900236_38.json', 'e1p/12_04_2024/response_header_availability_future_destination_898_1712900236_38.json', 'expediapackage', '2024-04-12 05:37:16', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '898');
[04/12/2024 05:37:16], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&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-12 05:37:16.688'
        , 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.245'
        , error_description = ''
        , memory_used = '1560728'
        WHERE id = '107944';
[04/12/2024 05:37:17], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/12_04_2024/request_availability_future_destination_898_1712900236_49.json', 'e1/12_04_2024/response_availability_future_destination_898_1712900236_49.json', 'e1/12_04_2024/response_header_availability_future_destination_898_1712900236_49.json', 'expedia', '2024-04-12 05:37:17', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '898');
[04/12/2024 05:37:18], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/12_04_2024/request_availability_future_destination_898_1712900236_26.json', 'e1p/12_04_2024/response_availability_future_destination_898_1712900236_26.json', 'e1p/12_04_2024/response_header_availability_future_destination_898_1712900236_26.json', 'expediapackage', '2024-04-12 05:37:18', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '898');
[04/12/2024 05:37:18], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/12_04_2024/request_availability_future_destination_898_1712900236_63.json', 'e1p/12_04_2024/response_availability_future_destination_898_1712900236_63.json', 'e1p/12_04_2024/response_header_availability_future_destination_898_1712900236_63.json', 'expediapackage', '2024-04-12 05:37:18', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '898');
[04/12/2024 05:37:18], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/12_04_2024/request_availability_future_destination_898_1712900236_48.json', 'e1/12_04_2024/response_availability_future_destination_898_1712900236_48.json', 'e1/12_04_2024/response_header_availability_future_destination_898_1712900236_48.json', 'expedia', '2024-04-12 05:37:18', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '898');
[04/12/2024 05:37:19], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&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-12 05:37:16.688'
        , 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.460'
        , error_description = ''
        , memory_used = '145361312'
        WHERE id = '107945';
[04/12/2024 05:37:19], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&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-12 05:37:16.688'
        , 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.798'
        , error_description = ''
        , memory_used = '152991552'
        WHERE id = '107947';
[04/12/2024 05:37:19], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&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-12 05:37:16.688'
        , 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.006'
        , error_description = ''
        , memory_used = '187169840'
        WHERE id = '107946';
[04/12/2024 05:37:19], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&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-12 05:37:16.688'
        , 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.097'
        , error_description = ''
        , memory_used = '178288896'
        WHERE id = '107948';
[04/12/2024 05:37:19], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '701',
        request_path = '/xml_all.php?userid=7856&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9',
        duration = '3.248',
        merge_duration = '0.003',
        assigned_supplier_count = '3',
        searched_supplier_count = '3',
        system_load_1_min = '0.40',
        system_load_5_min = '0.54',
        system_load_15_min = '0.67',
        system_memory_usage = '56.05',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '898') + '1955896',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '898';
[04/12/2024 05:37:20], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:37:20' WHERE id= '768';
[04/12/2024 05:37:22], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:37:22' WHERE id= '768';
[04/12/2024 05:37:25], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:37:25' WHERE id= '768';
[04/12/2024 05:37:25], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7856' , 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/23' , departure_date = '2024/04/24' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-04-12 05:37:25' , 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/12/2024 05:37:26], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:37:26' WHERE id= '768';
[04/12/2024 05:37: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', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-04-12 05:37:26', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '899');
[04/12/2024 05:37:26], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=localsystem&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&request_no=0&local_hotel_code=5&#039;,&#039;6&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-04-12 05:37:26.153'
        , 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.091'
        , error_description = ''
        , memory_used = '1592160'
        WHERE id = '107949';
[04/12/2024 05:37: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/12_04_2024/request_availability_future_destination_899_1712900246_61.json', 'e1p/12_04_2024/response_availability_future_destination_899_1712900246_61.json', 'e1p/12_04_2024/response_header_availability_future_destination_899_1712900246_61.json', 'expediapackage', '2024-04-12 05:37:26', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '899');
[04/12/2024 05:37:26], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&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-12 05:37:26.153'
        , 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.381'
        , error_description = ''
        , memory_used = '1560648'
        WHERE id = '107950';
[04/12/2024 05:37: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/12_04_2024/request_availability_future_destination_899_1712900246_75.json', 'e1/12_04_2024/response_availability_future_destination_899_1712900246_75.json', 'e1/12_04_2024/response_header_availability_future_destination_899_1712900246_75.json', 'expedia', '2024-04-12 05:37:26', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '899');
[04/12/2024 05:37:26], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&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-12 05:37:26.153'
        , 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.465'
        , error_description = ''
        , memory_used = '1560248'
        WHERE id = '107951';
[04/12/2024 05:37: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/12_04_2024/request_availability_future_destination_899_1712900246_70.json', 'e1/12_04_2024/response_availability_future_destination_899_1712900246_70.json', 'e1/12_04_2024/response_header_availability_future_destination_899_1712900246_70.json', 'expedia', '2024-04-12 05:37:27', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '899');
[04/12/2024 05:37: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/12_04_2024/request_availability_future_destination_899_1712900246_31.json', 'e1/12_04_2024/response_availability_future_destination_899_1712900246_31.json', 'e1/12_04_2024/response_header_availability_future_destination_899_1712900246_31.json', 'expedia', '2024-04-12 05:37:27', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '899');
[04/12/2024 05:37: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/12_04_2024/request_availability_future_destination_899_1712900246_33.json', 'e1p/12_04_2024/response_availability_future_destination_899_1712900246_33.json', 'e1p/12_04_2024/response_header_availability_future_destination_899_1712900246_33.json', 'expediapackage', '2024-04-12 05:37:27', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '899');
[04/12/2024 05:37: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/12_04_2024/request_availability_future_destination_899_1712900246_48.json', 'e1p/12_04_2024/response_availability_future_destination_899_1712900246_48.json', 'e1p/12_04_2024/response_header_availability_future_destination_899_1712900246_48.json', 'expediapackage', '2024-04-12 05:37:27', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '899');
[04/12/2024 05:37:28], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&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-12 05:37:26.153'
        , 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.234'
        , error_description = ''
        , memory_used = '145352784'
        WHERE id = '107953';
[04/12/2024 05:37:28], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&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-12 05:37:26.153'
        , 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.396'
        , error_description = ''
        , memory_used = '178284936'
        WHERE id = '107952';
[04/12/2024 05:37:29], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&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-12 05:37:26.153'
        , 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.045'
        , error_description = ''
        , memory_used = '152891800'
        WHERE id = '107955';
[04/12/2024 05:37:29], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&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-12 05:37:26.153'
        , 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.147'
        , error_description = ''
        , memory_used = '187262256'
        WHERE id = '107954';
[04/12/2024 05:37:29], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '701',
        request_path = '/xml_all.php?userid=7856&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9',
        duration = '3.305',
        merge_duration = '0.003',
        assigned_supplier_count = '3',
        searched_supplier_count = '3',
        system_load_1_min = '0.37',
        system_load_5_min = '0.53',
        system_load_15_min = '0.67',
        system_memory_usage = '55.98',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '899') + '1955896',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '899';
[04/12/2024 05:37:29], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:37:29' WHERE id= '768';
[04/12/2024 05:37:32], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:37:32' WHERE id= '768';
[04/12/2024 05:37:40], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:37:40' WHERE id= '768';
[04/12/2024 05:37:40], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7856' , 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/23' , departure_date = '2024/04/24' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-04-12 05:37:40' , 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/12/2024 05:37:40], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:37:40' WHERE id= '768';
[04/12/2024 05:37: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', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-04-12 05:37:40', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '900');
[04/12/2024 05:37:40], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=localsystem&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&request_no=0&local_hotel_code=5&#039;,&#039;6&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-04-12 05:37:40.701'
        , 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.090'
        , error_description = ''
        , memory_used = '1592160'
        WHERE id = '107956';
[04/12/2024 05:37: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/12_04_2024/request_availability_future_destination_900_1712900260_93.json', 'e1/12_04_2024/response_availability_future_destination_900_1712900260_93.json', 'e1/12_04_2024/response_header_availability_future_destination_900_1712900260_93.json', 'expedia', '2024-04-12 05:37:40', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '900');
[04/12/2024 05:37: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/12_04_2024/request_availability_future_destination_900_1712900260_100.json', 'e1p/12_04_2024/response_availability_future_destination_900_1712900260_100.json', 'e1p/12_04_2024/response_header_availability_future_destination_900_1712900260_100.json', 'expediapackage', '2024-04-12 05:37:40', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '900');
[04/12/2024 05:37:40], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&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-12 05:37:40.701'
        , 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 = '1559144'
        WHERE id = '107957';
[04/12/2024 05:37:40], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&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-12 05:37:40.701'
        , 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.231'
        , error_description = ''
        , memory_used = '1559656'
        WHERE id = '107958';
[04/12/2024 05:37: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/12_04_2024/request_availability_future_destination_900_1712900260_99.json', 'e1/12_04_2024/response_availability_future_destination_900_1712900260_99.json', 'e1/12_04_2024/response_header_availability_future_destination_900_1712900260_99.json', 'expedia', '2024-04-12 05:37:41', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '900');
[04/12/2024 05:37: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/12_04_2024/request_availability_future_destination_900_1712900260_59.json', 'e1/12_04_2024/response_availability_future_destination_900_1712900260_59.json', 'e1/12_04_2024/response_header_availability_future_destination_900_1712900260_59.json', 'expedia', '2024-04-12 05:37:41', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '900');
[04/12/2024 05:37: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/12_04_2024/request_availability_future_destination_900_1712900260_40.json', 'e1p/12_04_2024/response_availability_future_destination_900_1712900260_40.json', 'e1p/12_04_2024/response_header_availability_future_destination_900_1712900260_40.json', 'expediapackage', '2024-04-12 05:37:42', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '900');
[04/12/2024 05:37: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/12_04_2024/request_availability_future_destination_900_1712900260_99.json', 'e1p/12_04_2024/response_availability_future_destination_900_1712900260_99.json', 'e1p/12_04_2024/response_header_availability_future_destination_900_1712900260_99.json', 'expediapackage', '2024-04-12 05:37:42', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '900');
[04/12/2024 05:37:42], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&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-12 05:37:40.701'
        , 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.132'
        , error_description = ''
        , memory_used = '145476536'
        WHERE id = '107960';
[04/12/2024 05:37:43], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&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-12 05:37:40.701'
        , 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.341'
        , error_description = ''
        , memory_used = '178291160'
        WHERE id = '107959';
[04/12/2024 05:37:43], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&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-12 05:37:40.701'
        , 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.857'
        , error_description = ''
        , memory_used = '152583560'
        WHERE id = '107962';
[04/12/2024 05:37:43], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&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-12 05:37:40.701'
        , 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.022'
        , error_description = ''
        , memory_used = '187164656'
        WHERE id = '107961';
[04/12/2024 05:37:43], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '701',
        request_path = '/xml_all.php?userid=7856&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9',
        duration = '3.178',
        merge_duration = '0.003',
        assigned_supplier_count = '3',
        searched_supplier_count = '3',
        system_load_1_min = '0.42',
        system_load_5_min = '0.53',
        system_load_15_min = '0.67',
        system_memory_usage = '56.01',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '900') + '1955152',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '900';
[04/12/2024 05:37:44], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:37:44' WHERE id= '768';
[04/12/2024 05:37:46], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:37:46' WHERE id= '768';
[04/12/2024 05:39:44], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:39:44' WHERE id= '768';
[04/12/2024 05:39:44], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-04-12 05:39:44',login_attempt=0 where id = '7856';
[04/12/2024 05:39:44], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'future_destination', user_type = 'A', branch_id = '1', login_datetime = '2024-04-12 05:39:44', ip = '43.239.53.130', action = 'Login' ;
[04/12/2024 05:39:44], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:39:44' WHERE id= '768';
[04/12/2024 05:39:49], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:39:49' WHERE id= '768';
[04/12/2024 05:39:54], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:39:54' WHERE id= '768';
[04/12/2024 05:39:54], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7856' , 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-12 05:39:54' , 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/12/2024 05:39:55], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:39:55' WHERE id= '768';
[04/12/2024 05:39: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', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-04-12 05:39:55', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '901');
[04/12/2024 05:39:55], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=localsystem&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&request_no=0&local_hotel_code=5&#039;,&#039;6&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-04-12 05:39:55.658'
        , 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.096'
        , error_description = ''
        , memory_used = '1592200'
        WHERE id = '107963';
[04/12/2024 05:39: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/12_04_2024/request_availability_future_destination_901_1712900395_3.json', 'e1p/12_04_2024/response_availability_future_destination_901_1712900395_3.json', 'e1p/12_04_2024/response_header_availability_future_destination_901_1712900395_3.json', 'expediapackage', '2024-04-12 05:39:55', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '901');
[04/12/2024 05:39:55], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&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-12 05:39:55.658'
        , 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.224'
        , error_description = ''
        , memory_used = '1560736'
        WHERE id = '107964';
[04/12/2024 05:39: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/12_04_2024/request_availability_future_destination_901_1712900395_23.json', 'e1/12_04_2024/response_availability_future_destination_901_1712900395_23.json', 'e1/12_04_2024/response_header_availability_future_destination_901_1712900395_23.json', 'expedia', '2024-04-12 05:39:55', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '901');
[04/12/2024 05:39:55], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&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-12 05:39:55.658'
        , 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.231'
        , error_description = ''
        , memory_used = '1560248'
        WHERE id = '107965';
[04/12/2024 05:39: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', 'e1/12_04_2024/request_availability_future_destination_901_1712900395_80.json', 'e1/12_04_2024/response_availability_future_destination_901_1712900395_80.json', 'e1/12_04_2024/response_header_availability_future_destination_901_1712900395_80.json', 'expedia', '2024-04-12 05:39:56', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '901');
[04/12/2024 05:39:57], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/12_04_2024/request_availability_future_destination_901_1712900395_15.json', 'e1/12_04_2024/response_availability_future_destination_901_1712900395_15.json', 'e1/12_04_2024/response_header_availability_future_destination_901_1712900395_15.json', 'expedia', '2024-04-12 05:39:57', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '901');
[04/12/2024 05:39:57], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/12_04_2024/request_availability_future_destination_901_1712900395_71.json', 'e1p/12_04_2024/response_availability_future_destination_901_1712900395_71.json', 'e1p/12_04_2024/response_header_availability_future_destination_901_1712900395_71.json', 'expediapackage', '2024-04-12 05:39:57', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '901');
[04/12/2024 05:39:57], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/12_04_2024/request_availability_future_destination_901_1712900395_1.json', 'e1p/12_04_2024/response_availability_future_destination_901_1712900395_1.json', 'e1p/12_04_2024/response_header_availability_future_destination_901_1712900395_1.json', 'expediapackage', '2024-04-12 05:39:57', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '901');
[04/12/2024 05:39:58], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&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-12 05:39:55.658'
        , 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.411'
        , error_description = ''
        , memory_used = '148433944'
        WHERE id = '107966';
[04/12/2024 05:39:58], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&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-12 05:39:55.658'
        , 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.806'
        , error_description = ''
        , memory_used = '156281976'
        WHERE id = '107968';
[04/12/2024 05:39:58], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&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-12 05:39:55.658'
        , 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.276'
        , error_description = ''
        , memory_used = '182517424'
        WHERE id = '107967';
[04/12/2024 05:39:58], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&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-12 05:39:55.658'
        , 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.307'
        , error_description = ''
        , memory_used = '192593448'
        WHERE id = '107969';
[04/12/2024 05:39:58], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '707',
        request_path = '/xml_all.php?userid=7856&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9',
        duration = '3.464',
        merge_duration = '0.003',
        assigned_supplier_count = '3',
        searched_supplier_count = '3',
        system_load_1_min = '0.14',
        system_load_5_min = '0.39',
        system_load_15_min = '0.60',
        system_memory_usage = '55.97',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '901') + '1955656',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '901';
[04/12/2024 05:39:59], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:39:59' WHERE id= '768';
[04/12/2024 05:40:01], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:40:01' WHERE id= '768';
[04/12/2024 05:44:46], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:44:46' WHERE id= '768';
[04/12/2024 05:44:49], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:44:49' WHERE id= '768';
[04/12/2024 05:44:49], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:44:49' WHERE id= '768';
[04/12/2024 05:44:52], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:44:52' WHERE id= '768';
[04/12/2024 05:45:09], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:45:09' WHERE id= '768';
[04/12/2024 05:45:11], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:45:11' WHERE id= '768';
[04/12/2024 05:46:23], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:46:23' WHERE id= '768';
[04/12/2024 05:46:25], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:46:25' WHERE id= '768';
[04/12/2024 05:46:59], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:46:59' WHERE id= '768';
[04/12/2024 05:47:01], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:47:01' WHERE id= '768';
[04/12/2024 05:48:15], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:48:15' WHERE id= '768';
[04/12/2024 05:48:52], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:48:52' WHERE id= '768';
[04/12/2024 05:48:54], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:48:54' WHERE id= '768';
[04/12/2024 05:54:48], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:54:48' WHERE id= '768';
[04/12/2024 05:54:48], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-04-12 05:54:48',login_attempt=0 where id = '7856';
[04/12/2024 05:54:48], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'future_destination', user_type = 'A', branch_id = '1', login_datetime = '2024-04-12 05:54:48', ip = '43.239.53.130', action = 'Login' ;
[04/12/2024 05:54:48], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:54:48' WHERE id= '768';
[04/12/2024 05:54:52], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:54:52' WHERE id= '768';
[04/12/2024 05:54:56], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:54:56' WHERE id= '768';
[04/12/2024 05:54:56], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7856' , 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/18' , departure_date = '2024/04/19' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-04-12 05:54:56' , 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/12/2024 05:54:57], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:54:57' WHERE id= '768';
[04/12/2024 05:54:57], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-04-12 05:54:57', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '902');
[04/12/2024 05:54:57], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=localsystem&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&request_no=0&local_hotel_code=5&#039;,&#039;6&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-04-12 05:54:57.715'
        , 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.093'
        , error_description = ''
        , memory_used = '1840784'
        WHERE id = '107970';
[04/12/2024 05:54:57], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/12_04_2024/request_availability_future_destination_902_1712901297_74.json', 'e1p/12_04_2024/response_availability_future_destination_902_1712901297_74.json', 'e1p/12_04_2024/response_header_availability_future_destination_902_1712901297_74.json', 'expediapackage', '2024-04-12 05:54:57', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '902');
[04/12/2024 05:54:57], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&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-12 05:54:57.715'
        , 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.270'
        , error_description = ''
        , memory_used = '1560760'
        WHERE id = '107971';
[04/12/2024 05:54:58], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/12_04_2024/request_availability_future_destination_902_1712901297_91.json', 'e1/12_04_2024/response_availability_future_destination_902_1712901297_91.json', 'e1/12_04_2024/response_header_availability_future_destination_902_1712901297_91.json', 'expedia', '2024-04-12 05:54:58', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '902');
[04/12/2024 05:54:58], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&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-12 05:54:57.715'
        , 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.346'
        , error_description = ''
        , memory_used = '1560280'
        WHERE id = '107972';
[04/12/2024 05:54:58], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/12_04_2024/request_availability_future_destination_902_1712901297_37.json', 'e1/12_04_2024/response_availability_future_destination_902_1712901297_37.json', 'e1/12_04_2024/response_header_availability_future_destination_902_1712901297_37.json', 'expedia', '2024-04-12 05:54:58', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '902');
[04/12/2024 05:54:58], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/12_04_2024/request_availability_future_destination_902_1712901297_62.json', 'e1/12_04_2024/response_availability_future_destination_902_1712901297_62.json', 'e1/12_04_2024/response_header_availability_future_destination_902_1712901297_62.json', 'expedia', '2024-04-12 05:54:58', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '902');
[04/12/2024 05:54:59], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/12_04_2024/request_availability_future_destination_902_1712901297_23.json', 'e1p/12_04_2024/response_availability_future_destination_902_1712901297_23.json', 'e1p/12_04_2024/response_header_availability_future_destination_902_1712901297_23.json', 'expediapackage', '2024-04-12 05:54:59', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '902');
[04/12/2024 05:54:59], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/12_04_2024/request_availability_future_destination_902_1712901297_57.json', 'e1p/12_04_2024/response_availability_future_destination_902_1712901297_57.json', 'e1p/12_04_2024/response_header_availability_future_destination_902_1712901297_57.json', 'expediapackage', '2024-04-12 05:54:59', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '902');
[04/12/2024 05:54:59], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&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-12 05:54:57.715'
        , 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.865'
        , error_description = ''
        , memory_used = '122804912'
        WHERE id = '107973';
[04/12/2024 05:54:59], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&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-12 05:54:57.715'
        , 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.233'
        , error_description = ''
        , memory_used = '149267320'
        WHERE id = '107974';
[04/12/2024 05:55:00], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&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-12 05:54:57.715'
        , 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.551'
        , error_description = ''
        , memory_used = '128600960'
        WHERE id = '107976';
[04/12/2024 05:55:00], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&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-12 05:54:57.715'
        , 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.621'
        , error_description = ''
        , memory_used = '155565368'
        WHERE id = '107975';
[04/12/2024 05:55:00], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '666',
        request_path = '/xml_all.php?userid=7856&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9',
        duration = '2.786',
        merge_duration = '0.003',
        assigned_supplier_count = '3',
        searched_supplier_count = '3',
        system_load_1_min = '0.18',
        system_load_5_min = '0.23',
        system_load_15_min = '0.40',
        system_memory_usage = '56.25',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '902') + '1955744',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '902';
[04/12/2024 05:55:00], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:55:00' WHERE id= '768';
[04/12/2024 05:55:03], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:55:03' WHERE id= '768';
[04/12/2024 05:55:52], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:55:52' WHERE id= '768';
[04/12/2024 05:55:52], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-04-12 05:55:52',login_attempt=0 where id = '7856';
[04/12/2024 05:55:52], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'future_destination', user_type = 'A', branch_id = '1', login_datetime = '2024-04-12 05:55:52', ip = '43.239.53.130', action = 'Login' ;
[04/12/2024 05:55:52], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:55:52' WHERE id= '768';
[04/12/2024 05:55:58], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:55:58' WHERE id= '768';
[04/12/2024 05:56:08], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:56:08' WHERE id= '768';
[04/12/2024 05:56:08], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7856' , 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/26' , departure_date = '2024/04/27' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-04-12 05:56:08' , 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/12/2024 05:56:09], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:56:09' WHERE id= '768';
[04/12/2024 05:56: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', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-04-12 05:56:09', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '903');
[04/12/2024 05:56:09], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=localsystem&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&request_no=0&local_hotel_code=5&#039;,&#039;6&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-04-12 05:56:09.218'
        , 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.098'
        , error_description = ''
        , memory_used = '1592200'
        WHERE id = '107977';
[04/12/2024 05:56: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', 'e1p/12_04_2024/request_availability_future_destination_903_1712901369_69.json', 'e1p/12_04_2024/response_availability_future_destination_903_1712901369_69.json', 'e1p/12_04_2024/response_header_availability_future_destination_903_1712901369_69.json', 'expediapackage', '2024-04-12 05:56:09', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '903');
[04/12/2024 05:56:09], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&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-12 05:56:09.218'
        , 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.231'
        , error_description = ''
        , memory_used = '1560760'
        WHERE id = '107978';
[04/12/2024 05:56: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/12_04_2024/request_availability_future_destination_903_1712901369_99.json', 'e1/12_04_2024/response_availability_future_destination_903_1712901369_99.json', 'e1/12_04_2024/response_header_availability_future_destination_903_1712901369_99.json', 'expedia', '2024-04-12 05:56:09', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '903');
[04/12/2024 05:56:09], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&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-12 05:56:09.218'
        , 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.239'
        , error_description = ''
        , memory_used = '1560280'
        WHERE id = '107979';
[04/12/2024 05:56: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', 'e1/12_04_2024/request_availability_future_destination_903_1712901369_13.json', 'e1/12_04_2024/response_availability_future_destination_903_1712901369_13.json', 'e1/12_04_2024/response_header_availability_future_destination_903_1712901369_13.json', 'expedia', '2024-04-12 05:56:10', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '903');
[04/12/2024 05:56:11], [file name :-/home/otrams/public_html/beta/call.php],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/12_04_2024/request_availability_future_destination_903_1712901369_57.json', 'e1p/12_04_2024/response_availability_future_destination_903_1712901369_57.json', 'e1p/12_04_2024/response_header_availability_future_destination_903_1712901369_57.json', 'expediapackage', '2024-04-12 05:56:10', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '903');
[04/12/2024 05:56:11], [file name :-/home/otrams/public_html/beta/call.php],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/12_04_2024/request_availability_future_destination_903_1712901369_11.json', 'e1p/12_04_2024/response_availability_future_destination_903_1712901369_11.json', 'e1p/12_04_2024/response_header_availability_future_destination_903_1712901369_11.json', 'expediapackage', '2024-04-12 05:56:11', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '903');
[04/12/2024 05:56:11], [file name :-/home/otrams/public_html/beta/call.php],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/12_04_2024/request_availability_future_destination_903_1712901369_27.json', 'e1/12_04_2024/response_availability_future_destination_903_1712901369_27.json', 'e1/12_04_2024/response_header_availability_future_destination_903_1712901369_27.json', 'expedia', '2024-04-12 05:56:11', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '903');
[04/12/2024 05:56:11], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&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-12 05:56:09.218'
        , 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.419'
        , error_description = ''
        , memory_used = '158865112'
        WHERE id = '107980';
[04/12/2024 05:56:12], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&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-12 05:56:09.217'
        , 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.561'
        , error_description = ''
        , memory_used = '197963976'
        WHERE id = '107981';
[04/12/2024 05:56:12], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&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-12 05:56:09.218'
        , 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.602'
        , error_description = ''
        , memory_used = '166947696'
        WHERE id = '107982';
[04/12/2024 05:56:13], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&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-12 05:56:09.219'
        , 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.890'
        , error_description = ''
        , memory_used = '188614040'
        WHERE id = '107983';
[04/12/2024 05:56:13], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '707',
        request_path = '/xml_all.php?userid=7856&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9',
        duration = '4.071',
        merge_duration = '0.003',
        assigned_supplier_count = '3',
        searched_supplier_count = '3',
        system_load_1_min = '5.12',
        system_load_5_min = '1.64',
        system_load_15_min = '0.87',
        system_memory_usage = '56.38',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '903') + '1955768',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '903';
[04/12/2024 05:56:13], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:56:13' WHERE id= '768';
[04/12/2024 05:56:14], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:56:14' WHERE id= '768';
[04/12/2024 05:56:16], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:56:16' WHERE id= '768';
[04/12/2024 05:57:26], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:57:26' WHERE id= '769';
[04/12/2024 05:57:26], [file name :-/home/otrams/public_html/beta/index.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:57:26' WHERE id= '769';
[04/12/2024 05:57:27], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:57:27' WHERE id= '769';
[04/12/2024 05:57:32], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:57:32' WHERE id= '769';
[04/12/2024 05:57:41], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:57:41' WHERE id= '769';
[04/12/2024 05:57:41], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '27' , 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-12 05:57:41' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'SAR' , currency_code = 'SAR' , web_service = '' ;
[04/12/2024 05:57:41], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:57:41' WHERE id= '769';
[04/12/2024 05:57:41], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-04-12 05:57:41.981'
            , total_duration = '0.015'
            , hotel_count = 0
            , source_type = 'hotelbeds'
            , create_date = '2024-04-12 05:57:41'
            , session_id = 'f0b7acf331c136916ee0f73f410c87c69f0ea5d9e53b45f3c6afe54d5d9279a8'
            , agent_logs_id = '904'
            , error_description = ''
            , memory_used = '1811168';
[04/12/2024 05:57:41], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-04-12 05:57:41.981'
            , total_duration = '0.018'
            , hotel_count = 0
            , source_type = 'hotelbeds'
            , create_date = '2024-04-12 05:57:41'
            , session_id = 'f0b7acf331c136916ee0f73f410c87c69f0ea5d9e53b45f3c6afe54d5d9279a8'
            , agent_logs_id = '904'
            , error_description = ''
            , memory_used = '1811216';
[04/12/2024 05:57:41], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-04-12 05:57:41.981'
            , total_duration = '0.019'
            , hotel_count = 0
            , source_type = 'hotelbeds'
            , create_date = '2024-04-12 05:57:41'
            , session_id = 'f0b7acf331c136916ee0f73f410c87c69f0ea5d9e53b45f3c6afe54d5d9279a8'
            , agent_logs_id = '904'
            , error_description = ''
            , memory_used = '1811168';
[04/12/2024 05:57:41], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-04-12 05:57:41.981'
            , total_duration = '0.019'
            , hotel_count = 0
            , source_type = 'hotelbeds'
            , create_date = '2024-04-12 05:57:41'
            , session_id = 'f0b7acf331c136916ee0f73f410c87c69f0ea5d9e53b45f3c6afe54d5d9279a8'
            , agent_logs_id = '904'
            , error_description = ''
            , memory_used = '1811168';
[04/12/2024 05:57:42], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-04-12 05:57:41.981'
            , total_duration = '0.019'
            , hotel_count = 0
            , source_type = 'hotelbeds'
            , create_date = '2024-04-12 05:57:42'
            , session_id = 'f0b7acf331c136916ee0f73f410c87c69f0ea5d9e53b45f3c6afe54d5d9279a8'
            , agent_logs_id = '904'
            , error_description = ''
            , memory_used = '1811168';
[04/12/2024 05:57:42], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-04-12 05:57:41.981'
            , total_duration = '0.020'
            , hotel_count = 0
            , source_type = 'hotelbeds'
            , create_date = '2024-04-12 05:57:42'
            , session_id = 'f0b7acf331c136916ee0f73f410c87c69f0ea5d9e53b45f3c6afe54d5d9279a8'
            , agent_logs_id = '904'
            , error_description = ''
            , memory_used = '1811168';
[04/12/2024 05:57: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/12_04_2024/request_availability_Viator_test_904_1712901462_71.json', 'e1/12_04_2024/response_availability_Viator_test_904_1712901462_71.json', 'e1/12_04_2024/response_header_availability_Viator_test_904_1712901462_71.json', 'expedia', '2024-04-12 05:57:42', '', 'f0b7acf331c136916ee0f73f410c87c69f0ea5d9e53b45f3c6afe54d5d9279a8', '904');
[04/12/2024 05:57:42], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=f0b7acf331c136916ee0f73f410c87c69f0ea5d9e53b45f3c6afe54d5d9279a8&xml_user_id=7851&db_caching=1&erequest=2&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-12 05:57:41.981'
        , 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.231'
        , error_description = ''
        , memory_used = '1560160'
        WHERE id = '107990';
[04/12/2024 05:57:43], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/12_04_2024/request_availability_Viator_test_904_1712901462_15.json', 'e1/12_04_2024/response_availability_Viator_test_904_1712901462_15.json', 'e1/12_04_2024/response_header_availability_Viator_test_904_1712901462_15.json', 'expedia', '2024-04-12 05:57:43', '', 'f0b7acf331c136916ee0f73f410c87c69f0ea5d9e53b45f3c6afe54d5d9279a8', '904');
[04/12/2024 05:57:43], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/12_04_2024/request_availability_Viator_test_904_1712901462_8.json', 'e1/12_04_2024/response_availability_Viator_test_904_1712901462_8.json', 'e1/12_04_2024/response_header_availability_Viator_test_904_1712901462_8.json', 'expedia', '2024-04-12 05:57:43', '', 'f0b7acf331c136916ee0f73f410c87c69f0ea5d9e53b45f3c6afe54d5d9279a8', '904');
[04/12/2024 05:57:44], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=f0b7acf331c136916ee0f73f410c87c69f0ea5d9e53b45f3c6afe54d5d9279a8&xml_user_id=7851&db_caching=1&erequest=1&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-12 05:57:41.981'
        , 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.669'
        , error_description = ''
        , memory_used = '151977448'
        WHERE id = '107992';
[04/12/2024 05:57:44], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=f0b7acf331c136916ee0f73f410c87c69f0ea5d9e53b45f3c6afe54d5d9279a8&xml_user_id=7851&db_caching=1&erequest=0&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-12 05:57:41.981'
        , 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.754'
        , error_description = ''
        , memory_used = '183451072'
        WHERE id = '107991';
[04/12/2024 05:57:44], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '354',
        request_path = '/xml_all.php?userid=7851&sessionid=f0b7acf331c136916ee0f73f410c87c69f0ea5d9e53b45f3c6afe54d5d9279a8',
        duration = '2.933',
        merge_duration = '0.002',
        assigned_supplier_count = '2',
        searched_supplier_count = '2',
        system_load_1_min = '9.84',
        system_load_5_min = '4.34',
        system_load_15_min = '1.92',
        system_memory_usage = '56.67',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '904') + '1949920',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '904';
[04/12/2024 05:57:45], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:57:45' WHERE id= '769';
[04/12/2024 05:57:46], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:57:46' WHERE id= '769';
[04/12/2024 05:58:11], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:58:11' WHERE id= '768';
[04/12/2024 05:58:11], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-04-12 05:58:11',login_attempt=0 where id = '7856';
[04/12/2024 05:58:11], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'future_destination', user_type = 'A', branch_id = '1', login_datetime = '2024-04-12 05:58:11', ip = '43.239.53.130', action = 'Login' ;
[04/12/2024 05:58:11], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:58:11' WHERE id= '768';
[04/12/2024 05:58:18], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:58:18' WHERE id= '768';
[04/12/2024 05:58:32], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:58:32' WHERE id= '768';
[04/12/2024 05:58:32], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7856' , 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/18' , departure_date = '2024/04/19' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-04-12 05:58:32' , 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/12/2024 05:58:33], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:58:33' WHERE id= '768';
[04/12/2024 05:58: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', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-04-12 05:58:33', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '905');
[04/12/2024 05:58:33], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=localsystem&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&request_no=0&local_hotel_code=5&#039;,&#039;6&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-04-12 05:58:33.192'
        , 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.108'
        , error_description = ''
        , memory_used = '1592200'
        WHERE id = '107993';
[04/12/2024 05:58: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/12_04_2024/request_availability_future_destination_905_1712901513_9.json', 'e1p/12_04_2024/response_availability_future_destination_905_1712901513_9.json', 'e1p/12_04_2024/response_header_availability_future_destination_905_1712901513_9.json', 'expediapackage', '2024-04-12 05:58:33', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '905');
[04/12/2024 05:58:33], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&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-12 05:58:33.192'
        , 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 = '1560736'
        WHERE id = '107994';
[04/12/2024 05:58: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/12_04_2024/request_availability_future_destination_905_1712901513_68.json', 'e1/12_04_2024/response_availability_future_destination_905_1712901513_68.json', 'e1/12_04_2024/response_header_availability_future_destination_905_1712901513_68.json', 'expedia', '2024-04-12 05:58:33', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '905');
[04/12/2024 05:58:33], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&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-12 05:58:33.192'
        , 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.385'
        , error_description = ''
        , memory_used = '1560280'
        WHERE id = '107995';
[04/12/2024 05:58:34], [file name :-/home/otrams/public_html/beta/call.php],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/12_04_2024/request_availability_future_destination_905_1712901513_13.json', 'e1/12_04_2024/response_availability_future_destination_905_1712901513_13.json', 'e1/12_04_2024/response_header_availability_future_destination_905_1712901513_13.json', 'expedia', '2024-04-12 05:58:34', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '905');
[04/12/2024 05:58:34], [file name :-/home/otrams/public_html/beta/call.php],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/12_04_2024/request_availability_future_destination_905_1712901513_50.json', 'e1/12_04_2024/response_availability_future_destination_905_1712901513_50.json', 'e1/12_04_2024/response_header_availability_future_destination_905_1712901513_50.json', 'expedia', '2024-04-12 05:58:34', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '905');
[04/12/2024 05:58:34], [file name :-/home/otrams/public_html/beta/call.php],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/12_04_2024/request_availability_future_destination_905_1712901513_72.json', 'e1p/12_04_2024/response_availability_future_destination_905_1712901513_72.json', 'e1p/12_04_2024/response_header_availability_future_destination_905_1712901513_72.json', 'expediapackage', '2024-04-12 05:58:34', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '905');
[04/12/2024 05:58:34], [file name :-/home/otrams/public_html/beta/call.php],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/12_04_2024/request_availability_future_destination_905_1712901513_18.json', 'e1p/12_04_2024/response_availability_future_destination_905_1712901513_18.json', 'e1p/12_04_2024/response_header_availability_future_destination_905_1712901513_18.json', 'expediapackage', '2024-04-12 05:58:34', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '905');
[04/12/2024 05:58:35], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&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-12 05:58:33.192'
        , 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.239'
        , error_description = ''
        , memory_used = '123100888'
        WHERE id = '107996';
[04/12/2024 05:58:35], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&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-12 05:58:33.192'
        , 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.610'
        , error_description = ''
        , memory_used = '149267184'
        WHERE id = '107997';
[04/12/2024 05:58:36], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&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-12 05:58:33.192'
        , 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.930'
        , error_description = ''
        , memory_used = '129144480'
        WHERE id = '107999';
[04/12/2024 05:58:36], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9&xml_user_id=7856&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-12 05:58:33.192'
        , 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.182'
        , error_description = ''
        , memory_used = '155577368'
        WHERE id = '107998';
[04/12/2024 05:58:36], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '666',
        request_path = '/xml_all.php?userid=7856&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9',
        duration = '3.364',
        merge_duration = '0.003',
        assigned_supplier_count = '3',
        searched_supplier_count = '3',
        system_load_1_min = '8.99',
        system_load_5_min = '4.95',
        system_load_15_min = '2.25',
        system_memory_usage = '56.47',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '905') + '1955312',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '905';
[04/12/2024 05:58:36], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:58:36' WHERE id= '768';
[04/12/2024 05:58:39], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 05:58:39' WHERE id= '768';
