[04/12/2024 11:35:32], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-04-12 11:35:32',login_attempt=0 where id = '7873';
[04/12/2024 11:35:32], [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 11:35:32', ip = '43.239.53.130', action = 'Login' ;
[04/12/2024 11:35:32], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 11:35:32' WHERE id= '768';
[04/12/2024 11:35:39], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 11:35:39' WHERE id= '768';
[04/12/2024 11:35:45], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 11:35:45' WHERE id= '768';
[04/12/2024 11:35:45], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7873' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/04/26' , departure_date = '2024/04/27' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-04-12 11:35:45' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[04/12/2024 11:35:45], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 11:35:45' WHERE id= '768';
[04/12/2024 11:35:46], [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_921_1712921746_40.json', 'e1/12_04_2024/response_availability_Gajendra_921_1712921746_40.json', 'e1/12_04_2024/response_header_availability_Gajendra_921_1712921746_40.json', 'expedia', '2024-04-12 11:35:46', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '921');
[04/12/2024 11:35:46], [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 11:35:45.999'
        , 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.489'
        , error_description = ''
        , memory_used = '4112640'
        WHERE id = '108226';
[04/12/2024 11:35:46], [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_921_1712921746_4.json', 'e1p/12_04_2024/response_availability_Gajendra_921_1712921746_4.json', 'e1p/12_04_2024/response_header_availability_Gajendra_921_1712921746_4.json', 'expediapackage', '2024-04-12 11:35:46', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '921');
[04/12/2024 11:35:46], [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 11:35:45.998'
        , 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.505'
        , error_description = ''
        , memory_used = '4113080'
        WHERE id = '108227';
[04/12/2024 11:35: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_921_1712921746_57.json', 'e1/12_04_2024/response_availability_Gajendra_921_1712921746_57.json', 'e1/12_04_2024/response_header_availability_Gajendra_921_1712921746_57.json', 'expedia', '2024-04-12 11:35:47', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '921');
[04/12/2024 11:35: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_921_1712921746_91.json', 'e1/12_04_2024/response_availability_Gajendra_921_1712921746_91.json', 'e1/12_04_2024/response_header_availability_Gajendra_921_1712921746_91.json', 'expedia', '2024-04-12 11:35:47', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '921');
[04/12/2024 11:35:47], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/12_04_2024/request_availability_Gajendra_921_1712921746_38.json', 'e1p/12_04_2024/response_availability_Gajendra_921_1712921746_38.json', 'e1p/12_04_2024/response_header_availability_Gajendra_921_1712921746_38.json', 'expediapackage', '2024-04-12 11:35:47', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '921');
[04/12/2024 11:35:47], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/12_04_2024/request_availability_Gajendra_921_1712921746_21.json', 'e1p/12_04_2024/response_availability_Gajendra_921_1712921746_21.json', 'e1p/12_04_2024/response_header_availability_Gajendra_921_1712921746_21.json', 'expediapackage', '2024-04-12 11:35:47', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '921');
[04/12/2024 11:35:50], [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 11:35:45.998'
        , 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.144'
        , error_description = ''
        , memory_used = '162009448'
        WHERE id = '108228';
[04/12/2024 11:35:51], [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 11:35:45.998'
        , 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.157'
        , error_description = ''
        , memory_used = '189836592'
        WHERE id = '108229';
[04/12/2024 11:35:51], [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 11:35:45.998'
        , 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.760'
        , error_description = ''
        , memory_used = '170263392'
        WHERE id = '108230';
[04/12/2024 11:35:52], [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 11:35:45.998'
        , 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.208'
        , error_description = ''
        , memory_used = '200175800'
        WHERE id = '108231';
[04/12/2024 11:35:52], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '706',
        request_path = '/xml_all.php?userid=7873&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9',
        duration = '6.492',
        merge_duration = '0.030',
        assigned_supplier_count = '2',
        searched_supplier_count = '2',
        system_load_1_min = '1.56',
        system_load_5_min = '1.53',
        system_load_15_min = '2.10',
        system_memory_usage = '82.94',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '921') + '4212400',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '921';
[04/12/2024 11:35:52], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 11:35:52' WHERE id= '768';
[04/12/2024 11:35:52], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 11:35:52' WHERE id= '768';
[04/12/2024 11:35:53], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 11:35:53' WHERE id= '768';
[04/12/2024 11:35:54], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 11:35:54' WHERE id= '768';
[04/12/2024 11:36:12], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 11:36:12' WHERE id= '768';
[04/12/2024 11:36:12], [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/26' , departure_date = '2024/04/27' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-04-12 11:36:12' , 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 11:36:13], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 11:36:13' WHERE id= '768';
[04/12/2024 11:36: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_Gajendra_922_1712921773_52.json', 'e1/12_04_2024/response_availability_Gajendra_922_1712921773_52.json', 'e1/12_04_2024/response_header_availability_Gajendra_922_1712921773_52.json', 'expedia', '2024-04-12 11:36:13', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '922');
[04/12/2024 11:36: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=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 11:36:13.279'
        , 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.330'
        , error_description = ''
        , memory_used = '4111648'
        WHERE id = '108232';
[04/12/2024 11:36: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_Gajendra_922_1712921773_22.json', 'e1p/12_04_2024/response_availability_Gajendra_922_1712921773_22.json', 'e1p/12_04_2024/response_header_availability_Gajendra_922_1712921773_22.json', 'expediapackage', '2024-04-12 11:36:13', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '922');
[04/12/2024 11:36: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=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 11:36:13.279'
        , 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.416'
        , error_description = ''
        , memory_used = '4113080'
        WHERE id = '108233';
[04/12/2024 11:36: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_Gajendra_922_1712921773_13.json', 'e1/12_04_2024/response_availability_Gajendra_922_1712921773_13.json', 'e1/12_04_2024/response_header_availability_Gajendra_922_1712921773_13.json', 'expedia', '2024-04-12 11:36:14', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '922');
[04/12/2024 11:36: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_Gajendra_922_1712921773_1.json', 'e1/12_04_2024/response_availability_Gajendra_922_1712921773_1.json', 'e1/12_04_2024/response_header_availability_Gajendra_922_1712921773_1.json', 'expedia', '2024-04-12 11:36:14', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '922');
[04/12/2024 11:36: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_Gajendra_922_1712921773_5.json', 'e1p/12_04_2024/response_availability_Gajendra_922_1712921773_5.json', 'e1p/12_04_2024/response_header_availability_Gajendra_922_1712921773_5.json', 'expediapackage', '2024-04-12 11:36:14', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '922');
[04/12/2024 11:36: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_Gajendra_922_1712921773_17.json', 'e1p/12_04_2024/response_availability_Gajendra_922_1712921773_17.json', 'e1p/12_04_2024/response_header_availability_Gajendra_922_1712921773_17.json', 'expediapackage', '2024-04-12 11:36:15', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '922');
[04/12/2024 11:36: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=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 11:36:13.279'
        , 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.454'
        , error_description = ''
        , memory_used = '162092080'
        WHERE id = '108235';
[04/12/2024 11:36: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=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 11:36:13.279'
        , 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.698'
        , error_description = ''
        , memory_used = '189635224'
        WHERE id = '108234';
[04/12/2024 11:36: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=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 11:36:13.279'
        , 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.004'
        , error_description = ''
        , memory_used = '200268032'
        WHERE id = '108236';
[04/12/2024 11:36: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=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 11:36:13.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 = '3.259'
        , error_description = ''
        , memory_used = '169972192'
        WHERE id = '108237';
[04/12/2024 11:36:16], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '706',
        request_path = '/xml_all.php?userid=7873&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9',
        duration = '3.426',
        merge_duration = '0.004',
        assigned_supplier_count = '2',
        searched_supplier_count = '2',
        system_load_1_min = '3.30',
        system_load_5_min = '2.02',
        system_load_15_min = '2.25',
        system_memory_usage = '83.16',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '922') + '4212528',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '922';
[04/12/2024 11:36:16], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 11:36:16' WHERE id= '768';
[04/12/2024 11:36:18], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 11:36:18' WHERE id= '768';
[04/12/2024 11:36:47], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 11:36:47' WHERE id= '768';
[04/12/2024 11:36:53], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-04-12 11:36:53',login_attempt=0 where id = '7869';
[04/12/2024 11:36:53], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Viator', user_type = 'A', branch_id = '1', login_datetime = '2024-04-12 11:36:53', ip = '43.239.53.130', action = 'Login' ;
[04/12/2024 11:36:53], [file name :-/home/otrams/public_html/beta/hotel_search.php],insert into user_sessions_ip SET ip_addr='43.239.53.130', agent_id='7869', session_id='a0359b3d49350263d72c1c8017404347b6fad0c9f07a8198dcfef242eec99a13',create_date='2024-04-12 11:36:53', update_date='2024-04-12 11:36:53',domain='beta.astrabookings.com',sub_agent_id='',sub_user_id='';
[04/12/2024 11:37:06], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 11:37:06' WHERE id= '771';
[04/12/2024 11:37:09], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 11:37:09' WHERE id= '771';
[04/12/2024 11:37:11], [file name :-/home/otrams/public_html/beta/call.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 11:37:11' WHERE id= '768';
[04/12/2024 11:37: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_Gajendra_922_1712921831_24.json', 'e1/12_04_2024/response_availability_Gajendra_922_1712921831_24.json', 'e1/12_04_2024/response_header_availability_Gajendra_922_1712921831_24.json', 'expedia', '2024-04-12 11:37:12', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '922');
[04/12/2024 11: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=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 11:37:11.204'
        , 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.103'
        , error_description = ''
        , memory_used = '189743464'
        WHERE id = '108238';
[04/12/2024 11:37:16], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 11:37:16' WHERE id= '771';
[04/12/2024 11:37:16], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7869' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '43.239.53.130' , city = 'yangshuo' , arrival_date='2024/05/26',  departure_date='2024/05/26',  nights='1',  create_date='2024-04-12 :11:37:16',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[04/12/2024 11:37:16], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 11:37:16' WHERE id= '771';
[04/12/2024 11:37:22], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 11:37:22' WHERE id= '771';
[04/12/2024 11:37:22], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 11:37:22' WHERE id= '771';
[04/12/2024 11:37:28], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 11:37:28' WHERE id= '771';
[04/12/2024 11:37:28], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7869' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '43.239.53.130' , city = 'yangshuo' , arrival_date='2024/04/15',  departure_date='2024/04/15',  nights='1',  create_date='2024-04-12 :11:37:28',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[04/12/2024 11:37:28], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 11:37:28' WHERE id= '771';
[04/12/2024 11:37:34], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 11:37:34' WHERE id= '771';
[04/12/2024 11:37:34], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7869' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '43.239.53.130' , city = 'yangshuo' , arrival_date='2024/04/20',  departure_date='2024/04/20',  nights='1',  create_date='2024-04-12 :11:37:34',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[04/12/2024 11:37:35], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 11:37:35' WHERE id= '771';
[04/12/2024 11:37:41], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 11:37:41' WHERE id= '771';
[04/12/2024 11:37:42], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 11:37:42' WHERE id= '771';
[04/12/2024 11:37:47], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 11:37:47' WHERE id= '771';
[04/12/2024 11:37:47], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 11:37:47' WHERE id= '771';
[04/12/2024 11:37:58], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 11:37:58' WHERE id= '771';
[04/12/2024 11:38:01], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 11:38:01' WHERE id= '771';
[04/12/2024 11:38:01], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7869' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '43.239.53.130' , city = 'yangshuo' , arrival_date='2024/04/30',  departure_date='2024/04/30',  nights='1',  create_date='2024-04-12 :11:38:01',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[04/12/2024 11:38:02], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 11:38:02' WHERE id= '771';
[04/12/2024 11:38:42], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 11:38:42' WHERE id= '771';
[04/12/2024 11:38:46], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 11:38:46' WHERE id= '771';
[04/12/2024 11:38:47], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 11:38:47' WHERE id= '771';
[04/12/2024 11:38:51], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 11:38:51' WHERE id= '771';
[04/12/2024 11:38:51], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7869' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '43.239.53.130' , city = 'maui - hawaii' , arrival_date='2024/04/30',  departure_date='2024/04/30',  nights='1',  create_date='2024-04-12 :11:38:51',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[04/12/2024 11:38:51], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 11:38:51' WHERE id= '771';
[04/12/2024 11:38:59], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 11:38:59' WHERE id= '771';
[04/12/2024 11:38:59], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7869' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '43.239.53.130' , city = 'maui - hawaii' , arrival_date='2024/05/26',  departure_date='2024/05/26',  nights='1',  create_date='2024-04-12 :11:38:59',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[04/12/2024 11:39:00], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 11:39:00' WHERE id= '771';
[04/12/2024 11:53:31], [file name :-/home/otrams/public_html/beta/call.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 11:53:31' WHERE id= '768';
[04/12/2024 11:53:32], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/12_04_2024/request_availability_Gajendra_922_1712922811_47.json', 'e1/12_04_2024/response_availability_Gajendra_922_1712922811_47.json', 'e1/12_04_2024/response_header_availability_Gajendra_922_1712922811_47.json', 'expedia', '2024-04-12 11:53:32', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '922');
[04/12/2024 11:53: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 11:53:31.180'
        , 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.516'
        , error_description = ''
        , memory_used = '189760128'
        WHERE id = '108239';
[04/12/2024 11:54:06], [file name :-/home/otrams/public_html/beta/call.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 11:54:06' WHERE id= '768';
[04/12/2024 11:54: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_Gajendra_922_1712922846_28.json', 'e1/12_04_2024/response_availability_Gajendra_922_1712922846_28.json', 'e1/12_04_2024/response_header_availability_Gajendra_922_1712922846_28.json', 'expedia', '2024-04-12 11:54:07', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '922');
[04/12/2024 11:54: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=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 11:54:06.500'
        , 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.732'
        , error_description = ''
        , memory_used = '189751288'
        WHERE id = '108240';
[04/12/2024 11:54:27], [file name :-/home/otrams/public_html/beta/call.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 11:54:27' WHERE id= '768';
[04/12/2024 11:54: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_922_1712922867_50.json', 'e1/12_04_2024/response_availability_Gajendra_922_1712922867_50.json', 'e1/12_04_2024/response_header_availability_Gajendra_922_1712922867_50.json', 'expedia', '2024-04-12 11:54:29', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '922');
[04/12/2024 11:54:30], [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 11:54:27.852'
        , 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.535'
        , error_description = ''
        , memory_used = '189748256'
        WHERE id = '108241';
[04/12/2024 11:54:50], [file name :-/home/otrams/public_html/beta/call.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 11:54:50' WHERE id= '768';
[04/12/2024 11:54:51], [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_922_1712922890_15.json', 'e1/12_04_2024/response_availability_Gajendra_922_1712922890_15.json', 'e1/12_04_2024/response_header_availability_Gajendra_922_1712922890_15.json', 'expedia', '2024-04-12 11:54:51', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '922');
[04/12/2024 11:54:53], [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 11:54:50.442'
        , 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.625'
        , error_description = ''
        , memory_used = '189749656'
        WHERE id = '108242';
[04/12/2024 11:55:39], [file name :-/home/otrams/public_html/beta/call.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 11:55:39' WHERE id= '768';
[04/12/2024 11:55: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_Gajendra_922_1712922939_13.json', 'e1/12_04_2024/response_availability_Gajendra_922_1712922939_13.json', 'e1/12_04_2024/response_header_availability_Gajendra_922_1712922939_13.json', 'expedia', '2024-04-12 11:55:40', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '922');
[04/12/2024 11:55: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=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 11:55:39.74'
        , 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 = '189757576'
        WHERE id = '108243';
[04/12/2024 11:57:50], [file name :-/home/otrams/public_html/beta/call.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 11:57:50' WHERE id= '768';
[04/12/2024 11:57:52], [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_922_1712923071_22.json', 'e1/12_04_2024/response_availability_Gajendra_922_1712923071_22.json', 'e1/12_04_2024/response_header_availability_Gajendra_922_1712923071_22.json', 'expedia', '2024-04-12 11:57:52', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '922');
[04/12/2024 11:57: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=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 11:57:50.682'
        , 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.212'
        , error_description = ''
        , memory_used = '189747672'
        WHERE id = '108244';
[04/12/2024 11:58:42], [file name :-/home/otrams/public_html/beta/call.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 11:58:42' WHERE id= '768';
[04/12/2024 11:58: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_Gajendra_922_1712923122_16.json', 'e1/12_04_2024/response_availability_Gajendra_922_1712923122_16.json', 'e1/12_04_2024/response_header_availability_Gajendra_922_1712923122_16.json', 'expedia', '2024-04-12 11:58:43', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '922');
[04/12/2024 11:58:44], [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 11:58:42.94'
        , 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.416'
        , error_description = ''
        , memory_used = '190003392'
        WHERE id = '108245';
[04/12/2024 11:59:38], [file name :-/home/otrams/public_html/beta/call.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 11:59:38' WHERE id= '768';
[04/12/2024 11:59:39], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/12_04_2024/request_availability_Gajendra_922_1712923178_15.json', 'e1/12_04_2024/response_availability_Gajendra_922_1712923178_15.json', 'e1/12_04_2024/response_header_availability_Gajendra_922_1712923178_15.json', 'expedia', '2024-04-12 11:59:39', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '922');
[04/12/2024 11:59: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=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 11:59:38.493'
        , 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.145'
        , error_description = ''
        , memory_used = '189834232'
        WHERE id = '108246';
