[02/01/2024 06:00:00], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-01 06:00:00' WHERE id= '488';
[02/01/2024 06:00:00], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-01 06:00:00' WHERE id= '488';
[02/01/2024 06:00:05], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-01 06:00:05' WHERE id= '485';
[02/01/2024 06:00:09], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-01 06:00:09' WHERE id= '485';
[02/01/2024 06:00:19], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-02-01 06:00:19' WHERE id= '485';
[02/01/2024 06:00:32], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-02-01 06:00:32' WHERE id= '485';
[02/01/2024 06:00:32], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-01 06:00:32',login_attempt=0 where id = '7870';
[02/01/2024 06:00:32], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'hotelyards-agent', user_type = 'A', branch_id = '32', login_datetime = '2024-02-01 06:00:32', ip = '43.239.53.130', action = 'Login' ;
[02/01/2024 06:00:32], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-01 06:00:32' WHERE id= '485';
[02/01/2024 06:00:36], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-01 06:00:36' WHERE id= '485';
[02/01/2024 06:00:40], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-01 06:00:40' WHERE id= '485';
[02/01/2024 06:00:40], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7870' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '32' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '95' , service_type = 'hotel' , arrival_date = '2024/02/29' , departure_date = '2024/03/01' , nights = '1' , nationality = '95' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-02-01 06:00:40' , site_id = '21' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[02/01/2024 06:00:40], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-02-01 06:00:40' WHERE id= '485';
[02/01/2024 06:00:41], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/01_02_2024/request_availability_hotel_yards_06_00_40_1706767240_86.json', 'e1p/01_02_2024/response_availability_hotel_yards_06_00_40_1706767240_86.json', 'e1p/01_02_2024/response_header_availability_hotel_yards_06_00_40_1706767240_86.json', 'expediapackage', '2024-02-01 06:00:41', '', 'e84317825cd5dddd72212b59fdb25c61df0b28e6e40aa3bce1e3742181144b3b', '0');
[02/01/2024 06:00:41], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/01_02_2024/request_availability_hotel_yards_06_00_40_1706767240_31.json', 'e1/01_02_2024/response_availability_hotel_yards_06_00_40_1706767240_31.json', 'e1/01_02_2024/response_header_availability_hotel_yards_06_00_40_1706767240_31.json', 'expedia', '2024-02-01 06:00:41', '', 'e84317825cd5dddd72212b59fdb25c61df0b28e6e40aa3bce1e3742181144b3b', '0');
[02/01/2024 06:00:41], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=e84317825cd5dddd72212b59fdb25c61df0b28e6e40aa3bce1e3742181144b3b&xml_user_id=7867&db_caching=1&erequest=2&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=95'
            , http_hit_time = '2024-02-01 06:00:40.771'
            , request_start_time = '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.421'
            , error_description = ''
            , memory_used = '1792400'
            WHERE id = '30484';
[02/01/2024 06:00:41], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=e84317825cd5dddd72212b59fdb25c61df0b28e6e40aa3bce1e3742181144b3b&xml_user_id=7867&db_caching=1&erequest=2&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=95'
            , http_hit_time = '2024-02-01 06:00:40.771'
            , request_start_time = '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.425'
            , error_description = ''
            , memory_used = '1733384'
            WHERE id = '30485';
