[01/24/2024 12:30:19], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-24 12:30:19',login_attempt=0 where id = '7851';
[01/24/2024 12:30:19], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Viator_test', user_type = 'A', branch_id = '27', login_datetime = '2024-01-24 12:30:19', ip = '43.239.53.130', action = 'Login' ;
[01/24/2024 12:30:20], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 12:30:20' WHERE id= '309';
[01/24/2024 12:30:26], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 12:30:26' WHERE id= '309';
[01/24/2024 12:34:32], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 12:34:32' WHERE id= '309';
[01/24/2024 12:34:40], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 12:34:40' WHERE id= '309';
[01/24/2024 12:34:40], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '27' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/01/27',  departure_date='2024/01/27',  nights='1',  create_date='2024-01-24 :12:34:40',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/24/2024 12:34:42], [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/24_01_2024/request_availability_Viator_test_12_34_40_1706099680.json', 'v1/24_01_2024/response_availability_Viator_test_12_34_40_1706099680.json', 'v1/24_01_2024/response_header_availability_Viator_test_12_34_40_1706099680.json', 'viator', '2024-01-24 12:34:42', '', '', '1128');
[01/24/2024 12:34:44], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 12:34:44' WHERE id= '309';
[01/24/2024 12:34:44], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 12:34:44' WHERE id= '309';
[01/24/2024 12:36:16], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 12:36:16' WHERE id= '309';
[01/24/2024 12:36:17], [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/24_01_2024/request_sight_details_Viator_test_12_36_16_1706099776.json', 'v1/24_01_2024/response_sight_details_Viator_test_12_36_16_1706099776.json', 'v1/24_01_2024/response_header_sight_details_Viator_test_12_36_16_1706099776.json', 'viator', '2024-01-24 12:36:17', '', '', '1128');
[01/24/2024 12:49:58], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-24 12:49:58',login_attempt=0 where id = '7866';
[01/24/2024 12:49:58], [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-24 12:49:58', ip = '43.239.53.130', action = 'Login' ;
[01/24/2024 12:49:58], [file name :-/home/otrams/public_html/beta/hotel_search.php],insert into user_sessions_ip SET ip_addr='43.239.53.130', agent_id='7863', session_id='a63c6eb78d6f7a10cfb68b17ffe3a775e22e47dddbcef7ddb167f34243bb375d',create_date='2024-01-24 12:49:58', update_date='2024-01-24 12:49:58',domain='baysantravel.astrabookings.com',sub_agent_id='',sub_user_id='';
[01/24/2024 12:50:07], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 12:50:07' WHERE id= '333';
[01/24/2024 12:50:12], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 12:50:12' WHERE id= '333';
[01/24/2024 12:50:13], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 12:50:13' WHERE id= '333';
[01/24/2024 12:50:24], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 12:50:24' WHERE id= '333';
[01/24/2024 12:50:24], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7866' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '31' , ip = '43.239.53.130' , city = 'phuket' , service_name = '' , country_of_residence = '138' , service_type = 'hotel' , arrival_date = '2024/04/17' , departure_date = '2024/04/18' , nights = '1' , nationality = '138' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-01-24 12:50:24' , site_id = '20' , country_code = '136' , city_code = '71351' , ratings = '1.0,2.0,3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[01/24/2024 12:50:24], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 12:50:24' WHERE id= '333';
[01/24/2024 12:50:26], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/24_01_2024/request_availability_Baysan_Tourism_wh_12_50_25_1706100625_73.json', 'e1/24_01_2024/response_availability_Baysan_Tourism_wh_12_50_25_1706100625_73.json', 'e1/24_01_2024/response_header_availability_Baysan_Tourism_wh_12_50_25_1706100625_73.json', 'expedia', '2024-01-24 12:50:26', '', 'a63c6eb78d6f7a10cfb68b17ffe3a775e22e47dddbcef7ddb167f34243bb375d', '0');
[01/24/2024 12:50:26], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=a63c6eb78d6f7a10cfb68b17ffe3a775e22e47dddbcef7ddb167f34243bb375d&xml_user_id=7863&db_caching=1&erequest=7&total_request=8&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=138'
            , http_hit_time = '2024-01-24 12:50:25.707'
            , 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.393'
            , error_description = ''
            , memory_used = '2339864'
            WHERE id = '29300';
[01/24/2024 12:50:26], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/24_01_2024/request_availability_Baysan_Tourism_wh_12_50_25_1706100625_39.json', 'e1p/24_01_2024/response_availability_Baysan_Tourism_wh_12_50_25_1706100625_39.json', 'e1p/24_01_2024/response_header_availability_Baysan_Tourism_wh_12_50_25_1706100625_39.json', 'expediapackage', '2024-01-24 12:50:26', '', 'a63c6eb78d6f7a10cfb68b17ffe3a775e22e47dddbcef7ddb167f34243bb375d', '0');
[01/24/2024 12:50:26], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=a63c6eb78d6f7a10cfb68b17ffe3a775e22e47dddbcef7ddb167f34243bb375d&xml_user_id=7863&db_caching=1&erequest=7&total_request=8&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=138'
            , http_hit_time = '2024-01-24 12:50:25.708'
            , 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.412'
            , error_description = ''
            , memory_used = '2340712'
            WHERE id = '29301';
[01/24/2024 12:50:26], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/24_01_2024/request_availability_Baysan_Tourism_wh_12_50_25_1706100625_76.json', 'e1/24_01_2024/response_availability_Baysan_Tourism_wh_12_50_25_1706100625_76.json', 'e1/24_01_2024/response_header_availability_Baysan_Tourism_wh_12_50_25_1706100625_76.json', 'expedia', '2024-01-24 12:50:26', '', 'a63c6eb78d6f7a10cfb68b17ffe3a775e22e47dddbcef7ddb167f34243bb375d', '0');
[01/24/2024 12:50:26], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=a63c6eb78d6f7a10cfb68b17ffe3a775e22e47dddbcef7ddb167f34243bb375d&xml_user_id=7863&db_caching=1&erequest=6&total_request=8&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=138'
            , http_hit_time = '2024-01-24 12:50:25.707'
            , 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.796'
            , error_description = ''
            , memory_used = '7455144'
            WHERE id = '29302';
[01/24/2024 12:50:26], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/24_01_2024/request_availability_Baysan_Tourism_wh_12_50_25_1706100625_45.json', 'e1p/24_01_2024/response_availability_Baysan_Tourism_wh_12_50_25_1706100625_45.json', 'e1p/24_01_2024/response_header_availability_Baysan_Tourism_wh_12_50_25_1706100625_45.json', 'expediapackage', '2024-01-24 12:50:26', '', 'a63c6eb78d6f7a10cfb68b17ffe3a775e22e47dddbcef7ddb167f34243bb375d', '0');
[01/24/2024 12:50:26], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=a63c6eb78d6f7a10cfb68b17ffe3a775e22e47dddbcef7ddb167f34243bb375d&xml_user_id=7863&db_caching=1&erequest=6&total_request=8&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=138'
            , http_hit_time = '2024-01-24 12:50:25.707'
            , 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.991'
            , error_description = ''
            , memory_used = '8811968'
            WHERE id = '29303';
[01/24/2024 12:50:26], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/24_01_2024/request_availability_Baysan_Tourism_wh_12_50_25_1706100625_69.json', 'e1/24_01_2024/response_availability_Baysan_Tourism_wh_12_50_25_1706100625_69.json', 'e1/24_01_2024/response_header_availability_Baysan_Tourism_wh_12_50_25_1706100625_69.json', 'expedia', '2024-01-24 12:50:26', '', 'a63c6eb78d6f7a10cfb68b17ffe3a775e22e47dddbcef7ddb167f34243bb375d', '0');
[01/24/2024 12:50:26], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/24_01_2024/request_availability_Baysan_Tourism_wh_12_50_25_1706100625_25.json', 'e1/24_01_2024/response_availability_Baysan_Tourism_wh_12_50_25_1706100625_25.json', 'e1/24_01_2024/response_header_availability_Baysan_Tourism_wh_12_50_25_1706100625_25.json', 'expedia', '2024-01-24 12:50:26', '', 'a63c6eb78d6f7a10cfb68b17ffe3a775e22e47dddbcef7ddb167f34243bb375d', '0');
[01/24/2024 12:50:27], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/24_01_2024/request_availability_Baysan_Tourism_wh_12_50_25_1706100625_52.json', 'e1/24_01_2024/response_availability_Baysan_Tourism_wh_12_50_25_1706100625_52.json', 'e1/24_01_2024/response_header_availability_Baysan_Tourism_wh_12_50_25_1706100625_52.json', 'expedia', '2024-01-24 12:50:27', '', 'a63c6eb78d6f7a10cfb68b17ffe3a775e22e47dddbcef7ddb167f34243bb375d', '0');
[01/24/2024 12:50:27], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/24_01_2024/request_availability_Baysan_Tourism_wh_12_50_25_1706100625_36.json', 'e1/24_01_2024/response_availability_Baysan_Tourism_wh_12_50_25_1706100625_36.json', 'e1/24_01_2024/response_header_availability_Baysan_Tourism_wh_12_50_25_1706100625_36.json', 'expedia', '2024-01-24 12:50:27', '', 'a63c6eb78d6f7a10cfb68b17ffe3a775e22e47dddbcef7ddb167f34243bb375d', '0');
[01/24/2024 12:50:27], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=a63c6eb78d6f7a10cfb68b17ffe3a775e22e47dddbcef7ddb167f34243bb375d&xml_user_id=7863&db_caching=1&erequest=1&total_request=8&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=138'
            , http_hit_time = '2024-01-24 12:50:25.707'
            , 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.554'
            , error_description = ''
            , memory_used = '47794896'
            WHERE id = '29304';
[01/24/2024 12:50:27], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=a63c6eb78d6f7a10cfb68b17ffe3a775e22e47dddbcef7ddb167f34243bb375d&xml_user_id=7863&db_caching=1&erequest=4&total_request=8&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=138'
            , http_hit_time = '2024-01-24 12:50:25.707'
            , 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.665'
            , error_description = ''
            , memory_used = '39534248'
            WHERE id = '29305';
[01/24/2024 12:50:27], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=a63c6eb78d6f7a10cfb68b17ffe3a775e22e47dddbcef7ddb167f34243bb375d&xml_user_id=7863&db_caching=1&erequest=5&total_request=8&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=138'
            , http_hit_time = '2024-01-24 12:50:25.707'
            , 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.883'
            , error_description = ''
            , memory_used = '52665944'
            WHERE id = '29306';
[01/24/2024 12:50:27], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=a63c6eb78d6f7a10cfb68b17ffe3a775e22e47dddbcef7ddb167f34243bb375d&xml_user_id=7863&db_caching=1&erequest=0&total_request=8&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=138'
            , http_hit_time = '2024-01-24 12:50:25.707'
            , 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.890'
            , error_description = ''
            , memory_used = '52319168'
            WHERE id = '29307';
[01/24/2024 12:50:27], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/24_01_2024/request_availability_Baysan_Tourism_wh_12_50_25_1706100625_98.json', 'e1p/24_01_2024/response_availability_Baysan_Tourism_wh_12_50_25_1706100625_98.json', 'e1p/24_01_2024/response_header_availability_Baysan_Tourism_wh_12_50_25_1706100625_98.json', 'expediapackage', '2024-01-24 12:50:27', '', 'a63c6eb78d6f7a10cfb68b17ffe3a775e22e47dddbcef7ddb167f34243bb375d', '0');
[01/24/2024 12:50:27], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/24_01_2024/request_availability_Baysan_Tourism_wh_12_50_25_1706100625_44.json', 'e1p/24_01_2024/response_availability_Baysan_Tourism_wh_12_50_25_1706100625_44.json', 'e1p/24_01_2024/response_header_availability_Baysan_Tourism_wh_12_50_25_1706100625_44.json', 'expediapackage', '2024-01-24 12:50:27', '', 'a63c6eb78d6f7a10cfb68b17ffe3a775e22e47dddbcef7ddb167f34243bb375d', '0');
[01/24/2024 12:50:27], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/24_01_2024/request_availability_Baysan_Tourism_wh_12_50_25_1706100625_43.json', 'e1p/24_01_2024/response_availability_Baysan_Tourism_wh_12_50_25_1706100625_43.json', 'e1p/24_01_2024/response_header_availability_Baysan_Tourism_wh_12_50_25_1706100625_43.json', 'expediapackage', '2024-01-24 12:50:27', '', 'a63c6eb78d6f7a10cfb68b17ffe3a775e22e47dddbcef7ddb167f34243bb375d', '0');
[01/24/2024 12:50:27], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/24_01_2024/request_availability_Baysan_Tourism_wh_12_50_25_1706100625_27.json', 'e1p/24_01_2024/response_availability_Baysan_Tourism_wh_12_50_25_1706100625_27.json', 'e1p/24_01_2024/response_header_availability_Baysan_Tourism_wh_12_50_25_1706100625_27.json', 'expediapackage', '2024-01-24 12:50:27', '', 'a63c6eb78d6f7a10cfb68b17ffe3a775e22e47dddbcef7ddb167f34243bb375d', '0');
[01/24/2024 12:50:27], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/24_01_2024/request_availability_Baysan_Tourism_wh_12_50_25_1706100625_70.json', 'e1/24_01_2024/response_availability_Baysan_Tourism_wh_12_50_25_1706100625_70.json', 'e1/24_01_2024/response_header_availability_Baysan_Tourism_wh_12_50_25_1706100625_70.json', 'expedia', '2024-01-24 12:50:27', '', 'a63c6eb78d6f7a10cfb68b17ffe3a775e22e47dddbcef7ddb167f34243bb375d', '0');
[01/24/2024 12:50:28], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/24_01_2024/request_availability_Baysan_Tourism_wh_12_50_25_1706100625_53.json', 'e1p/24_01_2024/response_availability_Baysan_Tourism_wh_12_50_25_1706100625_53.json', 'e1p/24_01_2024/response_header_availability_Baysan_Tourism_wh_12_50_25_1706100625_53.json', 'expediapackage', '2024-01-24 12:50:28', '', 'a63c6eb78d6f7a10cfb68b17ffe3a775e22e47dddbcef7ddb167f34243bb375d', '0');
[01/24/2024 12:50:28], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=a63c6eb78d6f7a10cfb68b17ffe3a775e22e47dddbcef7ddb167f34243bb375d&xml_user_id=7863&db_caching=1&erequest=1&total_request=8&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=138'
            , http_hit_time = '2024-01-24 12:50:25.707'
            , 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.504'
            , error_description = ''
            , memory_used = '54551648'
            WHERE id = '29309';
[01/24/2024 12:50:28], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=a63c6eb78d6f7a10cfb68b17ffe3a775e22e47dddbcef7ddb167f34243bb375d&xml_user_id=7863&db_caching=1&erequest=4&total_request=8&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=138'
            , http_hit_time = '2024-01-24 12:50:25.707'
            , 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.515'
            , error_description = ''
            , memory_used = '47149320'
            WHERE id = '29310';
[01/24/2024 12:50:28], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/24_01_2024/request_availability_Baysan_Tourism_wh_12_50_25_1706100625_8.json', 'e1/24_01_2024/response_availability_Baysan_Tourism_wh_12_50_25_1706100625_8.json', 'e1/24_01_2024/response_header_availability_Baysan_Tourism_wh_12_50_25_1706100625_8.json', 'expedia', '2024-01-24 12:50:28', '', 'a63c6eb78d6f7a10cfb68b17ffe3a775e22e47dddbcef7ddb167f34243bb375d', '0');
[01/24/2024 12:50:28], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=a63c6eb78d6f7a10cfb68b17ffe3a775e22e47dddbcef7ddb167f34243bb375d&xml_user_id=7863&db_caching=1&erequest=3&total_request=8&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=138'
            , http_hit_time = '2024-01-24 12:50:25.707'
            , 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.713'
            , error_description = ''
            , memory_used = '71014008'
            WHERE id = '29308';
[01/24/2024 12:50:28], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=a63c6eb78d6f7a10cfb68b17ffe3a775e22e47dddbcef7ddb167f34243bb375d&xml_user_id=7863&db_caching=1&erequest=2&total_request=8&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=138'
            , http_hit_time = '2024-01-24 12:50:25.707'
            , 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.725'
            , error_description = ''
            , memory_used = '50463056'
            WHERE id = '29312';
[01/24/2024 12:50:28], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=a63c6eb78d6f7a10cfb68b17ffe3a775e22e47dddbcef7ddb167f34243bb375d&xml_user_id=7863&db_caching=1&erequest=2&total_request=8&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=138'
            , http_hit_time = '2024-01-24 12:50:25.707'
            , 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.768'
            , error_description = ''
            , memory_used = '57806816'
            WHERE id = '29311';
[01/24/2024 12:50:28], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=a63c6eb78d6f7a10cfb68b17ffe3a775e22e47dddbcef7ddb167f34243bb375d&xml_user_id=7863&db_caching=1&erequest=5&total_request=8&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=138'
            , http_hit_time = '2024-01-24 12:50:25.707'
            , 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.859'
            , error_description = ''
            , memory_used = '57889760'
            WHERE id = '29313';
[01/24/2024 12:50:28], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/24_01_2024/request_availability_Baysan_Tourism_wh_12_50_25_1706100625_42.json', 'e1p/24_01_2024/response_availability_Baysan_Tourism_wh_12_50_25_1706100625_42.json', 'e1p/24_01_2024/response_header_availability_Baysan_Tourism_wh_12_50_25_1706100625_42.json', 'expediapackage', '2024-01-24 12:50:28', '', 'a63c6eb78d6f7a10cfb68b17ffe3a775e22e47dddbcef7ddb167f34243bb375d', '0');
[01/24/2024 12:50:28], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=a63c6eb78d6f7a10cfb68b17ffe3a775e22e47dddbcef7ddb167f34243bb375d&xml_user_id=7863&db_caching=1&erequest=3&total_request=8&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=138'
            , http_hit_time = '2024-01-24 12:50:25.707'
            , 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.156'
            , error_description = ''
            , memory_used = '60205256'
            WHERE id = '29314';
[01/24/2024 12:50:29], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=a63c6eb78d6f7a10cfb68b17ffe3a775e22e47dddbcef7ddb167f34243bb375d&xml_user_id=7863&db_caching=1&erequest=0&total_request=8&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=138'
            , http_hit_time = '2024-01-24 12:50:25.707'
            , 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.359'
            , error_description = ''
            , memory_used = '56321032'
            WHERE id = '29315';
[01/24/2024 12:50:30], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 12:50:30' WHERE id= '333';
[01/24/2024 12:50:34], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 12:50:34' WHERE id= '333';
[01/24/2024 12:50:35], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 12:50:35' WHERE id= '333';
[01/24/2024 12:51:01], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 12:51:01' WHERE id= '333';
[01/24/2024 12:51:01], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 12:51:01' WHERE id= '333';
[01/24/2024 12:51:01], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1706100661','43.239.53.130');
[01/24/2024 12:51:02], [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/24_01_2024/request_valuation_Baysan_Tourism_wh_12_51_01_1706100661_17.json', 'e1p/24_01_2024/response_valuation_Baysan_Tourism_wh_12_51_01_1706100661_17.json', 'e1p/24_01_2024/response_header_valuation_Baysan_Tourism_wh_12_51_01_1706100661_17.json', 'expediapackage', '2024-01-24 12:51:02', '', 'a63c6eb78d6f7a10cfb68b17ffe3a775e22e47dddbcef7ddb167f34243bb375d', '0');
[01/24/2024 12:51:02], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 12:51:02' WHERE id= '333';
[01/24/2024 12:51:02], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 12:51:02' WHERE id= '333';
[01/24/2024 12:51:03], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1706100663','43.239.53.130');
[01/24/2024 12:51:03], [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', 'e1/24_01_2024/request_valuation_Baysan_Tourism_wh_12_51_03_1706100663_21.json', 'e1/24_01_2024/response_valuation_Baysan_Tourism_wh_12_51_03_1706100663_21.json', 'e1/24_01_2024/response_header_valuation_Baysan_Tourism_wh_12_51_03_1706100663_21.json', 'expedia', '2024-01-24 12:51:03', '', 'a63c6eb78d6f7a10cfb68b17ffe3a775e22e47dddbcef7ddb167f34243bb375d', '0');
[01/24/2024 12:51:05], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 12:51:05' WHERE id= '333';
[01/24/2024 12:51:05], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 12:51:05' WHERE id= '333';
[01/24/2024 12:51:05], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1706100665','43.239.53.130');
[01/24/2024 12:51:06], [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/24_01_2024/request_valuation_Baysan_Tourism_wh_12_51_05_1706100665_54.json', 'e1p/24_01_2024/response_valuation_Baysan_Tourism_wh_12_51_05_1706100665_54.json', 'e1p/24_01_2024/response_header_valuation_Baysan_Tourism_wh_12_51_05_1706100665_54.json', 'expediapackage', '2024-01-24 12:51:06', '', 'a63c6eb78d6f7a10cfb68b17ffe3a775e22e47dddbcef7ddb167f34243bb375d', '0');
[01/24/2024 12:51:08], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 12:51:08' WHERE id= '333';
[01/24/2024 12:51:08], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 12:51:08' WHERE id= '333';
[01/24/2024 12:51:08], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1706100668','43.239.53.130');
[01/24/2024 12:51:08], [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', 'e1/24_01_2024/request_valuation_Baysan_Tourism_wh_12_51_08_1706100668_30.json', 'e1/24_01_2024/response_valuation_Baysan_Tourism_wh_12_51_08_1706100668_30.json', 'e1/24_01_2024/response_header_valuation_Baysan_Tourism_wh_12_51_08_1706100668_30.json', 'expedia', '2024-01-24 12:51:08', '', 'a63c6eb78d6f7a10cfb68b17ffe3a775e22e47dddbcef7ddb167f34243bb375d', '0');
[01/24/2024 12:51:09], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 12:51:09' WHERE id= '333';
[01/24/2024 12:51:10], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 12:51:10' WHERE id= '333';
[01/24/2024 12:51:10], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1706100670','43.239.53.130');
[01/24/2024 12:51:10], [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/24_01_2024/request_valuation_Baysan_Tourism_wh_12_51_10_1706100670_86.json', 'e1p/24_01_2024/response_valuation_Baysan_Tourism_wh_12_51_10_1706100670_86.json', 'e1p/24_01_2024/response_header_valuation_Baysan_Tourism_wh_12_51_10_1706100670_86.json', 'expediapackage', '2024-01-24 12:51:10', '', 'a63c6eb78d6f7a10cfb68b17ffe3a775e22e47dddbcef7ddb167f34243bb375d', '0');
[01/24/2024 12:51:11], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 12:51:11' WHERE id= '333';
[01/24/2024 12:51:12], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 12:51:12' WHERE id= '333';
[01/24/2024 12:51:12], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1706100672','43.239.53.130');
[01/24/2024 12:51:12], [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', 'e1/24_01_2024/request_valuation_Baysan_Tourism_wh_12_51_12_1706100672_80.json', 'e1/24_01_2024/response_valuation_Baysan_Tourism_wh_12_51_12_1706100672_80.json', 'e1/24_01_2024/response_header_valuation_Baysan_Tourism_wh_12_51_12_1706100672_80.json', 'expedia', '2024-01-24 12:51:12', '', 'a63c6eb78d6f7a10cfb68b17ffe3a775e22e47dddbcef7ddb167f34243bb375d', '0');
[01/24/2024 12:51:16], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 12:51:16' WHERE id= '333';
[01/24/2024 12:51:16], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 12:51:16' WHERE id= '333';
[01/24/2024 12:51:16], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1706100676','43.239.53.130');
[01/24/2024 12:51:17], [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/24_01_2024/request_valuation_Baysan_Tourism_wh_12_51_16_1706100676_64.json', 'e1p/24_01_2024/response_valuation_Baysan_Tourism_wh_12_51_16_1706100676_64.json', 'e1p/24_01_2024/response_header_valuation_Baysan_Tourism_wh_12_51_16_1706100676_64.json', 'expediapackage', '2024-01-24 12:51:17', '', 'a63c6eb78d6f7a10cfb68b17ffe3a775e22e47dddbcef7ddb167f34243bb375d', '0');
[01/24/2024 12:51:17], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO mails_error_log set mailfrom='gajendra.rajpurohit@qtechsoftware.com',mailsubject='Payment Gateway credit limit is over for the days transaction (24-01-2024 12:51:17).(NOTIFICATION_PER_DAY_LIMIT)',mailbody='Dear Administrator,&lt;br/&gt;The Payment Gateway credit limit assigned is over for a day &lt;br/&gt; Payment Gateway Credit Limit IS  0 USD&lt;br/&gt; The customer wants to book for 0 USD&lt;br/&gt;&lt;br/&gt;Agent Information &lt;br/&gt;&lt;br/&gt;Agency Name : Qtech &lt;br&gt;Agency Code : CD7863 &lt;br&gt;City : phuket &lt;br&gt;Service Date : 2024/04/17 &lt;br&gt;',mailto='',mailcc='',mailbcc='',mailattachment='',reason='You must provide at least one recipient email address.',date_time='2024-01-24 12:51:17';
