[06/07/2023 11:24:04], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2023-06-07 11:24:04',login_attempt=0 where id = '7851';
[06/07/2023 11:24:04], [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 = '2023-06-07 11:24:04', ip = '43.239.53.130', action = 'Login' ;
[06/07/2023 11:24:04], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:24:04' WHERE id= '14';
[06/07/2023 11:24:09], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:24:09' WHERE id= '14';
[06/07/2023 11:24:14], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:24:14' WHERE id= '14';
[06/07/2023 11:24:14], [file name :-/home/otrams/public_html/beta/hotel_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' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2023/06/23' , departure_date = '2023/06/24' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2023-06-07 11:24:14' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'SAR' , currency_code = 'SAR' , web_service = '' ;
[06/07/2023 11:24:14], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:24:14' WHERE id= '14';
[06/07/2023 11:24:15], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:24:15' WHERE id= '14';
[06/07/2023 11:24:16], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:24:16' WHERE id= '14';
[06/07/2023 11:24:22], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:24:22' WHERE id= '14';
[06/07/2023 11:24:22], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2023-06-07 11:24:22',login_attempt=0 where id = '7848';
[06/07/2023 11:24:22], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'mv3alpha', user_type = 'A', branch_id = '1', login_datetime = '2023-06-07 11:24:22', ip = '43.239.53.130', action = 'Login' ;
[06/07/2023 11:24:22], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:24:22' WHERE id= '14';
[06/07/2023 11:24:37], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:24:37' WHERE id= '14';
[06/07/2023 11:24:37], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2023-06-07 11:24:37',login_attempt=0 where id = '7839';
[06/07/2023 11:24:37], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'sqtech', user_type = 'A', branch_id = '4', login_datetime = '2023-06-07 11:24:37', ip = '43.239.53.130', action = 'Login' ;
[06/07/2023 11:24:37], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:24:37' WHERE id= '14';
[06/07/2023 11:24:44], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:24:44' WHERE id= '14';
[06/07/2023 11:24:46], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:24:46' WHERE id= '14';
[06/07/2023 11:24:51], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:24:51' WHERE id= '14';
[06/07/2023 11:24:51], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7839' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '4' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2023/06/23' , departure_date = '2023/06/24' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2023-06-07 11:24:51' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'SAR' , currency_code = 'SAR' , web_service = '' ;
[06/07/2023 11:24:51], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:24:51' WHERE id= '14';
[06/07/2023 11:24:52], [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/07_06_2023/request_availability_sqtech_11_24_52_1686137092_75.json', 'e1/07_06_2023/response_availability_sqtech_11_24_52_1686137092_75.json', 'e1/07_06_2023/response_header_availability_sqtech_11_24_52_1686137092_75.json', 'expedia', '2023-06-07 11:24:52', '', '89a43df8fa2fdca9bb80fd04614371e24e042b880e7e56048964fe55995fe16b', '0');
[06/07/2023 11:24:52], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=89a43df8fa2fdca9bb80fd04614371e24e042b880e7e56048964fe55995fe16b&xml_user_id=7839&db_caching=1&erequest=2&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F113.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-06-07 11:24:52.637'
            , 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.314'
            , error_description = ''
            , memory_used = '2593344'
            WHERE id = '148';
[06/07/2023 11:24:53], [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/07_06_2023/request_availability_sqtech_11_24_52_1686137092_53.json', 'e1p/07_06_2023/response_availability_sqtech_11_24_52_1686137092_53.json', 'e1p/07_06_2023/response_header_availability_sqtech_11_24_52_1686137092_53.json', 'expediapackage', '2023-06-07 11:24:53', '', '89a43df8fa2fdca9bb80fd04614371e24e042b880e7e56048964fe55995fe16b', '0');
[06/07/2023 11:24:53], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=89a43df8fa2fdca9bb80fd04614371e24e042b880e7e56048964fe55995fe16b&xml_user_id=7839&db_caching=1&erequest=2&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F113.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-06-07 11:24:52.637'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.856'
            , error_description = ''
            , memory_used = '2594224'
            WHERE id = '149';
[06/07/2023 11:24:54], [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/07_06_2023/request_availability_sqtech_11_24_52_1686137092_22.json', 'e1/07_06_2023/response_availability_sqtech_11_24_52_1686137092_22.json', 'e1/07_06_2023/response_header_availability_sqtech_11_24_52_1686137092_22.json', 'expedia', '2023-06-07 11:24:54', '', '89a43df8fa2fdca9bb80fd04614371e24e042b880e7e56048964fe55995fe16b', '0');
[06/07/2023 11:24:55], [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/07_06_2023/request_availability_sqtech_11_24_52_1686137092_68.json', 'e1/07_06_2023/response_availability_sqtech_11_24_52_1686137092_68.json', 'e1/07_06_2023/response_header_availability_sqtech_11_24_52_1686137092_68.json', 'expedia', '2023-06-07 11:24:55', '', '89a43df8fa2fdca9bb80fd04614371e24e042b880e7e56048964fe55995fe16b', '0');
[06/07/2023 11:24:55], [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/07_06_2023/request_availability_sqtech_11_24_52_1686137092_47.json', 'e1p/07_06_2023/response_availability_sqtech_11_24_52_1686137092_47.json', 'e1p/07_06_2023/response_header_availability_sqtech_11_24_52_1686137092_47.json', 'expediapackage', '2023-06-07 11:24:55', '', '89a43df8fa2fdca9bb80fd04614371e24e042b880e7e56048964fe55995fe16b', '0');
[06/07/2023 11:24:57], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=89a43df8fa2fdca9bb80fd04614371e24e042b880e7e56048964fe55995fe16b&xml_user_id=7839&db_caching=1&erequest=1&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F113.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-06-07 11:24:52.637'
            , 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.436'
            , error_description = ''
            , memory_used = '151425744'
            WHERE id = '150';
[06/07/2023 11:24:57], [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/07_06_2023/request_availability_sqtech_11_24_52_1686137092_1.json', 'e1p/07_06_2023/response_availability_sqtech_11_24_52_1686137092_1.json', 'e1p/07_06_2023/response_header_availability_sqtech_11_24_52_1686137092_1.json', 'expediapackage', '2023-06-07 11:24:57', '', '89a43df8fa2fdca9bb80fd04614371e24e042b880e7e56048964fe55995fe16b', '0');
[06/07/2023 11:24:57], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=89a43df8fa2fdca9bb80fd04614371e24e042b880e7e56048964fe55995fe16b&xml_user_id=7839&db_caching=1&erequest=0&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F113.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-06-07 11:24:52.637'
            , 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.978'
            , error_description = ''
            , memory_used = '186883224'
            WHERE id = '151';
[06/07/2023 11:24:57], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=89a43df8fa2fdca9bb80fd04614371e24e042b880e7e56048964fe55995fe16b&xml_user_id=7839&db_caching=1&erequest=0&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F113.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-06-07 11:24:52.638'
            , 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.294'
            , error_description = ''
            , memory_used = '161256600'
            WHERE id = '152';
[06/07/2023 11:24:59], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=89a43df8fa2fdca9bb80fd04614371e24e042b880e7e56048964fe55995fe16b&xml_user_id=7839&db_caching=1&erequest=1&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F113.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-06-07 11:24:52.637'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '6.871'
            , error_description = ''
            , memory_used = '136153376'
            WHERE id = '153';
[06/07/2023 11:24:59], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:24:59' WHERE id= '14';
[06/07/2023 11:24:59], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:24:59' WHERE id= '14';
[06/07/2023 11:25:01], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:25:01' WHERE id= '14';
[06/07/2023 11:25:06], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:25:06' WHERE id= '14';
[06/07/2023 11:25:22], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Grand Central Hotel', 'dubai', '138', '7839', '', '4', '', 'hoteldetails', '2023-06-07 :11:25:22','');
[06/07/2023 11:25:22], [file name :-/home/otrams/public_html/beta/view_map.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:25:22' WHERE id= '14';
[06/07/2023 11:26:20], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:26:20' WHERE id= '14';
[06/07/2023 11:26:20], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2023-06-07 11:26:20',login_attempt=0 where id = '7851';
[06/07/2023 11:26:20], [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 = '2023-06-07 11:26:20', ip = '43.239.53.130', action = 'Login' ;
[06/07/2023 11:26:20], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:26:20' WHERE id= '14';
[06/07/2023 11:26:45], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:26:45' WHERE id= '14';
[06/07/2023 11:26:51], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:26:51' WHERE id= '14';
[06/07/2023 11:26:51], [file name :-/home/otrams/public_html/beta/hotel_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' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2023/06/23' , departure_date = '2023/06/24' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2023-06-07 11:26:51' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'SAR' , currency_code = 'SAR' , web_service = '' ;
[06/07/2023 11:26:52], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:26:52' WHERE id= '14';
[06/07/2023 11:26:53], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:26:53' WHERE id= '14';
[06/07/2023 11:26:54], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:26:54' WHERE id= '14';
[06/07/2023 11:27:00], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:27:00' WHERE id= '14';
[06/07/2023 11:27:00], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2023-06-07 11:27:00',login_attempt=0 where id = '7839';
[06/07/2023 11:27:00], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'sqtech', user_type = 'A', branch_id = '4', login_datetime = '2023-06-07 11:27:00', ip = '43.239.53.130', action = 'Login' ;
[06/07/2023 11:27:01], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:27:01' WHERE id= '14';
[06/07/2023 11:27:05], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:27:05' WHERE id= '14';
[06/07/2023 11:27:10], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:27:10' WHERE id= '14';
[06/07/2023 11:27:10], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7839' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '4' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2023/06/29' , departure_date = '2023/06/30' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2023-06-07 11:27:10' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'SAR' , currency_code = 'SAR' , web_service = '' ;
[06/07/2023 11:27:10], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:27:10' WHERE id= '14';
[06/07/2023 11:27:11], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/07_06_2023/request_availability_sqtech_11_27_10_1686137230_43.json', 'e1p/07_06_2023/response_availability_sqtech_11_27_10_1686137230_43.json', 'e1p/07_06_2023/response_header_availability_sqtech_11_27_10_1686137230_43.json', 'expediapackage', '2023-06-07 11:27:11', '', '89a43df8fa2fdca9bb80fd04614371e24e042b880e7e56048964fe55995fe16b', '0');
[06/07/2023 11:27:11], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=89a43df8fa2fdca9bb80fd04614371e24e042b880e7e56048964fe55995fe16b&xml_user_id=7839&db_caching=1&erequest=2&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F113.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-06-07 11:27:10.873'
            , 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.224'
            , error_description = ''
            , memory_used = '2594088'
            WHERE id = '160';
[06/07/2023 11:27:11], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/07_06_2023/request_availability_sqtech_11_27_10_1686137230_98.json', 'e1/07_06_2023/response_availability_sqtech_11_27_10_1686137230_98.json', 'e1/07_06_2023/response_header_availability_sqtech_11_27_10_1686137230_98.json', 'expedia', '2023-06-07 11:27:11', '', '89a43df8fa2fdca9bb80fd04614371e24e042b880e7e56048964fe55995fe16b', '0');
[06/07/2023 11:27:11], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=89a43df8fa2fdca9bb80fd04614371e24e042b880e7e56048964fe55995fe16b&xml_user_id=7839&db_caching=1&erequest=2&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F113.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-06-07 11:27:10.878'
            , 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.279'
            , error_description = ''
            , memory_used = '2593104'
            WHERE id = '161';
[06/07/2023 11:27:12], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/07_06_2023/request_availability_sqtech_11_27_10_1686137230_20.json', 'e1p/07_06_2023/response_availability_sqtech_11_27_10_1686137230_20.json', 'e1p/07_06_2023/response_header_availability_sqtech_11_27_10_1686137230_20.json', 'expediapackage', '2023-06-07 11:27:12', '', '89a43df8fa2fdca9bb80fd04614371e24e042b880e7e56048964fe55995fe16b', '0');
[06/07/2023 11:27: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/07_06_2023/request_availability_sqtech_11_27_10_1686137230_10.json', 'e1/07_06_2023/response_availability_sqtech_11_27_10_1686137230_10.json', 'e1/07_06_2023/response_header_availability_sqtech_11_27_10_1686137230_10.json', 'expedia', '2023-06-07 11:27:13', '', '89a43df8fa2fdca9bb80fd04614371e24e042b880e7e56048964fe55995fe16b', '0');
[06/07/2023 11:27: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/07_06_2023/request_availability_sqtech_11_27_10_1686137230_49.json', 'e1/07_06_2023/response_availability_sqtech_11_27_10_1686137230_49.json', 'e1/07_06_2023/response_header_availability_sqtech_11_27_10_1686137230_49.json', 'expedia', '2023-06-07 11:27:13', '', '89a43df8fa2fdca9bb80fd04614371e24e042b880e7e56048964fe55995fe16b', '0');
[06/07/2023 11:27: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', 'e1p/07_06_2023/request_availability_sqtech_11_27_10_1686137230_15.json', 'e1p/07_06_2023/response_availability_sqtech_11_27_10_1686137230_15.json', 'e1p/07_06_2023/response_header_availability_sqtech_11_27_10_1686137230_15.json', 'expediapackage', '2023-06-07 11:27:13', '', '89a43df8fa2fdca9bb80fd04614371e24e042b880e7e56048964fe55995fe16b', '0');
[06/07/2023 11:27:15], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=89a43df8fa2fdca9bb80fd04614371e24e042b880e7e56048964fe55995fe16b&xml_user_id=7839&db_caching=1&erequest=1&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F113.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-06-07 11:27:10.875'
            , 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.197'
            , error_description = ''
            , memory_used = '130550848'
            WHERE id = '162';
[06/07/2023 11:27:15], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=89a43df8fa2fdca9bb80fd04614371e24e042b880e7e56048964fe55995fe16b&xml_user_id=7839&db_caching=1&erequest=1&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F113.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-06-07 11:27:10.874'
            , 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.647'
            , error_description = ''
            , memory_used = '146073576'
            WHERE id = '164';
[06/07/2023 11:27:15], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=89a43df8fa2fdca9bb80fd04614371e24e042b880e7e56048964fe55995fe16b&xml_user_id=7839&db_caching=1&erequest=0&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F113.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-06-07 11:27:10.873'
            , 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.831'
            , error_description = ''
            , memory_used = '181095368'
            WHERE id = '163';
[06/07/2023 11:27:15], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=89a43df8fa2fdca9bb80fd04614371e24e042b880e7e56048964fe55995fe16b&xml_user_id=7839&db_caching=1&erequest=0&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F113.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-06-07 11:27:10.875'
            , 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.920'
            , error_description = ''
            , memory_used = '155054216'
            WHERE id = '165';
[06/07/2023 11:27:15], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:27:15' WHERE id= '14';
[06/07/2023 11:27:16], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:27:16' WHERE id= '14';
[06/07/2023 11:27:18], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:27:18' WHERE id= '14';
[06/07/2023 11:27:22], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:27:22' WHERE id= '14';
[06/07/2023 11:27:52], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Ascot Hotel', 'dubai', '138', '7839', '', '4', '', 'hoteldetails', '2023-06-07 :11:27:52','');
[06/07/2023 11:27:52], [file name :-/home/otrams/public_html/beta/view_map.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:27:52' WHERE id= '14';
[06/07/2023 11:28:33], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:28:33' WHERE id= '14';
[06/07/2023 11:28:54], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:28:54' WHERE id= '14';
[06/07/2023 11:28:56], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:28:56' WHERE id= '14';
[06/07/2023 11:29:00], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:29:00' WHERE id= '14';
[06/07/2023 11:29:04], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:29:04' WHERE id= '14';
[06/07/2023 11:29:12], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:29:12' WHERE id= '14';
[06/07/2023 11:29:24], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Ascot Hotel', 'dubai', '138', '7839', '', '4', '', 'hoteldetails', '2023-06-07 :11:29:24','');
[06/07/2023 11:29:24], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:29:24' WHERE id= '14';
[06/07/2023 11:29:25], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:29:25' WHERE id= '14';
[06/07/2023 11:29:25], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2023-06-07 11:29:25',login_attempt=0 where id = '7839';
[06/07/2023 11:29:25], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'sqtech', user_type = 'A', branch_id = '4', login_datetime = '2023-06-07 11:29:25', ip = '43.239.53.130', action = 'Login' ;
[06/07/2023 11:29:25], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:29:25' WHERE id= '14';
[06/07/2023 11:29:30], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:29:30' WHERE id= '14';
[06/07/2023 11:29:35], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:29:35' WHERE id= '14';
[06/07/2023 11:29:35], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7839' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '4' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2023/06/23' , departure_date = '2023/06/24' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2023-06-07 11:29:35' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'SAR' , currency_code = 'SAR' , web_service = '' ;
[06/07/2023 11:29:36], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:29:36' WHERE id= '14';
[06/07/2023 11:29:36], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/07_06_2023/request_availability_sqtech_11_29_36_1686137376_50.json', 'e1p/07_06_2023/response_availability_sqtech_11_29_36_1686137376_50.json', 'e1p/07_06_2023/response_header_availability_sqtech_11_29_36_1686137376_50.json', 'expediapackage', '2023-06-07 11:29:36', '', '89a43df8fa2fdca9bb80fd04614371e24e042b880e7e56048964fe55995fe16b', '0');
[06/07/2023 11:29:36], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=89a43df8fa2fdca9bb80fd04614371e24e042b880e7e56048964fe55995fe16b&xml_user_id=7839&db_caching=1&erequest=2&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F113.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-06-07 11:29:36.235'
            , 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.244'
            , error_description = ''
            , memory_used = '2593984'
            WHERE id = '171';
[06/07/2023 11:29:36], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/07_06_2023/request_availability_sqtech_11_29_36_1686137376_40.json', 'e1/07_06_2023/response_availability_sqtech_11_29_36_1686137376_40.json', 'e1/07_06_2023/response_header_availability_sqtech_11_29_36_1686137376_40.json', 'expedia', '2023-06-07 11:29:36', '', '89a43df8fa2fdca9bb80fd04614371e24e042b880e7e56048964fe55995fe16b', '0');
[06/07/2023 11:29:36], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=89a43df8fa2fdca9bb80fd04614371e24e042b880e7e56048964fe55995fe16b&xml_user_id=7839&db_caching=1&erequest=2&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F113.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-06-07 11:29:36.237'
            , 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 = '2593104'
            WHERE id = '172';
[06/07/2023 11:29:38], [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/07_06_2023/request_availability_sqtech_11_29_36_1686137376_72.json', 'e1/07_06_2023/response_availability_sqtech_11_29_36_1686137376_72.json', 'e1/07_06_2023/response_header_availability_sqtech_11_29_36_1686137376_72.json', 'expedia', '2023-06-07 11:29:38', '', '89a43df8fa2fdca9bb80fd04614371e24e042b880e7e56048964fe55995fe16b', '0');
[06/07/2023 11:29:38], [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/07_06_2023/request_availability_sqtech_11_29_36_1686137376_96.json', 'e1/07_06_2023/response_availability_sqtech_11_29_36_1686137376_96.json', 'e1/07_06_2023/response_header_availability_sqtech_11_29_36_1686137376_96.json', 'expedia', '2023-06-07 11:29:38', '', '89a43df8fa2fdca9bb80fd04614371e24e042b880e7e56048964fe55995fe16b', '0');
[06/07/2023 11:29:39], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=89a43df8fa2fdca9bb80fd04614371e24e042b880e7e56048964fe55995fe16b&xml_user_id=7839&db_caching=1&erequest=1&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F113.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-06-07 11:29:36.235'
            , 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.424'
            , error_description = ''
            , memory_used = '151360848'
            WHERE id = '173';
[06/07/2023 11:29:39], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/07_06_2023/request_availability_sqtech_11_29_36_1686137376_17.json', 'e1p/07_06_2023/response_availability_sqtech_11_29_36_1686137376_17.json', 'e1p/07_06_2023/response_header_availability_sqtech_11_29_36_1686137376_17.json', 'expediapackage', '2023-06-07 11:29:39', '', '89a43df8fa2fdca9bb80fd04614371e24e042b880e7e56048964fe55995fe16b', '0');
[06/07/2023 11:29:40], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/07_06_2023/request_availability_sqtech_11_29_36_1686137376_41.json', 'e1p/07_06_2023/response_availability_sqtech_11_29_36_1686137376_41.json', 'e1p/07_06_2023/response_header_availability_sqtech_11_29_36_1686137376_41.json', 'expediapackage', '2023-06-07 11:29:40', '', '89a43df8fa2fdca9bb80fd04614371e24e042b880e7e56048964fe55995fe16b', '0');
[06/07/2023 11:29:40], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=89a43df8fa2fdca9bb80fd04614371e24e042b880e7e56048964fe55995fe16b&xml_user_id=7839&db_caching=1&erequest=0&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F113.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-06-07 11:29:36.234'
            , 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.469'
            , error_description = ''
            , memory_used = '186871720'
            WHERE id = '174';
[06/07/2023 11:29:41], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=89a43df8fa2fdca9bb80fd04614371e24e042b880e7e56048964fe55995fe16b&xml_user_id=7839&db_caching=1&erequest=1&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F113.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-06-07 11:29:36.235'
            , 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.183'
            , error_description = ''
            , memory_used = '135774312'
            WHERE id = '175';
[06/07/2023 11:29:42], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=89a43df8fa2fdca9bb80fd04614371e24e042b880e7e56048964fe55995fe16b&xml_user_id=7839&db_caching=1&erequest=0&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F113.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-06-07 11:29:36.234'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '6.112'
            , error_description = ''
            , memory_used = '161312904'
            WHERE id = '176';
[06/07/2023 11:29:42], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:29:42' WHERE id= '14';
[06/07/2023 11:29:43], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:29:43' WHERE id= '14';
[06/07/2023 11:29:45], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:29:45' WHERE id= '14';
[06/07/2023 11:29:48], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:29:48' WHERE id= '14';
[06/07/2023 11:30:09], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Grand Central Hotel', 'dubai', '138', '7839', '', '4', '', 'hoteldetails', '2023-06-07 :11:30:09','');
[06/07/2023 11:30:09], [file name :-/home/otrams/public_html/beta/view_map.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:30:09' WHERE id= '14';
[06/07/2023 11:31:25], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:31:25' WHERE id= '14';
[06/07/2023 11:31:33], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:31:33' WHERE id= '14';
[06/07/2023 11:31:41], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:31:41' WHERE id= '14';
[06/07/2023 11:31:49], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Grand Central Hotel', 'dubai', '138', '7839', '', '4', '', 'hoteldetails', '2023-06-07 :11:31:49','');
[06/07/2023 11:31:49], [file name :-/home/otrams/public_html/beta/view_map.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:31:49' WHERE id= '14';
[06/07/2023 11:32:17], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:32:17' WHERE id= '14';
[06/07/2023 11:32:20], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:32:20' WHERE id= '14';
[06/07/2023 11:32:27], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:32:27' WHERE id= '14';
[06/07/2023 11:32:34], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Grand Central Hotel', 'dubai', '138', '7839', '', '4', '', 'hoteldetails', '2023-06-07 :11:32:34','');
[06/07/2023 11:32:34], [file name :-/home/otrams/public_html/beta/view_map.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:32:34' WHERE id= '14';
[06/07/2023 11:33:30], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:33:30' WHERE id= '14';
[06/07/2023 11:34:44], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:34:44' WHERE id= '14';
[06/07/2023 11:34:46], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:34:46' WHERE id= '14';
[06/07/2023 11:34:53], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:34:53' WHERE id= '14';
[06/07/2023 11:35:01], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Grand Central Hotel', 'dubai', '138', '7839', '', '4', '', 'hoteldetails', '2023-06-07 :11:35:01','');
[06/07/2023 11:35:02], [file name :-/home/otrams/public_html/beta/view_map.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:35:02' WHERE id= '14';
[06/07/2023 11:35:06], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:35:06' WHERE id= '14';
[06/07/2023 11:35:11], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:35:11' WHERE id= '14';
[06/07/2023 11:35:20], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:35:20' WHERE id= '14';
[06/07/2023 11:35:28], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Grand Central Hotel', 'dubai', '138', '7839', '', '4', '', 'hoteldetails', '2023-06-07 :11:35:28','');
[06/07/2023 11:35:31], [file name :-/home/otrams/public_html/beta/view_map.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:35:31' WHERE id= '14';
[06/07/2023 11:51:33], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2023-06-07 11:51:33',login_attempt=0 where id = '7849';
[06/07/2023 11:51:33], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'shiv_qtech', user_type = 'A', branch_id = '24', login_datetime = '2023-06-07 11:51:33', ip = '43.239.53.130', action = 'Login' ;
[06/07/2023 11:51: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='7849', session_id='cf7fa38eb12c303974eb3a7f22a4109343d3d07e5aa2374682884b0bc4a692d6',create_date='2023-06-07 11:51:34', update_date='2023-06-07 11:51:34',domain='beta.astrabookings.com',sub_agent_id='',sub_user_id='';
[06/07/2023 11:51:39], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:51:39' WHERE id= '17';
[06/07/2023 11:51:39], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2023-06-07 11:51:39',login_attempt=0 where id = '7839';
[06/07/2023 11:51:39], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'sqtech', user_type = 'A', branch_id = '4', login_datetime = '2023-06-07 11:51:39', ip = '43.239.53.130', action = 'Login' ;
[06/07/2023 11:51:39], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:51:39' WHERE id= '17';
[06/07/2023 11:51:47], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:51:47' WHERE id= '17';
[06/07/2023 11:51:52], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:51:52' WHERE id= '17';
[06/07/2023 11:51:52], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7839' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '4' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2023/06/22' , departure_date = '2023/06/23' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2023-06-07 11:51:52' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'SAR' , currency_code = 'SAR' , web_service = '' ;
[06/07/2023 11:51:53], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:51:53' WHERE id= '17';
[06/07/2023 11:51:53], [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/07_06_2023/request_availability_sqtech_11_51_53_1686138713_41.json', 'e1/07_06_2023/response_availability_sqtech_11_51_53_1686138713_41.json', 'e1/07_06_2023/response_header_availability_sqtech_11_51_53_1686138713_41.json', 'expedia', '2023-06-07 11:51:53', '', 'cf7fa38eb12c303974eb3a7f22a4109343d3d07e5aa2374682884b0bc4a692d6', '0');
[06/07/2023 11:51:53], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=cf7fa38eb12c303974eb3a7f22a4109343d3d07e5aa2374682884b0bc4a692d6&xml_user_id=7839&db_caching=1&erequest=2&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F113.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-06-07 11:51:53.492'
            , 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.249'
            , error_description = ''
            , memory_used = '2592792'
            WHERE id = '180';
[06/07/2023 11:51:53], [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/07_06_2023/request_availability_sqtech_11_51_53_1686138713_77.json', 'e1p/07_06_2023/response_availability_sqtech_11_51_53_1686138713_77.json', 'e1p/07_06_2023/response_header_availability_sqtech_11_51_53_1686138713_77.json', 'expediapackage', '2023-06-07 11:51:53', '', 'cf7fa38eb12c303974eb3a7f22a4109343d3d07e5aa2374682884b0bc4a692d6', '0');
[06/07/2023 11:51:53], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=cf7fa38eb12c303974eb3a7f22a4109343d3d07e5aa2374682884b0bc4a692d6&xml_user_id=7839&db_caching=1&erequest=2&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F113.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-06-07 11:51:53.492'
            , 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.336'
            , error_description = ''
            , memory_used = '2594000'
            WHERE id = '181';
[06/07/2023 11:51:55], [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/07_06_2023/request_availability_sqtech_11_51_53_1686138713_93.json', 'e1/07_06_2023/response_availability_sqtech_11_51_53_1686138713_93.json', 'e1/07_06_2023/response_header_availability_sqtech_11_51_53_1686138713_93.json', 'expedia', '2023-06-07 11:51:55', '', 'cf7fa38eb12c303974eb3a7f22a4109343d3d07e5aa2374682884b0bc4a692d6', '0');
[06/07/2023 11:51:55], [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/07_06_2023/request_availability_sqtech_11_51_53_1686138713_7.json', 'e1/07_06_2023/response_availability_sqtech_11_51_53_1686138713_7.json', 'e1/07_06_2023/response_header_availability_sqtech_11_51_53_1686138713_7.json', 'expedia', '2023-06-07 11:51:55', '', 'cf7fa38eb12c303974eb3a7f22a4109343d3d07e5aa2374682884b0bc4a692d6', '0');
[06/07/2023 11:51:56], [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/07_06_2023/request_availability_sqtech_11_51_53_1686138713_5.json', 'e1p/07_06_2023/response_availability_sqtech_11_51_53_1686138713_5.json', 'e1p/07_06_2023/response_header_availability_sqtech_11_51_53_1686138713_5.json', 'expediapackage', '2023-06-07 11:51:56', '', 'cf7fa38eb12c303974eb3a7f22a4109343d3d07e5aa2374682884b0bc4a692d6', '0');
[06/07/2023 11:51:57], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=cf7fa38eb12c303974eb3a7f22a4109343d3d07e5aa2374682884b0bc4a692d6&xml_user_id=7839&db_caching=1&erequest=1&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F113.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-06-07 11:51:53.491'
            , 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.692'
            , error_description = ''
            , memory_used = '153371424'
            WHERE id = '182';
[06/07/2023 11:51:57], [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/07_06_2023/request_availability_sqtech_11_51_53_1686138713_83.json', 'e1p/07_06_2023/response_availability_sqtech_11_51_53_1686138713_83.json', 'e1p/07_06_2023/response_header_availability_sqtech_11_51_53_1686138713_83.json', 'expediapackage', '2023-06-07 11:51:57', '', 'cf7fa38eb12c303974eb3a7f22a4109343d3d07e5aa2374682884b0bc4a692d6', '0');
[06/07/2023 11:51:57], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=cf7fa38eb12c303974eb3a7f22a4109343d3d07e5aa2374682884b0bc4a692d6&xml_user_id=7839&db_caching=1&erequest=0&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F113.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-06-07 11:51:53.491'
            , 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.392'
            , error_description = ''
            , memory_used = '186248744'
            WHERE id = '183';
[06/07/2023 11:51:58], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=cf7fa38eb12c303974eb3a7f22a4109343d3d07e5aa2374682884b0bc4a692d6&xml_user_id=7839&db_caching=1&erequest=0&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F113.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-06-07 11:51:53.491'
            , 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.913'
            , error_description = ''
            , memory_used = '160713616'
            WHERE id = '184';
[06/07/2023 11:51:58], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=cf7fa38eb12c303974eb3a7f22a4109343d3d07e5aa2374682884b0bc4a692d6&xml_user_id=7839&db_caching=1&erequest=1&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F113.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-06-07 11:51:53.491'
            , 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.068'
            , error_description = ''
            , memory_used = '137697816'
            WHERE id = '185';
[06/07/2023 11:51:58], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:51:58' WHERE id= '17';
[06/07/2023 11:51:59], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:51:59' WHERE id= '17';
[06/07/2023 11:52:02], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:52:02' WHERE id= '17';
[06/07/2023 11:52:24], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:52:24' WHERE id= '17';
[06/07/2023 11:52:27], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:52:27' WHERE id= '17';
[06/07/2023 11:52:38], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:52:38' WHERE id= '17';
[06/07/2023 11:52:48], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Grand Central Hotel', 'dubai', '138', '7839', '', '4', '', 'hoteldetails', '2023-06-07 :11:52:48','');
[06/07/2023 11:52:48], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:52:48' WHERE id= '17';
[06/07/2023 11:53:01], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Nihal Hotel', 'dubai', '138', '7839', '', '4', '', 'hoteldetails', '2023-06-07 :11:53:01','');
[06/07/2023 11:53:01], [file name :-/home/otrams/public_html/beta/view_map.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:53:01' WHERE id= '17';
[06/07/2023 11:53:01], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:53:01' WHERE id= '17';
[06/07/2023 11:53:08], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Grand Central Hotel', 'dubai', '138', '7839', '', '4', '', 'hoteldetails', '2023-06-07 :11:53:08','');
[06/07/2023 11:53:08], [file name :-/home/otrams/public_html/beta/view_map.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:53:08' WHERE id= '17';
[06/07/2023 11:53:08], [file name :-/home/otrams/public_html/beta/view_map.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:53:08' WHERE id= '17';
[06/07/2023 11:53:30], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:53:30' WHERE id= '17';
[06/07/2023 11:53:32], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:53:32' WHERE id= '17';
[06/07/2023 11:53:45], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:53:45' WHERE id= '17';
[06/07/2023 11:53:48], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:53:48' WHERE id= '17';
[06/07/2023 11:55:09], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:55:09' WHERE id= '17';
[06/07/2023 11:55:28], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:55:28' WHERE id= '17';
[06/07/2023 11:55:28], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:55:28' WHERE id= '17';
[06/07/2023 11:55:29], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:55:29' WHERE id= '14';
[06/07/2023 11:55:34], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:55:34' WHERE id= '17';
[06/07/2023 11:55:37], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:55:37' WHERE id= '17';
[06/07/2023 11:55:37], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7839' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '4' , ip = '43.239.53.130' , city = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2023/06/22' , departure_date = '2023/06/23' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2023-06-07 11:55:37' , site_id = '' , country_code = '106' , city_code = '64440' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'SAR' , currency_code = 'SAR' , web_service = '' ;
[06/07/2023 11:55:37], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:55:37' WHERE id= '17';
[06/07/2023 11:55:39], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/07_06_2023/request_availability_sqtech_11_55_38_1686138938_58.json', 'e1/07_06_2023/response_availability_sqtech_11_55_38_1686138938_58.json', 'e1/07_06_2023/response_header_availability_sqtech_11_55_38_1686138938_58.json', 'expedia', '2023-06-07 11:55:39', '', 'cf7fa38eb12c303974eb3a7f22a4109343d3d07e5aa2374682884b0bc4a692d6', '0');
[06/07/2023 11:55:39], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=cf7fa38eb12c303974eb3a7f22a4109343d3d07e5aa2374682884b0bc4a692d6&xml_user_id=7839&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F113.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-06-07 11:55:38.365'
            , 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.046'
            , error_description = ''
            , memory_used = '16771584'
            WHERE id = '186';
[06/07/2023 11:55:39], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/07_06_2023/request_availability_sqtech_11_55_38_1686138938_18.json', 'e1/07_06_2023/response_availability_sqtech_11_55_38_1686138938_18.json', 'e1/07_06_2023/response_header_availability_sqtech_11_55_38_1686138938_18.json', 'expedia', '2023-06-07 11:55:39', '', 'cf7fa38eb12c303974eb3a7f22a4109343d3d07e5aa2374682884b0bc4a692d6', '0');
[06/07/2023 11:55:39], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/07_06_2023/request_availability_sqtech_11_55_38_1686138938_19.json', 'e1p/07_06_2023/response_availability_sqtech_11_55_38_1686138938_19.json', 'e1p/07_06_2023/response_header_availability_sqtech_11_55_38_1686138938_19.json', 'expediapackage', '2023-06-07 11:55:39', '', 'cf7fa38eb12c303974eb3a7f22a4109343d3d07e5aa2374682884b0bc4a692d6', '0');
[06/07/2023 11:55:39], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=cf7fa38eb12c303974eb3a7f22a4109343d3d07e5aa2374682884b0bc4a692d6&xml_user_id=7839&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F113.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-06-07 11:55:38.365'
            , 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.424'
            , error_description = ''
            , memory_used = '29577320'
            WHERE id = '187';
[06/07/2023 11:55:39], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/07_06_2023/request_availability_sqtech_11_55_38_1686138938_24.json', 'e1p/07_06_2023/response_availability_sqtech_11_55_38_1686138938_24.json', 'e1p/07_06_2023/response_header_availability_sqtech_11_55_38_1686138938_24.json', 'expediapackage', '2023-06-07 11:55:39', '', 'cf7fa38eb12c303974eb3a7f22a4109343d3d07e5aa2374682884b0bc4a692d6', '0');
[06/07/2023 11:55:39], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=cf7fa38eb12c303974eb3a7f22a4109343d3d07e5aa2374682884b0bc4a692d6&xml_user_id=7839&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F113.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-06-07 11:55:38.365'
            , 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.613'
            , error_description = ''
            , memory_used = '16425600'
            WHERE id = '188';
[06/07/2023 11:55:40], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=cf7fa38eb12c303974eb3a7f22a4109343d3d07e5aa2374682884b0bc4a692d6&xml_user_id=7839&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F113.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-06-07 11:55:38.365'
            , 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.784'
            , error_description = ''
            , memory_used = '29735104'
            WHERE id = '189';
[06/07/2023 11:55:40], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:55:40' WHERE id= '17';
[06/07/2023 11:55:42], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:55:42' WHERE id= '17';
[06/07/2023 11:55:51], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:55:51' WHERE id= '17';
[06/07/2023 11:55:58], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Hotel Atlas Plaza', 'mumbai', '106', '7839', '', '4', '', 'hoteldetails', '2023-06-07 :11:55:58','');
[06/07/2023 11:55:58], [file name :-/home/otrams/public_html/beta/view_map.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:55:58' WHERE id= '17';
[06/07/2023 11:56:20], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:56:20' WHERE id= '17';
[06/07/2023 11:56:38], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Istay Hotels Andheri Midc', 'mumbai', '106', '7839', '', '4', '', 'hoteldetails', '2023-06-07 :11:56:38','');
[06/07/2023 11:56:38], [file name :-/home/otrams/public_html/beta/view_map.php],UPDATE user_sessions_ip SET update_date = '2023-06-07 11:56:38' WHERE id= '17';
