[01/31/2024 01:00:12], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:00:12' WHERE id= '485';
[01/31/2024 01:00:29], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:00:29' WHERE id= '485';
[01/31/2024 01:00:29], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-31 01:00:29',login_attempt=0 where id = '7870';
[01/31/2024 01:00:29], [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-01-31 13:00:29', ip = '43.239.53.130', action = 'Login' ;
[01/31/2024 01:00:29], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:00:29' WHERE id= '485';
[01/31/2024 01:00:35], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:00:35' WHERE id= '485';
[01/31/2024 01:00:38], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:00:38' WHERE id= '485';
[01/31/2024 01:00:38], [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/22' , departure_date = '2024/02/23' , nights = '1' , nationality = '95' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-01-31 13:00:38' , 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 = '' ;
[01/31/2024 01:00:39], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:00:39' WHERE id= '485';
[01/31/2024 01:00:39], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/31_01_2024/request_availability_hotel_yards_13_00_39_1706706039_53.json', 'e1/31_01_2024/response_availability_hotel_yards_13_00_39_1706706039_53.json', 'e1/31_01_2024/response_header_availability_hotel_yards_13_00_39_1706706039_53.json', 'expedia', '2024-01-31 01:00:39', '', 'e84317825cd5dddd72212b59fdb25c61df0b28e6e40aa3bce1e3742181144b3b', '0');
[01/31/2024 01:00:39], [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-01-31 13:00:39.274'
            , 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.349'
            , error_description = ''
            , memory_used = '2935672'
            WHERE id = '30412';
[01/31/2024 01:00:39], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/31_01_2024/request_availability_hotel_yards_13_00_39_1706706039_77.json', 'e1p/31_01_2024/response_availability_hotel_yards_13_00_39_1706706039_77.json', 'e1p/31_01_2024/response_header_availability_hotel_yards_13_00_39_1706706039_77.json', 'expediapackage', '2024-01-31 01:00:39', '', 'e84317825cd5dddd72212b59fdb25c61df0b28e6e40aa3bce1e3742181144b3b', '0');
[01/31/2024 01:00:39], [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-01-31 13:00:39.274'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.436'
            , error_description = ''
            , memory_used = '2936216'
            WHERE id = '30413';
[01/31/2024 01:00:40], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/31_01_2024/request_availability_hotel_yards_13_00_39_1706706039_66.json', 'e1/31_01_2024/response_availability_hotel_yards_13_00_39_1706706039_66.json', 'e1/31_01_2024/response_header_availability_hotel_yards_13_00_39_1706706039_66.json', 'expedia', '2024-01-31 01:00:40', '', 'e84317825cd5dddd72212b59fdb25c61df0b28e6e40aa3bce1e3742181144b3b', '0');
[01/31/2024 01: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/31_01_2024/request_availability_hotel_yards_13_00_39_1706706039_45.json', 'e1/31_01_2024/response_availability_hotel_yards_13_00_39_1706706039_45.json', 'e1/31_01_2024/response_header_availability_hotel_yards_13_00_39_1706706039_45.json', 'expedia', '2024-01-31 01:00:41', '', 'e84317825cd5dddd72212b59fdb25c61df0b28e6e40aa3bce1e3742181144b3b', '0');
[01/31/2024 01: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=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-01-31 13:00:39.274'
            , 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.552'
            , error_description = ''
            , memory_used = '147292064'
            WHERE id = '30414';
[01/31/2024 01:00:42], [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-01-31 13:00:39.274'
            , 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.408'
            , error_description = ''
            , memory_used = '164064776'
            WHERE id = '30415';
[01/31/2024 01: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', 'e1p/31_01_2024/request_availability_hotel_yards_13_00_39_1706706039_30.json', 'e1p/31_01_2024/response_availability_hotel_yards_13_00_39_1706706039_30.json', 'e1p/31_01_2024/response_header_availability_hotel_yards_13_00_39_1706706039_30.json', 'expediapackage', '2024-01-31 01:00:42', '', 'e84317825cd5dddd72212b59fdb25c61df0b28e6e40aa3bce1e3742181144b3b', '0');
[01/31/2024 01: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/31_01_2024/request_availability_hotel_yards_13_00_39_1706706039_72.json', 'e1p/31_01_2024/response_availability_hotel_yards_13_00_39_1706706039_72.json', 'e1p/31_01_2024/response_header_availability_hotel_yards_13_00_39_1706706039_72.json', 'expediapackage', '2024-01-31 01:00:43', '', 'e84317825cd5dddd72212b59fdb25c61df0b28e6e40aa3bce1e3742181144b3b', '0');
[01/31/2024 01:00:43], [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-01-31 13:00:39.274'
            , 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.609'
            , error_description = ''
            , memory_used = '151197792'
            WHERE id = '30416';
[01/31/2024 01:00:45], [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-01-31 13:00:39.274'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '5.751'
            , error_description = ''
            , memory_used = '175725112'
            WHERE id = '30417';
[01/31/2024 01:00:45], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:00:45' WHERE id= '485';
[01/31/2024 01:00:46], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:00:46' WHERE id= '485';
[01/31/2024 01:00:46], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:00:46' WHERE id= '485';
[01/31/2024 01:05:49], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:05:49' WHERE id= '485';
[01/31/2024 01:07:21], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:07:21' WHERE id= '485';
[01/31/2024 01:07:33], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:07:33' WHERE id= '485';
[01/31/2024 01:13:36], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-31 01:13:36',login_attempt=0 where id = '7866';
[01/31/2024 01:13:36], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'deepak_qtech', user_type = 'A', branch_id = '31', login_datetime = '2024-01-31 13:13:36', ip = '43.239.53.130', action = 'Login' ;
[01/31/2024 01:13:36], [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='1ea8e6bced2cc820ba5338ebf196dc4a8bca80d634ec25e3b80022481aa0ea86',create_date='2024-01-31 01:13:36', update_date='2024-01-31 01:13:36',domain='hotelyards.astrabookings.com',sub_agent_id='',sub_user_id='';
[01/31/2024 01:13:55], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:13:55' WHERE id= '486';
[01/31/2024 01:15:55], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:15:55' WHERE id= '484';
[01/31/2024 01:15:55], [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-01-31 :13:15:55',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/31/2024 01:16:00], [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/31_01_2024/request_availability_shiv_qtech_13_15_55_1706706955.json', 'v1/31_01_2024/response_availability_shiv_qtech_13_15_55_1706706955.json', 'v1/31_01_2024/response_header_availability_shiv_qtech_13_15_55_1706706955.json', 'viator', '2024-01-31 01:16:00', '', '', '1249');
[01/31/2024 01:16:01], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:16:01' WHERE id= '484';
[01/31/2024 01:16:01], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:16:01' WHERE id= '484';
[01/31/2024 01:16:07], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:16:07' WHERE id= '484';
[01/31/2024 01:16:08], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/31_01_2024/request_sight_details_shiv_qtech_13_16_07_1706706967.json', 'v1/31_01_2024/response_sight_details_shiv_qtech_13_16_07_1706706967.json', 'v1/31_01_2024/response_header_sight_details_shiv_qtech_13_16_07_1706706967.json', 'viator', '2024-01-31 01:16:08', '', '', '1249');
[01/31/2024 01:16:08], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/31_01_2024/request_sight_details_shiv_qtech_13_16_08_1706706968.json', 'v1/31_01_2024/response_sight_details_shiv_qtech_13_16_08_1706706968.json', 'v1/31_01_2024/response_header_sight_details_shiv_qtech_13_16_08_1706706968.json', 'viator', '2024-01-31 01:16:08', '', '', '1249');
[01/31/2024 01:16:30], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:16:30' WHERE id= '485';
[01/31/2024 01:17:51], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:17:51' WHERE id= '485';
[01/31/2024 01:19:47], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:19:47' WHERE id= '484';
[01/31/2024 01:19:47], [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-01-31 :13:19:47',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/31/2024 01:19:49], [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/31_01_2024/request_availability_shiv_qtech_13_19_47_1706707187.json', 'v1/31_01_2024/response_availability_shiv_qtech_13_19_47_1706707187.json', 'v1/31_01_2024/response_header_availability_shiv_qtech_13_19_47_1706707187.json', 'viator', '2024-01-31 01:19:49', '', '', '1250');
[01/31/2024 01:19:51], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:19:51' WHERE id= '484';
[01/31/2024 01:19:51], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:19:51' WHERE id= '484';
[01/31/2024 01:20:19], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:20:19' WHERE id= '484';
[01/31/2024 01:20:20], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/31_01_2024/request_sight_details_shiv_qtech_13_20_19_1706707219.json', 'v1/31_01_2024/response_sight_details_shiv_qtech_13_20_19_1706707219.json', 'v1/31_01_2024/response_header_sight_details_shiv_qtech_13_20_19_1706707219.json', 'viator', '2024-01-31 01:20:20', '', '', '1250');
[01/31/2024 01:20:20], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/31_01_2024/request_sight_details_shiv_qtech_13_20_20_1706707220.json', 'v1/31_01_2024/response_sight_details_shiv_qtech_13_20_20_1706707220.json', 'v1/31_01_2024/response_header_sight_details_shiv_qtech_13_20_20_1706707220.json', 'viator', '2024-01-31 01:20:20', '', '', '1250');
[01/31/2024 01:32:45], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:32:45' WHERE id= '485';
[01/31/2024 01:32:58], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:32:58' WHERE id= '485';
[01/31/2024 01:33:12], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:33:12' WHERE id= '485';
[01/31/2024 01:33:22], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:33:22' WHERE id= '485';
[01/31/2024 01:33:24], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:33:24' WHERE id= '485';
[01/31/2024 01:33:24], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1706708004','43.239.53.130');
[01/31/2024 01:33:25], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'valuation', 'e1p/31_01_2024/request_valuation_hotel_yards_13_33_24_1706708004_92.json', 'e1p/31_01_2024/response_valuation_hotel_yards_13_33_24_1706708004_92.json', 'e1p/31_01_2024/response_header_valuation_hotel_yards_13_33_24_1706708004_92.json', 'expediapackage', '2024-01-31 01:33:25', '', 'e84317825cd5dddd72212b59fdb25c61df0b28e6e40aa3bce1e3742181144b3b', '0');
[01/31/2024 01:33:28], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:33:28' WHERE id= '485';
[01/31/2024 01:33:28], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:33:28' WHERE id= '485';
[01/31/2024 01:33:28], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1706708008','43.239.53.130');
[01/31/2024 01:33:28], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'valuation', 'e1p/31_01_2024/request_valuation_hotel_yards_13_33_28_1706708008_3.json', 'e1p/31_01_2024/response_valuation_hotel_yards_13_33_28_1706708008_3.json', 'e1p/31_01_2024/response_header_valuation_hotel_yards_13_33_28_1706708008_3.json', 'expediapackage', '2024-01-31 01:33:28', '', 'e84317825cd5dddd72212b59fdb25c61df0b28e6e40aa3bce1e3742181144b3b', '0');
[01/31/2024 01:40:10], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-31 01:40:10',login_attempt=0 where id = '7870';
[01/31/2024 01:40:10], [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-01-31 13:40:10', ip = '117.213.19.121', action = 'Login' ;
[01/31/2024 01:40:10], [file name :-/home/otrams/public_html/beta/hotel_search.php],insert into user_sessions_ip SET ip_addr='117.213.19.121', agent_id='7867', session_id='97e4df1910e52a7d6204593402db0b93a1f1e375e7ae3bd4bba5b1d08c39b862',create_date='2024-01-31 01:40:10', update_date='2024-01-31 01:40:10',domain='hotelyards.astrabookings.com',sub_agent_id='',sub_user_id='';
[01/31/2024 01:40:28], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:40:28' WHERE id= '487';
[01/31/2024 01:40:29], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:40:29' WHERE id= '487';
[01/31/2024 01:40:35], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:40:35' WHERE id= '487';
[01/31/2024 01:40:38], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:40:38' WHERE id= '487';
[01/31/2024 01:40:43], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:40:43' WHERE id= '487';
[01/31/2024 01:40:43], [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 = '117.213.19.121' , city = 'dubai' , service_name = '' , country_of_residence = '95' , service_type = 'hotel' , arrival_date = '2024/02/10' , departure_date = '2024/02/11' , nights = '1' , nationality = '95' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-01-31 13:40:43' , 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 = '' ;
[01/31/2024 01:40:44], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:40:44' WHERE id= '487';
[01/31/2024 01: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', 'e1p/31_01_2024/request_availability_hotel_yards_13_40_44_1706708444_43.json', 'e1p/31_01_2024/response_availability_hotel_yards_13_40_44_1706708444_43.json', 'e1p/31_01_2024/response_header_availability_hotel_yards_13_40_44_1706708444_43.json', 'expediapackage', '2024-01-31 01:40:44', '', '97e4df1910e52a7d6204593402db0b93a1f1e375e7ae3bd4bba5b1d08c39b862', '0');
[01/31/2024 01:40:44], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=97e4df1910e52a7d6204593402db0b93a1f1e375e7ae3bd4bba5b1d08c39b862&xml_user_id=7867&db_caching=1&erequest=2&total_request=3&web_service=no&ip=117.213.19.121&browser=GoogleChrome%2F120.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=95'
            , http_hit_time = '2024-01-31 13:40:44.704'
            , 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.215'
            , error_description = ''
            , memory_used = '2936240'
            WHERE id = '30426';
[01/31/2024 01:40: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', 'e1/31_01_2024/request_availability_hotel_yards_13_40_44_1706708444_75.json', 'e1/31_01_2024/response_availability_hotel_yards_13_40_44_1706708444_75.json', 'e1/31_01_2024/response_header_availability_hotel_yards_13_40_44_1706708444_75.json', 'expedia', '2024-01-31 01:40:45', '', '97e4df1910e52a7d6204593402db0b93a1f1e375e7ae3bd4bba5b1d08c39b862', '0');
[01/31/2024 01:40:45], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=97e4df1910e52a7d6204593402db0b93a1f1e375e7ae3bd4bba5b1d08c39b862&xml_user_id=7867&db_caching=1&erequest=2&total_request=3&web_service=no&ip=117.213.19.121&browser=GoogleChrome%2F120.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=95'
            , http_hit_time = '2024-01-31 13:40:44.704'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.401'
            , error_description = ''
            , memory_used = '2935088'
            WHERE id = '30427';
[01/31/2024 01:40: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/31_01_2024/request_availability_hotel_yards_13_40_44_1706708444_40.json', 'e1/31_01_2024/response_availability_hotel_yards_13_40_44_1706708444_40.json', 'e1/31_01_2024/response_header_availability_hotel_yards_13_40_44_1706708444_40.json', 'expedia', '2024-01-31 01:40:46', '', '97e4df1910e52a7d6204593402db0b93a1f1e375e7ae3bd4bba5b1d08c39b862', '0');
[01/31/2024 01:40: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/31_01_2024/request_availability_hotel_yards_13_40_44_1706708444_2.json', 'e1/31_01_2024/response_availability_hotel_yards_13_40_44_1706708444_2.json', 'e1/31_01_2024/response_header_availability_hotel_yards_13_40_44_1706708444_2.json', 'expedia', '2024-01-31 01:40:46', '', '97e4df1910e52a7d6204593402db0b93a1f1e375e7ae3bd4bba5b1d08c39b862', '0');
[01/31/2024 01:40:47], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=97e4df1910e52a7d6204593402db0b93a1f1e375e7ae3bd4bba5b1d08c39b862&xml_user_id=7867&db_caching=1&erequest=1&total_request=3&web_service=no&ip=117.213.19.121&browser=GoogleChrome%2F120.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=95'
            , http_hit_time = '2024-01-31 13:40:44.704'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '2.847'
            , error_description = ''
            , memory_used = '145237264'
            WHERE id = '30428';
[01/31/2024 01:40:47], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/31_01_2024/request_availability_hotel_yards_13_40_44_1706708444_69.json', 'e1p/31_01_2024/response_availability_hotel_yards_13_40_44_1706708444_69.json', 'e1p/31_01_2024/response_header_availability_hotel_yards_13_40_44_1706708444_69.json', 'expediapackage', '2024-01-31 01:40:47', '', '97e4df1910e52a7d6204593402db0b93a1f1e375e7ae3bd4bba5b1d08c39b862', '0');
[01/31/2024 01:40:47], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/31_01_2024/request_availability_hotel_yards_13_40_44_1706708444_73.json', 'e1p/31_01_2024/response_availability_hotel_yards_13_40_44_1706708444_73.json', 'e1p/31_01_2024/response_header_availability_hotel_yards_13_40_44_1706708444_73.json', 'expediapackage', '2024-01-31 01:40:47', '', '97e4df1910e52a7d6204593402db0b93a1f1e375e7ae3bd4bba5b1d08c39b862', '0');
[01/31/2024 01:40:47], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=97e4df1910e52a7d6204593402db0b93a1f1e375e7ae3bd4bba5b1d08c39b862&xml_user_id=7867&db_caching=1&erequest=0&total_request=3&web_service=no&ip=117.213.19.121&browser=GoogleChrome%2F120.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=95'
            , http_hit_time = '2024-01-31 13:40:44.704'
            , 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.160'
            , error_description = ''
            , memory_used = '169156968'
            WHERE id = '30429';
[01/31/2024 01:40:49], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=97e4df1910e52a7d6204593402db0b93a1f1e375e7ae3bd4bba5b1d08c39b862&xml_user_id=7867&db_caching=1&erequest=1&total_request=3&web_service=no&ip=117.213.19.121&browser=GoogleChrome%2F120.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=95'
            , http_hit_time = '2024-01-31 13:40:44.704'
            , 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.420'
            , error_description = ''
            , memory_used = '151462728'
            WHERE id = '30430';
[01/31/2024 01:40:49], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=97e4df1910e52a7d6204593402db0b93a1f1e375e7ae3bd4bba5b1d08c39b862&xml_user_id=7867&db_caching=1&erequest=0&total_request=3&web_service=no&ip=117.213.19.121&browser=GoogleChrome%2F120.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=95'
            , http_hit_time = '2024-01-31 13:40:44.704'
            , 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.577'
            , error_description = ''
            , memory_used = '180485088'
            WHERE id = '30431';
[01/31/2024 01:40:50], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:40:50' WHERE id= '487';
[01/31/2024 01:40:50], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:40:50' WHERE id= '487';
[01/31/2024 01:40:50], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:40:50' WHERE id= '487';
[01/31/2024 01:41:21], [file name :-/home/otrams/public_html/beta/quotation.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:41:21' WHERE id= '487';
[01/31/2024 01:41:27], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:41:27' WHERE id= '485';
[01/31/2024 01:41:30], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:41:30' WHERE id= '487';
[01/31/2024 01:41:31], [file name :-/home/otrams/public_html/beta/view_map.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:41:31' WHERE id= '487';
[01/31/2024 01:41:52], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:41:52' WHERE id= '487';
[01/31/2024 01:41:53], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:41:53' WHERE id= '487';
[01/31/2024 01:41:53], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1706708513','117.213.19.121');
[01/31/2024 01:41:53], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'valuation', 'e1p/31_01_2024/request_valuation_hotel_yards_13_41_53_1706708513_21.json', 'e1p/31_01_2024/response_valuation_hotel_yards_13_41_53_1706708513_21.json', 'e1p/31_01_2024/response_header_valuation_hotel_yards_13_41_53_1706708513_21.json', 'expediapackage', '2024-01-31 01:41:53', '', '97e4df1910e52a7d6204593402db0b93a1f1e375e7ae3bd4bba5b1d08c39b862', '0');
[01/31/2024 01:41:59], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:41:59' WHERE id= '485';
[01/31/2024 01:42:00], [file name :-/home/otrams/public_html/beta/view_map.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:42:00' WHERE id= '485';
[01/31/2024 01:43:12], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:43:12' WHERE id= '485';
[01/31/2024 01:43:42], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:43:42' WHERE id= '485';
[01/31/2024 01:43:45], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:43:45' WHERE id= '485';
[01/31/2024 01:43:53], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:43:53' WHERE id= '485';
[01/31/2024 01:45:07], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:45:07' WHERE id= '487';
[01/31/2024 01:45:07], [file name :-/home/otrams/public_html/beta/view_map.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:45:07' WHERE id= '487';
[01/31/2024 01:45:17], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:45:17' WHERE id= '487';
[01/31/2024 01:45:17], [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 = '117.213.19.121' , city = 'dubai' , service_name = '' , country_of_residence = '95' , service_type = 'hotel' , arrival_date = '2024/02/10' , departure_date = '2024/02/11' , nights = '1' , nationality = '95' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-01-31 13:45:17' , site_id = '21' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[01/31/2024 01:45:17], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:45:17' WHERE id= '487';
[01/31/2024 01:45:19], [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/31_01_2024/request_availability_hotel_yards_13_45_17_1706708717_2.json', 'e1/31_01_2024/response_availability_hotel_yards_13_45_17_1706708717_2.json', 'e1/31_01_2024/response_header_availability_hotel_yards_13_45_17_1706708717_2.json', 'expedia', '2024-01-31 01:45:19', '', '97e4df1910e52a7d6204593402db0b93a1f1e375e7ae3bd4bba5b1d08c39b862', '0');
[01/31/2024 01:45:19], [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/31_01_2024/request_availability_hotel_yards_13_45_17_1706708717_53.json', 'e1/31_01_2024/response_availability_hotel_yards_13_45_17_1706708717_53.json', 'e1/31_01_2024/response_header_availability_hotel_yards_13_45_17_1706708717_53.json', 'expedia', '2024-01-31 01:45:19', '', '97e4df1910e52a7d6204593402db0b93a1f1e375e7ae3bd4bba5b1d08c39b862', '0');
[01/31/2024 01:45:20], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/31_01_2024/request_availability_hotel_yards_13_45_17_1706708717_63.json', 'e1p/31_01_2024/response_availability_hotel_yards_13_45_17_1706708717_63.json', 'e1p/31_01_2024/response_header_availability_hotel_yards_13_45_17_1706708717_63.json', 'expediapackage', '2024-01-31 01:45:20', '', '97e4df1910e52a7d6204593402db0b93a1f1e375e7ae3bd4bba5b1d08c39b862', '0');
[01/31/2024 01:45:20], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=97e4df1910e52a7d6204593402db0b93a1f1e375e7ae3bd4bba5b1d08c39b862&xml_user_id=7867&db_caching=1&erequest=1&total_request=2&web_service=no&ip=117.213.19.121&browser=GoogleChrome%2F120.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=95'
            , http_hit_time = '2024-01-31 13:45:17.943'
            , 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.336'
            , error_description = ''
            , memory_used = '84883440'
            WHERE id = '30434';
[01/31/2024 01:45:20], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/31_01_2024/request_availability_hotel_yards_13_45_17_1706708717_66.json', 'e1p/31_01_2024/response_availability_hotel_yards_13_45_17_1706708717_66.json', 'e1p/31_01_2024/response_header_availability_hotel_yards_13_45_17_1706708717_66.json', 'expediapackage', '2024-01-31 01:45:20', '', '97e4df1910e52a7d6204593402db0b93a1f1e375e7ae3bd4bba5b1d08c39b862', '0');
[01/31/2024 01:45:20], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=97e4df1910e52a7d6204593402db0b93a1f1e375e7ae3bd4bba5b1d08c39b862&xml_user_id=7867&db_caching=1&erequest=1&total_request=2&web_service=no&ip=117.213.19.121&browser=GoogleChrome%2F120.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=95'
            , http_hit_time = '2024-01-31 13:45:17.943'
            , 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.942'
            , error_description = ''
            , memory_used = '87284896'
            WHERE id = '30435';
[01/31/2024 01:45:20], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=97e4df1910e52a7d6204593402db0b93a1f1e375e7ae3bd4bba5b1d08c39b862&xml_user_id=7867&db_caching=1&erequest=0&total_request=2&web_service=no&ip=117.213.19.121&browser=GoogleChrome%2F120.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=95'
            , http_hit_time = '2024-01-31 13:45:17.943'
            , 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.036'
            , error_description = ''
            , memory_used = '194513448'
            WHERE id = '30433';
[01/31/2024 01:45:22], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=97e4df1910e52a7d6204593402db0b93a1f1e375e7ae3bd4bba5b1d08c39b862&xml_user_id=7867&db_caching=1&erequest=0&total_request=2&web_service=no&ip=117.213.19.121&browser=GoogleChrome%2F120.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=95'
            , http_hit_time = '2024-01-31 13:45:17.943'
            , 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.550'
            , error_description = ''
            , memory_used = '209528296'
            WHERE id = '30436';
[01/31/2024 01:45:23], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:45:23' WHERE id= '487';
[01/31/2024 01:45:23], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:45:23' WHERE id= '487';
[01/31/2024 01:45:23], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:45:23' WHERE id= '487';
[01/31/2024 01:47:31], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:47:31' WHERE id= '487';
[01/31/2024 01:47:32], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:47:32' WHERE id= '487';
[01/31/2024 01:47:32], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1706708852','117.213.19.121');
[01/31/2024 01:47:32], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'valuation', 'e1p/31_01_2024/request_valuation_hotel_yards_13_47_32_1706708852_65.json', 'e1p/31_01_2024/response_valuation_hotel_yards_13_47_32_1706708852_65.json', 'e1p/31_01_2024/response_header_valuation_hotel_yards_13_47_32_1706708852_65.json', 'expediapackage', '2024-01-31 01:47:32', '', '97e4df1910e52a7d6204593402db0b93a1f1e375e7ae3bd4bba5b1d08c39b862', '0');
[01/31/2024 01:47:48], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:47:48' WHERE id= '487';
[01/31/2024 01:54:00], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-31 01:54:00',login_attempt=0 where id = '7849';
[01/31/2024 01:54:00], [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-01-31 13:54:00', ip = '43.239.53.130', action = 'Login' ;
[01/31/2024 01:54:01], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:54:01' WHERE id= '484';
[01/31/2024 01:54:03], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:54:03' WHERE id= '484';
[01/31/2024 01:54:06], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:54:06' WHERE id= '484';
[01/31/2024 01:54:12], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:54:12' WHERE id= '484';
[01/31/2024 01:54:12], [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-01-31 :13:54:12',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/31/2024 01:54: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/31_01_2024/request_availability_shiv_qtech_13_54_12_1706709252.json', 'v1/31_01_2024/response_availability_shiv_qtech_13_54_12_1706709252.json', 'v1/31_01_2024/response_header_availability_shiv_qtech_13_54_12_1706709252.json', 'viator', '2024-01-31 01:54:13', '', '', '1251');
[01/31/2024 01:54:14], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:54:14' WHERE id= '484';
[01/31/2024 01:54:14], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:54:14' WHERE id= '484';
[01/31/2024 01:54:15], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:54:15' WHERE id= '484';
[01/31/2024 01:54:16], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/31_01_2024/request_sight_details_shiv_qtech_13_54_15_1706709255.json', 'v1/31_01_2024/response_sight_details_shiv_qtech_13_54_15_1706709255.json', 'v1/31_01_2024/response_header_sight_details_shiv_qtech_13_54_15_1706709255.json', 'viator', '2024-01-31 01:54:16', '', '', '1251');
[01/31/2024 01:54:16], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/31_01_2024/request_sight_details_shiv_qtech_13_54_16_1706709256.json', 'v1/31_01_2024/response_sight_details_shiv_qtech_13_54_16_1706709256.json', 'v1/31_01_2024/response_header_sight_details_shiv_qtech_13_54_16_1706709256.json', 'viator', '2024-01-31 01:54:16', '', '', '1251');
[01/31/2024 01:55:50], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:55:50' WHERE id= '484';
[01/31/2024 01:55:51], [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-01-31 :13:55:51',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/31/2024 01:55:53], [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/31_01_2024/request_availability_shiv_qtech_13_55_51_1706709351.json', 'v1/31_01_2024/response_availability_shiv_qtech_13_55_51_1706709351.json', 'v1/31_01_2024/response_header_availability_shiv_qtech_13_55_51_1706709351.json', 'viator', '2024-01-31 01:55:53', '', '', '1252');
[01/31/2024 01:55:55], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:55:55' WHERE id= '484';
[01/31/2024 01:55:55], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:55:55' WHERE id= '484';
[01/31/2024 01:55:58], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:55:58' WHERE id= '484';
[01/31/2024 01:55:58], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/31_01_2024/request_sight_details_shiv_qtech_13_55_58_1706709358.json', 'v1/31_01_2024/response_sight_details_shiv_qtech_13_55_58_1706709358.json', 'v1/31_01_2024/response_header_sight_details_shiv_qtech_13_55_58_1706709358.json', 'viator', '2024-01-31 01:55:58', '', '', '1252');
[01/31/2024 01:55:58], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/31_01_2024/request_sight_details_shiv_qtech_13_55_58_1706709358.json', 'v1/31_01_2024/response_sight_details_shiv_qtech_13_55_58_1706709358.json', 'v1/31_01_2024/response_header_sight_details_shiv_qtech_13_55_58_1706709358.json', 'viator', '2024-01-31 01:55:58', '', '', '1252');
[01/31/2024 01:58:23], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:58:23' WHERE id= '484';
[01/31/2024 01:58:23], [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-01-31 :13:58:23',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/31/2024 01:58:25], [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/31_01_2024/request_availability_shiv_qtech_13_58_23_1706709503.json', 'v1/31_01_2024/response_availability_shiv_qtech_13_58_23_1706709503.json', 'v1/31_01_2024/response_header_availability_shiv_qtech_13_58_23_1706709503.json', 'viator', '2024-01-31 01:58:25', '', '', '1253');
[01/31/2024 01:58:26], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:58:26' WHERE id= '484';
[01/31/2024 01:58:27], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:58:27' WHERE id= '484';
[01/31/2024 01:58:28], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:58:28' WHERE id= '484';
[01/31/2024 01:58:28], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/31_01_2024/request_sight_details_shiv_qtech_13_58_28_1706709508.json', 'v1/31_01_2024/response_sight_details_shiv_qtech_13_58_28_1706709508.json', 'v1/31_01_2024/response_header_sight_details_shiv_qtech_13_58_28_1706709508.json', 'viator', '2024-01-31 01:58:28', '', '', '1253');
[01/31/2024 01:58:28], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/31_01_2024/request_sight_details_shiv_qtech_13_58_28_1706709508.json', 'v1/31_01_2024/response_sight_details_shiv_qtech_13_58_28_1706709508.json', 'v1/31_01_2024/response_header_sight_details_shiv_qtech_13_58_28_1706709508.json', 'viator', '2024-01-31 01:58:28', '', '', '1253');
[01/31/2024 01:59:14], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:59:14' WHERE id= '484';
[01/31/2024 01:59:14], [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-01-31 :13:59:14',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/31/2024 01:59:18], [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/31_01_2024/request_availability_shiv_qtech_13_59_15_1706709555.json', 'v1/31_01_2024/response_availability_shiv_qtech_13_59_15_1706709555.json', 'v1/31_01_2024/response_header_availability_shiv_qtech_13_59_15_1706709555.json', 'viator', '2024-01-31 01:59:18', '', '', '1254');
[01/31/2024 01:59:19], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:59:19' WHERE id= '484';
[01/31/2024 01:59:19], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:59:19' WHERE id= '484';
[01/31/2024 01:59:22], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-31 01:59:22' WHERE id= '484';
[01/31/2024 01:59:22], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/31_01_2024/request_sight_details_shiv_qtech_13_59_22_1706709562.json', 'v1/31_01_2024/response_sight_details_shiv_qtech_13_59_22_1706709562.json', 'v1/31_01_2024/response_header_sight_details_shiv_qtech_13_59_22_1706709562.json', 'viator', '2024-01-31 01:59:22', '', '', '1254');
[01/31/2024 01:59:22], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/31_01_2024/request_sight_details_shiv_qtech_13_59_22_1706709562.json', 'v1/31_01_2024/response_sight_details_shiv_qtech_13_59_22_1706709562.json', 'v1/31_01_2024/response_header_sight_details_shiv_qtech_13_59_22_1706709562.json', 'viator', '2024-01-31 01:59:22', '', '', '1254');
