[04/18/2024 05:27:43], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-04-18 05:27:43',login_attempt=0 where id = '7873';
[04/18/2024 05:27:43], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Gajendra', user_type = 'A', branch_id = '1', login_datetime = '2024-04-18 05:27:43', ip = '43.239.53.130', action = 'Login' ;
[04/18/2024 05:27:43], [file name :-/home/otrams/public_html/beta/hotel_search.php],insert into user_sessions_ip SET ip_addr='43.239.53.130', agent_id='7873', session_id='4f1236abf232538ffb6e2b9212817d5aa1a713d4dbeb8bfd7d44721e47b2f975',create_date='2024-04-18 05:27:43', update_date='2024-04-18 05:27:43',domain='beta.astrabookings.com',sub_agent_id='',sub_user_id='';
[04/18/2024 05:27:54], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:27:54' WHERE id= '790';
[04/18/2024 05:28:02], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:28:02' WHERE id= '790';
[04/18/2024 05:28:02], [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-18 05:28:02' , 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/18/2024 05:28:03], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:28:03' WHERE id= '790';
[04/18/2024 05:28:03], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/18_04_2024/request_availability_Gajendra_1105_1713418083_6.json', 'e1p/18_04_2024/response_availability_Gajendra_1105_1713418083_6.json', 'e1p/18_04_2024/response_header_availability_Gajendra_1105_1713418083_6.json', 'expediapackage', '2024-04-18 05:28:03', '', '4f1236abf232538ffb6e2b9212817d5aa1a713d4dbeb8bfd7d44721e47b2f975', '1105');
[04/18/2024 05:28:03], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=4f1236abf232538ffb6e2b9212817d5aa1a713d4dbeb8bfd7d44721e47b2f975&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-18 05:28:03.385'
        , request_start_time = '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.306'
        , error_description = ''
        , memory_used = '1571032'
        WHERE id = '113733';
[04/18/2024 05:28:03], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/18_04_2024/request_availability_Gajendra_1105_1713418083_23.json', 'e1/18_04_2024/response_availability_Gajendra_1105_1713418083_23.json', 'e1/18_04_2024/response_header_availability_Gajendra_1105_1713418083_23.json', 'expedia', '2024-04-18 05:28:03', '', '4f1236abf232538ffb6e2b9212817d5aa1a713d4dbeb8bfd7d44721e47b2f975', '1105');
[04/18/2024 05:28:03], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=4f1236abf232538ffb6e2b9212817d5aa1a713d4dbeb8bfd7d44721e47b2f975&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-18 05:28:03.385'
        , request_start_time = '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.409'
        , error_description = ''
        , memory_used = '1569584'
        WHERE id = '113734';
[04/18/2024 05:28:04], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/18_04_2024/request_availability_Gajendra_1105_1713418083_97.json', 'e1/18_04_2024/response_availability_Gajendra_1105_1713418083_97.json', 'e1/18_04_2024/response_header_availability_Gajendra_1105_1713418083_97.json', 'expedia', '2024-04-18 05:28:04', '', '4f1236abf232538ffb6e2b9212817d5aa1a713d4dbeb8bfd7d44721e47b2f975', '1105');
[04/18/2024 05:28:04], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/18_04_2024/request_availability_Gajendra_1105_1713418083_4.json', 'e1/18_04_2024/response_availability_Gajendra_1105_1713418083_4.json', 'e1/18_04_2024/response_header_availability_Gajendra_1105_1713418083_4.json', 'expedia', '2024-04-18 05:28:04', '', '4f1236abf232538ffb6e2b9212817d5aa1a713d4dbeb8bfd7d44721e47b2f975', '1105');
[04/18/2024 05:28:05], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/18_04_2024/request_availability_Gajendra_1105_1713418083_57.json', 'e1p/18_04_2024/response_availability_Gajendra_1105_1713418083_57.json', 'e1p/18_04_2024/response_header_availability_Gajendra_1105_1713418083_57.json', 'expediapackage', '2024-04-18 05:28:05', '', '4f1236abf232538ffb6e2b9212817d5aa1a713d4dbeb8bfd7d44721e47b2f975', '1105');
[04/18/2024 05:28:05], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/18_04_2024/request_availability_Gajendra_1105_1713418083_33.json', 'e1p/18_04_2024/response_availability_Gajendra_1105_1713418083_33.json', 'e1p/18_04_2024/response_header_availability_Gajendra_1105_1713418083_33.json', 'expediapackage', '2024-04-18 05:28:05', '', '4f1236abf232538ffb6e2b9212817d5aa1a713d4dbeb8bfd7d44721e47b2f975', '1105');
[04/18/2024 05:28:05], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=4f1236abf232538ffb6e2b9212817d5aa1a713d4dbeb8bfd7d44721e47b2f975&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-18 05:28:03.385'
        , request_start_time = '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.355'
        , error_description = ''
        , memory_used = '146834864'
        WHERE id = '113735';
[04/18/2024 05:28:05], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=4f1236abf232538ffb6e2b9212817d5aa1a713d4dbeb8bfd7d44721e47b2f975&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-18 05:28:03.385'
        , request_start_time = '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.473'
        , error_description = ''
        , memory_used = '171329696'
        WHERE id = '113736';
[04/18/2024 05:28:06], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=4f1236abf232538ffb6e2b9212817d5aa1a713d4dbeb8bfd7d44721e47b2f975&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-18 05:28:03.385'
        , request_start_time = '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.066'
        , error_description = ''
        , memory_used = '153731992'
        WHERE id = '113738';
[04/18/2024 05:28:07], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=4f1236abf232538ffb6e2b9212817d5aa1a713d4dbeb8bfd7d44721e47b2f975&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-18 05:28:03.385'
        , request_start_time = '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.631'
        , error_description = ''
        , memory_used = '182141640'
        WHERE id = '113737';
[04/18/2024 05:28:07], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7873&sessionid=4f1236abf232538ffb6e2b9212817d5aa1a713d4dbeb8bfd7d44721e47b2f975',
        duration = '3.827',
        merge_duration = '0.003',
        assigned_supplier_count = '2',
        searched_supplier_count = '2',
        system_load_1_min = '0.04',
        system_load_5_min = '0.39',
        system_load_15_min = '0.53',
        system_memory_usage = '52.67',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1105') + '2790960',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1105';
[04/18/2024 05:28:07], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:28:07' WHERE id= '790';
[04/18/2024 05:28:08], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:28:08' WHERE id= '790';
[04/18/2024 05:28:10], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:28:10' WHERE id= '790';
[04/18/2024 05:36:22], [file name :-/home/otrams/public_html/beta/tms/logout.php],INSERT INTO psa_login_log set username = 'Ayman' , user_type = 'Ayman'_type , branch_id = '31' , login_datetime = '2024-04-18 05:36:22' , ip = '43.239.53.130' , action = 'Logout'  ;
[04/18/2024 05:36:57], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-04-18 05:36:57',login_attempt=0 where id = '7868';
[04/18/2024 05:36:57], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'hotelyards', user_type = 'A', branch_id = '32', login_datetime = '2024-04-18 05:36:57', ip = '43.239.53.130', action = 'Login' ;
[04/18/2024 05:36:57], [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='67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c',create_date='2024-04-18 05:36:57', update_date='2024-04-18 05:36:57',domain='hotelyards.astrabookings.com',sub_agent_id='',sub_user_id='';
[04/18/2024 05:37:01], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:37:01' WHERE id= '791';
[04/18/2024 05:37:06], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:37:06' WHERE id= '791';
[04/18/2024 05:37:06], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7868' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '32' , ip = '43.239.53.130' , city = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/01' , departure_date = '2024/05/02' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-04-18 05:37:06' , site_id = '21' , country_code = '106' , city_code = '64440' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[04/18/2024 05:37:07], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:37:07' WHERE id= '791';
[04/18/2024 05:37:08], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/18_04_2024/request_availability_hotel_yards_1106_1713418627_76.json', 'e1/18_04_2024/response_availability_hotel_yards_1106_1713418627_76.json', 'e1/18_04_2024/response_header_availability_hotel_yards_1106_1713418627_76.json', 'expedia', '2024-04-18 05:37:08', '', '67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c', '1106');
[04/18/2024 05:37:08], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/18_04_2024/request_availability_hotel_yards_1106_1713418627_79.json', 'e1/18_04_2024/response_availability_hotel_yards_1106_1713418627_79.json', 'e1/18_04_2024/response_header_availability_hotel_yards_1106_1713418627_79.json', 'expedia', '2024-04-18 05:37:08', '', '67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c', '1106');
[04/18/2024 05:37:08], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c&xml_user_id=7867&db_caching=1&erequest=1&total_request=2&web_service=no&site_id=21&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 05:37:07.693'
        , request_start_time = '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.887'
        , error_description = ''
        , memory_used = '17961128'
        WHERE id = '113739';
[04/18/2024 05:37:08], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c&xml_user_id=7867&db_caching=1&erequest=0&total_request=2&web_service=no&site_id=21&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 05:37:07.695'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '1.214'
        , error_description = ''
        , memory_used = '39546352'
        WHERE id = '113740';
[04/18/2024 05:37:08], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7867&sessionid=67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c',
        duration = '1.351',
        merge_duration = '0.002',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '1.71',
        system_load_5_min = '0.78',
        system_load_15_min = '0.58',
        system_memory_usage = '51.31',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1106') + '2034920',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1106';
[04/18/2024 05:37:09], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:37:09' WHERE id= '791';
[04/18/2024 05:37:22], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:37:22' WHERE id= '791';
[04/18/2024 05:37:22], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7868' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '32' , ip = '43.239.53.130' , city = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/01' , departure_date = '2024/05/02' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-04-18 05:37:22' , site_id = '21' , country_code = '106' , city_code = '64440' , ratings = '3.0,4.0,5.0' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[04/18/2024 05:37:22], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:37:22' WHERE id= '791';
[04/18/2024 05:37: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/18_04_2024/request_availability_hotel_yards_1107_1713418642_90.json', 'e1/18_04_2024/response_availability_hotel_yards_1107_1713418642_90.json', 'e1/18_04_2024/response_header_availability_hotel_yards_1107_1713418642_90.json', 'expedia', '2024-04-18 05:37:23', '', '67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c', '1107');
[04/18/2024 05:37: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/18_04_2024/request_availability_hotel_yards_1107_1713418642_20.json', 'e1/18_04_2024/response_availability_hotel_yards_1107_1713418642_20.json', 'e1/18_04_2024/response_header_availability_hotel_yards_1107_1713418642_20.json', 'expedia', '2024-04-18 05:37:23', '', '67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c', '1107');
[04/18/2024 05:37:23], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c&xml_user_id=7867&db_caching=1&erequest=1&total_request=2&web_service=no&site_id=21&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 05:37:22.790'
        , request_start_time = '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.749'
        , error_description = ''
        , memory_used = '17960552'
        WHERE id = '113741';
[04/18/2024 05:37:23], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c&xml_user_id=7867&db_caching=1&erequest=0&total_request=2&web_service=no&site_id=21&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 05:37:22.790'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '1.011'
        , error_description = ''
        , memory_used = '39547232'
        WHERE id = '113742';
[04/18/2024 05:37:23], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7867&sessionid=67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c',
        duration = '1.090',
        merge_duration = '0.002',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '3.78',
        system_load_5_min = '1.26',
        system_load_15_min = '0.74',
        system_memory_usage = '51.31',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1107') + '2037296',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1107';
[04/18/2024 05:37:24], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:37:24' WHERE id= '791';
[04/18/2024 05:37:49], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:37:49' WHERE id= '791';
[04/18/2024 05:37:49], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7868' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '32' , ip = '43.239.53.130' , city = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/01' , departure_date = '2024/05/02' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-04-18 05:37:49' , site_id = '21' , country_code = '106' , city_code = '64440' , ratings = '1.0,2.0,3.0,4.0,5.0' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[04/18/2024 05:37:49], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:37:49' WHERE id= '791';
[04/18/2024 05:37:50], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/18_04_2024/request_availability_hotel_yards_1108_1713418669_60.json', 'e1/18_04_2024/response_availability_hotel_yards_1108_1713418669_60.json', 'e1/18_04_2024/response_header_availability_hotel_yards_1108_1713418669_60.json', 'expedia', '2024-04-18 05:37:50', '', '67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c', '1108');
[04/18/2024 05:37:50], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c&xml_user_id=7867&db_caching=1&erequest=2&total_request=3&web_service=no&site_id=21&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 05:37:49.872'
        , request_start_time = '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.688'
        , error_description = ''
        , memory_used = '4867376'
        WHERE id = '113743';
[04/18/2024 05:37:50], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/18_04_2024/request_availability_hotel_yards_1108_1713418669_84.json', 'e1/18_04_2024/response_availability_hotel_yards_1108_1713418669_84.json', 'e1/18_04_2024/response_header_availability_hotel_yards_1108_1713418669_84.json', 'expedia', '2024-04-18 05:37:50', '', '67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c', '1108');
[04/18/2024 05:37:50], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/18_04_2024/request_availability_hotel_yards_1108_1713418669_88.json', 'e1/18_04_2024/response_availability_hotel_yards_1108_1713418669_88.json', 'e1/18_04_2024/response_header_availability_hotel_yards_1108_1713418669_88.json', 'expedia', '2024-04-18 05:37:50', '', '67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c', '1108');
[04/18/2024 05:37:50], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c&xml_user_id=7867&db_caching=1&erequest=1&total_request=3&web_service=no&site_id=21&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 05:37:49.871'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '1.023'
        , error_description = ''
        , memory_used = '28984608'
        WHERE id = '113744';
[04/18/2024 05:37:50], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c&xml_user_id=7867&db_caching=1&erequest=0&total_request=3&web_service=no&site_id=21&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 05:37:49.871'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '1.078'
        , error_description = ''
        , memory_used = '30117504'
        WHERE id = '113745';
[04/18/2024 05:37:50], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7867&sessionid=67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c',
        duration = '1.166',
        merge_duration = '0.002',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '3.05',
        system_load_5_min = '1.29',
        system_load_15_min = '0.76',
        system_memory_usage = '51.23',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1108') + '2037592',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1108';
[04/18/2024 05:37:51], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:37:51' WHERE id= '791';
[04/18/2024 05:38:29], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:38:29' WHERE id= '791';
[04/18/2024 05:38:29], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7868' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '32' , ip = '43.239.53.130' , city = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/01' , departure_date = '2024/05/02' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-04-18 05:38:29' , site_id = '21' , country_code = '106' , city_code = '64440' , ratings = '1.0,2.0,3.0,4.0,5.0' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[04/18/2024 05:38:30], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:38:30' WHERE id= '791';
[04/18/2024 05:38:31], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/18_04_2024/request_availability_hotel_yards_1109_1713418710_60.json', 'e1/18_04_2024/response_availability_hotel_yards_1109_1713418710_60.json', 'e1/18_04_2024/response_header_availability_hotel_yards_1109_1713418710_60.json', 'expedia', '2024-04-18 05:38:31', '', '67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c', '1109');
[04/18/2024 05:38:31], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c&xml_user_id=7867&db_caching=1&erequest=2&total_request=3&web_service=no&site_id=21&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 05:38:30.692'
        , request_start_time = '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.609'
        , error_description = ''
        , memory_used = '4864320'
        WHERE id = '113746';
[04/18/2024 05:38:31], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/18_04_2024/request_availability_hotel_yards_1109_1713418710_93.json', 'e1/18_04_2024/response_availability_hotel_yards_1109_1713418710_93.json', 'e1/18_04_2024/response_header_availability_hotel_yards_1109_1713418710_93.json', 'expedia', '2024-04-18 05:38:31', '', '67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c', '1109');
[04/18/2024 05:38:31], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/18_04_2024/request_availability_hotel_yards_1109_1713418710_90.json', 'e1/18_04_2024/response_availability_hotel_yards_1109_1713418710_90.json', 'e1/18_04_2024/response_header_availability_hotel_yards_1109_1713418710_90.json', 'expedia', '2024-04-18 05:38:31', '', '67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c', '1109');
[04/18/2024 05:38:31], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c&xml_user_id=7867&db_caching=1&erequest=1&total_request=3&web_service=no&site_id=21&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 05:38:30.692'
        , request_start_time = '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.952'
        , error_description = ''
        , memory_used = '28984360'
        WHERE id = '113748';
[04/18/2024 05:38:31], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c&xml_user_id=7867&db_caching=1&erequest=0&total_request=3&web_service=no&site_id=21&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 05:38:30.692'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '1.011'
        , error_description = ''
        , memory_used = '30080800'
        WHERE id = '113747';
[04/18/2024 05:38:31], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7867&sessionid=67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c',
        duration = '1.096',
        merge_duration = '0.002',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '2.59',
        system_load_5_min = '1.41',
        system_load_15_min = '0.83',
        system_memory_usage = '51.30',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1109') + '2037656',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1109';
[04/18/2024 05:38:32], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:38:32' WHERE id= '791';
[04/18/2024 05:38:47], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:38:47' WHERE id= '791';
[04/18/2024 05:38:47], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7868' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '32' , ip = '43.239.53.130' , city = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/01' , departure_date = '2024/05/02' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-04-18 05:38:47' , site_id = '21' , country_code = '106' , city_code = '64440' , ratings = '1.0,2.0,3.0,4.0,5.0' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[04/18/2024 05:38:48], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:38:48' WHERE id= '791';
[04/18/2024 05:38: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/18_04_2024/request_availability_hotel_yards_1110_1713418728_68.json', 'e1/18_04_2024/response_availability_hotel_yards_1110_1713418728_68.json', 'e1/18_04_2024/response_header_availability_hotel_yards_1110_1713418728_68.json', 'expedia', '2024-04-18 05:38:48', '', '67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c', '1110');
[04/18/2024 05:38:48], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c&xml_user_id=7867&db_caching=1&erequest=2&total_request=3&web_service=no&site_id=21&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 05:38:48.384'
        , request_start_time = '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.438'
        , error_description = ''
        , memory_used = '4863560'
        WHERE id = '113749';
[04/18/2024 05:38:49], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/18_04_2024/request_availability_hotel_yards_1110_1713418728_19.json', 'e1/18_04_2024/response_availability_hotel_yards_1110_1713418728_19.json', 'e1/18_04_2024/response_header_availability_hotel_yards_1110_1713418728_19.json', 'expedia', '2024-04-18 05:38:49', '', '67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c', '1110');
[04/18/2024 05:38:49], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/18_04_2024/request_availability_hotel_yards_1110_1713418728_44.json', 'e1/18_04_2024/response_availability_hotel_yards_1110_1713418728_44.json', 'e1/18_04_2024/response_header_availability_hotel_yards_1110_1713418728_44.json', 'expedia', '2024-04-18 05:38:49', '', '67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c', '1110');
[04/18/2024 05:38:49], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c&xml_user_id=7867&db_caching=1&erequest=0&total_request=3&web_service=no&site_id=21&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 05:38:48.383'
        , request_start_time = '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.916'
        , error_description = ''
        , memory_used = '30080272'
        WHERE id = '113750';
[04/18/2024 05:38:49], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c&xml_user_id=7867&db_caching=1&erequest=1&total_request=3&web_service=no&site_id=21&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 05:38:48.383'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '1.061'
        , error_description = ''
        , memory_used = '28985152'
        WHERE id = '113751';
[04/18/2024 05:38:49], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7867&sessionid=67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c',
        duration = '1.143',
        merge_duration = '0.002',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '2.39',
        system_load_5_min = '1.43',
        system_load_15_min = '0.84',
        system_memory_usage = '51.36',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1110') + '2036560',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1110';
[04/18/2024 05:38:49], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:38:49' WHERE id= '791';
[04/18/2024 05:39:07], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:39:07' WHERE id= '791';
[04/18/2024 05:39:07], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7868' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '32' , ip = '43.239.53.130' , city = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/01' , departure_date = '2024/05/02' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-04-18 05:39:07' , site_id = '21' , country_code = '106' , city_code = '64440' , ratings = '1.0,2.0,3.0,4.0,5.0' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[04/18/2024 05:39:08], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:39:08' WHERE id= '791';
[04/18/2024 05:39:08], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/18_04_2024/request_availability_hotel_yards_1111_1713418748_100.json', 'e1/18_04_2024/response_availability_hotel_yards_1111_1713418748_100.json', 'e1/18_04_2024/response_header_availability_hotel_yards_1111_1713418748_100.json', 'expedia', '2024-04-18 05:39:08', '', '67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c', '1111');
[04/18/2024 05:39:09], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/18_04_2024/request_availability_hotel_yards_1111_1713418748_78.json', 'e1/18_04_2024/response_availability_hotel_yards_1111_1713418748_78.json', 'e1/18_04_2024/response_header_availability_hotel_yards_1111_1713418748_78.json', 'expedia', '2024-04-18 05:39:09', '', '67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c', '1111');
[04/18/2024 05:39:09], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c&xml_user_id=7867&db_caching=1&erequest=0&total_request=3&web_service=no&site_id=21&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 05:39:08.385'
        , request_start_time = '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.884'
        , error_description = ''
        , memory_used = '30080184'
        WHERE id = '113752';
[04/18/2024 05:39:09], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/18_04_2024/request_availability_hotel_yards_1111_1713418748_61.json', 'e1/18_04_2024/response_availability_hotel_yards_1111_1713418748_61.json', 'e1/18_04_2024/response_header_availability_hotel_yards_1111_1713418748_61.json', 'expedia', '2024-04-18 05:39:09', '', '67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c', '1111');
[04/18/2024 05:39:09], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c&xml_user_id=7867&db_caching=1&erequest=2&total_request=3&web_service=no&site_id=21&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 05:39:08.386'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '1.060'
        , error_description = ''
        , memory_used = '4864408'
        WHERE id = '113754';
[04/18/2024 05:39:09], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c&xml_user_id=7867&db_caching=1&erequest=1&total_request=3&web_service=no&site_id=21&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 05:39:08.385'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '1.107'
        , error_description = ''
        , memory_used = '28984360'
        WHERE id = '113753';
[04/18/2024 05:39:09], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7867&sessionid=67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c',
        duration = '1.202',
        merge_duration = '0.002',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '3.16',
        system_load_5_min = '1.66',
        system_load_15_min = '0.93',
        system_memory_usage = '51.36',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1111') + '2036408',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1111';
[04/18/2024 05:39:09], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:39:09' WHERE id= '791';
[04/18/2024 05:39:46], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:39:46' WHERE id= '791';
[04/18/2024 05:39:46], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/18_04_2024/request_availability_hotel_yards_1111_1713418786_24.json', 'e1/18_04_2024/response_availability_hotel_yards_1111_1713418786_24.json', 'e1/18_04_2024/response_header_availability_hotel_yards_1111_1713418786_24.json', 'expedia', '2024-04-18 05:39:46', '', '67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c', '1111');
[04/18/2024 05:39:47], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c&xml_user_id=7867&db_caching=1&erequest=2&total_request=3&web_service=no&site_id=21&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 05:39:46.640'
        , request_start_time = '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.410'
        , error_description = ''
        , memory_used = '4899768'
        WHERE id = '113755';
[04/18/2024 05:39: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/18_04_2024/request_availability_hotel_yards_1111_1713418786_91.json', 'e1/18_04_2024/response_availability_hotel_yards_1111_1713418786_91.json', 'e1/18_04_2024/response_header_availability_hotel_yards_1111_1713418786_91.json', 'expedia', '2024-04-18 05:39:47', '', '67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c', '1111');
[04/18/2024 05:39: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/18_04_2024/request_availability_hotel_yards_1111_1713418786_55.json', 'e1/18_04_2024/response_availability_hotel_yards_1111_1713418786_55.json', 'e1/18_04_2024/response_header_availability_hotel_yards_1111_1713418786_55.json', 'expedia', '2024-04-18 05:39:47', '', '67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c', '1111');
[04/18/2024 05:39:47], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c&xml_user_id=7867&db_caching=1&erequest=1&total_request=3&web_service=no&site_id=21&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 05:39:46.640'
        , request_start_time = '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.856'
        , error_description = ''
        , memory_used = '29014960'
        WHERE id = '113756';
[04/18/2024 05:39:47], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c&xml_user_id=7867&db_caching=1&erequest=0&total_request=3&web_service=no&site_id=21&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 05:39:46.640'
        , request_start_time = '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.877'
        , error_description = ''
        , memory_used = '30168744'
        WHERE id = '113757';
[04/18/2024 05:39:47], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7867&sessionid=67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c',
        duration = '0.970',
        merge_duration = '0.003',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '2.54',
        system_load_5_min = '1.69',
        system_load_15_min = '0.97',
        system_memory_usage = '51.41',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1111') + '2135264',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1111';
[04/18/2024 05:40:02], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-04-18 05:40:02',login_attempt=0 where id = '7867';
[04/18/2024 05:40:02], [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-18 05:40:02', ip = '43.239.53.130', action = 'Login' ;
[04/18/2024 05:40:02], [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='8e61d9246e6bab30cf4d65107d77bdf428d0cdca723d411f6a279c0e61a01703',create_date='2024-04-18 05:40:02', update_date='2024-04-18 05:40:02',domain='beta.astrabookings.com',sub_agent_id='',sub_user_id='';
[04/18/2024 05:40:12], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:40:12' WHERE id= '791';
[04/18/2024 05:40:28], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:40:28' WHERE id= '792';
[04/18/2024 05:40:40], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:40:40' WHERE id= '792';
[04/18/2024 05:40:40], [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 = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/01' , departure_date = '2024/05/02' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-04-18 05:40:40' , site_id = '' , country_code = '106' , city_code = '64440' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[04/18/2024 05:40:41], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:40:41' WHERE id= '792';
[04/18/2024 05:40:42], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/18_04_2024/request_availability_hotel_yards_1112_1713418841_79.json', 'e1/18_04_2024/response_availability_hotel_yards_1112_1713418841_79.json', 'e1/18_04_2024/response_header_availability_hotel_yards_1112_1713418841_79.json', 'expedia', '2024-04-18 05:40:42', '', '8e61d9246e6bab30cf4d65107d77bdf428d0cdca723d411f6a279c0e61a01703', '1112');
[04/18/2024 05:40:42], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/18_04_2024/request_availability_hotel_yards_1112_1713418841_28.json', 'e1/18_04_2024/response_availability_hotel_yards_1112_1713418841_28.json', 'e1/18_04_2024/response_header_availability_hotel_yards_1112_1713418841_28.json', 'expedia', '2024-04-18 05:40:42', '', '8e61d9246e6bab30cf4d65107d77bdf428d0cdca723d411f6a279c0e61a01703', '1112');
[04/18/2024 05:40:42], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=8e61d9246e6bab30cf4d65107d77bdf428d0cdca723d411f6a279c0e61a01703&xml_user_id=7867&db_caching=1&erequest=1&total_request=2&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 05:40:41.644'
        , request_start_time = '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.827'
        , error_description = ''
        , memory_used = '15225872'
        WHERE id = '113759';
[04/18/2024 05:40:42], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=8e61d9246e6bab30cf4d65107d77bdf428d0cdca723d411f6a279c0e61a01703&xml_user_id=7867&db_caching=1&erequest=0&total_request=2&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 05:40:41.645'
        , request_start_time = '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.869'
        , error_description = ''
        , memory_used = '33240808'
        WHERE id = '113758';
[04/18/2024 05:40:42], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7867&sessionid=8e61d9246e6bab30cf4d65107d77bdf428d0cdca723d411f6a279c0e61a01703',
        duration = '0.995',
        merge_duration = '0.001',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '2.65',
        system_load_5_min = '1.86',
        system_load_15_min = '1.07',
        system_memory_usage = '51.54',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1112') + '1945016',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1112';
[04/18/2024 05:40:42], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:40:42' WHERE id= '792';
[04/18/2024 05:40:43], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:40:43' WHERE id= '792';
[04/18/2024 05:40:44], [file name :-/home/otrams/public_html/beta/call.php],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/18_04_2024/request_availability_hotel_yards_1112_1713418843_44.json', 'e1/18_04_2024/response_availability_hotel_yards_1112_1713418843_44.json', 'e1/18_04_2024/response_header_availability_hotel_yards_1112_1713418843_44.json', 'expedia', '2024-04-18 05:40:44', '', '8e61d9246e6bab30cf4d65107d77bdf428d0cdca723d411f6a279c0e61a01703', '1112');
[04/18/2024 05:40:44], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=8e61d9246e6bab30cf4d65107d77bdf428d0cdca723d411f6a279c0e61a01703&xml_user_id=7867&db_caching=1&erequest=1&total_request=2&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 05:40:43.526'
        , request_start_time = '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.696'
        , error_description = ''
        , memory_used = '15263048'
        WHERE id = '113760';
[04/18/2024 05:40:44], [file name :-/home/otrams/public_html/beta/call.php],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/18_04_2024/request_availability_hotel_yards_1112_1713418843_43.json', 'e1/18_04_2024/response_availability_hotel_yards_1112_1713418843_43.json', 'e1/18_04_2024/response_header_availability_hotel_yards_1112_1713418843_43.json', 'expedia', '2024-04-18 05:40:44', '', '8e61d9246e6bab30cf4d65107d77bdf428d0cdca723d411f6a279c0e61a01703', '1112');
[04/18/2024 05:40:44], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=8e61d9246e6bab30cf4d65107d77bdf428d0cdca723d411f6a279c0e61a01703&xml_user_id=7867&db_caching=1&erequest=0&total_request=2&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 05:40:43.525'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '1.260'
        , error_description = ''
        , memory_used = '33359128'
        WHERE id = '113761';
[04/18/2024 05:40:44], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7867&sessionid=8e61d9246e6bab30cf4d65107d77bdf428d0cdca723d411f6a279c0e61a01703',
        duration = '1.337',
        merge_duration = '0.002',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '2.65',
        system_load_5_min = '1.86',
        system_load_15_min = '1.07',
        system_memory_usage = '51.53',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1112') + '2012760',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1112';
[04/18/2024 05:40:45], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:40:45' WHERE id= '792';
[04/18/2024 05:40:50], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:40:50' WHERE id= '792';
[04/18/2024 05:41:00], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:41:00' WHERE id= '791';
[04/18/2024 05:42:36], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:42:36' WHERE id= '791';
[04/18/2024 05:42:40], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:42:40' WHERE id= '792';
[04/18/2024 05:42:42], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:42:42' WHERE id= '792';
[04/18/2024 05:42:45], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:42:45' WHERE id= '792';
[04/18/2024 05:42:47], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:42:47' WHERE id= '792';
[04/18/2024 05:42:53], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:42:53' WHERE id= '791';
[04/18/2024 05:42:54], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:42:54' WHERE id= '792';
[04/18/2024 05:42:57], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:42:57' WHERE id= '791';
[04/18/2024 05:43:01], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:43:01' WHERE id= '791';
[04/18/2024 05:43:01], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7868' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '32' , ip = '43.239.53.130' , city = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/01' , departure_date = '2024/05/02' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-04-18 05:43:01' , site_id = '21' , country_code = '106' , city_code = '64440' , ratings = '1.0,2.0,3.0,4.0,5.0' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[04/18/2024 05:43:02], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:43:02' WHERE id= '791';
[04/18/2024 05:43:02], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/18_04_2024/request_availability_hotel_yards_1113_1713418982_14.json', 'e1/18_04_2024/response_availability_hotel_yards_1113_1713418982_14.json', 'e1/18_04_2024/response_header_availability_hotel_yards_1113_1713418982_14.json', 'expedia', '2024-04-18 05:43:02', '', '67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c', '1113');
[04/18/2024 05:43:02], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c&xml_user_id=7867&db_caching=1&erequest=2&total_request=3&web_service=no&site_id=21&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 05:43:02.201'
        , request_start_time = '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.546'
        , error_description = ''
        , memory_used = '4864288'
        WHERE id = '113762';
[04/18/2024 05:43:02], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/18_04_2024/request_availability_hotel_yards_1113_1713418982_95.json', 'e1/18_04_2024/response_availability_hotel_yards_1113_1713418982_95.json', 'e1/18_04_2024/response_header_availability_hotel_yards_1113_1713418982_95.json', 'expedia', '2024-04-18 05:43:02', '', '67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c', '1113');
[04/18/2024 05:43:03], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/18_04_2024/request_availability_hotel_yards_1113_1713418982_76.json', 'e1/18_04_2024/response_availability_hotel_yards_1113_1713418982_76.json', 'e1/18_04_2024/response_header_availability_hotel_yards_1113_1713418982_76.json', 'expedia', '2024-04-18 05:43:03', '', '67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c', '1113');
[04/18/2024 05:43:03], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c&xml_user_id=7867&db_caching=1&erequest=0&total_request=3&web_service=no&site_id=21&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 05:43:02.201'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '1.025'
        , error_description = ''
        , memory_used = '30117504'
        WHERE id = '113763';
[04/18/2024 05:43:03], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c&xml_user_id=7867&db_caching=1&erequest=1&total_request=3&web_service=no&site_id=21&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 05:43:02.201'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '1.130'
        , error_description = ''
        , memory_used = '28984272'
        WHERE id = '113764';
[04/18/2024 05:43:03], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7867&sessionid=67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c',
        duration = '1.252',
        merge_duration = '0.002',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '2.18',
        system_load_5_min = '2.21',
        system_load_15_min = '1.34',
        system_memory_usage = '51.32',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1113') + '2037192',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1113';
[04/18/2024 05:43:03], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:43:03' WHERE id= '791';
[04/18/2024 05:43:08], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:43:08' WHERE id= '792';
[04/18/2024 05:43:08], [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 = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/01' , departure_date = '2024/05/02' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-04-18 05:43:08' , site_id = '' , country_code = '106' , city_code = '64440' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[04/18/2024 05:43:09], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:43:09' WHERE id= '792';
[04/18/2024 05:43:10], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/18_04_2024/request_availability_hotel_yards_1114_1713418990_61.json', 'e1/18_04_2024/response_availability_hotel_yards_1114_1713418990_61.json', 'e1/18_04_2024/response_header_availability_hotel_yards_1114_1713418990_61.json', 'expedia', '2024-04-18 05:43:10', '', '8e61d9246e6bab30cf4d65107d77bdf428d0cdca723d411f6a279c0e61a01703', '1114');
[04/18/2024 05:43:10], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/18_04_2024/request_availability_hotel_yards_1114_1713418990_7.json', 'e1/18_04_2024/response_availability_hotel_yards_1114_1713418990_7.json', 'e1/18_04_2024/response_header_availability_hotel_yards_1114_1713418990_7.json', 'expedia', '2024-04-18 05:43:10', '', '8e61d9246e6bab30cf4d65107d77bdf428d0cdca723d411f6a279c0e61a01703', '1114');
[04/18/2024 05:43:10], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=8e61d9246e6bab30cf4d65107d77bdf428d0cdca723d411f6a279c0e61a01703&xml_user_id=7867&db_caching=1&erequest=1&total_request=2&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 05:43:10.57'
        , request_start_time = '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.875'
        , error_description = ''
        , memory_used = '15225744'
        WHERE id = '113765';
[04/18/2024 05:43:11], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=8e61d9246e6bab30cf4d65107d77bdf428d0cdca723d411f6a279c0e61a01703&xml_user_id=7867&db_caching=1&erequest=0&total_request=2&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 05:43:10.58'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '1.209'
        , error_description = ''
        , memory_used = '33295784'
        WHERE id = '113766';
[04/18/2024 05:43:11], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7867&sessionid=8e61d9246e6bab30cf4d65107d77bdf428d0cdca723d411f6a279c0e61a01703',
        duration = '1.283',
        merge_duration = '0.001',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '2.08',
        system_load_5_min = '2.18',
        system_load_15_min = '1.34',
        system_memory_usage = '51.35',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1114') + '1945936',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1114';
[04/18/2024 05:43:11], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:43:11' WHERE id= '792';
[04/18/2024 05:43:13], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:43:13' WHERE id= '792';
[04/18/2024 05:43:40], [file name :-/home/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[04/18/2024 05:43:40], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '67' ,status = '' ,priority = '' ,lead_time = '8760',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[04/18/2024 05:43:40], [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/18/2024 05:43:40], [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/18/2024 05:43:40], [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/18/2024 05:43:40], [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/18/2024 05:43:40], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7867',supplier_id = '64' ,status = '' ,priority = '12' ,lead_time = '8760',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[04/18/2024 05:43:40], [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/18/2024 05:43:40], [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/18/2024 05:43:40], [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/18/2024 05:43:40], [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/18/2024 05:43:40], [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/18/2024 05:43:40], [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/18/2024 05:43:40], [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/18/2024 05:43:40], [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/18/2024 05:43:40], [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/18/2024 05:43:40], [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/18/2024 05:43:40], [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/18/2024 05:43:40], [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/18/2024 05:43:40], [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/18/2024 05:43:40], [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/18/2024 05:43:40], [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/18/2024 05:43:40], [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/18/2024 05:43:40], [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/18/2024 05:43:40], [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/18/2024 05:43:40], [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/18/2024 05:43:40], [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/18/2024 05:43:40], [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/18/2024 05:43:40], [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/18/2024 05:43:40], [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/18/2024 05:43:40], [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/18/2024 05:43:40], [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/18/2024 05:43:40], [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/18/2024 05:43:40], [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/18/2024 05:43:40], [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/18/2024 05:43:40], [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/18/2024 05:43:40], [file name :-/home/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'v3alpha',`create_date`= '2024-04-18 05:43:40',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7867\&#039;,supplier_id = 67 ,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 = 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;\&#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;\&#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 - 8760 ',`ip`= '43.239.53.130';
[04/18/2024 05:43:44], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:43:44' WHERE id= '792';
[04/18/2024 05:43:44], [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 = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/01' , departure_date = '2024/05/02' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-04-18 05:43:44' , site_id = '' , country_code = '106' , city_code = '64440' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[04/18/2024 05:43:45], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:43:45' WHERE id= '792';
[04/18/2024 05:43:46], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/18_04_2024/request_availability_hotel_yards_1115_1713419025_46.json', 'e1p/18_04_2024/response_availability_hotel_yards_1115_1713419025_46.json', 'e1p/18_04_2024/response_header_availability_hotel_yards_1115_1713419025_46.json', 'expediapackage', '2024-04-18 05:43:46', '', '8e61d9246e6bab30cf4d65107d77bdf428d0cdca723d411f6a279c0e61a01703', '1115');
[04/18/2024 05:43:46], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=8e61d9246e6bab30cf4d65107d77bdf428d0cdca723d411f6a279c0e61a01703&xml_user_id=7867&db_caching=1&erequest=1&total_request=2&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 05:43:45.232'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '1.031'
        , error_description = ''
        , memory_used = '16042232'
        WHERE id = '113767';
[04/18/2024 05:43:46], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/18_04_2024/request_availability_hotel_yards_1115_1713419025_52.json', 'e1p/18_04_2024/response_availability_hotel_yards_1115_1713419025_52.json', 'e1p/18_04_2024/response_header_availability_hotel_yards_1115_1713419025_52.json', 'expediapackage', '2024-04-18 05:43:46', '', '8e61d9246e6bab30cf4d65107d77bdf428d0cdca723d411f6a279c0e61a01703', '1115');
[04/18/2024 05:43:46], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=8e61d9246e6bab30cf4d65107d77bdf428d0cdca723d411f6a279c0e61a01703&xml_user_id=7867&db_caching=1&erequest=0&total_request=2&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 05:43:45.233'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '1.509'
        , error_description = ''
        , memory_used = '34887344'
        WHERE id = '113768';
[04/18/2024 05:43:46], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7867&sessionid=8e61d9246e6bab30cf4d65107d77bdf428d0cdca723d411f6a279c0e61a01703',
        duration = '1.591',
        merge_duration = '0.001',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '1.92',
        system_load_5_min = '2.13',
        system_load_15_min = '1.35',
        system_memory_usage = '51.68',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1115') + '1946600',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1115';
[04/18/2024 05:43:47], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:43:47' WHERE id= '792';
[04/18/2024 05:43:49], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:43:49' WHERE id= '791';
[04/18/2024 05:43:49], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7868' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '32' , ip = '43.239.53.130' , city = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/01' , departure_date = '2024/05/02' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-04-18 05:43:49' , site_id = '21' , country_code = '106' , city_code = '64440' , ratings = '1.0,2.0,3.0,4.0,5.0' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[04/18/2024 05:43:49], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:43:49' WHERE id= '792';
[04/18/2024 05:43:49], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:43:49' WHERE id= '791';
[04/18/2024 05:43:50], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/18_04_2024/request_availability_hotel_yards_1116_1713419029_6.json', 'e1p/18_04_2024/response_availability_hotel_yards_1116_1713419029_6.json', 'e1p/18_04_2024/response_header_availability_hotel_yards_1116_1713419029_6.json', 'expediapackage', '2024-04-18 05:43:50', '', '67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c', '1116');
[04/18/2024 05:43:50], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c&xml_user_id=7867&db_caching=1&erequest=2&total_request=3&web_service=no&site_id=21&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 05:43:49.653'
        , request_start_time = '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.557'
        , error_description = ''
        , memory_used = '5062568'
        WHERE id = '113769';
[04/18/2024 05:43:50], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:43:50' WHERE id= '792';
[04/18/2024 05:43:50], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/18_04_2024/request_availability_hotel_yards_1116_1713419029_6.json', 'e1p/18_04_2024/response_availability_hotel_yards_1116_1713419029_6.json', 'e1p/18_04_2024/response_header_availability_hotel_yards_1116_1713419029_6.json', 'expediapackage', '2024-04-18 05:43:50', '', '67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c', '1116');
[04/18/2024 05:43:50], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/18_04_2024/request_availability_hotel_yards_1116_1713419029_51.json', 'e1p/18_04_2024/response_availability_hotel_yards_1116_1713419029_51.json', 'e1p/18_04_2024/response_header_availability_hotel_yards_1116_1713419029_51.json', 'expediapackage', '2024-04-18 05:43:50', '', '67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c', '1116');
[04/18/2024 05:43:50], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c&xml_user_id=7867&db_caching=1&erequest=0&total_request=3&web_service=no&site_id=21&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 05:43:49.653'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '1.063'
        , error_description = ''
        , memory_used = '31595800'
        WHERE id = '113770';
[04/18/2024 05:43:50], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c&xml_user_id=7867&db_caching=1&erequest=1&total_request=3&web_service=no&site_id=21&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 05:43:49.653'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '1.132'
        , error_description = ''
        , memory_used = '29291080'
        WHERE id = '113771';
[04/18/2024 05:43:50], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7867&sessionid=67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c',
        duration = '1.221',
        merge_duration = '0.004',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '1.92',
        system_load_5_min = '2.13',
        system_load_15_min = '1.35',
        system_memory_usage = '51.68',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1116') + '2036608',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1116';
[04/18/2024 05:43:51], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:43:51' WHERE id= '791';
[04/18/2024 05:43:52], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:43:52' WHERE id= '791';
[04/18/2024 05:43:57], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:43:57' WHERE id= '792';
[04/18/2024 05:44:00], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:44:00' WHERE id= '791';
[04/18/2024 05:45:05], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:45:05' WHERE id= '792';
[04/18/2024 05:45:05], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:45:05' WHERE id= '792';
[04/18/2024 05:45:06], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:45:06' WHERE id= '792';
[04/18/2024 05:45:07], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:45:07' WHERE id= '792';
[04/18/2024 05:45:08], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:45:08' WHERE id= '792';
[04/18/2024 05:45:27], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:45:27' WHERE id= '792';
[04/18/2024 05:45:35], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:45:35' WHERE id= '792';
[04/18/2024 05:45:35], [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 = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/01' , departure_date = '2024/05/02' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-04-18 05:45:35' , site_id = '' , country_code = '106' , city_code = '64440' , ratings = '1.0,2.0,3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[04/18/2024 05:45:35], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:45:35' WHERE id= '792';
[04/18/2024 05:45:36], [file name :-/home/otrams/public_html/beta/call.php],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/18_04_2024/request_availability_hotel_yards_1117_1713419136_80.json', 'e1p/18_04_2024/response_availability_hotel_yards_1117_1713419136_80.json', 'e1p/18_04_2024/response_header_availability_hotel_yards_1117_1713419136_80.json', 'expediapackage', '2024-04-18 05:45:36', '', '8e61d9246e6bab30cf4d65107d77bdf428d0cdca723d411f6a279c0e61a01703', '1117');
[04/18/2024 05:45:36], [file name :-/home/otrams/public_html/beta/call.php],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/18_04_2024/request_availability_hotel_yards_1117_1713419136_94.json', 'e1p/18_04_2024/response_availability_hotel_yards_1117_1713419136_94.json', 'e1p/18_04_2024/response_header_availability_hotel_yards_1117_1713419136_94.json', 'expediapackage', '2024-04-18 05:45:36', '', '8e61d9246e6bab30cf4d65107d77bdf428d0cdca723d411f6a279c0e61a01703', '1117');
[04/18/2024 05:45:36], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=8e61d9246e6bab30cf4d65107d77bdf428d0cdca723d411f6a279c0e61a01703&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=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 05:45:35.966'
        , request_start_time = '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.890'
        , error_description = ''
        , memory_used = '4557688'
        WHERE id = '113772';
[04/18/2024 05:45:37], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/18_04_2024/request_availability_hotel_yards_1117_1713419135_63.json', 'e1p/18_04_2024/response_availability_hotel_yards_1117_1713419135_63.json', 'e1p/18_04_2024/response_header_availability_hotel_yards_1117_1713419135_63.json', 'expediapackage', '2024-04-18 05:45:37', '', '8e61d9246e6bab30cf4d65107d77bdf428d0cdca723d411f6a279c0e61a01703', '1117');
[04/18/2024 05:45:37], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=8e61d9246e6bab30cf4d65107d77bdf428d0cdca723d411f6a279c0e61a01703&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=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 05:45:35.966'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '1.061'
        , error_description = ''
        , memory_used = '25112528'
        WHERE id = '113773';
[04/18/2024 05:45:37], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=8e61d9246e6bab30cf4d65107d77bdf428d0cdca723d411f6a279c0e61a01703&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=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 05:45:35.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 = '1.346'
        , error_description = ''
        , memory_used = '26763816'
        WHERE id = '113774';
[04/18/2024 05:45:37], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7867&sessionid=8e61d9246e6bab30cf4d65107d77bdf428d0cdca723d411f6a279c0e61a01703',
        duration = '1.430',
        merge_duration = '0.001',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '3.19',
        system_load_5_min = '2.42',
        system_load_15_min = '1.53',
        system_memory_usage = '51.51',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1117') + '1948832',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1117';
[04/18/2024 05:45:37], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:45:37' WHERE id= '792';
[04/18/2024 05:45:39], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:45:39' WHERE id= '792';
[04/18/2024 05:45:48], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:45:48' WHERE id= '791';
[04/18/2024 05:45:48], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7868' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '32' , ip = '43.239.53.130' , city = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/01' , departure_date = '2024/05/02' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-04-18 05:45:48' , site_id = '21' , country_code = '106' , city_code = '64440' , ratings = '1.0,2.0,3.0,4.0,5.0' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[04/18/2024 05:45:49], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:45:49' WHERE id= '791';
[04/18/2024 05:45: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/18_04_2024/request_availability_hotel_yards_1118_1713419149_52.json', 'e1p/18_04_2024/response_availability_hotel_yards_1118_1713419149_52.json', 'e1p/18_04_2024/response_header_availability_hotel_yards_1118_1713419149_52.json', 'expediapackage', '2024-04-18 05:45:49', '', '67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c', '1118');
[04/18/2024 05:45:49], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c&xml_user_id=7867&db_caching=1&erequest=2&total_request=3&web_service=no&site_id=21&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 05:45:49.345'
        , request_start_time = '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.634'
        , error_description = ''
        , memory_used = '5060608'
        WHERE id = '113775';
[04/18/2024 05:45:50], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/18_04_2024/request_availability_hotel_yards_1118_1713419149_32.json', 'e1p/18_04_2024/response_availability_hotel_yards_1118_1713419149_32.json', 'e1p/18_04_2024/response_header_availability_hotel_yards_1118_1713419149_32.json', 'expediapackage', '2024-04-18 05:45:50', '', '67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c', '1118');
[04/18/2024 05:45:50], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/18_04_2024/request_availability_hotel_yards_1118_1713419149_87.json', 'e1p/18_04_2024/response_availability_hotel_yards_1118_1713419149_87.json', 'e1p/18_04_2024/response_header_availability_hotel_yards_1118_1713419149_87.json', 'expediapackage', '2024-04-18 05:45:50', '', '67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c', '1118');
[04/18/2024 05:45:50], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c&xml_user_id=7867&db_caching=1&erequest=1&total_request=3&web_service=no&site_id=21&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 05:45:49.345'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '1.059'
        , error_description = ''
        , memory_used = '29290904'
        WHERE id = '113776';
[04/18/2024 05:45:50], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c&xml_user_id=7867&db_caching=1&erequest=0&total_request=3&web_service=no&site_id=21&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 05:45:49.346'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '1.084'
        , error_description = ''
        , memory_used = '31589416'
        WHERE id = '113777';
[04/18/2024 05:45:50], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7867&sessionid=67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c',
        duration = '1.190',
        merge_duration = '0.002',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '2.93',
        system_load_5_min = '2.39',
        system_load_15_min = '1.53',
        system_memory_usage = '51.51',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1118') + '2039520',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1118';
[04/18/2024 05:45:50], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:45:50' WHERE id= '791';
[04/18/2024 05:45:51], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:45:51' WHERE id= '792';
[04/18/2024 05:45:55], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:45:55' WHERE id= '791';
[04/18/2024 05:49:22], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:49:22' WHERE id= '792';
[04/18/2024 05:49:30], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:49:30' WHERE id= '792';
[04/18/2024 05:49:30], [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 = 'istanbul' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/01' , departure_date = '2024/05/02' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-04-18 05:49:30' , site_id = '' , country_code = '93' , city_code = '61872' , ratings = '1.0,2.0,3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[04/18/2024 05:49:31], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:49:31' WHERE id= '792';
[04/18/2024 05:49:31], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/18_04_2024/request_availability_hotel_yards_1119_1713419371_26.json', 'e1p/18_04_2024/response_availability_hotel_yards_1119_1713419371_26.json', 'e1p/18_04_2024/response_header_availability_hotel_yards_1119_1713419371_26.json', 'expediapackage', '2024-04-18 05:49:31', '', '8e61d9246e6bab30cf4d65107d77bdf428d0cdca723d411f6a279c0e61a01703', '1119');
[04/18/2024 05:49:31], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=8e61d9246e6bab30cf4d65107d77bdf428d0cdca723d411f6a279c0e61a01703&xml_user_id=7867&db_caching=1&erequest=9&total_request=10&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 05:49:31.283'
        , request_start_time = '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.599'
        , error_description = ''
        , memory_used = '1562224'
        WHERE id = '113778';
[04/18/2024 05:49:32], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/18_04_2024/request_availability_hotel_yards_1119_1713419371_45.json', 'e1p/18_04_2024/response_availability_hotel_yards_1119_1713419371_45.json', 'e1p/18_04_2024/response_header_availability_hotel_yards_1119_1713419371_45.json', 'expediapackage', '2024-04-18 05:49:32', '', '8e61d9246e6bab30cf4d65107d77bdf428d0cdca723d411f6a279c0e61a01703', '1119');
[04/18/2024 05:49:32], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=8e61d9246e6bab30cf4d65107d77bdf428d0cdca723d411f6a279c0e61a01703&xml_user_id=7867&db_caching=1&erequest=8&total_request=10&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 05:49:31.283'
        , request_start_time = '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.751'
        , error_description = ''
        , memory_used = '1562096'
        WHERE id = '113779';
[04/18/2024 05:49:32], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/18_04_2024/request_availability_hotel_yards_1119_1713419371_66.json', 'e1p/18_04_2024/response_availability_hotel_yards_1119_1713419371_66.json', 'e1p/18_04_2024/response_header_availability_hotel_yards_1119_1713419371_66.json', 'expediapackage', '2024-04-18 05:49:32', '', '8e61d9246e6bab30cf4d65107d77bdf428d0cdca723d411f6a279c0e61a01703', '1119');
[04/18/2024 05:49:32], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/18_04_2024/request_availability_hotel_yards_1119_1713419371_84.json', 'e1p/18_04_2024/response_availability_hotel_yards_1119_1713419371_84.json', 'e1p/18_04_2024/response_header_availability_hotel_yards_1119_1713419371_84.json', 'expediapackage', '2024-04-18 05:49:32', '', '8e61d9246e6bab30cf4d65107d77bdf428d0cdca723d411f6a279c0e61a01703', '1119');
[04/18/2024 05:49:32], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/18_04_2024/request_availability_hotel_yards_1119_1713419371_15.json', 'e1p/18_04_2024/response_availability_hotel_yards_1119_1713419371_15.json', 'e1p/18_04_2024/response_header_availability_hotel_yards_1119_1713419371_15.json', 'expediapackage', '2024-04-18 05:49:32', '', '8e61d9246e6bab30cf4d65107d77bdf428d0cdca723d411f6a279c0e61a01703', '1119');
[04/18/2024 05:49:32], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/18_04_2024/request_availability_hotel_yards_1119_1713419371_77.json', 'e1p/18_04_2024/response_availability_hotel_yards_1119_1713419371_77.json', 'e1p/18_04_2024/response_header_availability_hotel_yards_1119_1713419371_77.json', 'expediapackage', '2024-04-18 05:49:32', '', '8e61d9246e6bab30cf4d65107d77bdf428d0cdca723d411f6a279c0e61a01703', '1119');
[04/18/2024 05:49:32], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/18_04_2024/request_availability_hotel_yards_1119_1713419371_64.json', 'e1p/18_04_2024/response_availability_hotel_yards_1119_1713419371_64.json', 'e1p/18_04_2024/response_header_availability_hotel_yards_1119_1713419371_64.json', 'expediapackage', '2024-04-18 05:49:32', '', '8e61d9246e6bab30cf4d65107d77bdf428d0cdca723d411f6a279c0e61a01703', '1119');
[04/18/2024 05:49:32], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/18_04_2024/request_availability_hotel_yards_1119_1713419371_46.json', 'e1p/18_04_2024/response_availability_hotel_yards_1119_1713419371_46.json', 'e1p/18_04_2024/response_header_availability_hotel_yards_1119_1713419371_46.json', 'expediapackage', '2024-04-18 05:49:32', '', '8e61d9246e6bab30cf4d65107d77bdf428d0cdca723d411f6a279c0e61a01703', '1119');
[04/18/2024 05:49:32], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/18_04_2024/request_availability_hotel_yards_1119_1713419371_27.json', 'e1p/18_04_2024/response_availability_hotel_yards_1119_1713419371_27.json', 'e1p/18_04_2024/response_header_availability_hotel_yards_1119_1713419371_27.json', 'expediapackage', '2024-04-18 05:49:32', '', '8e61d9246e6bab30cf4d65107d77bdf428d0cdca723d411f6a279c0e61a01703', '1119');
[04/18/2024 05:49:32], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=8e61d9246e6bab30cf4d65107d77bdf428d0cdca723d411f6a279c0e61a01703&xml_user_id=7867&db_caching=1&erequest=3&total_request=10&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 05:49:31.283'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '1.627'
        , error_description = ''
        , memory_used = '57861952'
        WHERE id = '113780';
[04/18/2024 05:49:32], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=8e61d9246e6bab30cf4d65107d77bdf428d0cdca723d411f6a279c0e61a01703&xml_user_id=7867&db_caching=1&erequest=7&total_request=10&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 05:49:31.283'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '1.711'
        , error_description = ''
        , memory_used = '39986112'
        WHERE id = '113782';
[04/18/2024 05:49:33], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=8e61d9246e6bab30cf4d65107d77bdf428d0cdca723d411f6a279c0e61a01703&xml_user_id=7867&db_caching=1&erequest=2&total_request=10&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 05:49:31.283'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '1.968'
        , error_description = ''
        , memory_used = '66227336'
        WHERE id = '113783';
[04/18/2024 05:49:33], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=8e61d9246e6bab30cf4d65107d77bdf428d0cdca723d411f6a279c0e61a01703&xml_user_id=7867&db_caching=1&erequest=1&total_request=10&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 05:49:31.283'
        , request_start_time = '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.013'
        , error_description = ''
        , memory_used = '67536616'
        WHERE id = '113785';
[04/18/2024 05:49:33], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=8e61d9246e6bab30cf4d65107d77bdf428d0cdca723d411f6a279c0e61a01703&xml_user_id=7867&db_caching=1&erequest=0&total_request=10&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 05:49:31.283'
        , request_start_time = '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.050'
        , error_description = ''
        , memory_used = '66509432'
        WHERE id = '113781';
[04/18/2024 05:49:33], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/18_04_2024/request_availability_hotel_yards_1119_1713419371_46.json', 'e1p/18_04_2024/response_availability_hotel_yards_1119_1713419371_46.json', 'e1p/18_04_2024/response_header_availability_hotel_yards_1119_1713419371_46.json', 'expediapackage', '2024-04-18 05:49:33', '', '8e61d9246e6bab30cf4d65107d77bdf428d0cdca723d411f6a279c0e61a01703', '1119');
[04/18/2024 05:49:33], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=8e61d9246e6bab30cf4d65107d77bdf428d0cdca723d411f6a279c0e61a01703&xml_user_id=7867&db_caching=1&erequest=6&total_request=10&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 05:49:31.283'
        , request_start_time = '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.091'
        , error_description = ''
        , memory_used = '64290216'
        WHERE id = '113786';
[04/18/2024 05:49:33], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=8e61d9246e6bab30cf4d65107d77bdf428d0cdca723d411f6a279c0e61a01703&xml_user_id=7867&db_caching=1&erequest=4&total_request=10&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 05:49:31.283'
        , request_start_time = '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.103'
        , error_description = ''
        , memory_used = '64982728'
        WHERE id = '113784';
[04/18/2024 05:49:34], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=8e61d9246e6bab30cf4d65107d77bdf428d0cdca723d411f6a279c0e61a01703&xml_user_id=7867&db_caching=1&erequest=5&total_request=10&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 05:49:31.283'
        , request_start_time = '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.720'
        , error_description = ''
        , memory_used = '72170528'
        WHERE id = '113787';
[04/18/2024 05:49:34], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7867&sessionid=8e61d9246e6bab30cf4d65107d77bdf428d0cdca723d411f6a279c0e61a01703',
        duration = '2.936',
        merge_duration = '0.004',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '2.29',
        system_load_5_min = '2.39',
        system_load_15_min = '1.72',
        system_memory_usage = '51.55',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1119') + '1948848',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1119';
[04/18/2024 05:49:34], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:49:34' WHERE id= '792';
[04/18/2024 05:49:36], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:49:36' WHERE id= '792';
[04/18/2024 05:49:36], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:49:36' WHERE id= '791';
[04/18/2024 05:49:38], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:49:38' WHERE id= '791';
[04/18/2024 05:49:42], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:49:42' WHERE id= '791';
[04/18/2024 05:49:42], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7868' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '32' , ip = '43.239.53.130' , city = 'istanbul' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/01' , departure_date = '2024/05/02' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-04-18 05:49:42' , site_id = '21' , country_code = '93' , city_code = '61872' , ratings = '1.0,2.0,3.0,4.0,5.0' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[04/18/2024 05:49:43], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:49:43' WHERE id= '791';
[04/18/2024 05:49:44], [file name :-/home/otrams/public_html/beta/call.php],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/18_04_2024/request_availability_hotel_yards_1120_1713419383_12.json', 'e1p/18_04_2024/response_availability_hotel_yards_1120_1713419383_12.json', 'e1p/18_04_2024/response_header_availability_hotel_yards_1120_1713419383_12.json', 'expediapackage', '2024-04-18 05:49:44', '', '67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c', '1120');
[04/18/2024 05:49:44], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c&xml_user_id=7867&db_caching=1&erequest=3&total_request=4&web_service=no&site_id=21&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 05:49:43.510'
        , request_start_time = '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.512'
        , error_description = ''
        , memory_used = '1646752'
        WHERE id = '113788';
[04/18/2024 05:49:44], [file name :-/home/otrams/public_html/beta/call.php],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/18_04_2024/request_availability_hotel_yards_1120_1713419383_84.json', 'e1p/18_04_2024/response_availability_hotel_yards_1120_1713419383_84.json', 'e1p/18_04_2024/response_header_availability_hotel_yards_1120_1713419383_84.json', 'expediapackage', '2024-04-18 05:49:44', '', '67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c', '1120');
[04/18/2024 05:49:45], [file name :-/home/otrams/public_html/beta/call.php],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/18_04_2024/request_availability_hotel_yards_1120_1713419383_66.json', 'e1p/18_04_2024/response_availability_hotel_yards_1120_1713419383_66.json', 'e1p/18_04_2024/response_header_availability_hotel_yards_1120_1713419383_66.json', 'expediapackage', '2024-04-18 05:49:45', '', '67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c', '1120');
[04/18/2024 05:49:45], [file name :-/home/otrams/public_html/beta/call.php],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/18_04_2024/request_availability_hotel_yards_1120_1713419383_19.json', 'e1p/18_04_2024/response_availability_hotel_yards_1120_1713419383_19.json', 'e1p/18_04_2024/response_header_availability_hotel_yards_1120_1713419383_19.json', 'expediapackage', '2024-04-18 05:49:45', '', '67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c', '1120');
[04/18/2024 05:49:45], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c&xml_user_id=7867&db_caching=1&erequest=2&total_request=4&web_service=no&site_id=21&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 05:49:43.510'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '1.935'
        , error_description = ''
        , memory_used = '71177888'
        WHERE id = '113789';
[04/18/2024 05:49:46], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c&xml_user_id=7867&db_caching=1&erequest=1&total_request=4&web_service=no&site_id=21&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 05:49:43.510'
        , request_start_time = '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.726'
        , error_description = ''
        , memory_used = '127853296'
        WHERE id = '113790';
[04/18/2024 05:49:46], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c&xml_user_id=7867&db_caching=1&erequest=0&total_request=4&web_service=no&site_id=21&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 05:49:43.510'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '2.917'
        , error_description = ''
        , memory_used = '129073784'
        WHERE id = '113791';
[04/18/2024 05:49:46], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7867&sessionid=67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c',
        duration = '3.046',
        merge_duration = '0.002',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '2.09',
        system_load_5_min = '2.34',
        system_load_15_min = '1.71',
        system_memory_usage = '51.61',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1120') + '2039520',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1120';
[04/18/2024 05:49:46], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:49:46' WHERE id= '791';
[04/18/2024 05:49:48], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:49:48' WHERE id= '792';
[04/18/2024 05:49:50], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 05:49:50' WHERE id= '791';
