[04/12/2024 01:05:13], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 01:05:13' WHERE id= '768';
[04/12/2024 01:05:13], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-04-12 01:05:13',login_attempt=0 where id = '7873';
[04/12/2024 01:05:13], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Gajendra', user_type = 'A', branch_id = '1', login_datetime = '2024-04-12 13:05:13', ip = '43.239.53.130', action = 'Login' ;
[04/12/2024 01:05:13], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 01:05:13' WHERE id= '768';
[04/12/2024 01:05:21], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 01:05:21' WHERE id= '768';
[04/12/2024 01:05:27], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 01:05:27' WHERE id= '768';
[04/12/2024 01:05:27], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7873' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/04/24' , departure_date = '2024/04/25' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-04-12 13:05:27' , 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 01:05:28], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 01:05:28' WHERE id= '768';
[04/12/2024 01:05:28], [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_Gajendra_933_1712927128_8.json', 'e1/12_04_2024/response_availability_Gajendra_933_1712927128_8.json', 'e1/12_04_2024/response_header_availability_Gajendra_933_1712927128_8.json', 'expedia', '2024-04-12 01:05:28', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '933');
[04/12/2024 01:05: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=7873&db_caching=1&erequest=2&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-12 13:05:28.160'
        , 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.285'
        , error_description = ''
        , memory_used = '4133344'
        WHERE id = '108299';
[04/12/2024 01:05:28], [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_Gajendra_933_1712927128_39.json', 'e1p/12_04_2024/response_availability_Gajendra_933_1712927128_39.json', 'e1p/12_04_2024/response_header_availability_Gajendra_933_1712927128_39.json', 'expediapackage', '2024-04-12 01:05:28', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '933');
[04/12/2024 01:05:28], [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=7873&db_caching=1&erequest=2&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-12 13:05:28.160'
        , 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.539'
        , error_description = ''
        , memory_used = '4133840'
        WHERE id = '108300';
[04/12/2024 01:05:29], [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_Gajendra_933_1712927128_66.json', 'e1/12_04_2024/response_availability_Gajendra_933_1712927128_66.json', 'e1/12_04_2024/response_header_availability_Gajendra_933_1712927128_66.json', 'expedia', '2024-04-12 01:05:29', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '933');
[04/12/2024 01:05:29], [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_Gajendra_933_1712927128_30.json', 'e1/12_04_2024/response_availability_Gajendra_933_1712927128_30.json', 'e1/12_04_2024/response_header_availability_Gajendra_933_1712927128_30.json', 'expedia', '2024-04-12 01:05:29', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '933');
[04/12/2024 01:05:29], [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_Gajendra_933_1712927128_72.json', 'e1p/12_04_2024/response_availability_Gajendra_933_1712927128_72.json', 'e1p/12_04_2024/response_header_availability_Gajendra_933_1712927128_72.json', 'expediapackage', '2024-04-12 01:05:29', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '933');
[04/12/2024 01:05:30], [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_Gajendra_933_1712927128_96.json', 'e1p/12_04_2024/response_availability_Gajendra_933_1712927128_96.json', 'e1p/12_04_2024/response_header_availability_Gajendra_933_1712927128_96.json', 'expediapackage', '2024-04-12 01:05:30', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '933');
[04/12/2024 01:05: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=7873&db_caching=1&erequest=1&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-12 13:05:28.160'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '4.849'
        , error_description = ''
        , memory_used = '151880752'
        WHERE id = '108302';
[04/12/2024 01:05: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=7873&db_caching=1&erequest=1&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-12 13:05:28.160'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '5.162'
        , error_description = ''
        , memory_used = '159899000'
        WHERE id = '108303';
[04/12/2024 01:05: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=7873&db_caching=1&erequest=0&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-12 13:05:28.160'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '5.538'
        , error_description = ''
        , memory_used = '182471456'
        WHERE id = '108301';
[04/12/2024 01:05:34], [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=7873&db_caching=1&erequest=0&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-12 13:05:28.160'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '6.572'
        , error_description = ''
        , memory_used = '193159224'
        WHERE id = '108304';
[04/12/2024 01:05:35], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7873&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9',
        duration = '6.970',
        merge_duration = '0.129',
        assigned_supplier_count = '2',
        searched_supplier_count = '2',
        system_load_1_min = '10.61',
        system_load_5_min = '5.36',
        system_load_15_min = '3.88',
        system_memory_usage = '84.42',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '933') + '497410888',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '933';
[04/12/2024 01:05:35], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 01:05:35' WHERE id= '768';
[04/12/2024 01:05:35], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 01:05:35' WHERE id= '768';
[04/12/2024 01:05:35], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 01:05:35' WHERE id= '768';
[04/12/2024 01:05:37], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 01:05:37' WHERE id= '768';
[04/12/2024 01:06:02], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 01:06:02' WHERE id= '768';
[04/12/2024 01:06:13], [file name :-/home/otrams/public_html/beta/call.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 01:06:13' WHERE id= '768';
[04/12/2024 01:06: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_Gajendra_933_1712927173_39.json', 'e1/12_04_2024/response_availability_Gajendra_933_1712927173_39.json', 'e1/12_04_2024/response_header_availability_Gajendra_933_1712927173_39.json', 'expedia', '2024-04-12 01:06:15', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '933');
[04/12/2024 01:06:18], [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=7873&db_caching=1&erequest=0&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106&debug-1'
        , http_hit_time = '2024-04-12 13:06:13.906'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '4.146'
        , error_description = ''
        , memory_used = '182757256'
        WHERE id = '108305';
[04/12/2024 01:06:24], [file name :-/home/otrams/public_html/beta/call.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 01:06:24' WHERE id= '768';
[04/12/2024 01:06: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_Gajendra_933_1712927184_91.json', 'e1/12_04_2024/response_availability_Gajendra_933_1712927184_91.json', 'e1/12_04_2024/response_header_availability_Gajendra_933_1712927184_91.json', 'expedia', '2024-04-12 01:06:26', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '933');
[04/12/2024 01:06: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=7873&db_caching=1&erequest=0&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-12 13:06:24.909'
        , 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 = '8.304'
        , error_description = ''
        , memory_used = '182713696'
        WHERE id = '108306';
[04/12/2024 01:07:19], [file name :-/home/otrams/public_html/beta/call.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 01:07:19' WHERE id= '768';
[04/12/2024 01:07:20], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/12_04_2024/request_availability_Gajendra_933_1712927239_10.json', 'e1/12_04_2024/response_availability_Gajendra_933_1712927239_10.json', 'e1/12_04_2024/response_header_availability_Gajendra_933_1712927239_10.json', 'expedia', '2024-04-12 01:07:20', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '933');
[04/12/2024 01:07: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=7873&db_caching=1&erequest=1&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-12 13:07:19.700'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '6.533'
        , error_description = ''
        , memory_used = '151991792'
        WHERE id = '108307';
[04/12/2024 01:11:43], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 01:11:43' WHERE id= '768';
[04/12/2024 01:11:43], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-04-12 01:11:43',login_attempt=0 where id = '7873';
[04/12/2024 01:11:43], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Gajendra', user_type = 'A', branch_id = '1', login_datetime = '2024-04-12 13:11:43', ip = '43.239.53.130', action = 'Login' ;
[04/12/2024 01:11:44], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 01:11:44' WHERE id= '768';
[04/12/2024 01:11:54], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 01:11:54' WHERE id= '768';
[04/12/2024 01:12:00], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 01:12:00' WHERE id= '768';
[04/12/2024 01:12:00], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7873' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/04/23' , departure_date = '2024/04/24' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-04-12 13:12:00' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[04/12/2024 01:12:00], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 01:12:00' WHERE id= '768';
[04/12/2024 01:12: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_Gajendra_934_1712927521_82.json', 'e1/12_04_2024/response_availability_Gajendra_934_1712927521_82.json', 'e1/12_04_2024/response_header_availability_Gajendra_934_1712927521_82.json', 'expedia', '2024-04-12 01:12:01', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '934');
[04/12/2024 01:12: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=7873&db_caching=1&erequest=2&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-12 13:12:01.15'
        , 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.500'
        , error_description = ''
        , memory_used = '4133696'
        WHERE id = '108308';
[04/12/2024 01:12: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_Gajendra_934_1712927521_88.json', 'e1p/12_04_2024/response_availability_Gajendra_934_1712927521_88.json', 'e1p/12_04_2024/response_header_availability_Gajendra_934_1712927521_88.json', 'expediapackage', '2024-04-12 01:12:01', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '934');
[04/12/2024 01:12: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=7873&db_caching=1&erequest=2&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-12 13:12:01.15'
        , 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.509'
        , error_description = ''
        , memory_used = '4133416'
        WHERE id = '108309';
[04/12/2024 01:12: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_Gajendra_934_1712927521_37.json', 'e1/12_04_2024/response_availability_Gajendra_934_1712927521_37.json', 'e1/12_04_2024/response_header_availability_Gajendra_934_1712927521_37.json', 'expedia', '2024-04-12 01:12:02', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '934');
[04/12/2024 01:12: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_Gajendra_934_1712927521_37.json', 'e1/12_04_2024/response_availability_Gajendra_934_1712927521_37.json', 'e1/12_04_2024/response_header_availability_Gajendra_934_1712927521_37.json', 'expedia', '2024-04-12 01:12:02', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '934');
[04/12/2024 01:12: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_Gajendra_934_1712927521_7.json', 'e1p/12_04_2024/response_availability_Gajendra_934_1712927521_7.json', 'e1p/12_04_2024/response_header_availability_Gajendra_934_1712927521_7.json', 'expediapackage', '2024-04-12 01:12:02', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '934');
[04/12/2024 01:12: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_Gajendra_934_1712927521_60.json', 'e1p/12_04_2024/response_availability_Gajendra_934_1712927521_60.json', 'e1p/12_04_2024/response_header_availability_Gajendra_934_1712927521_60.json', 'expediapackage', '2024-04-12 01:12:02', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '934');
[04/12/2024 01:12:05], [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=7873&db_caching=1&erequest=1&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-12 13:12:01.15'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '4.814'
        , error_description = ''
        , memory_used = '148042664'
        WHERE id = '108311';
[04/12/2024 01:12:05], [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=7873&db_caching=1&erequest=1&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-12 13:12:01.15'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '4.896'
        , error_description = ''
        , memory_used = '155206088'
        WHERE id = '108313';
[04/12/2024 01:12:05], [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=7873&db_caching=1&erequest=0&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-12 13:12:01.15'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '4.925'
        , error_description = ''
        , memory_used = '177071152'
        WHERE id = '108310';
[04/12/2024 01:12:06], [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=7873&db_caching=1&erequest=0&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-12 13:12:01.15'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '5.961'
        , error_description = ''
        , memory_used = '186654248'
        WHERE id = '108312';
[04/12/2024 01:12:07], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7873&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9',
        duration = '6.403',
        merge_duration = '0.136',
        assigned_supplier_count = '2',
        searched_supplier_count = '2',
        system_load_1_min = '0.54',
        system_load_5_min = '2.28',
        system_load_15_min = '2.96',
        system_memory_usage = '83.81',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '934') + '509528496',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '934';
[04/12/2024 01:12:07], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 01:12:07' WHERE id= '768';
[04/12/2024 01:12:07], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 01:12:07' WHERE id= '768';
[04/12/2024 01:12:08], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 01:12:08' WHERE id= '768';
[04/12/2024 01:12:10], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 01:12:10' WHERE id= '768';
[04/12/2024 01:12:24], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 01:12:24' WHERE id= '768';
[04/12/2024 01:12:35], [file name :-/home/otrams/public_html/beta/call.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 01:12:35' WHERE id= '768';
[04/12/2024 01:12:37], [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_Gajendra_934_1712927555_42.json', 'e1/12_04_2024/response_availability_Gajendra_934_1712927555_42.json', 'e1/12_04_2024/response_header_availability_Gajendra_934_1712927555_42.json', 'expedia', '2024-04-12 01:12:37', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '934');
[04/12/2024 01:12: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=7873&db_caching=1&erequest=0&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-12 13:12:35.538'
        , 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 = '8.223'
        , error_description = ''
        , memory_used = '177191120'
        WHERE id = '108314';
[04/12/2024 01:15:46], [file name :-/home/otrams/public_html/beta/call.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 01:15:46' WHERE id= '768';
[04/12/2024 01:15:47], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/12_04_2024/request_availability_Gajendra_934_1712927746_15.json', 'e1/12_04_2024/response_availability_Gajendra_934_1712927746_15.json', 'e1/12_04_2024/response_header_availability_Gajendra_934_1712927746_15.json', 'expedia', '2024-04-12 01:15:47', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '934');
[04/12/2024 01:15:52], [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=7873&db_caching=1&erequest=0&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-12 13:15:46.280'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '6.377'
        , error_description = ''
        , memory_used = '177181752'
        WHERE id = '108315';
[04/12/2024 01:18:51], [file name :-/home/otrams/public_html/beta/call.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 01:18:51' WHERE id= '768';
[04/12/2024 01:18:53], [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_Gajendra_934_1712927931_85.json', 'e1/12_04_2024/response_availability_Gajendra_934_1712927931_85.json', 'e1/12_04_2024/response_header_availability_Gajendra_934_1712927931_85.json', 'expedia', '2024-04-12 01:18:53', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '934');
[04/12/2024 01:18:54], [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=7873&db_caching=1&erequest=1&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-12 13:18:51.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.553'
        , error_description = ''
        , memory_used = '148080240'
        WHERE id = '108316';
[04/12/2024 01:26:25], [file name :-/home/otrams/public_html/beta/call.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 01:26:25' WHERE id= '768';
[04/12/2024 01:26: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_Gajendra_934_1712928385_59.json', 'e1/12_04_2024/response_availability_Gajendra_934_1712928385_59.json', 'e1/12_04_2024/response_header_availability_Gajendra_934_1712928385_59.json', 'expedia', '2024-04-12 01:26:26', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '934');
[04/12/2024 01:26:27], [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=7873&db_caching=1&erequest=1&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-12 13:26:25.206'
        , 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.376'
        , error_description = ''
        , memory_used = '148078528'
        WHERE id = '108317';
[04/12/2024 01:27:03], [file name :-/home/otrams/public_html/beta/call.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 01:27:03' WHERE id= '768';
[04/12/2024 01:27:04], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/12_04_2024/request_availability_Gajendra_934_1712928424_75.json', 'e1/12_04_2024/response_availability_Gajendra_934_1712928424_75.json', 'e1/12_04_2024/response_header_availability_Gajendra_934_1712928424_75.json', 'expedia', '2024-04-12 01:27:04', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '934');
[04/12/2024 01:27:06], [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=7873&db_caching=1&erequest=1&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-12 13:27:03.950'
        , 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.219'
        , error_description = ''
        , memory_used = '148198376'
        WHERE id = '108318';
