[01/25/2024 07:36:56], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-25 07:36:56',login_attempt=0 where id = '7851';
[01/25/2024 07:36:56], [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-25 07:36:56', ip = '43.239.53.130', action = 'Login' ;
[01/25/2024 07:36:56], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-25 07:36:56' WHERE id= '309';
[01/25/2024 07:36:59], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-25 07:36:59' WHERE id= '309';
[01/25/2024 07:37:03], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-25 07:37:03' WHERE id= '309';
[01/25/2024 07:50:34], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-25 07:50:34',login_attempt=0 where id = '7865';
[01/25/2024 07:50:34], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'test_Whitelable', user_type = 'A', branch_id = '31', login_datetime = '2024-01-25 07:50:34', ip = '43.239.53.130', action = 'Login' ;
[01/25/2024 07:50:34], [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='02311073f9485e66612e176c7610fa70df5e02fc461c84ced9b30ffa27e388af',create_date='2024-01-25 07:50:34', update_date='2024-01-25 07:50:34',domain='baysantravel.astrabookings.com',sub_agent_id='',sub_user_id='';
[01/25/2024 07:50:47], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-25 07:50:47' WHERE id= '335';
[01/25/2024 07:50:48], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-25 07:50:48' WHERE id= '335';
[01/25/2024 07:51:07], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-25 07:51:07' WHERE id= '335';
[01/25/2024 07:51:07], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7865' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '31' , ip = '43.239.53.130' , city = 'bangkok' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2025/03/11' , departure_date = '2025/03/12' , nights = '1' , nationality = '106' , room_types = '1, 1' , room_type='[{"numberOfAdults":1},{"numberOfAdults":1}]' , available='0' , create_date = '2024-01-25 07:51:07' , site_id = '20' , country_code = '136' , city_code = '71325' , ratings = '1.0,3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[01/25/2024 07:51:09], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-01-25 07:51:09' WHERE id= '335';
[01/25/2024 07:51:09], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/25_01_2024/request_availability_Baysan_Tourism_wh_07_51_09_1706169069_26.json', 'e1/25_01_2024/response_availability_Baysan_Tourism_wh_07_51_09_1706169069_26.json', 'e1/25_01_2024/response_header_availability_Baysan_Tourism_wh_07_51_09_1706169069_26.json', 'expedia', '2024-01-25 07:51:09', '', '02311073f9485e66612e176c7610fa70df5e02fc461c84ced9b30ffa27e388af', '0');
[01/25/2024 07:51:09], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=02311073f9485e66612e176c7610fa70df5e02fc461c84ced9b30ffa27e388af&xml_user_id=7863&db_caching=1&erequest=1&total_request=7&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-25 07:51:09.543'
            , 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.295'
            , error_description = ''
            , memory_used = '2388624'
            WHERE id = '29402';
[01/25/2024 07:51:09], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/25_01_2024/request_availability_Baysan_Tourism_wh_07_51_09_1706169069_74.json', 'e1/25_01_2024/response_availability_Baysan_Tourism_wh_07_51_09_1706169069_74.json', 'e1/25_01_2024/response_header_availability_Baysan_Tourism_wh_07_51_09_1706169069_74.json', 'expedia', '2024-01-25 07:51:09', '', '02311073f9485e66612e176c7610fa70df5e02fc461c84ced9b30ffa27e388af', '0');
[01/25/2024 07:51:09], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=02311073f9485e66612e176c7610fa70df5e02fc461c84ced9b30ffa27e388af&xml_user_id=7863&db_caching=1&erequest=2&total_request=7&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-25 07:51:09.543'
            , 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.320'
            , error_description = ''
            , memory_used = '2389112'
            WHERE id = '29403';
[01/25/2024 07:51:09], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/25_01_2024/request_availability_Baysan_Tourism_wh_07_51_09_1706169069_35.json', 'e1p/25_01_2024/response_availability_Baysan_Tourism_wh_07_51_09_1706169069_35.json', 'e1p/25_01_2024/response_header_availability_Baysan_Tourism_wh_07_51_09_1706169069_35.json', 'expediapackage', '2024-01-25 07:51:09', '', '02311073f9485e66612e176c7610fa70df5e02fc461c84ced9b30ffa27e388af', '0');
[01/25/2024 07:51:09], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=02311073f9485e66612e176c7610fa70df5e02fc461c84ced9b30ffa27e388af&xml_user_id=7863&db_caching=1&erequest=6&total_request=7&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-25 07:51:09.542'
            , 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.332'
            , error_description = ''
            , memory_used = '2344024'
            WHERE id = '29404';
[01/25/2024 07:51:09], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/25_01_2024/request_availability_Baysan_Tourism_wh_07_51_09_1706169069_46.json', 'e1/25_01_2024/response_availability_Baysan_Tourism_wh_07_51_09_1706169069_46.json', 'e1/25_01_2024/response_header_availability_Baysan_Tourism_wh_07_51_09_1706169069_46.json', 'expedia', '2024-01-25 07:51:09', '', '02311073f9485e66612e176c7610fa70df5e02fc461c84ced9b30ffa27e388af', '0');
[01/25/2024 07:51:09], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/25_01_2024/request_availability_Baysan_Tourism_wh_07_51_09_1706169069_55.json', 'e1p/25_01_2024/response_availability_Baysan_Tourism_wh_07_51_09_1706169069_55.json', 'e1p/25_01_2024/response_header_availability_Baysan_Tourism_wh_07_51_09_1706169069_55.json', 'expediapackage', '2024-01-25 07:51:09', '', '02311073f9485e66612e176c7610fa70df5e02fc461c84ced9b30ffa27e388af', '0');
[01/25/2024 07:51:09], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=02311073f9485e66612e176c7610fa70df5e02fc461c84ced9b30ffa27e388af&xml_user_id=7863&db_caching=1&erequest=3&total_request=7&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-25 07:51:09.543'
            , 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.337'
            , error_description = ''
            , memory_used = '2390128'
            WHERE id = '29406';
[01/25/2024 07:51:09], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=02311073f9485e66612e176c7610fa70df5e02fc461c84ced9b30ffa27e388af&xml_user_id=7863&db_caching=1&erequest=6&total_request=7&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-25 07:51:09.542'
            , 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.337'
            , error_description = ''
            , memory_used = '2342536'
            WHERE id = '29405';
[01/25/2024 07:51:09], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/25_01_2024/request_availability_Baysan_Tourism_wh_07_51_09_1706169069_52.json', 'e1p/25_01_2024/response_availability_Baysan_Tourism_wh_07_51_09_1706169069_52.json', 'e1p/25_01_2024/response_header_availability_Baysan_Tourism_wh_07_51_09_1706169069_52.json', 'expediapackage', '2024-01-25 07:51:09', '', '02311073f9485e66612e176c7610fa70df5e02fc461c84ced9b30ffa27e388af', '0');
[01/25/2024 07:51:09], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=02311073f9485e66612e176c7610fa70df5e02fc461c84ced9b30ffa27e388af&xml_user_id=7863&db_caching=1&erequest=5&total_request=7&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-25 07:51:09.543'
            , 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.352'
            , error_description = ''
            , memory_used = '2370008'
            WHERE id = '29407';
[01/25/2024 07:51:09], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/25_01_2024/request_availability_Baysan_Tourism_wh_07_51_09_1706169069_99.json', 'e1/25_01_2024/response_availability_Baysan_Tourism_wh_07_51_09_1706169069_99.json', 'e1/25_01_2024/response_header_availability_Baysan_Tourism_wh_07_51_09_1706169069_99.json', 'expedia', '2024-01-25 07:51:09', '', '02311073f9485e66612e176c7610fa70df5e02fc461c84ced9b30ffa27e388af', '0');
[01/25/2024 07:51:09], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=02311073f9485e66612e176c7610fa70df5e02fc461c84ced9b30ffa27e388af&xml_user_id=7863&db_caching=1&erequest=5&total_request=7&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-25 07:51:09.543'
            , 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.365'
            , error_description = ''
            , memory_used = '2368576'
            WHERE id = '29408';
[01/25/2024 07:51:09], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/25_01_2024/request_availability_Baysan_Tourism_wh_07_51_09_1706169069_30.json', 'e1p/25_01_2024/response_availability_Baysan_Tourism_wh_07_51_09_1706169069_30.json', 'e1p/25_01_2024/response_header_availability_Baysan_Tourism_wh_07_51_09_1706169069_30.json', 'expediapackage', '2024-01-25 07:51:09', '', '02311073f9485e66612e176c7610fa70df5e02fc461c84ced9b30ffa27e388af', '0');
[01/25/2024 07:51:09], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=02311073f9485e66612e176c7610fa70df5e02fc461c84ced9b30ffa27e388af&xml_user_id=7863&db_caching=1&erequest=1&total_request=7&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-25 07:51:09.543'
            , 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.416'
            , error_description = ''
            , memory_used = '2389616'
            WHERE id = '29409';
[01/25/2024 07:51:09], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/25_01_2024/request_availability_Baysan_Tourism_wh_07_51_09_1706169069_75.json', 'e1p/25_01_2024/response_availability_Baysan_Tourism_wh_07_51_09_1706169069_75.json', 'e1p/25_01_2024/response_header_availability_Baysan_Tourism_wh_07_51_09_1706169069_75.json', 'expediapackage', '2024-01-25 07:51:09', '', '02311073f9485e66612e176c7610fa70df5e02fc461c84ced9b30ffa27e388af', '0');
[01/25/2024 07:51:09], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=02311073f9485e66612e176c7610fa70df5e02fc461c84ced9b30ffa27e388af&xml_user_id=7863&db_caching=1&erequest=4&total_request=7&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-25 07:51:09.543'
            , 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.442'
            , error_description = ''
            , memory_used = '2389688'
            WHERE id = '29410';
[01/25/2024 07:51:09], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/25_01_2024/request_availability_Baysan_Tourism_wh_07_51_09_1706169069_67.json', 'e1/25_01_2024/response_availability_Baysan_Tourism_wh_07_51_09_1706169069_67.json', 'e1/25_01_2024/response_header_availability_Baysan_Tourism_wh_07_51_09_1706169069_67.json', 'expedia', '2024-01-25 07:51:09', '', '02311073f9485e66612e176c7610fa70df5e02fc461c84ced9b30ffa27e388af', '0');
[01/25/2024 07:51:09], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=02311073f9485e66612e176c7610fa70df5e02fc461c84ced9b30ffa27e388af&xml_user_id=7863&db_caching=1&erequest=3&total_request=7&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-25 07:51:09.542'
            , 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.448'
            , error_description = ''
            , memory_used = '2389136'
            WHERE id = '29411';
[01/25/2024 07:51:10], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/25_01_2024/request_availability_Baysan_Tourism_wh_07_51_09_1706169069_1.json', 'e1/25_01_2024/response_availability_Baysan_Tourism_wh_07_51_09_1706169069_1.json', 'e1/25_01_2024/response_header_availability_Baysan_Tourism_wh_07_51_09_1706169069_1.json', 'expedia', '2024-01-25 07:51:10', '', '02311073f9485e66612e176c7610fa70df5e02fc461c84ced9b30ffa27e388af', '0');
[01/25/2024 07:51:10], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=02311073f9485e66612e176c7610fa70df5e02fc461c84ced9b30ffa27e388af&xml_user_id=7863&db_caching=1&erequest=0&total_request=7&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-25 07:51:09.543'
            , 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.478'
            , error_description = ''
            , memory_used = '2761216'
            WHERE id = '29412';
[01/25/2024 07:51:10], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/25_01_2024/request_availability_Baysan_Tourism_wh_07_51_09_1706169069_22.json', 'e1p/25_01_2024/response_availability_Baysan_Tourism_wh_07_51_09_1706169069_22.json', 'e1p/25_01_2024/response_header_availability_Baysan_Tourism_wh_07_51_09_1706169069_22.json', 'expediapackage', '2024-01-25 07:51:10', '', '02311073f9485e66612e176c7610fa70df5e02fc461c84ced9b30ffa27e388af', '0');
[01/25/2024 07:51:10], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=02311073f9485e66612e176c7610fa70df5e02fc461c84ced9b30ffa27e388af&xml_user_id=7863&db_caching=1&erequest=0&total_request=7&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-25 07:51:09.543'
            , 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.518'
            , error_description = ''
            , memory_used = '2761696'
            WHERE id = '29413';
[01/25/2024 07:51:10], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/25_01_2024/request_availability_Baysan_Tourism_wh_07_51_09_1706169069_3.json', 'e1p/25_01_2024/response_availability_Baysan_Tourism_wh_07_51_09_1706169069_3.json', 'e1p/25_01_2024/response_header_availability_Baysan_Tourism_wh_07_51_09_1706169069_3.json', 'expediapackage', '2024-01-25 07:51:10', '', '02311073f9485e66612e176c7610fa70df5e02fc461c84ced9b30ffa27e388af', '0');
[01/25/2024 07:51:10], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=02311073f9485e66612e176c7610fa70df5e02fc461c84ced9b30ffa27e388af&xml_user_id=7863&db_caching=1&erequest=2&total_request=7&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-25 07:51:09.543'
            , 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.563'
            , error_description = ''
            , memory_used = '2390272'
            WHERE id = '29414';
[01/25/2024 07:51:10], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/25_01_2024/request_availability_Baysan_Tourism_wh_07_51_09_1706169069_77.json', 'e1/25_01_2024/response_availability_Baysan_Tourism_wh_07_51_09_1706169069_77.json', 'e1/25_01_2024/response_header_availability_Baysan_Tourism_wh_07_51_09_1706169069_77.json', 'expedia', '2024-01-25 07:51:10', '', '02311073f9485e66612e176c7610fa70df5e02fc461c84ced9b30ffa27e388af', '0');
[01/25/2024 07:51:10], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=02311073f9485e66612e176c7610fa70df5e02fc461c84ced9b30ffa27e388af&xml_user_id=7863&db_caching=1&erequest=4&total_request=7&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-25 07:51:09.543'
            , 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.595'
            , error_description = ''
            , memory_used = '2388696'
            WHERE id = '29415';
[01/25/2024 07:51:14], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-01-25 07:51:14' WHERE id= '335';
[01/25/2024 07:51:15], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-25 07:51:15' WHERE id= '335';
[01/25/2024 07:51:15], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-25 07:51:15' WHERE id= '335';
[01/25/2024 07:51:27], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-25 07:51:27' WHERE id= '335';
[01/25/2024 07:51:43], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-25 07:51:43' WHERE id= '335';
[01/25/2024 07:51:43], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7865' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '31' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/14' , departure_date = '2024/05/15' , nights = '1' , nationality = '106' , room_types = '1, 1' , room_type='[{"numberOfAdults":1},{"numberOfAdults":1}]' , available='0' , create_date = '2024-01-25 07:51:43' , site_id = '20' , country_code = '138' , city_code = '71649' , ratings = '1.0,3.0,4.0,5.0' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[01/25/2024 07:51:44], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-01-25 07:51:44' WHERE id= '335';
[01/25/2024 07:51: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/25_01_2024/request_availability_Baysan_Tourism_wh_07_51_44_1706169104_54.json', 'e1/25_01_2024/response_availability_Baysan_Tourism_wh_07_51_44_1706169104_54.json', 'e1/25_01_2024/response_header_availability_Baysan_Tourism_wh_07_51_44_1706169104_54.json', 'expedia', '2024-01-25 07:51:45', '', '02311073f9485e66612e176c7610fa70df5e02fc461c84ced9b30ffa27e388af', '0');
[01/25/2024 07:51:46], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/25_01_2024/request_availability_Baysan_Tourism_wh_07_51_44_1706169104_51.json', 'e1p/25_01_2024/response_availability_Baysan_Tourism_wh_07_51_44_1706169104_51.json', 'e1p/25_01_2024/response_header_availability_Baysan_Tourism_wh_07_51_44_1706169104_51.json', 'expediapackage', '2024-01-25 07:51:46', '', '02311073f9485e66612e176c7610fa70df5e02fc461c84ced9b30ffa27e388af', '0');
[01/25/2024 07:51:46], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=02311073f9485e66612e176c7610fa70df5e02fc461c84ced9b30ffa27e388af&xml_user_id=7863&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-25 07:51:44.199'
            , 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.492'
            , error_description = ''
            , memory_used = '105016912'
            WHERE id = '29416';
[01/25/2024 07:51: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/25_01_2024/request_availability_Baysan_Tourism_wh_07_51_44_1706169104_80.json', 'e1/25_01_2024/response_availability_Baysan_Tourism_wh_07_51_44_1706169104_80.json', 'e1/25_01_2024/response_header_availability_Baysan_Tourism_wh_07_51_44_1706169104_80.json', 'expedia', '2024-01-25 07:51:46', '', '02311073f9485e66612e176c7610fa70df5e02fc461c84ced9b30ffa27e388af', '0');
[01/25/2024 07:51: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/25_01_2024/request_availability_Baysan_Tourism_wh_07_51_44_1706169104_18.json', 'e1p/25_01_2024/response_availability_Baysan_Tourism_wh_07_51_44_1706169104_18.json', 'e1p/25_01_2024/response_header_availability_Baysan_Tourism_wh_07_51_44_1706169104_18.json', 'expediapackage', '2024-01-25 07:51:47', '', '02311073f9485e66612e176c7610fa70df5e02fc461c84ced9b30ffa27e388af', '0');
[01/25/2024 07:51:47], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=02311073f9485e66612e176c7610fa70df5e02fc461c84ced9b30ffa27e388af&xml_user_id=7863&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-25 07:51:44.199'
            , 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.356'
            , error_description = ''
            , memory_used = '110946088'
            WHERE id = '29417';
[01/25/2024 07:51:48], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=02311073f9485e66612e176c7610fa70df5e02fc461c84ced9b30ffa27e388af&xml_user_id=7863&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-25 07:51:44.199'
            , 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.657'
            , error_description = ''
            , memory_used = '211364640'
            WHERE id = '29418';
[01/25/2024 07:51:49], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=02311073f9485e66612e176c7610fa70df5e02fc461c84ced9b30ffa27e388af&xml_user_id=7863&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-25 07:51:44.199'
            , 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.139'
            , error_description = ''
            , memory_used = '224993088'
            WHERE id = '29419';
[01/25/2024 07:51:50], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-01-25 07:51:50' WHERE id= '335';
[01/25/2024 07:51:50], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-25 07:51:50' WHERE id= '335';
[01/25/2024 07:53:02], [file name :-/home/otrams/public_html/beta/tms/agent.php],UPDATE agents SET agency_name= 'Qtech',other_language_agency_name= '',accounting_name= '',first_name= 'Deepak',middle_name= 'Trivedi',last_name= 'kumar',agent_type= 'CC',sort_type= 'price',credit_limit_assigned= '5000.000',credit_limit= '5000.000',credit_distribution= '0',temp_credit_limit= '',address= 'Mumbai',other_language_address= '',city= '71649',pincode= '',country= '138',time_zone_offset= '3',enable_dst= '',branch_id='31',phone= '91-1234567890',mobile= '91-1234567890',fax= '',currency= '6',email= 'Sujay.raut@qtechsoftware.com',website= '',lead_time= '',search_by_multicurrency= '1',debug= '',profile= '',designation= '',iata_status= '0',iata_number= '',nature_of_business= 'Travel Agent',can_book= '1',sales_manager_id= '',comp_reg_no= '',allow_quotation= '1',can_voucher= '1',markup= '10.0',allow_book_under_cancellation='0',modify_date='2024-01-25 07:53:02',consultant_id= 'Ayman',agency_email= '',acc_name= 'DEEPAK',acc_email= 'sujay.raut@qtechsoftware.com',acc_phone= '',man_name= '',man_email= '',man_phone= '',res_name= '',res_email= '',res_phone= '',remarks= '',apply_service_tax= 'no',allow_ticketing= '1' WHERE id= '7866';
[01/25/2024 07:53:02], [file name :-/home/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'Ayman',`create_date`= '2024-01-25 07:53:02',`log_type`= 'Agent Updated',`sql_query`= 'UPDATE agents SET agency_name= \&#039;Qtech\&#039;,other_language_agency_name= \&#039;\&#039;,accounting_name= \&#039;\&#039;,first_name= \&#039;Deepak\&#039;,middle_name= \&#039;Trivedi\&#039;,last_name= \&#039;kumar\&#039;,agent_type= \&#039;CC\&#039;,sort_type= \&#039;price\&#039;,credit_limit_assigned= \&#039;5000.000\&#039;,credit_limit= \&#039;5000.000\&#039;,credit_distribution= \&#039;0\&#039;,temp_credit_limit= \&#039;\&#039;,address= \&#039;Mumbai\&#039;,other_language_address= \&#039;\&#039;,city= \&#039;71649\&#039;,pincode= \&#039;\&#039;,country= \&#039;138\&#039;,time_zone_offset= \&#039;3\&#039;,enable_dst= 0,branch_id=\&#039;31\&#039;,phone= \&#039;91-1234567890\&#039;,mobile= \&#039;91-1234567890\&#039;,fax= \&#039;\&#039;,currency= \&#039;6\&#039;,email= \&#039;Sujay.raut@qtechsoftware.com\&#039;,website= \&#039;\&#039;,lead_time= 0,search_by_multicurrency= \&#039;1\&#039;,debug= 0,profile= \&#039;\&#039;,designation= \&#039;\&#039;,iata_status= \&#039;0\&#039;,iata_number= \&#039;\&#039;,nature_of_business= \&#039;Travel Agent\&#039;,can_book= \&#039;1\&#039;,sales_manager_id= ,comp_reg_no= \&#039;\&#039;,allow_quotation= \&#039;1\&#039;,can_voucher= \&#039;1\&#039;,markup= \&#039;10.0\&#039;,allow_book_under_cancellation=\&#039;0\&#039;,modify_date=\&#039;2024-01-25 07:53:02\&#039;,consultant_id= \&#039;Ayman\&#039;,agency_email= \&#039;\&#039;,acc_name= \&#039;DEEPAK\&#039;,acc_email= \&#039;sujay.raut@qtechsoftware.com\&#039;,acc_phone= \&#039;\&#039;,man_name= \&#039;\&#039;,man_email= \&#039;\&#039;,man_phone= \&#039;\&#039;,res_name= \&#039;\&#039;,res_email= \&#039;\&#039;,res_phone= \&#039;\&#039;,remarks= ,apply_service_tax= \&#039;no\&#039;,allow_ticketing= 1 WHERE id= \&#039;7866\&#039;',`log_description`= 'Agent 7866 updated For  - modify_date=2024-01-19+11%3A50%3A58&markup=0.5 changed to - modify_date=2024-01-25+07%3A53%3A02&markup=10.0',`ip`= '43.239.53.130';
[01/25/2024 07:53:02], [file name :-/home/otrams/public_html/beta/tms/agent.php],UPDATE agents SET cd_credit_limit=credit_limit-'7866' , cd_credit_value=cd_credit_limit-cd_credit_usage WHERE id= ?;
[01/25/2024 07:53:02], [file name :-/home/otrams/public_html/beta/tms/agent.php],insert into  agent_credit_log SET agent_id= '7866',credit_value= '4689.870',credit_usage= '310.130',credit_limit= '5000.000',receipt_id= '',amount= '',ip='43.239.53.130',user_type='admin',admin_id='Ayman',temp_credit_limit='',log_type='Edit_Agent',note='Agent Edited by Ayman',create_date='2024-01-25 07:01:02';
[01/25/2024 07:53:02], [file name :-/home/otrams/public_html/beta/tms/agent.php],UPDATE agents SET currency= '6',branch_id= '31',consultant_id= 'Ayman',sales_manager_id= '',profile= '', agent_type= 'CC' WHERE parent_agent= '7866';
[01/25/2024 07:53:09], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-25 07:53:09' WHERE id= '335';
[01/25/2024 07:53:09], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7865' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '31' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/14' , departure_date = '2024/05/15' , nights = '1' , nationality = '106' , room_types = '1, 1' , room_type='[{"numberOfAdults":1},{"numberOfAdults":1}]' , available='0' , create_date = '2024-01-25 07:53:09' , site_id = '20' , country_code = '138' , city_code = '71649' , ratings = '1.0,2.0,3.0,4.0,5.0' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[01/25/2024 07:53:11], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-01-25 07:53:11' WHERE id= '335';
[01/25/2024 07:53:13], [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/25_01_2024/request_availability_Baysan_Tourism_wh_07_53_11_1706169191_40.json', 'e1/25_01_2024/response_availability_Baysan_Tourism_wh_07_53_11_1706169191_40.json', 'e1/25_01_2024/response_header_availability_Baysan_Tourism_wh_07_53_11_1706169191_40.json', 'expedia', '2024-01-25 07:53:13', '', '02311073f9485e66612e176c7610fa70df5e02fc461c84ced9b30ffa27e388af', '0');
[01/25/2024 07:53:14], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=02311073f9485e66612e176c7610fa70df5e02fc461c84ced9b30ffa27e388af&xml_user_id=7863&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-25 07:53:11.348'
            , 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.828'
            , error_description = ''
            , memory_used = '118063104'
            WHERE id = '29420';
[01/25/2024 07:53:14], [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/25_01_2024/request_availability_Baysan_Tourism_wh_07_53_11_1706169191_18.json', 'e1/25_01_2024/response_availability_Baysan_Tourism_wh_07_53_11_1706169191_18.json', 'e1/25_01_2024/response_header_availability_Baysan_Tourism_wh_07_53_11_1706169191_18.json', 'expedia', '2024-01-25 07:53:14', '', '02311073f9485e66612e176c7610fa70df5e02fc461c84ced9b30ffa27e388af', '0');
[01/25/2024 07:53:14], [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/25_01_2024/request_availability_Baysan_Tourism_wh_07_53_11_1706169191_45.json', 'e1p/25_01_2024/response_availability_Baysan_Tourism_wh_07_53_11_1706169191_45.json', 'e1p/25_01_2024/response_header_availability_Baysan_Tourism_wh_07_53_11_1706169191_45.json', 'expediapackage', '2024-01-25 07:53:14', '', '02311073f9485e66612e176c7610fa70df5e02fc461c84ced9b30ffa27e388af', '0');
[01/25/2024 07:53:14], [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/25_01_2024/request_availability_Baysan_Tourism_wh_07_53_11_1706169191_69.json', 'e1p/25_01_2024/response_availability_Baysan_Tourism_wh_07_53_11_1706169191_69.json', 'e1p/25_01_2024/response_header_availability_Baysan_Tourism_wh_07_53_11_1706169191_69.json', 'expediapackage', '2024-01-25 07:53:14', '', '02311073f9485e66612e176c7610fa70df5e02fc461c84ced9b30ffa27e388af', '0');
[01/25/2024 07:53:15], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=02311073f9485e66612e176c7610fa70df5e02fc461c84ced9b30ffa27e388af&xml_user_id=7863&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-25 07:53:11.348'
            , 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.462'
            , error_description = ''
            , memory_used = '200862928'
            WHERE id = '29421';
[01/25/2024 07:53:15], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=02311073f9485e66612e176c7610fa70df5e02fc461c84ced9b30ffa27e388af&xml_user_id=7863&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-25 07:53:11.348'
            , 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.508'
            , error_description = ''
            , memory_used = '125211416'
            WHERE id = '29422';
[01/25/2024 07:53:16], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=02311073f9485e66612e176c7610fa70df5e02fc461c84ced9b30ffa27e388af&xml_user_id=7863&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-25 07:53:11.348'
            , 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.326'
            , error_description = ''
            , memory_used = '213088752'
            WHERE id = '29423';
[01/25/2024 07:53:17], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-01-25 07:53:17' WHERE id= '335';
[01/25/2024 07:53:17], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-25 07:53:17' WHERE id= '335';
[01/25/2024 07:53:18], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-25 07:53:18' WHERE id= '335';
[01/25/2024 07:54:39], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-25 07:54:39' WHERE id= '335';
[01/25/2024 07:54:39], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7865' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '31' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/14' , departure_date = '2024/05/15' , nights = '1' , nationality = '106' , room_types = '1' , room_type='[{"numberOfAdults":1}]' , available='0' , create_date = '2024-01-25 07:54:39' , site_id = '20' , country_code = '138' , city_code = '71649' , ratings = '1.0,2.0,3.0,4.0,5.0' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[01/25/2024 07:54:39], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-01-25 07:54:39' WHERE id= '335';
[01/25/2024 07:54: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/25_01_2024/request_availability_Baysan_Tourism_wh_07_54_39_1706169279_35.json', 'e1/25_01_2024/response_availability_Baysan_Tourism_wh_07_54_39_1706169279_35.json', 'e1/25_01_2024/response_header_availability_Baysan_Tourism_wh_07_54_39_1706169279_35.json', 'expedia', '2024-01-25 07:54:41', '', '02311073f9485e66612e176c7610fa70df5e02fc461c84ced9b30ffa27e388af', '0');
[01/25/2024 07:54: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/25_01_2024/request_availability_Baysan_Tourism_wh_07_54_39_1706169279_62.json', 'e1/25_01_2024/response_availability_Baysan_Tourism_wh_07_54_39_1706169279_62.json', 'e1/25_01_2024/response_header_availability_Baysan_Tourism_wh_07_54_39_1706169279_62.json', 'expedia', '2024-01-25 07:54:41', '', '02311073f9485e66612e176c7610fa70df5e02fc461c84ced9b30ffa27e388af', '0');
[01/25/2024 07:54: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/25_01_2024/request_availability_Baysan_Tourism_wh_07_54_39_1706169279_94.json', 'e1p/25_01_2024/response_availability_Baysan_Tourism_wh_07_54_39_1706169279_94.json', 'e1p/25_01_2024/response_header_availability_Baysan_Tourism_wh_07_54_39_1706169279_94.json', 'expediapackage', '2024-01-25 07:54:42', '', '02311073f9485e66612e176c7610fa70df5e02fc461c84ced9b30ffa27e388af', '0');
[01/25/2024 07:54: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/25_01_2024/request_availability_Baysan_Tourism_wh_07_54_39_1706169279_76.json', 'e1p/25_01_2024/response_availability_Baysan_Tourism_wh_07_54_39_1706169279_76.json', 'e1p/25_01_2024/response_header_availability_Baysan_Tourism_wh_07_54_39_1706169279_76.json', 'expediapackage', '2024-01-25 07:54:42', '', '02311073f9485e66612e176c7610fa70df5e02fc461c84ced9b30ffa27e388af', '0');
[01/25/2024 07:54:42], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=02311073f9485e66612e176c7610fa70df5e02fc461c84ced9b30ffa27e388af&xml_user_id=7863&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-25 07:54:39.727'
            , 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.907'
            , error_description = ''
            , memory_used = '123537496'
            WHERE id = '29424';
[01/25/2024 07:54:43], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=02311073f9485e66612e176c7610fa70df5e02fc461c84ced9b30ffa27e388af&xml_user_id=7863&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-25 07:54:39.727'
            , 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.710'
            , error_description = ''
            , memory_used = '131363296'
            WHERE id = '29426';
[01/25/2024 07:54:43], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=02311073f9485e66612e176c7610fa70df5e02fc461c84ced9b30ffa27e388af&xml_user_id=7863&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-25 07:54:39.727'
            , 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.737'
            , error_description = ''
            , memory_used = '209358896'
            WHERE id = '29425';
[01/25/2024 07:54:44], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=02311073f9485e66612e176c7610fa70df5e02fc461c84ced9b30ffa27e388af&xml_user_id=7863&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-25 07:54:39.727'
            , 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 = '222235592'
            WHERE id = '29427';
[01/25/2024 07:54:45], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-01-25 07:54:45' WHERE id= '335';
[01/25/2024 07:54:45], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-25 07:54:45' WHERE id= '335';
[01/25/2024 07:55:00], [file name :-/home/otrams/public_html/beta/tms/agent.php],UPDATE agents SET agency_name= 'Qtech',other_language_agency_name= '',accounting_name= '',first_name= 'Deepak',middle_name= 'Trivedi',last_name= 'kumar',agent_type= 'CC',sort_type= 'price',credit_limit_assigned= '5000.000',credit_limit= '5000.000',credit_distribution= '0',temp_credit_limit= '',address= 'Mumbai',other_language_address= '',city= '71649',pincode= '',country= '138',time_zone_offset= '3',enable_dst= '',branch_id='31',phone= '91-1234567890',mobile= '91-1234567890',fax= '',currency= '6',email= 'Sujay.raut@qtechsoftware.com',website= '',lead_time= '',search_by_multicurrency= '1',debug= '',profile= '',designation= '',iata_status= '0',iata_number= '',nature_of_business= 'Travel Agent',can_book= '1',sales_manager_id= '',comp_reg_no= '',allow_quotation= '1',can_voucher= '1',markup= '0.5',allow_book_under_cancellation='0',modify_date='2024-01-25 07:55:00',consultant_id= 'Ayman',agency_email= '',acc_name= 'DEEPAK',acc_email= 'sujay.raut@qtechsoftware.com',acc_phone= '',man_name= '',man_email= '',man_phone= '',res_name= '',res_email= '',res_phone= '',remarks= '',apply_service_tax= 'no',allow_ticketing= '1' WHERE id= '7866';
[01/25/2024 07:55:00], [file name :-/home/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'Ayman',`create_date`= '2024-01-25 07:55:00',`log_type`= 'Agent Updated',`sql_query`= 'UPDATE agents SET agency_name= \&#039;Qtech\&#039;,other_language_agency_name= \&#039;\&#039;,accounting_name= \&#039;\&#039;,first_name= \&#039;Deepak\&#039;,middle_name= \&#039;Trivedi\&#039;,last_name= \&#039;kumar\&#039;,agent_type= \&#039;CC\&#039;,sort_type= \&#039;price\&#039;,credit_limit_assigned= \&#039;5000.000\&#039;,credit_limit= \&#039;5000.000\&#039;,credit_distribution= \&#039;0\&#039;,temp_credit_limit= \&#039;\&#039;,address= \&#039;Mumbai\&#039;,other_language_address= \&#039;\&#039;,city= \&#039;71649\&#039;,pincode= \&#039;\&#039;,country= \&#039;138\&#039;,time_zone_offset= \&#039;3\&#039;,enable_dst= 0,branch_id=\&#039;31\&#039;,phone= \&#039;91-1234567890\&#039;,mobile= \&#039;91-1234567890\&#039;,fax= \&#039;\&#039;,currency= \&#039;6\&#039;,email= \&#039;Sujay.raut@qtechsoftware.com\&#039;,website= \&#039;\&#039;,lead_time= 0,search_by_multicurrency= \&#039;1\&#039;,debug= 0,profile= \&#039;\&#039;,designation= \&#039;\&#039;,iata_status= \&#039;0\&#039;,iata_number= \&#039;\&#039;,nature_of_business= \&#039;Travel Agent\&#039;,can_book= \&#039;1\&#039;,sales_manager_id= ,comp_reg_no= \&#039;\&#039;,allow_quotation= \&#039;1\&#039;,can_voucher= \&#039;1\&#039;,markup= \&#039;0.5\&#039;,allow_book_under_cancellation=\&#039;0\&#039;,modify_date=\&#039;2024-01-25 07:55:00\&#039;,consultant_id= \&#039;Ayman\&#039;,agency_email= \&#039;\&#039;,acc_name= \&#039;DEEPAK\&#039;,acc_email= \&#039;sujay.raut@qtechsoftware.com\&#039;,acc_phone= \&#039;\&#039;,man_name= \&#039;\&#039;,man_email= \&#039;\&#039;,man_phone= \&#039;\&#039;,res_name= \&#039;\&#039;,res_email= \&#039;\&#039;,res_phone= \&#039;\&#039;,remarks= ,apply_service_tax= \&#039;no\&#039;,allow_ticketing= 1 WHERE id= \&#039;7866\&#039;',`log_description`= 'Agent 7866 updated For  - modify_date=2024-01-25+07%3A53%3A02&markup=10.0 changed to - modify_date=2024-01-25+07%3A55%3A00&markup=0.5',`ip`= '43.239.53.130';
[01/25/2024 07:55:00], [file name :-/home/otrams/public_html/beta/tms/agent.php],UPDATE agents SET cd_credit_limit=credit_limit-'7866' , cd_credit_value=cd_credit_limit-cd_credit_usage WHERE id= ?;
[01/25/2024 07:55:00], [file name :-/home/otrams/public_html/beta/tms/agent.php],insert into  agent_credit_log SET agent_id= '7866',credit_value= '4689.870',credit_usage= '310.130',credit_limit= '5000.000',receipt_id= '',amount= '',ip='43.239.53.130',user_type='admin',admin_id='Ayman',temp_credit_limit='',log_type='Edit_Agent',note='Agent Edited by Ayman',create_date='2024-01-25 07:01:00';
[01/25/2024 07:55:00], [file name :-/home/otrams/public_html/beta/tms/agent.php],UPDATE agents SET currency= '6',branch_id= '31',consultant_id= 'Ayman',sales_manager_id= '',profile= '', agent_type= 'CC' WHERE parent_agent= '7866';
[01/25/2024 07:55:04], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-01-25 07:55:04' WHERE id= '335';
[01/25/2024 07:55:04], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-25 07:55:04',login_attempt=0 where id = '7866';
[01/25/2024 07:55:04], [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-25 07:55:04', ip = '43.239.53.130', action = 'Login' ;
[01/25/2024 07:55:04], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-25 07:55:04' WHERE id= '335';
[01/25/2024 07:55:11], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-25 07:55:11' WHERE id= '335';
[01/25/2024 07:55:18], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-25 07:55:18' WHERE id= '335';
[01/25/2024 07:55:18], [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 = 'dubai' , service_name = '' , country_of_residence = '138' , service_type = 'hotel' , arrival_date = '2024/02/22' , departure_date = '2024/02/23' , nights = '1' , nationality = '138' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-01-25 07:55:18' , site_id = '20' , country_code = '138' , city_code = '71649' , ratings = '1.0,2.0,3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[01/25/2024 07:55:19], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-01-25 07:55:19' WHERE id= '335';
[01/25/2024 07:55: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/25_01_2024/request_availability_Baysan_Tourism_wh_07_55_19_1706169319_60.json', 'e1/25_01_2024/response_availability_Baysan_Tourism_wh_07_55_19_1706169319_60.json', 'e1/25_01_2024/response_header_availability_Baysan_Tourism_wh_07_55_19_1706169319_60.json', 'expedia', '2024-01-25 07:55:19', '', '02311073f9485e66612e176c7610fa70df5e02fc461c84ced9b30ffa27e388af', '0');
[01/25/2024 07:55:19], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=02311073f9485e66612e176c7610fa70df5e02fc461c84ced9b30ffa27e388af&xml_user_id=7863&db_caching=1&erequest=2&total_request=3&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-25 07:55:19.173'
            , 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.204'
            , error_description = ''
            , memory_used = '2340608'
            WHERE id = '29428';
[01/25/2024 07:55: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', 'e1p/25_01_2024/request_availability_Baysan_Tourism_wh_07_55_19_1706169319_55.json', 'e1p/25_01_2024/response_availability_Baysan_Tourism_wh_07_55_19_1706169319_55.json', 'e1p/25_01_2024/response_header_availability_Baysan_Tourism_wh_07_55_19_1706169319_55.json', 'expediapackage', '2024-01-25 07:55:19', '', '02311073f9485e66612e176c7610fa70df5e02fc461c84ced9b30ffa27e388af', '0');
[01/25/2024 07:55:19], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=02311073f9485e66612e176c7610fa70df5e02fc461c84ced9b30ffa27e388af&xml_user_id=7863&db_caching=1&erequest=2&total_request=3&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-25 07:55:19.173'
            , 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.212'
            , error_description = ''
            , memory_used = '2340992'
            WHERE id = '29429';
[01/25/2024 07:55: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', 'e1/25_01_2024/request_availability_Baysan_Tourism_wh_07_55_19_1706169319_81.json', 'e1/25_01_2024/response_availability_Baysan_Tourism_wh_07_55_19_1706169319_81.json', 'e1/25_01_2024/response_header_availability_Baysan_Tourism_wh_07_55_19_1706169319_81.json', 'expedia', '2024-01-25 07:55:20', '', '02311073f9485e66612e176c7610fa70df5e02fc461c84ced9b30ffa27e388af', '0');
[01/25/2024 07:55: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', 'e1/25_01_2024/request_availability_Baysan_Tourism_wh_07_55_19_1706169319_66.json', 'e1/25_01_2024/response_availability_Baysan_Tourism_wh_07_55_19_1706169319_66.json', 'e1/25_01_2024/response_header_availability_Baysan_Tourism_wh_07_55_19_1706169319_66.json', 'expedia', '2024-01-25 07:55:20', '', '02311073f9485e66612e176c7610fa70df5e02fc461c84ced9b30ffa27e388af', '0');
[01/25/2024 07:55:21], [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/25_01_2024/request_availability_Baysan_Tourism_wh_07_55_19_1706169319_77.json', 'e1p/25_01_2024/response_availability_Baysan_Tourism_wh_07_55_19_1706169319_77.json', 'e1p/25_01_2024/response_header_availability_Baysan_Tourism_wh_07_55_19_1706169319_77.json', 'expediapackage', '2024-01-25 07:55:21', '', '02311073f9485e66612e176c7610fa70df5e02fc461c84ced9b30ffa27e388af', '0');
[01/25/2024 07:55:22], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=02311073f9485e66612e176c7610fa70df5e02fc461c84ced9b30ffa27e388af&xml_user_id=7863&db_caching=1&erequest=1&total_request=3&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-25 07:55:19.173'
            , 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.016'
            , error_description = ''
            , memory_used = '163905504'
            WHERE id = '29430';
[01/25/2024 07:55:22], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=02311073f9485e66612e176c7610fa70df5e02fc461c84ced9b30ffa27e388af&xml_user_id=7863&db_caching=1&erequest=0&total_request=3&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-25 07:55:19.172'
            , 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.188'
            , error_description = ''
            , memory_used = '161713728'
            WHERE id = '29431';
[01/25/2024 07:55:22], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/25_01_2024/request_availability_Baysan_Tourism_wh_07_55_19_1706169319_47.json', 'e1p/25_01_2024/response_availability_Baysan_Tourism_wh_07_55_19_1706169319_47.json', 'e1p/25_01_2024/response_header_availability_Baysan_Tourism_wh_07_55_19_1706169319_47.json', 'expediapackage', '2024-01-25 07:55:22', '', '02311073f9485e66612e176c7610fa70df5e02fc461c84ced9b30ffa27e388af', '0');
[01/25/2024 07:55:22], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=02311073f9485e66612e176c7610fa70df5e02fc461c84ced9b30ffa27e388af&xml_user_id=7863&db_caching=1&erequest=1&total_request=3&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-25 07:55:19.173'
            , 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.550'
            , error_description = ''
            , memory_used = '172037104'
            WHERE id = '29432';
[01/25/2024 07:55:23], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=02311073f9485e66612e176c7610fa70df5e02fc461c84ced9b30ffa27e388af&xml_user_id=7863&db_caching=1&erequest=0&total_request=3&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-25 07:55:19.172'
            , 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.800'
            , error_description = ''
            , memory_used = '173767864'
            WHERE id = '29433';
[01/25/2024 07:55:24], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-01-25 07:55:24' WHERE id= '335';
[01/25/2024 07:55:25], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-25 07:55:25' WHERE id= '335';
[01/25/2024 07:55:46], [file name :-/home/otrams/public_html/beta/tms/agent.php],UPDATE agents SET agency_name= 'Qtech',other_language_agency_name= '',accounting_name= '',first_name= 'Deepak',middle_name= 'Trivedi',last_name= 'kumar',agent_type= 'CC',sort_type= 'price',credit_limit_assigned= '5000.000',credit_limit= '5000.000',credit_distribution= '0',temp_credit_limit= '',address= 'Mumbai',other_language_address= '',city= '71649',pincode= '',country= '138',time_zone_offset= '3',enable_dst= '',branch_id='31',phone= '91-1234567890',mobile= '91-1234567890',fax= '',currency= '6',email= 'Sujay.raut@qtechsoftware.com',website= '',lead_time= '',search_by_multicurrency= '1',debug= '',profile= '',designation= '',iata_status= '0',iata_number= '',nature_of_business= 'Travel Agent',can_book= '1',sales_manager_id= '',comp_reg_no= '',allow_quotation= '1',can_voucher= '1',markup= '10.0',allow_book_under_cancellation='0',modify_date='2024-01-25 07:55:46',consultant_id= 'Ayman',agency_email= '',acc_name= 'DEEPAK',acc_email= 'sujay.raut@qtechsoftware.com',acc_phone= '',man_name= '',man_email= '',man_phone= '',res_name= '',res_email= '',res_phone= '',remarks= '',apply_service_tax= 'no',allow_ticketing= '1' WHERE id= '7866';
[01/25/2024 07:55:46], [file name :-/home/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'Ayman',`create_date`= '2024-01-25 07:55:46',`log_type`= 'Agent Updated',`sql_query`= 'UPDATE agents SET agency_name= \&#039;Qtech\&#039;,other_language_agency_name= \&#039;\&#039;,accounting_name= \&#039;\&#039;,first_name= \&#039;Deepak\&#039;,middle_name= \&#039;Trivedi\&#039;,last_name= \&#039;kumar\&#039;,agent_type= \&#039;CC\&#039;,sort_type= \&#039;price\&#039;,credit_limit_assigned= \&#039;5000.000\&#039;,credit_limit= \&#039;5000.000\&#039;,credit_distribution= \&#039;0\&#039;,temp_credit_limit= \&#039;\&#039;,address= \&#039;Mumbai\&#039;,other_language_address= \&#039;\&#039;,city= \&#039;71649\&#039;,pincode= \&#039;\&#039;,country= \&#039;138\&#039;,time_zone_offset= \&#039;3\&#039;,enable_dst= 0,branch_id=\&#039;31\&#039;,phone= \&#039;91-1234567890\&#039;,mobile= \&#039;91-1234567890\&#039;,fax= \&#039;\&#039;,currency= \&#039;6\&#039;,email= \&#039;Sujay.raut@qtechsoftware.com\&#039;,website= \&#039;\&#039;,lead_time= 0,search_by_multicurrency= \&#039;1\&#039;,debug= 0,profile= \&#039;\&#039;,designation= \&#039;\&#039;,iata_status= \&#039;0\&#039;,iata_number= \&#039;\&#039;,nature_of_business= \&#039;Travel Agent\&#039;,can_book= \&#039;1\&#039;,sales_manager_id= ,comp_reg_no= \&#039;\&#039;,allow_quotation= \&#039;1\&#039;,can_voucher= \&#039;1\&#039;,markup= \&#039;10.0\&#039;,allow_book_under_cancellation=\&#039;0\&#039;,modify_date=\&#039;2024-01-25 07:55:46\&#039;,consultant_id= \&#039;Ayman\&#039;,agency_email= \&#039;\&#039;,acc_name= \&#039;DEEPAK\&#039;,acc_email= \&#039;sujay.raut@qtechsoftware.com\&#039;,acc_phone= \&#039;\&#039;,man_name= \&#039;\&#039;,man_email= \&#039;\&#039;,man_phone= \&#039;\&#039;,res_name= \&#039;\&#039;,res_email= \&#039;\&#039;,res_phone= \&#039;\&#039;,remarks= ,apply_service_tax= \&#039;no\&#039;,allow_ticketing= 1 WHERE id= \&#039;7866\&#039;',`log_description`= 'Agent 7866 updated For  - modify_date=2024-01-25+07%3A55%3A00&markup=0.5 changed to - modify_date=2024-01-25+07%3A55%3A46&markup=10.0',`ip`= '43.239.53.130';
[01/25/2024 07:55:46], [file name :-/home/otrams/public_html/beta/tms/agent.php],UPDATE agents SET cd_credit_limit=credit_limit-'7866' , cd_credit_value=cd_credit_limit-cd_credit_usage WHERE id= ?;
[01/25/2024 07:55:46], [file name :-/home/otrams/public_html/beta/tms/agent.php],insert into  agent_credit_log SET agent_id= '7866',credit_value= '4689.870',credit_usage= '310.130',credit_limit= '5000.000',receipt_id= '',amount= '',ip='43.239.53.130',user_type='admin',admin_id='Ayman',temp_credit_limit='',log_type='Edit_Agent',note='Agent Edited by Ayman',create_date='2024-01-25 07:01:46';
[01/25/2024 07:55:46], [file name :-/home/otrams/public_html/beta/tms/agent.php],UPDATE agents SET currency= '6',branch_id= '31',consultant_id= 'Ayman',sales_manager_id= '',profile= '', agent_type= 'CC' WHERE parent_agent= '7866';
[01/25/2024 07:58:32], [file name :-/home/otrams/public_html/beta/tms/logout.php],INSERT INTO psa_login_log set username = 'Ayman' , user_type = 'Ayman'_type , branch_id = '31' , login_datetime = '2024-01-25 07:58:32' , ip = '43.239.53.130' , action = 'Logout'  ;
[01/25/2024 07:58:36], [file name :-/home/otrams/public_html/beta/logout.php],UPDATE user_sessions_ip SET update_date = '2024-01-25 07:58:36' WHERE id= '335';
[01/25/2024 07:59:18], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-25 07:59:18',login_attempt=0 where id = '7865';
[01/25/2024 07:59:18], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'test_Whitelable', user_type = 'A', branch_id = '31', login_datetime = '2024-01-25 07:59:18', ip = '43.239.53.130', action = 'Login' ;
[01/25/2024 07:59:18], [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='6d69969915d6f534225f080444abb7461bd6b3a2d735d5623f2ebcfbc4477501',create_date='2024-01-25 07:59:18', update_date='2024-01-25 07:59:18',domain='baysantravel.astrabookings.com',sub_agent_id='',sub_user_id='';
[01/25/2024 07:59:30], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-25 07:59:30' WHERE id= '336';
[01/25/2024 07:59:41], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-25 07:59:41' WHERE id= '336';
[01/25/2024 07:59:41], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7865' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '31' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/03/12' , departure_date = '2024/03/13' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-01-25 07:59:41' , site_id = '20' , country_code = '138' , city_code = '71649' , ratings = '1.0,2.0,3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[01/25/2024 07:59:41], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-01-25 07:59:41' WHERE id= '336';
[01/25/2024 07:59:42], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/25_01_2024/request_availability_Baysan_Tourism_wh_07_59_41_1706169581_44.json', 'e1/25_01_2024/response_availability_Baysan_Tourism_wh_07_59_41_1706169581_44.json', 'e1/25_01_2024/response_header_availability_Baysan_Tourism_wh_07_59_41_1706169581_44.json', 'expedia', '2024-01-25 07:59:42', '', '6d69969915d6f534225f080444abb7461bd6b3a2d735d5623f2ebcfbc4477501', '0');
[01/25/2024 07:59: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/25_01_2024/request_availability_Baysan_Tourism_wh_07_59_41_1706169581_85.json', 'e1p/25_01_2024/response_availability_Baysan_Tourism_wh_07_59_41_1706169581_85.json', 'e1p/25_01_2024/response_header_availability_Baysan_Tourism_wh_07_59_41_1706169581_85.json', 'expediapackage', '2024-01-25 07:59:42', '', '6d69969915d6f534225f080444abb7461bd6b3a2d735d5623f2ebcfbc4477501', '0');
[01/25/2024 07:59:42], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=6d69969915d6f534225f080444abb7461bd6b3a2d735d5623f2ebcfbc4477501&xml_user_id=7863&db_caching=1&erequest=2&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-25 07:59:41.850'
            , 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.182'
            , error_description = ''
            , memory_used = '2340608'
            WHERE id = '29434';
[01/25/2024 07:59:42], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=6d69969915d6f534225f080444abb7461bd6b3a2d735d5623f2ebcfbc4477501&xml_user_id=7863&db_caching=1&erequest=2&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-25 07:59:41.850'
            , 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.187'
            , error_description = ''
            , memory_used = '2341088'
            WHERE id = '29435';
[01/25/2024 07:59: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', 'e1/25_01_2024/request_availability_Baysan_Tourism_wh_07_59_41_1706169581_96.json', 'e1/25_01_2024/response_availability_Baysan_Tourism_wh_07_59_41_1706169581_96.json', 'e1/25_01_2024/response_header_availability_Baysan_Tourism_wh_07_59_41_1706169581_96.json', 'expedia', '2024-01-25 07:59:43', '', '6d69969915d6f534225f080444abb7461bd6b3a2d735d5623f2ebcfbc4477501', '0');
[01/25/2024 07:59:44], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/25_01_2024/request_availability_Baysan_Tourism_wh_07_59_41_1706169581_87.json', 'e1/25_01_2024/response_availability_Baysan_Tourism_wh_07_59_41_1706169581_87.json', 'e1/25_01_2024/response_header_availability_Baysan_Tourism_wh_07_59_41_1706169581_87.json', 'expedia', '2024-01-25 07:59:44', '', '6d69969915d6f534225f080444abb7461bd6b3a2d735d5623f2ebcfbc4477501', '0');
[01/25/2024 07:59: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/25_01_2024/request_availability_Baysan_Tourism_wh_07_59_41_1706169581_65.json', 'e1p/25_01_2024/response_availability_Baysan_Tourism_wh_07_59_41_1706169581_65.json', 'e1p/25_01_2024/response_header_availability_Baysan_Tourism_wh_07_59_41_1706169581_65.json', 'expediapackage', '2024-01-25 07:59:44', '', '6d69969915d6f534225f080444abb7461bd6b3a2d735d5623f2ebcfbc4477501', '0');
[01/25/2024 07:59:45], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/25_01_2024/request_availability_Baysan_Tourism_wh_07_59_41_1706169581_27.json', 'e1p/25_01_2024/response_availability_Baysan_Tourism_wh_07_59_41_1706169581_27.json', 'e1p/25_01_2024/response_header_availability_Baysan_Tourism_wh_07_59_41_1706169581_27.json', 'expediapackage', '2024-01-25 07:59:45', '', '6d69969915d6f534225f080444abb7461bd6b3a2d735d5623f2ebcfbc4477501', '0');
[01/25/2024 07:59:45], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=6d69969915d6f534225f080444abb7461bd6b3a2d735d5623f2ebcfbc4477501&xml_user_id=7863&db_caching=1&erequest=1&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-25 07:59:41.850'
            , 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.841'
            , error_description = ''
            , memory_used = '195861400'
            WHERE id = '29436';
[01/25/2024 07:59:45], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=6d69969915d6f534225f080444abb7461bd6b3a2d735d5623f2ebcfbc4477501&xml_user_id=7863&db_caching=1&erequest=0&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-25 07:59:41.850'
            , 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.951'
            , error_description = ''
            , memory_used = '189949528'
            WHERE id = '29437';
[01/25/2024 07:59:46], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=6d69969915d6f534225f080444abb7461bd6b3a2d735d5623f2ebcfbc4477501&xml_user_id=7863&db_caching=1&erequest=1&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-25 07:59:41.850'
            , 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.307'
            , error_description = ''
            , memory_used = '202071184'
            WHERE id = '29438';
[01/25/2024 07:59:46], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=6d69969915d6f534225f080444abb7461bd6b3a2d735d5623f2ebcfbc4477501&xml_user_id=7863&db_caching=1&erequest=0&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-25 07:59:41.850'
            , 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.001'
            , error_description = ''
            , memory_used = '198612832'
            WHERE id = '29439';
[01/25/2024 07:59:47], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-01-25 07:59:47' WHERE id= '336';
[01/25/2024 07:59:48], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-25 07:59:48' WHERE id= '336';
[01/25/2024 07:59:48], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-25 07:59:48' WHERE id= '336';