[02/01/2024 06:00: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/01_02_2024/request_availability_hotel_yards_06_00_40_1706767240_77.json', 'e1/01_02_2024/response_availability_hotel_yards_06_00_40_1706767240_77.json', 'e1/01_02_2024/response_header_availability_hotel_yards_06_00_40_1706767240_77.json', 'expedia', '2024-02-01 06:00:42', '', 'e84317825cd5dddd72212b59fdb25c61df0b28e6e40aa3bce1e3742181144b3b', '0');
[02/01/2024 06:00: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/01_02_2024/request_availability_hotel_yards_06_00_40_1706767240_79.json', 'e1/01_02_2024/response_availability_hotel_yards_06_00_40_1706767240_79.json', 'e1/01_02_2024/response_header_availability_hotel_yards_06_00_40_1706767240_79.json', 'expedia', '2024-02-01 06:00:42', '', 'e84317825cd5dddd72212b59fdb25c61df0b28e6e40aa3bce1e3742181144b3b', '0');
[02/01/2024 06:00:43], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/01_02_2024/request_availability_hotel_yards_06_00_40_1706767240_99.json', 'e1p/01_02_2024/response_availability_hotel_yards_06_00_40_1706767240_99.json', 'e1p/01_02_2024/response_header_availability_hotel_yards_06_00_40_1706767240_99.json', 'expediapackage', '2024-02-01 06:00:43', '', 'e84317825cd5dddd72212b59fdb25c61df0b28e6e40aa3bce1e3742181144b3b', '0');
[02/01/2024 06:00:44], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=e84317825cd5dddd72212b59fdb25c61df0b28e6e40aa3bce1e3742181144b3b&xml_user_id=7867&db_caching=1&erequest=0&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=95'
            , http_hit_time = '2024-02-01 06:00:40.771'
            , request_start_time = '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.231'
            , error_description = ''
            , memory_used = '179125992'
            WHERE id = '30486';
[02/01/2024 06:00:44], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=e84317825cd5dddd72212b59fdb25c61df0b28e6e40aa3bce1e3742181144b3b&xml_user_id=7867&db_caching=1&erequest=1&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=95'
            , http_hit_time = '2024-02-01 06:00:40.771'
            , request_start_time = '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.415'
            , error_description = ''
            , memory_used = '159963728'
            WHERE id = '30487';
[02/01/2024 06:00:44], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=e84317825cd5dddd72212b59fdb25c61df0b28e6e40aa3bce1e3742181144b3b&xml_user_id=7867&db_caching=1&erequest=1&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=95'
            , http_hit_time = '2024-02-01 06:00:40.771'
            , request_start_time = '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.765'
            , error_description = ''
            , memory_used = '167793208'
            WHERE id = '30488';
[02/01/2024 06:00: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/01_02_2024/request_availability_hotel_yards_06_00_40_1706767240_34.json', 'e1p/01_02_2024/response_availability_hotel_yards_06_00_40_1706767240_34.json', 'e1p/01_02_2024/response_header_availability_hotel_yards_06_00_40_1706767240_34.json', 'expediapackage', '2024-02-01 06:00:45', '', 'e84317825cd5dddd72212b59fdb25c61df0b28e6e40aa3bce1e3742181144b3b', '0');
[02/01/2024 06:00:47], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=e84317825cd5dddd72212b59fdb25c61df0b28e6e40aa3bce1e3742181144b3b&xml_user_id=7867&db_caching=1&erequest=0&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=95'
            , http_hit_time = '2024-02-01 06:00:40.771'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '6.350'
            , error_description = ''
            , memory_used = '190090056'
            WHERE id = '30489';
[02/01/2024 06:00:47], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-02-01 06:00:47' WHERE id= '485';
[02/01/2024 06:00:48], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-02-01 06:00:48' WHERE id= '485';
[02/01/2024 06:00:48], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-02-01 06:00:48' WHERE id= '485';
[02/01/2024 06:00:52], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-01 06:00:52' WHERE id= '485';
[02/01/2024 06:00:52], [file name :-/home/otrams/public_html/beta/view_map.php],UPDATE user_sessions_ip SET update_date = '2024-02-01 06:00:52' WHERE id= '485';
[02/01/2024 06:06:35], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-02-01 06:06:35' WHERE id= '485';
[02/01/2024 06:06:44], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-01 06:06:44' WHERE id= '485';
[02/01/2024 06:06:54], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-01 06:06:54' WHERE id= '485';
[02/01/2024 06:06:55], [file name :-/home/otrams/public_html/beta/view_map.php],UPDATE user_sessions_ip SET update_date = '2024-02-01 06:06:55' WHERE id= '485';
[02/01/2024 06:18:02], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-02-01 06:18:02' WHERE id= '485';
[02/01/2024 06:18:02], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-01 06:18:02',login_attempt=0 where id = '7870';
[02/01/2024 06:18:02], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'hotelyards-agent', user_type = 'A', branch_id = '32', login_datetime = '2024-02-01 06:18:02', ip = '43.239.53.130', action = 'Login' ;
[02/01/2024 06:18:02], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-01 06:18:02' WHERE id= '485';
[02/01/2024 06:18:06], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-01 06:18:06' WHERE id= '485';
[02/01/2024 06:18:09], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-01 06:18:09' WHERE id= '485';
[02/01/2024 06:18:09], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7870' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '32' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '95' , service_type = 'hotel' , arrival_date = '2024/02/29' , departure_date = '2024/03/01' , nights = '1' , nationality = '95' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-02-01 06:18:09' , site_id = '21' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[02/01/2024 06:18:09], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-02-01 06:18:09' WHERE id= '485';
[02/01/2024 06:18: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/01_02_2024/request_availability_hotel_yards_06_18_10_1706768290_25.json', 'e1/01_02_2024/response_availability_hotel_yards_06_18_10_1706768290_25.json', 'e1/01_02_2024/response_header_availability_hotel_yards_06_18_10_1706768290_25.json', 'expedia', '2024-02-01 06:18:10', '', 'e84317825cd5dddd72212b59fdb25c61df0b28e6e40aa3bce1e3742181144b3b', '0');
[02/01/2024 06:18:10], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=e84317825cd5dddd72212b59fdb25c61df0b28e6e40aa3bce1e3742181144b3b&xml_user_id=7867&db_caching=1&erequest=2&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=95'
            , http_hit_time = '2024-02-01 06:18:10.96'
            , request_start_time = '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.230'
            , error_description = ''
            , memory_used = '1425472'
            WHERE id = '30490';
[02/01/2024 06:18: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', 'e1p/01_02_2024/request_availability_hotel_yards_06_18_10_1706768290_44.json', 'e1p/01_02_2024/response_availability_hotel_yards_06_18_10_1706768290_44.json', 'e1p/01_02_2024/response_header_availability_hotel_yards_06_18_10_1706768290_44.json', 'expediapackage', '2024-02-01 06:18:10', '', 'e84317825cd5dddd72212b59fdb25c61df0b28e6e40aa3bce1e3742181144b3b', '0');
[02/01/2024 06:18:10], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=e84317825cd5dddd72212b59fdb25c61df0b28e6e40aa3bce1e3742181144b3b&xml_user_id=7867&db_caching=1&erequest=2&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=95'
            , http_hit_time = '2024-02-01 06:18:10.96'
            , request_start_time = '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.342'
            , error_description = ''
            , memory_used = '1425984'
            WHERE id = '30491';
[02/01/2024 06:18:11], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/01_02_2024/request_availability_hotel_yards_06_18_10_1706768290_53.json', 'e1/01_02_2024/response_availability_hotel_yards_06_18_10_1706768290_53.json', 'e1/01_02_2024/response_header_availability_hotel_yards_06_18_10_1706768290_53.json', 'expedia', '2024-02-01 06:18:11', '', 'e84317825cd5dddd72212b59fdb25c61df0b28e6e40aa3bce1e3742181144b3b', '0');
[02/01/2024 06:18:11], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/01_02_2024/request_availability_hotel_yards_06_18_10_1706768290_43.json', 'e1/01_02_2024/response_availability_hotel_yards_06_18_10_1706768290_43.json', 'e1/01_02_2024/response_header_availability_hotel_yards_06_18_10_1706768290_43.json', 'expedia', '2024-02-01 06:18:11', '', 'e84317825cd5dddd72212b59fdb25c61df0b28e6e40aa3bce1e3742181144b3b', '0');
[02/01/2024 06:18:12], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/01_02_2024/request_availability_hotel_yards_06_18_10_1706768290_56.json', 'e1p/01_02_2024/response_availability_hotel_yards_06_18_10_1706768290_56.json', 'e1p/01_02_2024/response_header_availability_hotel_yards_06_18_10_1706768290_56.json', 'expediapackage', '2024-02-01 06:18:12', '', 'e84317825cd5dddd72212b59fdb25c61df0b28e6e40aa3bce1e3742181144b3b', '0');
[02/01/2024 06:18:12], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/01_02_2024/request_availability_hotel_yards_06_18_10_1706768290_55.json', 'e1p/01_02_2024/response_availability_hotel_yards_06_18_10_1706768290_55.json', 'e1p/01_02_2024/response_header_availability_hotel_yards_06_18_10_1706768290_55.json', 'expediapackage', '2024-02-01 06:18:12', '', 'e84317825cd5dddd72212b59fdb25c61df0b28e6e40aa3bce1e3742181144b3b', '0');
[02/01/2024 06:18:13], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=e84317825cd5dddd72212b59fdb25c61df0b28e6e40aa3bce1e3742181144b3b&xml_user_id=7867&db_caching=1&erequest=0&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=95'
            , http_hit_time = '2024-02-01 06:18:10.96'
            , request_start_time = '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.025'
            , error_description = ''
            , memory_used = '179112040'
            WHERE id = '30492';
[02/01/2024 06:18:13], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=e84317825cd5dddd72212b59fdb25c61df0b28e6e40aa3bce1e3742181144b3b&xml_user_id=7867&db_caching=1&erequest=1&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=95'
            , http_hit_time = '2024-02-01 06:18:10.96'
            , request_start_time = '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.170'
            , error_description = ''
            , memory_used = '160025408'
            WHERE id = '30493';
[02/01/2024 06:18:14], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=e84317825cd5dddd72212b59fdb25c61df0b28e6e40aa3bce1e3742181144b3b&xml_user_id=7867&db_caching=1&erequest=0&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=95'
            , http_hit_time = '2024-02-01 06:18:10.96'
            , request_start_time = '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.922'
            , error_description = ''
            , memory_used = '190516336'
            WHERE id = '30494';
[02/01/2024 06:18:14], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=e84317825cd5dddd72212b59fdb25c61df0b28e6e40aa3bce1e3742181144b3b&xml_user_id=7867&db_caching=1&erequest=1&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=95'
            , http_hit_time = '2024-02-01 06:18:10.96'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '4.239'
            , error_description = ''
            , memory_used = '167745248'
            WHERE id = '30495';
[02/01/2024 06:18:15], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-02-01 06:18:15' WHERE id= '485';
[02/01/2024 06:18:15], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-02-01 06:18:15' WHERE id= '485';
[02/01/2024 06:18:15], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-02-01 06:18:15' WHERE id= '485';
[02/01/2024 06:18:19], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-01 06:18:19' WHERE id= '485';
[02/01/2024 06:18:20], [file name :-/home/otrams/public_html/beta/view_map.php],UPDATE user_sessions_ip SET update_date = '2024-02-01 06:18:20' WHERE id= '485';
[02/01/2024 06:27:57], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-01 06:27:57',login_attempt=0 where id = '7849';
[02/01/2024 06:27:57], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'shiv_qtech', user_type = 'A', branch_id = '24', login_datetime = '2024-02-01 06:27:57', ip = '43.239.53.130', action = 'Login' ;
[02/01/2024 06:27:57], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-01 06:27:57' WHERE id= '488';
[02/01/2024 06:27:59], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-01 06:27:59' WHERE id= '488';
[02/01/2024 06:28:03], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-01 06:28:03' WHERE id= '488';
[02/01/2024 06:28:07], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-01 06:28:07' WHERE id= '488';
[02/01/2024 06:28:07], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7849' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '24' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/02/09',  departure_date='2024/02/09',  nights='1',  create_date='2024-02-01 :06:28:07',  nationality='',  additional_markup='',  selected_currency='INR',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/01/2024 06:28:13], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'v1/01_02_2024/request_availability_shiv_qtech_06_28_07_1706768887.json', 'v1/01_02_2024/response_availability_shiv_qtech_06_28_07_1706768887.json', 'v1/01_02_2024/response_header_availability_shiv_qtech_06_28_07_1706768887.json', 'viator', '2024-02-01 06:28:13', '', '', '1264');
[02/01/2024 06:32:44], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-02-01 06:32:44' WHERE id= '485';
[02/01/2024 06:32:51], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-02-01 06:32:51' WHERE id= '485';
[02/01/2024 06:33:18], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-01 06:33:18' WHERE id= '485';
[02/01/2024 06:33:19], [file name :-/home/otrams/public_html/beta/view_map.php],UPDATE user_sessions_ip SET update_date = '2024-02-01 06:33:19' WHERE id= '485';
[02/01/2024 06:37:48], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-02-01 06:37:48' WHERE id= '485';
[02/01/2024 06:37:53], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-01 06:37:53' WHERE id= '485';
[02/01/2024 06:37:54], [file name :-/home/otrams/public_html/beta/view_map.php],UPDATE user_sessions_ip SET update_date = '2024-02-01 06:37:54' WHERE id= '485';
[02/01/2024 06:38:56], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-02-01 06:38:56' WHERE id= '485';
[02/01/2024 06:39:02], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-01 06:39:02' WHERE id= '485';
[02/01/2024 06:39:02], [file name :-/home/otrams/public_html/beta/view_map.php],UPDATE user_sessions_ip SET update_date = '2024-02-01 06:39:02' WHERE id= '485';
[02/01/2024 06:49:23], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-02-01 06:49:23' WHERE id= '485';
[02/01/2024 06:49:27], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-01 06:49:27' WHERE id= '485';
[02/01/2024 06:49:28], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-01 06:49:28' WHERE id= '485';
[02/01/2024 06:49:28], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-01 06:49:28' WHERE id= '485';
[02/01/2024 06:49:29], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-01 06:49:29' WHERE id= '485';
[02/01/2024 06:49:30], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-01 06:49:30' WHERE id= '485';
[02/01/2024 06:49:36], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-01 06:49:36' WHERE id= '485';
[02/01/2024 06:49:38], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-01 06:49:38' WHERE id= '485';
[02/01/2024 06:49:39], [file name :-/home/otrams/public_html/beta/compare.php],UPDATE user_sessions_ip SET update_date = '2024-02-01 06:49:39' WHERE id= '485';
[02/01/2024 06:55:03], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-02-01 06:55:03' WHERE id= '485';
[02/01/2024 06:55:08], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-01 06:55:08' WHERE id= '485';
[02/01/2024 06:55:08], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-01 06:55:08' WHERE id= '485';
[02/01/2024 06:55:08], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-01 06:55:08' WHERE id= '485';
[02/01/2024 06:55:09], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-01 06:55:09' WHERE id= '485';
[02/01/2024 06:55:09], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-01 06:55:09' WHERE id= '485';
[02/01/2024 06:55:14], [file name :-/home/otrams/public_html/beta/compare.php],UPDATE user_sessions_ip SET update_date = '2024-02-01 06:55:14' WHERE id= '485';
[02/01/2024 06:55:21], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-01 06:55:21' WHERE id= '485';
[02/01/2024 06:56:01], [file name :-/home/otrams/public_html/beta/compare.php],UPDATE user_sessions_ip SET update_date = '2024-02-01 06:56:01' WHERE id= '485';
[02/01/2024 06:56:08], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-01 06:56:08' WHERE id= '485';
[02/01/2024 06:56:47], [file name :-/home/otrams/public_html/beta/compare.php],UPDATE user_sessions_ip SET update_date = '2024-02-01 06:56:47' WHERE id= '485';
[02/01/2024 06:58:51], [file name :-/home/otrams/public_html/beta/compare.php],UPDATE user_sessions_ip SET update_date = '2024-02-01 06:58:51' WHERE id= '485';
[02/01/2024 06:58:55], [file name :-/home/otrams/public_html/beta/compare.php],UPDATE user_sessions_ip SET update_date = '2024-02-01 06:58:55' WHERE id= '485';
[02/01/2024 06:58:58], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-02-01 06:58:58' WHERE id= '485';
