[04/12/2024 06:00:12], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 06:00:12' WHERE id= '768';
[04/12/2024 06:00:12], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-04-12 06:00:12',login_attempt=0 where id = '7856';
[04/12/2024 06:00:12], [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 06:00:12', ip = '43.239.53.130', action = 'Login' ;
[04/12/2024 06:00:12], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 06:00:12' WHERE id= '768';
[04/12/2024 06:00:18], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 06:00:18' WHERE id= '768';
[04/12/2024 06:00:24], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 06:00:24' WHERE id= '768';
[04/12/2024 06:00:24], [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/27' , departure_date = '2024/04/28' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-04-12 06:00:24' , 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 06:00:25], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 06:00:25' WHERE id= '768';
[04/12/2024 06:00:25], [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 06:00:25', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '906');
[04/12/2024 06:00:25], [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 06:00:25.409'
        , 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.117'
        , error_description = ''
        , memory_used = '1839328'
        WHERE id = '108000';
[04/12/2024 06:00:25], [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_906_1712901625_33.json', 'e1/12_04_2024/response_availability_future_destination_906_1712901625_33.json', 'e1/12_04_2024/response_header_availability_future_destination_906_1712901625_33.json', 'expedia', '2024-04-12 06:00:25', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '906');
[04/12/2024 06:00:25], [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_906_1712901625_71.json', 'e1p/12_04_2024/response_availability_future_destination_906_1712901625_71.json', 'e1p/12_04_2024/response_header_availability_future_destination_906_1712901625_71.json', 'expediapackage', '2024-04-12 06:00:25', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '906');
[04/12/2024 06:00:25], [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 06:00:25.409'
        , 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.226'
        , error_description = ''
        , memory_used = '1560248'
        WHERE id = '108001';
[04/12/2024 06:00:25], [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 06:00:25.409'
        , 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.227'
        , error_description = ''
        , memory_used = '1559688'
        WHERE id = '108002';
[04/12/2024 06:00: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_906_1712901625_2.json', 'e1/12_04_2024/response_availability_future_destination_906_1712901625_2.json', 'e1/12_04_2024/response_header_availability_future_destination_906_1712901625_2.json', 'expedia', '2024-04-12 06:00:26', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '906');
[04/12/2024 06:00: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_906_1712901625_26.json', 'e1/12_04_2024/response_availability_future_destination_906_1712901625_26.json', 'e1/12_04_2024/response_header_availability_future_destination_906_1712901625_26.json', 'expedia', '2024-04-12 06:00:26', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '906');
[04/12/2024 06:00: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_906_1712901625_3.json', 'e1p/12_04_2024/response_availability_future_destination_906_1712901625_3.json', 'e1p/12_04_2024/response_header_availability_future_destination_906_1712901625_3.json', 'expediapackage', '2024-04-12 06:00:27', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '906');
[04/12/2024 06:00: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_future_destination_906_1712901625_65.json', 'e1p/12_04_2024/response_availability_future_destination_906_1712901625_65.json', 'e1p/12_04_2024/response_header_availability_future_destination_906_1712901625_65.json', 'expediapackage', '2024-04-12 06:00:28', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '906');
[04/12/2024 06:00: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 06:00:25.409'
        , 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.746'
        , error_description = ''
        , memory_used = '160052960'
        WHERE id = '108003';
[04/12/2024 06:00: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 06:00:25.409'
        , 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.223'
        , error_description = ''
        , memory_used = '190127824'
        WHERE id = '108004';
[04/12/2024 06:00: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 06:00:25.409'
        , 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.315'
        , error_description = ''
        , memory_used = '200246952'
        WHERE id = '108005';
[04/12/2024 06:00: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 06:00:25.409'
        , 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.383'
        , error_description = ''
        , memory_used = '165867576'
        WHERE id = '108006';
[04/12/2024 06:00:29], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '711',
        request_path = '/xml_all.php?userid=7856&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9',
        duration = '4.567',
        merge_duration = '0.004',
        assigned_supplier_count = '3',
        searched_supplier_count = '3',
        system_load_1_min = '15.69',
        system_load_5_min = '8.84',
        system_load_15_min = '3.98',
        system_memory_usage = '56.70',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '906') + '1955272',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '906';
[04/12/2024 06:00:30], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 06:00:30' WHERE id= '768';
[04/12/2024 06:00:30], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 06:00:30' WHERE id= '768';
[04/12/2024 06:00:30], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 06:00:30' WHERE id= '768';
[04/12/2024 06:00:33], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 06:00:33' WHERE id= '768';
[04/12/2024 06:01:24], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 06:01:24' WHERE id= '768';
[04/12/2024 06:01:27], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 06:01:27' WHERE id= '768';
[04/12/2024 06:04:20], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 06:04:20' WHERE id= '768';
[04/12/2024 06:04:23], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 06:04:23' WHERE id= '768';
[04/12/2024 06:04:41], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 06:04:41' WHERE id= '768';
[04/12/2024 06:04:44], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 06:04:44' WHERE id= '768';
[04/12/2024 06:06:57], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 06:06:57' WHERE id= '768';
[04/12/2024 06:07:11], [file name :-/home/otrams/public_html/beta/call.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 06:07:11' WHERE id= '768';
[04/12/2024 06:07: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_906_1712902032_25.json', 'e1/12_04_2024/response_availability_future_destination_906_1712902032_25.json', 'e1/12_04_2024/response_header_availability_future_destination_906_1712902032_25.json', 'expedia', '2024-04-12 06:07:12', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '906');
[04/12/2024 06:07: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&debug=1'
        , http_hit_time = '2024-04-12 06:07:11.967'
        , 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.792'
        , error_description = ''
        , memory_used = '190227256'
        WHERE id = '108007';
[04/12/2024 06:33:10], [file name :-/home/otrams/public_html/beta/call.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 06:33:10' WHERE id= '768';
[04/12/2024 06:33: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_906_1712903590_5.json', 'e1/12_04_2024/response_availability_future_destination_906_1712903590_5.json', 'e1/12_04_2024/response_header_availability_future_destination_906_1712903590_5.json', 'expedia', '2024-04-12 06:33:12', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '906');
[04/12/2024 06:33: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&debug=1'
        , http_hit_time = '2024-04-12 06:33:10.19'
        , 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 = '190715168'
        WHERE id = '108008';
[04/12/2024 06:33:32], [file name :-/home/otrams/public_html/beta/call.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 06:33:32' WHERE id= '768';
[04/12/2024 06:33:32], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-04-12 06:33:32.500'
            , total_duration = '0.374'
            , hotel_count = 0
            , source_type = 'expedia'
            , create_date = '2024-04-12 06:33:32'
            , session_id = '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9'
            , agent_logs_id = '906'
            , error_description = ''
            , memory_used = '1778856';
[04/12/2024 06:34:04], [file name :-/home/otrams/public_html/beta/call.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 06:34:04' WHERE id= '768';
[04/12/2024 06:34:05], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/12_04_2024/request_availability_future_destination_906_1712903644_98.json', 'e1/12_04_2024/response_availability_future_destination_906_1712903644_98.json', 'e1/12_04_2024/response_header_availability_future_destination_906_1712903644_98.json', 'expedia', '2024-04-12 06:34:05', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '906');
[04/12/2024 06:34:08], [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&debug=1'
        , http_hit_time = '2024-04-12 06:34:04.414'
        , 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.919'
        , error_description = ''
        , memory_used = '190883928'
        WHERE id = '108010';
[04/12/2024 06:34:37], [file name :-/home/otrams/public_html/beta/call.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 06:34:37' WHERE id= '768';
[04/12/2024 06:34:38], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/12_04_2024/request_availability_future_destination_906_1712903677_57.json', 'e1/12_04_2024/response_availability_future_destination_906_1712903677_57.json', 'e1/12_04_2024/response_header_availability_future_destination_906_1712903677_57.json', 'expedia', '2024-04-12 06:34:38', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '906');
[04/12/2024 06:34:41], [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&debug=1'
        , http_hit_time = '2024-04-12 06:34:37.469'
        , 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.672'
        , error_description = ''
        , memory_used = '191049480'
        WHERE id = '108011';
[04/12/2024 06:44:51], [file name :-/home/otrams/public_html/beta/call.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 06:44:51' WHERE id= '768';
[04/12/2024 06:44:51], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-04-12 06:44:51.723'
            , total_duration = '0.024'
            , hotel_count = 0
            , source_type = 'expedia'
            , create_date = '2024-04-12 06:44:51'
            , session_id = '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9'
            , agent_logs_id = ''
            , error_description = ''
            , memory_used = '1898896';
[04/12/2024 06:45:04], [file name :-/home/otrams/public_html/beta/call.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 06:45:04' WHERE id= '768';
[04/12/2024 06:45:04], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-04-12 06:45:04.493'
            , total_duration = '0.029'
            , hotel_count = 0
            , source_type = 'expedia'
            , create_date = '2024-04-12 06:45:04'
            , session_id = '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9'
            , agent_logs_id = ''
            , error_description = ''
            , memory_used = '1960240';
[04/12/2024 06:47:51], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 06:47:51' WHERE id= '768';
[04/12/2024 06:47:51], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-04-12 06:47:51',login_attempt=0 where id = '7873';
[04/12/2024 06:47:51], [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 06:47:51', ip = '43.239.53.130', action = 'Login' ;
[04/12/2024 06:47:51], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 06:47:51' WHERE id= '768';
[04/12/2024 06:48:02], [file name :-/home/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[04/12/2024 06:48:02], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '67' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[04/12/2024 06:48:02], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '52' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[04/12/2024 06:48:02], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '76' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[04/12/2024 06:48:02], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '24' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[04/12/2024 06:48:02], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '77' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[04/12/2024 06:48:02], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '64' ,status = '1' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[04/12/2024 06:48:02], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '65' ,status = '1' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[04/12/2024 06:48:02], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '34' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[04/12/2024 06:48:02], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '20' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[04/12/2024 06:48:02], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '55' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[04/12/2024 06:48:02], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '62' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[04/12/2024 06:48:02], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '53' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[04/12/2024 06:48:02], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '16' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[04/12/2024 06:48:02], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '78' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[04/12/2024 06:48:02], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '75' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[04/12/2024 06:48:02], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '60' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[04/12/2024 06:48:02], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '18' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[04/12/2024 06:48:02], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '19' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[04/12/2024 06:48:02], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '73' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[04/12/2024 06:48:02], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '71' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[04/12/2024 06:48:02], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '69' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[04/12/2024 06:48:02], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '68' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[04/12/2024 06:48:02], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '74' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[04/12/2024 06:48:02], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '35' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[04/12/2024 06:48:02], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '70' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[04/12/2024 06:48:02], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '59' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[04/12/2024 06:48:02], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '32' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[04/12/2024 06:48:02], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '58' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[04/12/2024 06:48:02], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '56' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[04/12/2024 06:48:02], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '57' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[04/12/2024 06:48:02], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '61' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[04/12/2024 06:48:02], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '63' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[04/12/2024 06:48:02], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '54' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[04/12/2024 06:48:02], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '66' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[04/12/2024 06:48:02], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '45' ,status = '' ,priority = '' ,lead_time = '',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:48:02], [file name :-/home/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'v3alpha',`create_date`= '2024-04-12 06:48:02',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 67 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 52 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 76 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 24 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 77 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 64 ,status = \&#039;1\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 65 ,status = \&#039;1\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 34 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 20 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 55 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 62 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 53 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 16 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 78 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 75 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 60 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 18 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 19 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 73 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 71 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 69 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 68 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 74 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 35 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 70 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 59 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 32 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 58 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 56 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 57 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 61 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 63 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 54 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 66 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 45 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = ,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;',`log_description`= 'Supplier setting updated  Previous data-- agent_id-7873 ## supplier_id- 64 ## company_name - Expedia ## supplier_code-expedia  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-7873 ## supplier_id- 65 ## company_name - Expedia Package ## supplier_code-expediapackage  ## percentage - 0.00 ## lead_time - 0 ',`ip`= '43.239.53.130';
[04/12/2024 06:48:06], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 06:48:06' WHERE id= '768';
[04/12/2024 06:48:06], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-04-12 06:48:06',login_attempt=0 where id = '7873';
[04/12/2024 06:48:06], [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 06:48:06', ip = '43.239.53.130', action = 'Login' ;
[04/12/2024 06:48:06], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 06:48:06' WHERE id= '768';
[04/12/2024 06:48:10], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 06:48:10' WHERE id= '768';
[04/12/2024 06:48:15], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 06:48:15' WHERE id= '768';
[04/12/2024 06:48:15], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7873' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/04/25' , departure_date = '2024/04/26' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-04-12 06:48:15' , 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 06:48:16], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 06:48:16' WHERE id= '768';
[04/12/2024 06:48: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_Gajendra_907_1712904496_3.json', 'e1p/12_04_2024/response_availability_Gajendra_907_1712904496_3.json', 'e1p/12_04_2024/response_header_availability_Gajendra_907_1712904496_3.json', 'expediapackage', '2024-04-12 06:48:16', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '907');
[04/12/2024 06:48: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=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 06:48:16.362'
        , 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.266'
        , error_description = ''
        , memory_used = '1993872'
        WHERE id = '108014';
[04/12/2024 06:48: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_Gajendra_907_1712904496_17.json', 'e1/12_04_2024/response_availability_Gajendra_907_1712904496_17.json', 'e1/12_04_2024/response_header_availability_Gajendra_907_1712904496_17.json', 'expedia', '2024-04-12 06:48:16', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '907');
[04/12/2024 06:48: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=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 06:48:16.361'
        , 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.276'
        , error_description = ''
        , memory_used = '1994040'
        WHERE id = '108015';
[04/12/2024 06:48: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_Gajendra_907_1712904496_55.json', 'e1/12_04_2024/response_availability_Gajendra_907_1712904496_55.json', 'e1/12_04_2024/response_header_availability_Gajendra_907_1712904496_55.json', 'expedia', '2024-04-12 06:48:17', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '907');
[04/12/2024 06:48: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_Gajendra_907_1712904496_77.json', 'e1/12_04_2024/response_availability_Gajendra_907_1712904496_77.json', 'e1/12_04_2024/response_header_availability_Gajendra_907_1712904496_77.json', 'expedia', '2024-04-12 06:48:17', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '907');
[04/12/2024 06:48: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_Gajendra_907_1712904496_59.json', 'e1p/12_04_2024/response_availability_Gajendra_907_1712904496_59.json', 'e1p/12_04_2024/response_header_availability_Gajendra_907_1712904496_59.json', 'expediapackage', '2024-04-12 06:48:17', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '907');
[04/12/2024 06:48: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_Gajendra_907_1712904496_11.json', 'e1p/12_04_2024/response_availability_Gajendra_907_1712904496_11.json', 'e1p/12_04_2024/response_header_availability_Gajendra_907_1712904496_11.json', 'expediapackage', '2024-04-12 06:48:18', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '907');
[04/12/2024 06:48: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=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 06:48:16.361'
        , 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.313'
        , error_description = ''
        , memory_used = '151620976'
        WHERE id = '108016';
[04/12/2024 06:48: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'
        , http_hit_time = '2024-04-12 06:48:16.361'
        , 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.580'
        , error_description = ''
        , memory_used = '184033352'
        WHERE id = '108017';
[04/12/2024 06:48: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=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 06:48:16.361'
        , 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.110'
        , error_description = ''
        , memory_used = '194439040'
        WHERE id = '108018';
[04/12/2024 06:48: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=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 06:48:16.361'
        , 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 = '159907424'
        WHERE id = '108019';
[04/12/2024 06:48:19], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '708',
        request_path = '/xml_all.php?userid=7873&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9',
        duration = '3.299',
        merge_duration = '0.003',
        assigned_supplier_count = '2',
        searched_supplier_count = '2',
        system_load_1_min = '0.10',
        system_load_5_min = '0.91',
        system_load_15_min = '2.35',
        system_memory_usage = '63.03',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '907') + '2384072',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '907';
[04/12/2024 06:48:19], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 06:48:19' WHERE id= '768';
[04/12/2024 06:48:21], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 06:48:21' WHERE id= '768';
[04/12/2024 06:50:29], [file name :-/home/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[04/12/2024 06:50:29], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '67' ,status = '1' ,priority = '' ,lead_time = '8760',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:50:29], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '52' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:50:29], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '76' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:50:29], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '24' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:50:29], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '77' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:50:29], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '64' ,status = '1' ,priority = '12' ,lead_time = '8760',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[04/12/2024 06:50:29], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '65' ,status = '1' ,priority = '' ,lead_time = '8760',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:50:29], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '34' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:50:29], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '20' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[04/12/2024 06:50:29], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '55' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:50:29], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '62' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:50:29], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '53' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:50:29], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '16' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:50:29], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '78' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:50:29], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '75' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:50:29], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '60' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:50:29], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '18' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:50:29], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '19' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:50:29], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '73' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:50:29], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '71' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:50:29], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '69' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:50:29], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '68' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:50:29], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '74' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:50:29], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '35' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:50:29], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '70' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:50:29], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '59' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:50:29], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '32' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:50:29], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '58' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:50:29], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '56' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:50:29], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '57' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:50:29], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '61' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:50:29], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '63' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:50:29], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '54' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:50:29], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '66' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:50:29], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '45' ,status = '' ,priority = '' ,lead_time = '',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:50:29], [file name :-/home/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'v3alpha',`create_date`= '2024-04-12 06:50:29',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 67 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;8760\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 52 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 76 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 24 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 77 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 64 ,status = \&#039;1\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;8760\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 65 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;8760\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 34 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 20 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 55 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 62 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 53 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 16 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 78 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 75 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 60 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 18 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 19 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 73 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 71 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 69 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 68 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 74 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 35 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 70 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 59 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 32 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 58 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 56 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 57 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 61 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 63 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 54 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 66 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 45 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = ,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;',`log_description`= 'Supplier setting updated  Previous data-- agent_id-7867 ## supplier_id- 64 ## company_name - Expedia ## supplier_code-expedia  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-7867 ## supplier_id- 65 ## company_name - Expedia Package ## supplier_code-expediapackage  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-7867 ## supplier_id- 75 ## company_name - TBO Holidays ## supplier_code-tboholidays  ## percentage - 0.00 ## lead_time - 0 ',`ip`= '43.239.53.130';
[04/12/2024 06:50:33], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-04-12 06:50:33',login_attempt=0 where id = '7867';
[04/12/2024 06:50:33], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'hotel_yards', user_type = 'A', branch_id = '32', login_datetime = '2024-04-12 06:50:33', ip = '43.239.53.130', action = 'Login' ;
[04/12/2024 06:50:33], [file name :-/home/otrams/public_html/beta/hotel_search.php],insert into user_sessions_ip SET ip_addr='43.239.53.130', agent_id='7867', session_id='3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a',create_date='2024-04-12 06:50:33', update_date='2024-04-12 06:50:33',domain='beta.astrabookings.com',sub_agent_id='',sub_user_id='';
[04/12/2024 06:50:38], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 06:50:38' WHERE id= '770';
[04/12/2024 06:50:46], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 06:50:46' WHERE id= '770';
[04/12/2024 06:50:46], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7867' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '32' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/04/21' , departure_date = '2024/04/22' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-04-12 06:50:46' , 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 06:50:46], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 06:50:46' WHERE id= '770';
[04/12/2024 06:50: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_hotel_yards_908_1712904647_4.json', 'e1/12_04_2024/response_availability_hotel_yards_908_1712904647_4.json', 'e1/12_04_2024/response_header_availability_hotel_yards_908_1712904647_4.json', 'expedia', '2024-04-12 06:50:47', '', '3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a', '908');
[04/12/2024 06:50: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', 't7/12_04_2024/request_Availability__hotel_yards_1_06_50_47_1712904647.xml', 't7/12_04_2024/response_Availability__hotel_yards_1_06_50_47_1712904647.xml', 't7/12_04_2024/response_header_Availability__hotel_yards_1_06_50_47_1712904647.xml', 'tboholidays', '2024-04-12 06:50:47', '', '3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a', '908');
[04/12/2024 06:50: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', 't7/12_04_2024/request_Availability__hotel_yards_4_06_50_47_1712904647.xml', 't7/12_04_2024/response_Availability__hotel_yards_4_06_50_47_1712904647.xml', 't7/12_04_2024/response_header_Availability__hotel_yards_4_06_50_47_1712904647.xml', 'tboholidays', '2024-04-12 06:50:47', '', '3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a', '908');
[04/12/2024 06:50:47], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a&xml_user_id=7867&db_caching=1&erequest=2&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F120.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-12 06:50:47.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 = '0.249'
        , error_description = ''
        , memory_used = '1993624'
        WHERE id = '108020';
[04/12/2024 06:50: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', 't7/12_04_2024/request_Availability__hotel_yards_13_06_50_47_1712904647.xml', 't7/12_04_2024/response_Availability__hotel_yards_13_06_50_47_1712904647.xml', 't7/12_04_2024/response_header_Availability__hotel_yards_13_06_50_47_1712904647.xml', 'tboholidays', '2024-04-12 06:50:47', '', '3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a', '908');
[04/12/2024 06:50: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', 't7/12_04_2024/request_Availability__hotel_yards_12_06_50_47_1712904647.xml', 't7/12_04_2024/response_Availability__hotel_yards_12_06_50_47_1712904647.xml', 't7/12_04_2024/response_header_Availability__hotel_yards_12_06_50_47_1712904647.xml', 'tboholidays', '2024-04-12 06:50:47', '', '3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a', '908');
[04/12/2024 06:50: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', 't7/12_04_2024/request_Availability__hotel_yards_9_06_50_47_1712904647.xml', 't7/12_04_2024/response_Availability__hotel_yards_9_06_50_47_1712904647.xml', 't7/12_04_2024/response_header_Availability__hotel_yards_9_06_50_47_1712904647.xml', 'tboholidays', '2024-04-12 06:50:47', '', '3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a', '908');
[04/12/2024 06:50: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', 't7/12_04_2024/request_Availability__hotel_yards_11_06_50_47_1712904647.xml', 't7/12_04_2024/response_Availability__hotel_yards_11_06_50_47_1712904647.xml', 't7/12_04_2024/response_header_Availability__hotel_yards_11_06_50_47_1712904647.xml', 'tboholidays', '2024-04-12 06:50:47', '', '3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a', '908');
[04/12/2024 06:50: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', 't7/12_04_2024/request_Availability__hotel_yards_17_06_50_47_1712904647.xml', 't7/12_04_2024/response_Availability__hotel_yards_17_06_50_47_1712904647.xml', 't7/12_04_2024/response_header_Availability__hotel_yards_17_06_50_47_1712904647.xml', 'tboholidays', '2024-04-12 06:50:47', '', '3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a', '908');
[04/12/2024 06:50: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', 't7/12_04_2024/request_Availability__hotel_yards_6_06_50_47_1712904647.xml', 't7/12_04_2024/response_Availability__hotel_yards_6_06_50_47_1712904647.xml', 't7/12_04_2024/response_header_Availability__hotel_yards_6_06_50_47_1712904647.xml', 'tboholidays', '2024-04-12 06:50:47', '', '3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a', '908');
[04/12/2024 06:50: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', 't7/12_04_2024/request_Availability__hotel_yards_8_06_50_47_1712904647.xml', 't7/12_04_2024/response_Availability__hotel_yards_8_06_50_47_1712904647.xml', 't7/12_04_2024/response_header_Availability__hotel_yards_8_06_50_47_1712904647.xml', 'tboholidays', '2024-04-12 06:50:47', '', '3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a', '908');
[04/12/2024 06:50: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_hotel_yards_908_1712904647_54.json', 'e1p/12_04_2024/response_availability_hotel_yards_908_1712904647_54.json', 'e1p/12_04_2024/response_header_availability_hotel_yards_908_1712904647_54.json', 'expediapackage', '2024-04-12 06:50:47', '', '3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a', '908');
[04/12/2024 06:50: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', 't7/12_04_2024/request_Availability__hotel_yards_15_06_50_47_1712904647.xml', 't7/12_04_2024/response_Availability__hotel_yards_15_06_50_47_1712904647.xml', 't7/12_04_2024/response_header_Availability__hotel_yards_15_06_50_47_1712904647.xml', 'tboholidays', '2024-04-12 06:50:47', '', '3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a', '908');
[04/12/2024 06:50: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', 't7/12_04_2024/request_Availability__hotel_yards_5_06_50_47_1712904647.xml', 't7/12_04_2024/response_Availability__hotel_yards_5_06_50_47_1712904647.xml', 't7/12_04_2024/response_header_Availability__hotel_yards_5_06_50_47_1712904647.xml', 'tboholidays', '2024-04-12 06:50:47', '', '3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a', '908');
[04/12/2024 06:50: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', 't7/12_04_2024/request_Availability__hotel_yards_2_06_50_47_1712904647.xml', 't7/12_04_2024/response_Availability__hotel_yards_2_06_50_47_1712904647.xml', 't7/12_04_2024/response_header_Availability__hotel_yards_2_06_50_47_1712904647.xml', 'tboholidays', '2024-04-12 06:50:47', '', '3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a', '908');
[04/12/2024 06:50: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', 't7/12_04_2024/request_Availability__hotel_yards_18_06_50_47_1712904647.xml', 't7/12_04_2024/response_Availability__hotel_yards_18_06_50_47_1712904647.xml', 't7/12_04_2024/response_header_Availability__hotel_yards_18_06_50_47_1712904647.xml', 'tboholidays', '2024-04-12 06:50:47', '', '3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a', '908');
[04/12/2024 06:50:47], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a&xml_user_id=7867&db_caching=1&erequest=2&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F120.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-12 06:50:47.220'
        , 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 = '1993680'
        WHERE id = '108030';
[04/12/2024 06:50: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', 't7/12_04_2024/request_Availability__hotel_yards_06_50_47_1712904647.xml', 't7/12_04_2024/response_Availability__hotel_yards_06_50_47_1712904647.xml', 't7/12_04_2024/response_header_Availability__hotel_yards_06_50_47_1712904647.xml', 'tboholidays', '2024-04-12 06:50:47', '', '3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a', '908');
[04/12/2024 06:50: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', 't7/12_04_2024/request_Availability__hotel_yards_14_06_50_47_1712904647.xml', 't7/12_04_2024/response_Availability__hotel_yards_14_06_50_47_1712904647.xml', 't7/12_04_2024/response_header_Availability__hotel_yards_14_06_50_47_1712904647.xml', 'tboholidays', '2024-04-12 06:50:47', '', '3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a', '908');
[04/12/2024 06:50: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', 't7/12_04_2024/request_Availability__hotel_yards_7_06_50_47_1712904647.xml', 't7/12_04_2024/response_Availability__hotel_yards_7_06_50_47_1712904647.xml', 't7/12_04_2024/response_header_Availability__hotel_yards_7_06_50_47_1712904647.xml', 'tboholidays', '2024-04-12 06:50:47', '', '3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a', '908');
[04/12/2024 06:50: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', 't7/12_04_2024/request_Availability__hotel_yards_3_06_50_47_1712904647.xml', 't7/12_04_2024/response_Availability__hotel_yards_3_06_50_47_1712904647.xml', 't7/12_04_2024/response_header_Availability__hotel_yards_3_06_50_47_1712904647.xml', 'tboholidays', '2024-04-12 06:50:47', '', '3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a', '908');
[04/12/2024 06:50: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', 't7/12_04_2024/request_Availability__hotel_yards_16_06_50_47_1712904647.xml', 't7/12_04_2024/response_Availability__hotel_yards_16_06_50_47_1712904647.xml', 't7/12_04_2024/response_header_Availability__hotel_yards_16_06_50_47_1712904647.xml', 'tboholidays', '2024-04-12 06:50:47', '', '3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a', '908');
[04/12/2024 06:50: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', 't7/12_04_2024/request_Availability__hotel_yards_10_06_50_47_1712904647.xml', 't7/12_04_2024/response_Availability__hotel_yards_10_06_50_47_1712904647.xml', 't7/12_04_2024/response_header_Availability__hotel_yards_10_06_50_47_1712904647.xml', 'tboholidays', '2024-04-12 06:50:47', '', '3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a', '908');
[04/12/2024 06:50:47], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=tboholidays&sessionid=3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a&xml_user_id=7867&db_caching=1&wh_agent_id=&erequest=1&total_request=19&hotel_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-04-12 06:50:47.220'
        , 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.287'
        , error_description = ''
        , memory_used = '2817144'
        WHERE id = '108021';
[04/12/2024 06:50:47], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=tboholidays&sessionid=3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a&xml_user_id=7867&db_caching=1&wh_agent_id=&erequest=13&total_request=19&hotel_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-04-12 06:50:47.220'
        , 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.334'
        , error_description = ''
        , memory_used = '2816968'
        WHERE id = '108023';
[04/12/2024 06:50:47], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=tboholidays&sessionid=3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a&xml_user_id=7867&db_caching=1&wh_agent_id=&erequest=11&total_request=19&hotel_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-04-12 06:50:47.220'
        , 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.356'
        , error_description = ''
        , memory_used = '2817240'
        WHERE id = '108026';
[04/12/2024 06:50:47], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=tboholidays&sessionid=3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a&xml_user_id=7867&db_caching=1&wh_agent_id=&erequest=4&total_request=19&hotel_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-04-12 06:50:47.220'
        , 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.362'
        , error_description = ''
        , memory_used = '2816648'
        WHERE id = '108022';
[04/12/2024 06:50:47], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=tboholidays&sessionid=3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a&xml_user_id=7867&db_caching=1&wh_agent_id=&erequest=2&total_request=19&hotel_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-04-12 06:50:47.220'
        , 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.383'
        , error_description = ''
        , memory_used = '2816576'
        WHERE id = '108033';
[04/12/2024 06:50:47], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=tboholidays&sessionid=3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a&xml_user_id=7867&db_caching=1&wh_agent_id=&erequest=18&total_request=19&hotel_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-04-12 06:50:47.221'
        , 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.388'
        , error_description = ''
        , memory_used = '2816568'
        WHERE id = '108034';
[04/12/2024 06:50:47], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=tboholidays&sessionid=3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a&xml_user_id=7867&db_caching=1&wh_agent_id=&erequest=8&total_request=19&hotel_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-04-12 06:50:47.220'
        , 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.394'
        , error_description = ''
        , memory_used = '2817144'
        WHERE id = '108029';
[04/12/2024 06:50:47], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=tboholidays&sessionid=3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a&xml_user_id=7867&db_caching=1&wh_agent_id=&erequest=0&total_request=19&hotel_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-04-12 06:50:47.220'
        , 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.411'
        , error_description = ''
        , memory_used = '2816648'
        WHERE id = '108035';
[04/12/2024 06:50:47], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=tboholidays&sessionid=3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a&xml_user_id=7867&db_caching=1&wh_agent_id=&erequest=6&total_request=19&hotel_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-04-12 06:50:47.220'
        , 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.417'
        , error_description = ''
        , memory_used = '2817096'
        WHERE id = '108028';
[04/12/2024 06:50:47], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=tboholidays&sessionid=3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a&xml_user_id=7867&db_caching=1&wh_agent_id=&erequest=15&total_request=19&hotel_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-04-12 06:50:47.220'
        , 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.428'
        , error_description = ''
        , memory_used = '2817240'
        WHERE id = '108031';
[04/12/2024 06:50:47], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=tboholidays&sessionid=3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a&xml_user_id=7867&db_caching=1&wh_agent_id=&erequest=7&total_request=19&hotel_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-04-12 06:50:47.220'
        , 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.433'
        , error_description = ''
        , memory_used = '2816472'
        WHERE id = '108037';
[04/12/2024 06:50:47], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=tboholidays&sessionid=3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a&xml_user_id=7867&db_caching=1&wh_agent_id=&erequest=3&total_request=19&hotel_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-04-12 06:50:47.220'
        , 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.439'
        , error_description = ''
        , memory_used = '2816472'
        WHERE id = '108038';
[04/12/2024 06:50:47], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=tboholidays&sessionid=3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a&xml_user_id=7867&db_caching=1&wh_agent_id=&erequest=10&total_request=19&hotel_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-04-12 06:50:47.220'
        , 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.443'
        , error_description = ''
        , memory_used = '2816968'
        WHERE id = '108040';
[04/12/2024 06:50:47], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=tboholidays&sessionid=3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a&xml_user_id=7867&db_caching=1&wh_agent_id=&erequest=12&total_request=19&hotel_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-04-12 06:50:47.221'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.449'
        , error_description = ''
        , memory_used = '2817168'
        WHERE id = '108025';
[04/12/2024 06:50:47], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=tboholidays&sessionid=3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a&xml_user_id=7867&db_caching=1&wh_agent_id=&erequest=9&total_request=19&hotel_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-04-12 06:50:47.220'
        , 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.455'
        , error_description = ''
        , memory_used = '2817144'
        WHERE id = '108024';
[04/12/2024 06:50:47], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=tboholidays&sessionid=3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a&xml_user_id=7867&db_caching=1&wh_agent_id=&erequest=17&total_request=19&hotel_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-04-12 06:50:47.221'
        , 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.462'
        , error_description = ''
        , memory_used = '2817104'
        WHERE id = '108027';
[04/12/2024 06:50:47], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=tboholidays&sessionid=3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a&xml_user_id=7867&db_caching=1&wh_agent_id=&erequest=5&total_request=19&hotel_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-04-12 06:50:47.220'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.468'
        , error_description = ''
        , memory_used = '2816568'
        WHERE id = '108032';
[04/12/2024 06:50:47], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=tboholidays&sessionid=3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a&xml_user_id=7867&db_caching=1&wh_agent_id=&erequest=14&total_request=19&hotel_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-04-12 06:50:47.221'
        , 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.473'
        , error_description = ''
        , memory_used = '2817112'
        WHERE id = '108036';
[04/12/2024 06:50:47], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=tboholidays&sessionid=3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a&xml_user_id=7867&db_caching=1&wh_agent_id=&erequest=16&total_request=19&hotel_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-04-12 06:50:47.220'
        , 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.479'
        , error_description = ''
        , memory_used = '2817168'
        WHERE id = '108039';
[04/12/2024 06:50:48], [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_hotel_yards_908_1712904647_8.json', 'e1/12_04_2024/response_availability_hotel_yards_908_1712904647_8.json', 'e1/12_04_2024/response_header_availability_hotel_yards_908_1712904647_8.json', 'expedia', '2024-04-12 06:50:48', '', '3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a', '908');
[04/12/2024 06:50:48], [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_hotel_yards_908_1712904647_100.json', 'e1/12_04_2024/response_availability_hotel_yards_908_1712904647_100.json', 'e1/12_04_2024/response_header_availability_hotel_yards_908_1712904647_100.json', 'expedia', '2024-04-12 06:50:48', '', '3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a', '908');
[04/12/2024 06:50:48], [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_hotel_yards_908_1712904647_82.json', 'e1p/12_04_2024/response_availability_hotel_yards_908_1712904647_82.json', 'e1p/12_04_2024/response_header_availability_hotel_yards_908_1712904647_82.json', 'expediapackage', '2024-04-12 06:50:48', '', '3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a', '908');
[04/12/2024 06:50:49], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/12_04_2024/request_availability_hotel_yards_908_1712904647_10.json', 'e1p/12_04_2024/response_availability_hotel_yards_908_1712904647_10.json', 'e1p/12_04_2024/response_header_availability_hotel_yards_908_1712904647_10.json', 'expediapackage', '2024-04-12 06:50:49', '', '3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a', '908');
[04/12/2024 06:50:49], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a&xml_user_id=7867&db_caching=1&erequest=1&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F120.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-12 06:50:47.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 = '2.406'
        , error_description = ''
        , memory_used = '150784032'
        WHERE id = '108042';
[04/12/2024 06:50:49], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a&xml_user_id=7867&db_caching=1&erequest=0&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F120.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-12 06:50:47.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 = '2.580'
        , error_description = ''
        , memory_used = '184549096'
        WHERE id = '108041';
[04/12/2024 06:50:50], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a&xml_user_id=7867&db_caching=1&erequest=0&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F120.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-12 06:50:47.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.083'
        , error_description = ''
        , memory_used = '194969440'
        WHERE id = '108043';
[04/12/2024 06:50:50], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a&xml_user_id=7867&db_caching=1&erequest=1&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F120.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-12 06:50:47.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.103'
        , error_description = ''
        , memory_used = '158387440'
        WHERE id = '108044';
[04/12/2024 06:50:50], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '696',
        request_path = '/xml_all.php?userid=7867&sessionid=3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a',
        duration = '3.369',
        merge_duration = '0.003',
        assigned_supplier_count = '4',
        searched_supplier_count = '3',
        system_load_1_min = '0.90',
        system_load_5_min = '0.94',
        system_load_15_min = '2.14',
        system_memory_usage = '63.29',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '908') + '3796576',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '908';
[04/12/2024 06:50:50], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 06:50:50' WHERE id= '770';
[04/12/2024 06:50:53], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 06:50:53' WHERE id= '770';
[04/12/2024 06:51:21], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 06:51:21' WHERE id= '770';
[04/12/2024 06:51:23], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 06:51:23' WHERE id= '770';
[04/12/2024 06:52:03], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 06:52:03' WHERE id= '770';
[04/12/2024 06:52:05], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 06:52:05' WHERE id= '770';
[04/12/2024 06:52:15], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 06:52:15' WHERE id= '770';
[04/12/2024 06:52:15], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-04-12 06:52:15',login_attempt=0 where id = '7867';
[04/12/2024 06:52:15], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'hotel_yards', user_type = 'A', branch_id = '32', login_datetime = '2024-04-12 06:52:15', ip = '43.239.53.130', action = 'Login' ;
[04/12/2024 06:52:15], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 06:52:15' WHERE id= '770';
[04/12/2024 06:52:21], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 06:52:21' WHERE id= '770';
[04/12/2024 06:52:26], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 06:52:26' WHERE id= '770';
[04/12/2024 06:52:26], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7867' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '32' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/04/21' , departure_date = '2024/04/22' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-04-12 06:52:26' , 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 06:52:27], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 06:52:27' WHERE id= '770';
[04/12/2024 06:52: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', 't7/12_04_2024/request_Availability__hotel_yards_7_06_52_27_1712904747.xml', 't7/12_04_2024/response_Availability__hotel_yards_7_06_52_27_1712904747.xml', 't7/12_04_2024/response_header_Availability__hotel_yards_7_06_52_27_1712904747.xml', 'tboholidays', '2024-04-12 06:52:28', '', '3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a', '909');
[04/12/2024 06:52: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', 't7/12_04_2024/request_Availability__hotel_yards_06_52_27_1712904747.xml', 't7/12_04_2024/response_Availability__hotel_yards_06_52_27_1712904747.xml', 't7/12_04_2024/response_header_Availability__hotel_yards_06_52_27_1712904747.xml', 'tboholidays', '2024-04-12 06:52:28', '', '3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a', '909');
[04/12/2024 06:52: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', 't7/12_04_2024/request_Availability__hotel_yards_5_06_52_27_1712904747.xml', 't7/12_04_2024/response_Availability__hotel_yards_5_06_52_27_1712904747.xml', 't7/12_04_2024/response_header_Availability__hotel_yards_5_06_52_27_1712904747.xml', 'tboholidays', '2024-04-12 06:52:28', '', '3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a', '909');
[04/12/2024 06:52: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', 't7/12_04_2024/request_Availability__hotel_yards_4_06_52_27_1712904747.xml', 't7/12_04_2024/response_Availability__hotel_yards_4_06_52_27_1712904747.xml', 't7/12_04_2024/response_header_Availability__hotel_yards_4_06_52_27_1712904747.xml', 'tboholidays', '2024-04-12 06:52:28', '', '3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a', '909');
[04/12/2024 06:52: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', 't7/12_04_2024/request_Availability__hotel_yards_15_06_52_27_1712904747.xml', 't7/12_04_2024/response_Availability__hotel_yards_15_06_52_27_1712904747.xml', 't7/12_04_2024/response_header_Availability__hotel_yards_15_06_52_27_1712904747.xml', 'tboholidays', '2024-04-12 06:52:28', '', '3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a', '909');
[04/12/2024 06:52: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', 't7/12_04_2024/request_Availability__hotel_yards_2_06_52_27_1712904747.xml', 't7/12_04_2024/response_Availability__hotel_yards_2_06_52_27_1712904747.xml', 't7/12_04_2024/response_header_Availability__hotel_yards_2_06_52_27_1712904747.xml', 'tboholidays', '2024-04-12 06:52:28', '', '3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a', '909');
[04/12/2024 06:52: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', 't7/12_04_2024/request_Availability__hotel_yards_8_06_52_27_1712904747.xml', 't7/12_04_2024/response_Availability__hotel_yards_8_06_52_27_1712904747.xml', 't7/12_04_2024/response_header_Availability__hotel_yards_8_06_52_27_1712904747.xml', 'tboholidays', '2024-04-12 06:52:28', '', '3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a', '909');
[04/12/2024 06:52: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', 't7/12_04_2024/request_Availability__hotel_yards_6_06_52_27_1712904747.xml', 't7/12_04_2024/response_Availability__hotel_yards_6_06_52_27_1712904747.xml', 't7/12_04_2024/response_header_Availability__hotel_yards_6_06_52_27_1712904747.xml', 'tboholidays', '2024-04-12 06:52:28', '', '3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a', '909');
[04/12/2024 06:52: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', 't7/12_04_2024/request_Availability__hotel_yards_14_06_52_27_1712904747.xml', 't7/12_04_2024/response_Availability__hotel_yards_14_06_52_27_1712904747.xml', 't7/12_04_2024/response_header_Availability__hotel_yards_14_06_52_27_1712904747.xml', 'tboholidays', '2024-04-12 06:52:28', '', '3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a', '909');
[04/12/2024 06:52: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', 't7/12_04_2024/request_Availability__hotel_yards_12_06_52_27_1712904747.xml', 't7/12_04_2024/response_Availability__hotel_yards_12_06_52_27_1712904747.xml', 't7/12_04_2024/response_header_Availability__hotel_yards_12_06_52_27_1712904747.xml', 'tboholidays', '2024-04-12 06:52:28', '', '3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a', '909');
[04/12/2024 06:52: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', 't7/12_04_2024/request_Availability__hotel_yards_17_06_52_27_1712904747.xml', 't7/12_04_2024/response_Availability__hotel_yards_17_06_52_27_1712904747.xml', 't7/12_04_2024/response_header_Availability__hotel_yards_17_06_52_27_1712904747.xml', 'tboholidays', '2024-04-12 06:52:28', '', '3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a', '909');
[04/12/2024 06:52: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', 't7/12_04_2024/request_Availability__hotel_yards_1_06_52_27_1712904747.xml', 't7/12_04_2024/response_Availability__hotel_yards_1_06_52_27_1712904747.xml', 't7/12_04_2024/response_header_Availability__hotel_yards_1_06_52_27_1712904747.xml', 'tboholidays', '2024-04-12 06:52:28', '', '3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a', '909');
[04/12/2024 06:52: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', 't7/12_04_2024/request_Availability__hotel_yards_9_06_52_27_1712904747.xml', 't7/12_04_2024/response_Availability__hotel_yards_9_06_52_27_1712904747.xml', 't7/12_04_2024/response_header_Availability__hotel_yards_9_06_52_27_1712904747.xml', 'tboholidays', '2024-04-12 06:52:28', '', '3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a', '909');
[04/12/2024 06:52: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', 't7/12_04_2024/request_Availability__hotel_yards_16_06_52_27_1712904747.xml', 't7/12_04_2024/response_Availability__hotel_yards_16_06_52_27_1712904747.xml', 't7/12_04_2024/response_header_Availability__hotel_yards_16_06_52_27_1712904747.xml', 'tboholidays', '2024-04-12 06:52:28', '', '3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a', '909');
[04/12/2024 06:52: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', 't7/12_04_2024/request_Availability__hotel_yards_3_06_52_27_1712904747.xml', 't7/12_04_2024/response_Availability__hotel_yards_3_06_52_27_1712904747.xml', 't7/12_04_2024/response_header_Availability__hotel_yards_3_06_52_27_1712904747.xml', 'tboholidays', '2024-04-12 06:52:28', '', '3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a', '909');
[04/12/2024 06:52: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', 't7/12_04_2024/request_Availability__hotel_yards_18_06_52_27_1712904747.xml', 't7/12_04_2024/response_Availability__hotel_yards_18_06_52_27_1712904747.xml', 't7/12_04_2024/response_header_Availability__hotel_yards_18_06_52_27_1712904747.xml', 'tboholidays', '2024-04-12 06:52:28', '', '3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a', '909');
[04/12/2024 06:52: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', 't7/12_04_2024/request_Availability__hotel_yards_13_06_52_27_1712904747.xml', 't7/12_04_2024/response_Availability__hotel_yards_13_06_52_27_1712904747.xml', 't7/12_04_2024/response_header_Availability__hotel_yards_13_06_52_27_1712904747.xml', 'tboholidays', '2024-04-12 06:52:28', '', '3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a', '909');
[04/12/2024 06:52: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', 't7/12_04_2024/request_Availability__hotel_yards_10_06_52_27_1712904747.xml', 't7/12_04_2024/response_Availability__hotel_yards_10_06_52_27_1712904747.xml', 't7/12_04_2024/response_header_Availability__hotel_yards_10_06_52_27_1712904747.xml', 'tboholidays', '2024-04-12 06:52:28', '', '3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a', '909');
[04/12/2024 06:52: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', 't7/12_04_2024/request_Availability__hotel_yards_11_06_52_27_1712904747.xml', 't7/12_04_2024/response_Availability__hotel_yards_11_06_52_27_1712904747.xml', 't7/12_04_2024/response_header_Availability__hotel_yards_11_06_52_27_1712904747.xml', 'tboholidays', '2024-04-12 06:52:28', '', '3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a', '909');
[04/12/2024 06:52:28], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=tboholidays&sessionid=3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a&xml_user_id=7867&db_caching=1&wh_agent_id=&erequest=0&total_request=19&hotel_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-04-12 06:52:27.890'
        , 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.282'
        , error_description = ''
        , memory_used = '2845616'
        WHERE id = '108046';
[04/12/2024 06:52:28], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=tboholidays&sessionid=3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a&xml_user_id=7867&db_caching=1&wh_agent_id=&erequest=4&total_request=19&hotel_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-04-12 06:52:27.890'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.292'
        , error_description = ''
        , memory_used = '2845864'
        WHERE id = '108048';
[04/12/2024 06:52:28], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=tboholidays&sessionid=3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a&xml_user_id=7867&db_caching=1&wh_agent_id=&erequest=2&total_request=19&hotel_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-04-12 06:52:27.890'
        , 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.298'
        , error_description = ''
        , memory_used = '2847680'
        WHERE id = '108050';
[04/12/2024 06:52:28], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=tboholidays&sessionid=3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a&xml_user_id=7867&db_caching=1&wh_agent_id=&erequest=8&total_request=19&hotel_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-04-12 06:52:27.890'
        , 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.313'
        , error_description = ''
        , memory_used = '2846456'
        WHERE id = '108051';
[04/12/2024 06:52:28], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=tboholidays&sessionid=3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a&xml_user_id=7867&db_caching=1&wh_agent_id=&erequest=6&total_request=19&hotel_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-04-12 06:52:27.890'
        , 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.319'
        , error_description = ''
        , memory_used = '2845864'
        WHERE id = '108052';
[04/12/2024 06:52:28], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=tboholidays&sessionid=3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a&xml_user_id=7867&db_caching=1&wh_agent_id=&erequest=14&total_request=19&hotel_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-04-12 06:52:27.890'
        , 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.335'
        , error_description = ''
        , memory_used = '2846096'
        WHERE id = '108053';
[04/12/2024 06:52: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_hotel_yards_909_1712904747_99.json', 'e1/12_04_2024/response_availability_hotel_yards_909_1712904747_99.json', 'e1/12_04_2024/response_header_availability_hotel_yards_909_1712904747_99.json', 'expedia', '2024-04-12 06:52:28', '', '3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a', '909');
[04/12/2024 06:52:28], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=tboholidays&sessionid=3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a&xml_user_id=7867&db_caching=1&wh_agent_id=&erequest=7&total_request=19&hotel_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-04-12 06:52:27.890'
        , 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.341'
        , error_description = ''
        , memory_used = '2845864'
        WHERE id = '108045';
[04/12/2024 06:52:28], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a&xml_user_id=7867&db_caching=1&erequest=2&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F120.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-12 06:52:27.890'
        , 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.345'
        , error_description = ''
        , memory_used = '2036488'
        WHERE id = '108064';
[04/12/2024 06:52: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_hotel_yards_909_1712904747_68.json', 'e1p/12_04_2024/response_availability_hotel_yards_909_1712904747_68.json', 'e1p/12_04_2024/response_header_availability_hotel_yards_909_1712904747_68.json', 'expediapackage', '2024-04-12 06:52:28', '', '3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a', '909');
[04/12/2024 06:52:28], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a&xml_user_id=7867&db_caching=1&erequest=2&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F120.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-12 06:52:27.890'
        , 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.357'
        , error_description = ''
        , memory_used = '2036920'
        WHERE id = '108065';
[04/12/2024 06:52:28], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=tboholidays&sessionid=3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a&xml_user_id=7867&db_caching=1&wh_agent_id=&erequest=16&total_request=19&hotel_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-04-12 06:52:27.891'
        , 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.357'
        , error_description = ''
        , memory_used = '2846240'
        WHERE id = '108058';
[04/12/2024 06:52:28], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=tboholidays&sessionid=3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a&xml_user_id=7867&db_caching=1&wh_agent_id=&erequest=5&total_request=19&hotel_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-04-12 06:52:27.890'
        , 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.380'
        , error_description = ''
        , memory_used = '2846280'
        WHERE id = '108047';
[04/12/2024 06:52:28], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=tboholidays&sessionid=3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a&xml_user_id=7867&db_caching=1&wh_agent_id=&erequest=10&total_request=19&hotel_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-04-12 06:52:27.890'
        , 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.396'
        , error_description = ''
        , memory_used = '2846248'
        WHERE id = '108062';
[04/12/2024 06:52:28], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=tboholidays&sessionid=3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a&xml_user_id=7867&db_caching=1&wh_agent_id=&erequest=9&total_request=19&hotel_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-04-12 06:52:27.890'
        , 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.401'
        , error_description = ''
        , memory_used = '2846456'
        WHERE id = '108057';
[04/12/2024 06:52:28], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=tboholidays&sessionid=3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a&xml_user_id=7867&db_caching=1&wh_agent_id=&erequest=13&total_request=19&hotel_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-04-12 06:52:27.890'
        , 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.408'
        , error_description = ''
        , memory_used = '2846096'
        WHERE id = '108061';
[04/12/2024 06:52:28], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=tboholidays&sessionid=3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a&xml_user_id=7867&db_caching=1&wh_agent_id=&erequest=15&total_request=19&hotel_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-04-12 06:52:27.891'
        , 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.413'
        , error_description = ''
        , memory_used = '2846672'
        WHERE id = '108049';
[04/12/2024 06:52:28], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=tboholidays&sessionid=3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a&xml_user_id=7867&db_caching=1&wh_agent_id=&erequest=12&total_request=19&hotel_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-04-12 06:52:27.890'
        , 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.418'
        , error_description = ''
        , memory_used = '2846096'
        WHERE id = '108054';
[04/12/2024 06:52:28], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=tboholidays&sessionid=3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a&xml_user_id=7867&db_caching=1&wh_agent_id=&erequest=17&total_request=19&hotel_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-04-12 06:52:27.891'
        , 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.424'
        , error_description = ''
        , memory_used = '2846096'
        WHERE id = '108055';
[04/12/2024 06:52:28], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=tboholidays&sessionid=3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a&xml_user_id=7867&db_caching=1&wh_agent_id=&erequest=3&total_request=19&hotel_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-04-12 06:52:27.890'
        , 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.430'
        , error_description = ''
        , memory_used = '2847680'
        WHERE id = '108059';
[04/12/2024 06:52:28], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=tboholidays&sessionid=3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a&xml_user_id=7867&db_caching=1&wh_agent_id=&erequest=1&total_request=19&hotel_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-04-12 06:52:27.890'
        , 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.436'
        , error_description = ''
        , memory_used = '2847680'
        WHERE id = '108056';
[04/12/2024 06:52:28], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=tboholidays&sessionid=3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a&xml_user_id=7867&db_caching=1&wh_agent_id=&erequest=18&total_request=19&hotel_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-04-12 06:52:27.891'
        , 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.440'
        , error_description = ''
        , memory_used = '2842464'
        WHERE id = '108060';
[04/12/2024 06:52:28], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=tboholidays&sessionid=3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a&xml_user_id=7867&db_caching=1&wh_agent_id=&erequest=11&total_request=19&hotel_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-04-12 06:52:27.890'
        , 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.446'
        , error_description = ''
        , memory_used = '2846336'
        WHERE id = '108063';
[04/12/2024 06:52: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_hotel_yards_909_1712904747_44.json', 'e1/12_04_2024/response_availability_hotel_yards_909_1712904747_44.json', 'e1/12_04_2024/response_header_availability_hotel_yards_909_1712904747_44.json', 'expedia', '2024-04-12 06:52:28', '', '3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a', '909');
[04/12/2024 06:52: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_hotel_yards_909_1712904747_7.json', 'e1/12_04_2024/response_availability_hotel_yards_909_1712904747_7.json', 'e1/12_04_2024/response_header_availability_hotel_yards_909_1712904747_7.json', 'expedia', '2024-04-12 06:52:29', '', '3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a', '909');
[04/12/2024 06:52: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_hotel_yards_909_1712904747_27.json', 'e1p/12_04_2024/response_availability_hotel_yards_909_1712904747_27.json', 'e1p/12_04_2024/response_header_availability_hotel_yards_909_1712904747_27.json', 'expediapackage', '2024-04-12 06:52:29', '', '3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a', '909');
[04/12/2024 06:52: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_hotel_yards_909_1712904747_95.json', 'e1p/12_04_2024/response_availability_hotel_yards_909_1712904747_95.json', 'e1p/12_04_2024/response_header_availability_hotel_yards_909_1712904747_95.json', 'expediapackage', '2024-04-12 06:52:29', '', '3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a', '909');
[04/12/2024 06:52:30], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a&xml_user_id=7867&db_caching=1&erequest=1&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F120.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-12 06:52:27.890'
        , 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.191'
        , error_description = ''
        , memory_used = '150919160'
        WHERE id = '108066';
[04/12/2024 06:52:30], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a&xml_user_id=7867&db_caching=1&erequest=0&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F120.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-12 06:52:27.891'
        , 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.564'
        , error_description = ''
        , memory_used = '184699200'
        WHERE id = '108067';
[04/12/2024 06:52:30], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a&xml_user_id=7867&db_caching=1&erequest=1&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F120.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-12 06:52:27.890'
        , 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.847'
        , error_description = ''
        , memory_used = '158274504'
        WHERE id = '108069';
[04/12/2024 06:52:30], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a&xml_user_id=7867&db_caching=1&erequest=0&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F120.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-12 06:52:27.891'
        , 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.026'
        , error_description = ''
        , memory_used = '195100712'
        WHERE id = '108068';
[04/12/2024 06:52:30], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '696',
        request_path = '/xml_all.php?userid=7867&sessionid=3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a',
        duration = '3.316',
        merge_duration = '0.003',
        assigned_supplier_count = '4',
        searched_supplier_count = '3',
        system_load_1_min = '0.37',
        system_load_5_min = '0.73',
        system_load_15_min = '1.94',
        system_memory_usage = '63.31',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '909') + '4102496',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '909';
[04/12/2024 06:52:31], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 06:52:31' WHERE id= '770';
[04/12/2024 06:52:33], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 06:52:33' WHERE id= '770';
[04/12/2024 06:52:45], [file name :-/home/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[04/12/2024 06:52:45], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '67' ,status = '1' ,priority = '' ,lead_time = '8760',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:52:45], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '52' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:52:45], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '76' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:52:45], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '24' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:52:45], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '77' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:52:45], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '64' ,status = '1' ,priority = '12' ,lead_time = '8760',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[04/12/2024 06:52:45], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '65' ,status = '1' ,priority = '' ,lead_time = '8760',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:52:45], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '34' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:52:45], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '20' ,status = '1' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[04/12/2024 06:52:45], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '55' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:52:45], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '62' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:52:45], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '53' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:52:45], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '16' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:52:45], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '78' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:52:45], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '75' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:52:45], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '60' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:52:45], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '18' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:52:45], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '19' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:52:45], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '73' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:52:45], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '71' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:52:45], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '69' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:52:45], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '68' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:52:45], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '74' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:52:45], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '35' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:52:45], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '70' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:52:45], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '59' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:52:45], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '32' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:52:45], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '58' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:52:45], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '56' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:52:45], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '57' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:52:45], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '61' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:52:45], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '63' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:52:45], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '54' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:52:45], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '66' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:52:45], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '45' ,status = '1' ,priority = '' ,lead_time = '',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:52:45], [file name :-/home/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'v3alpha',`create_date`= '2024-04-12 06:52:45',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 67 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;8760\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 52 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 76 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 24 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 77 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 64 ,status = \&#039;1\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;8760\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 65 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;8760\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 34 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 20 ,status = \&#039;1\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 55 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 62 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 53 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 16 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 78 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 75 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 60 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 18 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 19 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 73 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 71 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 69 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 68 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 74 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 35 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 70 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 59 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 32 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 58 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 56 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 57 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 61 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 63 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 54 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 66 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 45 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = ,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;',`log_description`= 'Supplier setting updated  Previous data-- agent_id-7867 ## supplier_id- 67 ## company_name - Agoda ## supplier_code-agoda  ## percentage - 0.00 ## lead_time - 8760 ==&lt;br&gt;== agent_id-7867 ## supplier_id- 64 ## company_name - Expedia ## supplier_code-expedia  ## percentage - 0.00 ## lead_time - 8760 ==&lt;br&gt;== agent_id-7867 ## supplier_id- 65 ## company_name - Expedia Package ## supplier_code-expediapackage  ## percentage - 0.00 ## lead_time - 8760 ==&lt;br&gt;== agent_id-7867 ## supplier_id- 75 ## company_name - TBO Holidays ## supplier_code-tboholidays  ## percentage - 0.00 ## lead_time - 0 ',`ip`= '43.239.53.130';
[04/12/2024 06:52:50], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 06:52:50' WHERE id= '770';
[04/12/2024 06:52:50], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7867' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '32' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/04/21' , departure_date = '2024/04/22' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-04-12 06:52:50' , 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 06:52:50], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 06:52:50' WHERE id= '770';
[04/12/2024 06:52:51], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 06:52:51' WHERE id= '770';
[04/12/2024 06:52:52], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 06:52:52' WHERE id= '770';
[04/12/2024 06:53:13], [file name :-/home/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[04/12/2024 06:53:13], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '67' ,status = '1' ,priority = '' ,lead_time = '8760',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:53:13], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '52' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:53:13], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '76' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:53:13], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '24' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:53:13], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '77' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:53:13], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '64' ,status = '1' ,priority = '12' ,lead_time = '8760',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[04/12/2024 06:53:13], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '65' ,status = '' ,priority = '' ,lead_time = '8760',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:53:13], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '34' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:53:13], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '20' ,status = '1' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[04/12/2024 06:53:13], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '55' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:53:13], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '62' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:53:13], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '53' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:53:13], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '16' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:53:13], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '78' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:53:13], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '75' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:53:13], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '60' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:53:13], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '18' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:53:13], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '19' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:53:13], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '73' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:53:13], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '71' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:53:13], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '69' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:53:13], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '68' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:53:13], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '74' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:53:13], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '35' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:53:13], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '70' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:53:13], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '59' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:53:13], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '32' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:53:13], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '58' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:53:13], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '56' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:53:13], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '57' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:53:13], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '61' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:53:13], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '63' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:53:13], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '54' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:53:13], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '66' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:53:13], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '45' ,status = '' ,priority = '' ,lead_time = '',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/12/2024 06:53:13], [file name :-/home/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'v3alpha',`create_date`= '2024-04-12 06:53:13',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 67 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;8760\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 52 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 76 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 24 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 77 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 64 ,status = \&#039;1\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;8760\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 65 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;8760\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 34 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 20 ,status = \&#039;1\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 55 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 62 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 53 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 16 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 78 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 75 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 60 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 18 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 19 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 73 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 71 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 69 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 68 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 74 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 35 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 70 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 59 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 32 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 58 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 56 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 57 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 61 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 63 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 54 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 66 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 45 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = ,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;',`log_description`= 'Supplier setting updated  Previous data-- agent_id-7867 ## supplier_id- 67 ## company_name - Agoda ## supplier_code-agoda  ## percentage - 0.00 ## lead_time - 8760 ==&lt;br&gt;== agent_id-7867 ## supplier_id- 52 ## company_name - Alphatours Dubai- Live ## supplier_code-alphatours  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-7867 ## supplier_id- 76 ## company_name - Dida ## supplier_code-dida  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-7867 ## supplier_id- 24 ## company_name - Destinations of the world (DOTW) ## supplier_code-dotw  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-7867 ## supplier_id- 77 ## company_name - Ebooking Center ## supplier_code-ebookingcenter  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-7867 ## supplier_id- 64 ## company_name - Expedia ## supplier_code-expedia  ## percentage - 0.00 ## lead_time - 8760 ==&lt;br&gt;== agent_id-7867 ## supplier_id- 65 ## company_name - Expedia Package ## supplier_code-expediapackage  ## percentage - 0.00 ## lead_time - 8760 ==&lt;br&gt;== agent_id-7867 ## supplier_id- 34 ## company_name - Gullivers Travel (Hotels) ## supplier_code-gta  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-7867 ## supplier_id- 20 ## company_name - Hotelbeds ## supplier_code-hotelbeds  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-7867 ## supplier_id- 55 ## company_name - Hotels Pro ## supplier_code-hotelspro  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-7867 ## supplier_id- 62 ## company_name - local_system ## supplier_code-localsystem  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-7867 ## supplier_id- 53 ## company_name - Lots of Hotels ## supplier_code-lotsofhotels  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-7867 ## supplier_id- 16 ## company_name - Miki ## supplier_code-miki  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-7867 ## supplier_id- 78 ## company_name - sunhotels ## supplier_code-sunhotels  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-7867 ## supplier_id- 75 ## company_name - TBO Holidays ## supplier_code-tboholidays  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-7867 ## supplier_id- 60 ## company_name - totalstay ## supplier_code-totalstay  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-7867 ## supplier_id- 18 ## company_name - Tourico ## supplier_code-tourico  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-7867 ## supplier_id- 19 ## company_name - Travco ## supplier_code-travco  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-7867 ## supplier_id- 73 ## company_name - WhiteSands ## supplier_code-whitesands  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-7867 ## supplier_id- 71 ## company_name - World Net Hotel ## supplier_code-wnh  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-7867 ## supplier_id- 69 ## company_name - Amadeus Flight ## supplier_code-amadeus  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-7867 ## supplier_id- 68 ## company_name - Pyton ## supplier_code-pyton  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-7867 ## supplier_id- 74 ## company_name - Sabre ## supplier_code-sabre  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-7867 ## supplier_id- 35 ## company_name - Gullivers Travel (Transfers) ## supplier_code-gtatransfer  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-7867 ## supplier_id- 70 ## company_name - Hotelbeds Transfer Test ## supplier_code-hotelbedstransfer  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-7867 ## supplier_id- 59 ## company_name - Local Transfer System ## supplier_code-localtransfer  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-7867 ## supplier_id- 32 ## company_name - Gullivers Travel (SS) ## supplier_code-gtasight  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-7867 ## supplier_id- 58 ## company_name - Viator (SightSeeing) ## supplier_code-viator  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-7867 ## supplier_id- 56 ## company_name - Group ## supplier_code-groups  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-7867 ## supplier_id- 57 ## compa',`ip`= '43.239.53.130';
[04/12/2024 06:53:17], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 06:53:17' WHERE id= '770';
[04/12/2024 06:53:21], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 06:53:21' WHERE id= '770';
[04/12/2024 06:53:21], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7867' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '32' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/04/21' , departure_date = '2024/04/22' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-04-12 06:53:21' , 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 06:53:21], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 06:53:21' WHERE id= '770';
[04/12/2024 06:53:22], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-04-12 06:53:22.28'
            , total_duration = '0.014'
            , hotel_count = 0
            , source_type = 'hotelbeds'
            , create_date = '2024-04-12 06:53:22'
            , session_id = '3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a'
            , agent_logs_id = '911'
            , error_description = ''
            , memory_used = '2287600';
[04/12/2024 06:53:22], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-04-12 06:53:22.29'
            , total_duration = '0.014'
            , hotel_count = 0
            , source_type = 'hotelbeds'
            , create_date = '2024-04-12 06:53:22'
            , session_id = '3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a'
            , agent_logs_id = '911'
            , error_description = ''
            , memory_used = '2287600';
[04/12/2024 06:53:22], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-04-12 06:53:22.28'
            , total_duration = '0.014'
            , hotel_count = 0
            , source_type = 'hotelbeds'
            , create_date = '2024-04-12 06:53:22'
            , session_id = '3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a'
            , agent_logs_id = '911'
            , error_description = ''
            , memory_used = '2287600';
[04/12/2024 06:53:22], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-04-12 06:53:22.28'
            , total_duration = '0.017'
            , hotel_count = 0
            , source_type = 'hotelbeds'
            , create_date = '2024-04-12 06:53:22'
            , session_id = '3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a'
            , agent_logs_id = '911'
            , error_description = ''
            , memory_used = '2287600';
[04/12/2024 06:53:22], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-04-12 06:53:22.28'
            , total_duration = '0.018'
            , hotel_count = 0
            , source_type = 'hotelbeds'
            , create_date = '2024-04-12 06:53:22'
            , session_id = '3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a'
            , agent_logs_id = '911'
            , error_description = ''
            , memory_used = '2287664';
[04/12/2024 06:53:22], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-04-12 06:53:22.28'
            , total_duration = '0.018'
            , hotel_count = 0
            , source_type = 'hotelbeds'
            , create_date = '2024-04-12 06:53:22'
            , session_id = '3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a'
            , agent_logs_id = '911'
            , error_description = ''
            , memory_used = '2287600';
[04/12/2024 06:53:22], [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_hotel_yards_911_1712904802_84.json', 'e1/12_04_2024/response_availability_hotel_yards_911_1712904802_84.json', 'e1/12_04_2024/response_header_availability_hotel_yards_911_1712904802_84.json', 'expedia', '2024-04-12 06:53:22', '', '3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a', '911');
[04/12/2024 06:53:22], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a&xml_user_id=7867&db_caching=1&erequest=2&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F120.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-12 06:53:22.29'
        , 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 = '2036488'
        WHERE id = '108076';
[04/12/2024 06:53:23], [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_hotel_yards_911_1712904802_38.json', 'e1/12_04_2024/response_availability_hotel_yards_911_1712904802_38.json', 'e1/12_04_2024/response_header_availability_hotel_yards_911_1712904802_38.json', 'expedia', '2024-04-12 06:53:23', '', '3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a', '911');
[04/12/2024 06:53:23], [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_hotel_yards_911_1712904802_31.json', 'e1/12_04_2024/response_availability_hotel_yards_911_1712904802_31.json', 'e1/12_04_2024/response_header_availability_hotel_yards_911_1712904802_31.json', 'expedia', '2024-04-12 06:53:23', '', '3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a', '911');
[04/12/2024 06:53:24], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a&xml_user_id=7867&db_caching=1&erequest=1&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F120.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-12 06:53:22.29'
        , 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.374'
        , error_description = ''
        , memory_used = '150923816'
        WHERE id = '108077';
[04/12/2024 06:53:25], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a&xml_user_id=7867&db_caching=1&erequest=0&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F120.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-12 06:53:22.28'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '3.013'
        , error_description = ''
        , memory_used = '184696016'
        WHERE id = '108078';
[04/12/2024 06:53:25], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '348',
        request_path = '/xml_all.php?userid=7867&sessionid=3899046b14d9a4b645633d4e42d545889ae60e539616ac442d711330f28cab8a',
        duration = '3.152',
        merge_duration = '0.002',
        assigned_supplier_count = '3',
        searched_supplier_count = '2',
        system_load_1_min = '0.16',
        system_load_5_min = '0.62',
        system_load_15_min = '1.84',
        system_memory_usage = '63.19',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '911') + '3205344',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '911';
[04/12/2024 06:53:25], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 06:53:25' WHERE id= '770';
[04/12/2024 06:53:27], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 06:53:27' WHERE id= '770';
[04/12/2024 06:56:12], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 06:56:12' WHERE id= '768';
[04/12/2024 06:56:12], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-04-12 06:56:12',login_attempt=0 where id = '7873';
[04/12/2024 06:56:12], [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 06:56:12', ip = '43.239.53.130', action = 'Login' ;
[04/12/2024 06:56:12], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 06:56:12' WHERE id= '768';
[04/12/2024 06:56:16], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 06:56:16' WHERE id= '768';
[04/12/2024 06:56:22], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 06:56:22' WHERE id= '768';
[04/12/2024 06:56:22], [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 06:56:22' , 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 06:56:22], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 06:56:22' WHERE id= '768';
[04/12/2024 06:56:23], [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_912_1712904983_5.json', 'e1p/12_04_2024/response_availability_Gajendra_912_1712904983_5.json', 'e1p/12_04_2024/response_header_availability_Gajendra_912_1712904983_5.json', 'expediapackage', '2024-04-12 06:56:23', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '912');
[04/12/2024 06:56:23], [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 06:56:23.101'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.231'
        , error_description = ''
        , memory_used = '2037168'
        WHERE id = '108079';
[04/12/2024 06:56:23], [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_912_1712904983_89.json', 'e1/12_04_2024/response_availability_Gajendra_912_1712904983_89.json', 'e1/12_04_2024/response_header_availability_Gajendra_912_1712904983_89.json', 'expedia', '2024-04-12 06:56:23', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '912');
[04/12/2024 06:56:23], [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 06:56:23.101'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.244'
        , error_description = ''
        , memory_used = '2036736'
        WHERE id = '108080';
[04/12/2024 06:56:24], [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_912_1712904983_8.json', 'e1/12_04_2024/response_availability_Gajendra_912_1712904983_8.json', 'e1/12_04_2024/response_header_availability_Gajendra_912_1712904983_8.json', 'expedia', '2024-04-12 06:56:24', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '912');
[04/12/2024 06:56:24], [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_912_1712904983_76.json', 'e1/12_04_2024/response_availability_Gajendra_912_1712904983_76.json', 'e1/12_04_2024/response_header_availability_Gajendra_912_1712904983_76.json', 'expedia', '2024-04-12 06:56:24', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '912');
[04/12/2024 06:56:25], [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_912_1712904983_37.json', 'e1p/12_04_2024/response_availability_Gajendra_912_1712904983_37.json', 'e1p/12_04_2024/response_header_availability_Gajendra_912_1712904983_37.json', 'expediapackage', '2024-04-12 06:56:25', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '912');
[04/12/2024 06:56:25], [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 06:56:23.101'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '2.575'
        , error_description = ''
        , memory_used = '159038888'
        WHERE id = '108081';
[04/12/2024 06:56: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_Gajendra_912_1712904983_78.json', 'e1p/12_04_2024/response_availability_Gajendra_912_1712904983_78.json', 'e1p/12_04_2024/response_header_availability_Gajendra_912_1712904983_78.json', 'expediapackage', '2024-04-12 06:56:26', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '912');
[04/12/2024 06:56: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=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 06:56:23.101'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '3.034'
        , error_description = ''
        , memory_used = '189336384'
        WHERE id = '108082';
[04/12/2024 06:56: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=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 06:56:23.101'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '3.671'
        , error_description = ''
        , memory_used = '166724176'
        WHERE id = '108083';
[04/12/2024 06:56:27], [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 06:56:23.101'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '4.401'
        , error_description = ''
        , memory_used = '197720536'
        WHERE id = '108084';
[04/12/2024 06:56:27], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '705',
        request_path = '/xml_all.php?userid=7873&sessionid=9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9',
        duration = '4.550',
        merge_duration = '0.003',
        assigned_supplier_count = '2',
        searched_supplier_count = '2',
        system_load_1_min = '0.96',
        system_load_5_min = '1.17',
        system_load_15_min = '1.86',
        system_memory_usage = '64.06',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '912') + '2425528',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '912';
[04/12/2024 06:56:27], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 06:56:27' WHERE id= '768';
[04/12/2024 06:56:28], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 06:56:28' WHERE id= '768';
[04/12/2024 06:56:30], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 06:56:30' WHERE id= '768';
[04/12/2024 06:56:46], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 06:56:46' WHERE id= '768';
[04/12/2024 06:56:57], [file name :-/home/otrams/public_html/beta/call.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 06:56:57' WHERE id= '768';
[04/12/2024 06:56: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_Gajendra_912_1712905017_21.json', 'e1p/12_04_2024/response_availability_Gajendra_912_1712905017_21.json', 'e1p/12_04_2024/response_header_availability_Gajendra_912_1712905017_21.json', 'expediapackage', '2024-04-12 06:56:57', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '912');
[04/12/2024 06:56: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=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 06:56:57.595'
        , 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.293'
        , error_description = ''
        , memory_used = '2305568'
        WHERE id = '108085';
[04/12/2024 06:59:06], [file name :-/home/otrams/public_html/beta/call.php],UPDATE user_sessions_ip SET update_date = '2024-04-12 06:59:06' WHERE id= '768';
[04/12/2024 06:59:06], [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_912_1712905146_23.json', 'e1p/12_04_2024/response_availability_Gajendra_912_1712905146_23.json', 'e1p/12_04_2024/response_header_availability_Gajendra_912_1712905146_23.json', 'expediapackage', '2024-04-12 06:59:06', '', '9cec254b4814512ad43813d531440504f2c9878bb2cdf6ecfb9d92bcebb5bee9', '912');
[04/12/2024 06:59: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=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 06:59:06.605'
        , 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.301'
        , error_description = ''
        , memory_used = '3219544'
        WHERE id = '108086';
