[01/08/2024 07:01:04], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-08 07:01:04',login_attempt=0 where id = '7864';
[01/08/2024 07:01:04], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'being_gajju', user_type = 'A', branch_id = '28', login_datetime = '2024-01-08 07:01:04', ip = '43.239.53.130', action = 'Login' ;
[01/08/2024 07:01:04], [file name :-/home/otrams/public_html/beta/hotel_search.php],insert into user_sessions_ip SET ip_addr='43.239.53.130', agent_id='7864', session_id='4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f',create_date='2024-01-08 07:01:04', update_date='2024-01-08 07:01:04',domain='beta.astrabookings.com',sub_agent_id='',sub_user_id='';
[01/08/2024 07:01:09], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-08 07:01:09' WHERE id= '264';
[01/08/2024 07:01:11], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-08 07:01:11' WHERE id= '264';
[01/08/2024 07:01:15], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-08 07:01:15' WHERE id= '264';
[01/08/2024 07:01:15], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7864' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '28' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/01/24' , departure_date = '2024/01/25' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-01-08 07:01:15' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'INR' , currency_code = 'INR' , web_service = '' ;
[01/08/2024 07:01:16], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-01-08 07:01:16' WHERE id= '264';
[01/08/2024 07:01:16], [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', 'ts/08_01_2024/request_availability_being_gajju_07_01_16_17046972762733730.xml', 'ts/08_01_2024/response_availability_being_gajju_07_01_16_17046972762733730.xml', 'ts/08_01_2024/response_header_availability_being_gajju_07_01_16_17046972762733730.xml', 'totalstay', '2024-01-08 07:01:16', '', '4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f', '0');
[01/08/2024 07:01:16], [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', 'ts/08_01_2024/request_availability_being_gajju_07_01_16_17046972762924271.xml', 'ts/08_01_2024/response_availability_being_gajju_07_01_16_17046972762924271.xml', 'ts/08_01_2024/response_header_availability_being_gajju_07_01_16_17046972762924271.xml', 'totalstay', '2024-01-08 07:01:16', '', '4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f', '0');
[01/08/2024 07:01:16], [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', 'ts/08_01_2024/request_availability_being_gajju_07_01_16_17046972763024310.xml', 'ts/08_01_2024/response_availability_being_gajju_07_01_16_17046972763024310.xml', 'ts/08_01_2024/response_header_availability_being_gajju_07_01_16_17046972763024310.xml', 'totalstay', '2024-01-08 07:01:16', '', '4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f', '0');
[01/08/2024 07:01:16], [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', 'ts/08_01_2024/request_availability_being_gajju_07_01_16_17046972766824280.xml', 'ts/08_01_2024/response_availability_being_gajju_07_01_16_17046972766824280.xml', 'ts/08_01_2024/response_header_availability_being_gajju_07_01_16_17046972766824280.xml', 'totalstay', '2024-01-08 07:01:16', '', '4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f', '0');
[01/08/2024 07:01:16], [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', 'ts/08_01_2024/request_availability_being_gajju_07_01_16_1704697276132360.xml', 'ts/08_01_2024/response_availability_being_gajju_07_01_16_1704697276132360.xml', 'ts/08_01_2024/response_header_availability_being_gajju_07_01_16_1704697276132360.xml', 'totalstay', '2024-01-08 07:01:16', '', '4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f', '0');
[01/08/2024 07:01:16], [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', 'ts/08_01_2024/request_availability_being_gajju_07_01_16_170469727673103840.xml', 'ts/08_01_2024/response_availability_being_gajju_07_01_16_170469727673103840.xml', 'ts/08_01_2024/response_header_availability_being_gajju_07_01_16_170469727673103840.xml', 'totalstay', '2024-01-08 07:01:16', '', '4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f', '0');
[01/08/2024 07:01:16], [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', 'ts/08_01_2024/request_availability_being_gajju_07_01_16_17046972768324311.xml', 'ts/08_01_2024/response_availability_being_gajju_07_01_16_17046972768324311.xml', 'ts/08_01_2024/response_header_availability_being_gajju_07_01_16_17046972768324311.xml', 'totalstay', '2024-01-08 07:01:16', '', '4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f', '0');
[01/08/2024 07:01:16], [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', 'ts/08_01_2024/request_availability_being_gajju_07_01_16_1704697276224301.xml', 'ts/08_01_2024/response_availability_being_gajju_07_01_16_1704697276224301.xml', 'ts/08_01_2024/response_header_availability_being_gajju_07_01_16_1704697276224301.xml', 'totalstay', '2024-01-08 07:01:16', '', '4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f', '0');
[01/08/2024 07:01:16], [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', 'ts/08_01_2024/request_availability_being_gajju_07_01_16_17046972767124300.xml', 'ts/08_01_2024/response_availability_being_gajju_07_01_16_17046972767124300.xml', 'ts/08_01_2024/response_header_availability_being_gajju_07_01_16_17046972767124300.xml', 'totalstay', '2024-01-08 07:01:16', '', '4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f', '0');
[01/08/2024 07:01:16], [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', 'ts/08_01_2024/request_availability_being_gajju_07_01_16_17046972767724270.xml', 'ts/08_01_2024/response_availability_being_gajju_07_01_16_17046972767724270.xml', 'ts/08_01_2024/response_header_availability_being_gajju_07_01_16_17046972767724270.xml', 'totalstay', '2024-01-08 07:01:16', '', '4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f', '0');
[01/08/2024 07:01:16], [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', 'ts/08_01_2024/request_availability_being_gajju_07_01_16_17046972761024281.xml', 'ts/08_01_2024/response_availability_being_gajju_07_01_16_17046972761024281.xml', 'ts/08_01_2024/response_header_availability_being_gajju_07_01_16_17046972761024281.xml', 'totalstay', '2024-01-08 07:01:16', '', '4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f', '0');
[01/08/2024 07:01:16], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=totalstay&sessionid=4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f&xml_user_id=7864&db_caching=1&country_code=UNI&country_name=United+Arab+Emirates&city_code=3373&city_name=Dubai&scurrency_code=2&scurrency_name=USD&erequest=0&total_request=1&hotel_ids=&web_service=no'
            , http_hit_time = '2024-01-08 07:01:16.381'
            , 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.053'
            , error_description = ''
            , memory_used = '1514320'
            WHERE id = '26694';
[01/08/2024 07:01:16], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=totalstay&sessionid=4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f&xml_user_id=7864&db_caching=1&country_code=UNI&country_name=United+Arab+Emirates&city_code=2431&city_name=Dubai&scurrency_code=2&scurrency_name=USD&erequest=0&total_request=2&hotel_ids=&web_service=no'
            , http_hit_time = '2024-01-08 07:01:16.381'
            , 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.054'
            , error_description = ''
            , memory_used = '1504032'
            WHERE id = '26695';
[01/08/2024 07:01:16], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=totalstay&sessionid=4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f&xml_user_id=7864&db_caching=1&country_code=UNI&country_name=United+Arab+Emirates&city_code=10384&city_name=Dubai&scurrency_code=2&scurrency_name=USD&erequest=0&total_request=1&hotel_ids=&web_service=no'
            , http_hit_time = '2024-01-08 07:01:16.381'
            , 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.055'
            , error_description = ''
            , memory_used = '1514296'
            WHERE id = '26699';
[01/08/2024 07:01:16], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=totalstay&sessionid=4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f&xml_user_id=7864&db_caching=1&country_code=UNI&country_name=United+Arab+Emirates&city_code=2428&city_name=Dubai&scurrency_code=2&scurrency_name=USD&erequest=0&total_request=2&hotel_ids=&web_service=no'
            , http_hit_time = '2024-01-08 07:01:16.380'
            , 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.055'
            , error_description = ''
            , memory_used = '1504072'
            WHERE id = '26698';
[01/08/2024 07:01:16], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=totalstay&sessionid=4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f&xml_user_id=7864&db_caching=1&country_code=UNI&country_name=United+Arab+Emirates&city_code=2430&city_name=Dubai&scurrency_code=2&scurrency_name=USD&erequest=0&total_request=2&hotel_ids=&web_service=no'
            , http_hit_time = '2024-01-08 07:01:16.381'
            , 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.055'
            , error_description = ''
            , memory_used = '1514320'
            WHERE id = '26700';
[01/08/2024 07:01:16], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=totalstay&sessionid=4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f&xml_user_id=7864&db_caching=1&country_code=UNI&country_name=United+Arab+Emirates&city_code=2427&city_name=Dubai&scurrency_code=2&scurrency_name=USD&erequest=1&total_request=2&hotel_ids=&web_service=no'
            , http_hit_time = '2024-01-08 07:01:16.380'
            , 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.055'
            , error_description = ''
            , memory_used = '1514320'
            WHERE id = '26693';
[01/08/2024 07:01:16], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=totalstay&sessionid=4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f&xml_user_id=7864&db_caching=1&country_code=UNI&country_name=United+Arab+Emirates&city_code=2430&city_name=Dubai&scurrency_code=2&scurrency_name=USD&erequest=1&total_request=2&hotel_ids=&web_service=no'
            , http_hit_time = '2024-01-08 07:01:16.381'
            , 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.055'
            , error_description = ''
            , memory_used = '1514320'
            WHERE id = '26701';
[01/08/2024 07:01:16], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=totalstay&sessionid=4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f&xml_user_id=7864&db_caching=1&country_code=UNI&country_name=United+Arab+Emirates&city_code=2427&city_name=Dubai&scurrency_code=2&scurrency_name=USD&erequest=0&total_request=2&hotel_ids=&web_service=no'
            , http_hit_time = '2024-01-08 07:01:16.380'
            , 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.055'
            , error_description = ''
            , memory_used = '1514320'
            WHERE id = '26702';
[01/08/2024 07:01:16], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=totalstay&sessionid=4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f&xml_user_id=7864&db_caching=1&country_code=UNI&country_name=United+Arab+Emirates&city_code=3236&city_name=Dubai&scurrency_code=2&scurrency_name=USD&erequest=0&total_request=1&hotel_ids=&web_service=no'
            , http_hit_time = '2024-01-08 07:01:16.381'
            , 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.055'
            , error_description = ''
            , memory_used = '1514320'
            WHERE id = '26697';
[01/08/2024 07:01:16], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=totalstay&sessionid=4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f&xml_user_id=7864&db_caching=1&country_code=UNI&country_name=United+Arab+Emirates&city_code=2431&city_name=Dubai&scurrency_code=2&scurrency_name=USD&erequest=1&total_request=2&hotel_ids=&web_service=no'
            , http_hit_time = '2024-01-08 07:01:16.381'
            , 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.055'
            , error_description = ''
            , memory_used = '1514320'
            WHERE id = '26696';
[01/08/2024 07:01:16], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=totalstay&sessionid=4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f&xml_user_id=7864&db_caching=1&country_code=UNI&country_name=United+Arab+Emirates&city_code=2428&city_name=Dubai&scurrency_code=2&scurrency_name=USD&erequest=1&total_request=2&hotel_ids=&web_service=no'
            , http_hit_time = '2024-01-08 07:01:16.380'
            , 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.057'
            , error_description = ''
            , memory_used = '1514320'
            WHERE id = '26703';
[01/08/2024 07:01:16], [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/08_01_2024/request_availability_being_gajju_07_01_16_1704697276_75.json', 'e1/08_01_2024/response_availability_being_gajju_07_01_16_1704697276_75.json', 'e1/08_01_2024/response_header_availability_being_gajju_07_01_16_1704697276_75.json', 'expedia', '2024-01-08 07:01:16', '', '4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f', '0');
[01/08/2024 07:01:16], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f&xml_user_id=7864&db_caching=1&erequest=2&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F120.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-08 07:01:16.381'
            , 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.214'
            , error_description = ''
            , memory_used = '2194152'
            WHERE id = '26704';
[01/08/2024 07:01:16], [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/08_01_2024/request_availability_being_gajju_07_01_16_1704697276_40.json', 'e1p/08_01_2024/response_availability_being_gajju_07_01_16_1704697276_40.json', 'e1p/08_01_2024/response_header_availability_being_gajju_07_01_16_1704697276_40.json', 'expediapackage', '2024-01-08 07:01:16', '', '4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f', '0');
[01/08/2024 07:01:16], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f&xml_user_id=7864&db_caching=1&erequest=2&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F120.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-08 07:01:16.380'
            , 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.344'
            , error_description = ''
            , memory_used = '2195104'
            WHERE id = '26705';
[01/08/2024 07:01:18], [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/08_01_2024/request_availability_being_gajju_07_01_16_1704697276_44.json', 'e1/08_01_2024/response_availability_being_gajju_07_01_16_1704697276_44.json', 'e1/08_01_2024/response_header_availability_being_gajju_07_01_16_1704697276_44.json', 'expedia', '2024-01-08 07:01:18', '', '4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f', '0');
[01/08/2024 07:01:18], [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/08_01_2024/request_availability_being_gajju_07_01_16_1704697276_91.json', 'e1/08_01_2024/response_availability_being_gajju_07_01_16_1704697276_91.json', 'e1/08_01_2024/response_header_availability_being_gajju_07_01_16_1704697276_91.json', 'expedia', '2024-01-08 07:01:18', '', '4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f', '0');
[01/08/2024 07:01:18], [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/08_01_2024/request_availability_being_gajju_07_01_16_1704697276_22.json', 'e1p/08_01_2024/response_availability_being_gajju_07_01_16_1704697276_22.json', 'e1p/08_01_2024/response_header_availability_being_gajju_07_01_16_1704697276_22.json', 'expediapackage', '2024-01-08 07:01:18', '', '4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f', '0');
[01/08/2024 07:01:18], [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/08_01_2024/request_availability_being_gajju_07_01_16_1704697276_50.json', 'e1p/08_01_2024/response_availability_being_gajju_07_01_16_1704697276_50.json', 'e1p/08_01_2024/response_header_availability_being_gajju_07_01_16_1704697276_50.json', 'expediapackage', '2024-01-08 07:01:18', '', '4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f', '0');
[01/08/2024 07:01:19], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f&xml_user_id=7864&db_caching=1&erequest=1&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F120.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-08 07:01:16.381'
            , 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.088'
            , error_description = ''
            , memory_used = '170781376'
            WHERE id = '26706';
[01/08/2024 07:01:19], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f&xml_user_id=7864&db_caching=1&erequest=0&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F120.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-08 07:01:16.381'
            , 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.481'
            , error_description = ''
            , memory_used = '195817440'
            WHERE id = '26707';
[01/08/2024 07:01:20], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f&xml_user_id=7864&db_caching=1&erequest=1&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F120.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-08 07:01:16.381'
            , 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.719'
            , error_description = ''
            , memory_used = '176153064'
            WHERE id = '26708';
[01/08/2024 07:01:20], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f&xml_user_id=7864&db_caching=1&erequest=0&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F120.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-08 07:01:16.381'
            , 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.045'
            , error_description = ''
            , memory_used = '206321064'
            WHERE id = '26709';
[01/08/2024 07:01:20], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-08 07:01:20' WHERE id= '264';
[01/08/2024 07:01:21], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-01-08 07:01:21' WHERE id= '264';
[01/08/2024 07:01:22], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-01-08 07:01:22' WHERE id= '264';
[01/08/2024 07:03:57], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-08 07:03:57' WHERE id= '264';
[01/08/2024 07:03:57], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7864' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '28' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/01/24' , departure_date = '2024/01/25' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-01-08 07:03:57' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'INR' , currency_code = 'INR' , web_service = '' ;
[01/08/2024 07:03:57], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-01-08 07:03:57' WHERE id= '264';
[01/08/2024 07:03: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', 'ts/08_01_2024/request_availability_being_gajju_07_03_57_17046974377124281.xml', 'ts/08_01_2024/response_availability_being_gajju_07_03_57_17046974377124281.xml', 'ts/08_01_2024/response_header_availability_being_gajju_07_03_57_17046974377124281.xml', 'totalstay', '2024-01-08 07:03:57', '', '4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f', '0');
[01/08/2024 07:03: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', 'ts/08_01_2024/request_availability_being_gajju_07_03_57_17046974375933730.xml', 'ts/08_01_2024/response_availability_being_gajju_07_03_57_17046974375933730.xml', 'ts/08_01_2024/response_header_availability_being_gajju_07_03_57_17046974375933730.xml', 'totalstay', '2024-01-08 07:03:57', '', '4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f', '0');
[01/08/2024 07:03: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', 'ts/08_01_2024/request_availability_being_gajju_07_03_57_17046974371624270.xml', 'ts/08_01_2024/response_availability_being_gajju_07_03_57_17046974371624270.xml', 'ts/08_01_2024/response_header_availability_being_gajju_07_03_57_17046974371624270.xml', 'totalstay', '2024-01-08 07:03:57', '', '4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f', '0');
[01/08/2024 07:03: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', 'ts/08_01_2024/request_availability_being_gajju_07_03_57_170469743736103840.xml', 'ts/08_01_2024/response_availability_being_gajju_07_03_57_170469743736103840.xml', 'ts/08_01_2024/response_header_availability_being_gajju_07_03_57_170469743736103840.xml', 'totalstay', '2024-01-08 07:03:57', '', '4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f', '0');
[01/08/2024 07:03: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', 'ts/08_01_2024/request_availability_being_gajju_07_03_57_17046974372424271.xml', 'ts/08_01_2024/response_availability_being_gajju_07_03_57_17046974372424271.xml', 'ts/08_01_2024/response_header_availability_being_gajju_07_03_57_17046974372424271.xml', 'totalstay', '2024-01-08 07:03:57', '', '4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f', '0');
[01/08/2024 07:03: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', 'ts/08_01_2024/request_availability_being_gajju_07_03_57_17046974379132360.xml', 'ts/08_01_2024/response_availability_being_gajju_07_03_57_17046974379132360.xml', 'ts/08_01_2024/response_header_availability_being_gajju_07_03_57_17046974379132360.xml', 'totalstay', '2024-01-08 07:03:57', '', '4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f', '0');
[01/08/2024 07:03: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', 'ts/08_01_2024/request_availability_being_gajju_07_03_57_17046974373224311.xml', 'ts/08_01_2024/response_availability_being_gajju_07_03_57_17046974373224311.xml', 'ts/08_01_2024/response_header_availability_being_gajju_07_03_57_17046974373224311.xml', 'totalstay', '2024-01-08 07:03:57', '', '4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f', '0');
[01/08/2024 07:03: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', 'ts/08_01_2024/request_availability_being_gajju_07_03_57_17046974372124300.xml', 'ts/08_01_2024/response_availability_being_gajju_07_03_57_17046974372124300.xml', 'ts/08_01_2024/response_header_availability_being_gajju_07_03_57_17046974372124300.xml', 'totalstay', '2024-01-08 07:03:57', '', '4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f', '0');
[01/08/2024 07:03: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', 'ts/08_01_2024/request_availability_being_gajju_07_03_57_17046974373824280.xml', 'ts/08_01_2024/response_availability_being_gajju_07_03_57_17046974373824280.xml', 'ts/08_01_2024/response_header_availability_being_gajju_07_03_57_17046974373824280.xml', 'totalstay', '2024-01-08 07:03:57', '', '4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f', '0');
[01/08/2024 07:03: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', 'ts/08_01_2024/request_availability_being_gajju_07_03_57_1704697437424310.xml', 'ts/08_01_2024/response_availability_being_gajju_07_03_57_1704697437424310.xml', 'ts/08_01_2024/response_header_availability_being_gajju_07_03_57_1704697437424310.xml', 'totalstay', '2024-01-08 07:03:57', '', '4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f', '0');
[01/08/2024 07:03: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', 'ts/08_01_2024/request_availability_being_gajju_07_03_57_17046974373424301.xml', 'ts/08_01_2024/response_availability_being_gajju_07_03_57_17046974373424301.xml', 'ts/08_01_2024/response_header_availability_being_gajju_07_03_57_17046974373424301.xml', 'totalstay', '2024-01-08 07:03:57', '', '4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f', '0');
[01/08/2024 07:03:57], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=totalstay&sessionid=4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f&xml_user_id=7864&db_caching=1&country_code=UNI&country_name=United+Arab+Emirates&city_code=2428&city_name=Dubai&scurrency_code=2&scurrency_name=USD&erequest=1&total_request=2&hotel_ids=&web_service=no'
            , http_hit_time = '2024-01-08 07:03:57.750'
            , 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.020'
            , error_description = ''
            , memory_used = '1504072'
            WHERE id = '26710';
[01/08/2024 07:03:57], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=totalstay&sessionid=4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f&xml_user_id=7864&db_caching=1&country_code=UNI&country_name=United+Arab+Emirates&city_code=3373&city_name=Dubai&scurrency_code=2&scurrency_name=USD&erequest=0&total_request=1&hotel_ids=&web_service=no'
            , http_hit_time = '2024-01-08 07:03:57.751'
            , 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.022'
            , error_description = ''
            , memory_used = '1514320'
            WHERE id = '26711';
[01/08/2024 07:03:57], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=totalstay&sessionid=4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f&xml_user_id=7864&db_caching=1&country_code=UNI&country_name=United+Arab+Emirates&city_code=2427&city_name=Dubai&scurrency_code=2&scurrency_name=USD&erequest=0&total_request=2&hotel_ids=&web_service=no'
            , http_hit_time = '2024-01-08 07:03:57.750'
            , 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.022'
            , error_description = ''
            , memory_used = '1514320'
            WHERE id = '26712';
[01/08/2024 07:03:57], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=totalstay&sessionid=4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f&xml_user_id=7864&db_caching=1&country_code=UNI&country_name=United+Arab+Emirates&city_code=10384&city_name=Dubai&scurrency_code=2&scurrency_name=USD&erequest=0&total_request=1&hotel_ids=&web_service=no'
            , http_hit_time = '2024-01-08 07:03:57.750'
            , 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.022'
            , error_description = ''
            , memory_used = '1504128'
            WHERE id = '26713';
[01/08/2024 07:03:57], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=totalstay&sessionid=4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f&xml_user_id=7864&db_caching=1&country_code=UNI&country_name=United+Arab+Emirates&city_code=2431&city_name=Dubai&scurrency_code=2&scurrency_name=USD&erequest=1&total_request=2&hotel_ids=&web_service=no'
            , http_hit_time = '2024-01-08 07:03:57.751'
            , 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.023'
            , error_description = ''
            , memory_used = '1504072'
            WHERE id = '26715';
[01/08/2024 07:03:57], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=totalstay&sessionid=4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f&xml_user_id=7864&db_caching=1&country_code=UNI&country_name=United+Arab+Emirates&city_code=3236&city_name=Dubai&scurrency_code=2&scurrency_name=USD&erequest=0&total_request=1&hotel_ids=&web_service=no'
            , http_hit_time = '2024-01-08 07:03:57.750'
            , 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.023'
            , error_description = ''
            , memory_used = '1514352'
            WHERE id = '26716';
[01/08/2024 07:03:57], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=totalstay&sessionid=4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f&xml_user_id=7864&db_caching=1&country_code=UNI&country_name=United+Arab+Emirates&city_code=2427&city_name=Dubai&scurrency_code=2&scurrency_name=USD&erequest=1&total_request=2&hotel_ids=&web_service=no'
            , http_hit_time = '2024-01-08 07:03:57.750'
            , 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.024'
            , error_description = ''
            , memory_used = '1504072'
            WHERE id = '26714';
[01/08/2024 07:03:57], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=totalstay&sessionid=4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f&xml_user_id=7864&db_caching=1&country_code=UNI&country_name=United+Arab+Emirates&city_code=2431&city_name=Dubai&scurrency_code=2&scurrency_name=USD&erequest=0&total_request=2&hotel_ids=&web_service=no'
            , http_hit_time = '2024-01-08 07:03:57.751'
            , 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.023'
            , error_description = ''
            , memory_used = '1514320'
            WHERE id = '26719';
[01/08/2024 07:03:57], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=totalstay&sessionid=4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f&xml_user_id=7864&db_caching=1&country_code=UNI&country_name=United+Arab+Emirates&city_code=2430&city_name=Dubai&scurrency_code=2&scurrency_name=USD&erequest=0&total_request=2&hotel_ids=&web_service=no'
            , http_hit_time = '2024-01-08 07:03:57.751'
            , 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.023'
            , error_description = ''
            , memory_used = '1514320'
            WHERE id = '26717';
[01/08/2024 07:03:57], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=totalstay&sessionid=4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f&xml_user_id=7864&db_caching=1&country_code=UNI&country_name=United+Arab+Emirates&city_code=2428&city_name=Dubai&scurrency_code=2&scurrency_name=USD&erequest=0&total_request=2&hotel_ids=&web_service=no'
            , http_hit_time = '2024-01-08 07:03:57.750'
            , 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.024'
            , error_description = ''
            , memory_used = '1514320'
            WHERE id = '26718';
[01/08/2024 07:03:57], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=totalstay&sessionid=4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f&xml_user_id=7864&db_caching=1&country_code=UNI&country_name=United+Arab+Emirates&city_code=2430&city_name=Dubai&scurrency_code=2&scurrency_name=USD&erequest=1&total_request=2&hotel_ids=&web_service=no'
            , http_hit_time = '2024-01-08 07:03:57.751'
            , 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.025'
            , error_description = ''
            , memory_used = '1504072'
            WHERE id = '26720';
[01/08/2024 07:03:58], [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/08_01_2024/request_availability_being_gajju_07_03_57_1704697437_67.json', 'e1p/08_01_2024/response_availability_being_gajju_07_03_57_1704697437_67.json', 'e1p/08_01_2024/response_header_availability_being_gajju_07_03_57_1704697437_67.json', 'expediapackage', '2024-01-08 07:03:58', '', '4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f', '0');
[01/08/2024 07:03:58], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f&xml_user_id=7864&db_caching=1&erequest=2&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F120.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-08 07:03:57.751'
            , 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.570'
            , error_description = ''
            , memory_used = '2195104'
            WHERE id = '26721';
[01/08/2024 07:03:58], [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/08_01_2024/request_availability_being_gajju_07_03_57_1704697437_13.json', 'e1/08_01_2024/response_availability_being_gajju_07_03_57_1704697437_13.json', 'e1/08_01_2024/response_header_availability_being_gajju_07_03_57_1704697437_13.json', 'expedia', '2024-01-08 07:03:58', '', '4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f', '0');
[01/08/2024 07:03:58], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f&xml_user_id=7864&db_caching=1&erequest=2&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F120.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-08 07:03:57.751'
            , 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.613'
            , error_description = ''
            , memory_used = '2194064'
            WHERE id = '26722';
[01/08/2024 07:03:59], [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/08_01_2024/request_availability_being_gajju_07_03_57_1704697437_73.json', 'e1/08_01_2024/response_availability_being_gajju_07_03_57_1704697437_73.json', 'e1/08_01_2024/response_header_availability_being_gajju_07_03_57_1704697437_73.json', 'expedia', '2024-01-08 07:03:59', '', '4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f', '0');
[01/08/2024 07:04:00], [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/08_01_2024/request_availability_being_gajju_07_03_57_1704697437_28.json', 'e1p/08_01_2024/response_availability_being_gajju_07_03_57_1704697437_28.json', 'e1p/08_01_2024/response_header_availability_being_gajju_07_03_57_1704697437_28.json', 'expediapackage', '2024-01-08 07:04:00', '', '4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f', '0');
[01/08/2024 07:04:00], [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/08_01_2024/request_availability_being_gajju_07_03_57_1704697437_11.json', 'e1/08_01_2024/response_availability_being_gajju_07_03_57_1704697437_11.json', 'e1/08_01_2024/response_header_availability_being_gajju_07_03_57_1704697437_11.json', 'expedia', '2024-01-08 07:04:00', '', '4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f', '0');
[01/08/2024 07:04:01], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f&xml_user_id=7864&db_caching=1&erequest=0&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F120.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-08 07:03:57.751'
            , 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.374'
            , error_description = ''
            , memory_used = '195856264'
            WHERE id = '26723';
[01/08/2024 07:04:01], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f&xml_user_id=7864&db_caching=1&erequest=1&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F120.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-08 07:03:57.751'
            , 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.818'
            , error_description = ''
            , memory_used = '175800496'
            WHERE id = '26724';
[01/08/2024 07:04:01], [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/08_01_2024/request_availability_being_gajju_07_03_57_1704697437_3.json', 'e1p/08_01_2024/response_availability_being_gajju_07_03_57_1704697437_3.json', 'e1p/08_01_2024/response_header_availability_being_gajju_07_03_57_1704697437_3.json', 'expediapackage', '2024-01-08 07:04:01', '', '4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f', '0');
[01/08/2024 07:04:01], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f&xml_user_id=7864&db_caching=1&erequest=1&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F120.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-08 07:03:57.751'
            , 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.110'
            , error_description = ''
            , memory_used = '170794160'
            WHERE id = '26725';
[01/08/2024 07:04:03], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f&xml_user_id=7864&db_caching=1&erequest=0&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F120.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-08 07:03:57.751'
            , 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.353'
            , error_description = ''
            , memory_used = '206135480'
            WHERE id = '26726';
[01/08/2024 07:04:03], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-01-08 07:04:03' WHERE id= '264';
[01/08/2024 07:04:03], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-08 07:04:03' WHERE id= '264';
[01/08/2024 07:04:03], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-08 07:04:03' WHERE id= '264';
[01/08/2024 07:04:07], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-01-08 07:04:07' WHERE id= '264';
[01/08/2024 07:04:13], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-08 07:04:13' WHERE id= '264';
[01/08/2024 07:04:13], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7864' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '28' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/01/24' , departure_date = '2024/01/25' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-01-08 07:04:13' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'INR' , currency_code = 'INR' , web_service = '' ;
[01/08/2024 07:04:14], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-01-08 07:04:14' WHERE id= '264';
[01/08/2024 07:04: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', 'ts/08_01_2024/request_availability_being_gajju_07_04_14_17046974541432360.xml', 'ts/08_01_2024/response_availability_being_gajju_07_04_14_17046974541432360.xml', 'ts/08_01_2024/response_header_availability_being_gajju_07_04_14_17046974541432360.xml', 'totalstay', '2024-01-08 07:04:14', '', '4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f', '0');
[01/08/2024 07:04: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', 'ts/08_01_2024/request_availability_being_gajju_07_04_14_1704697454424300.xml', 'ts/08_01_2024/response_availability_being_gajju_07_04_14_1704697454424300.xml', 'ts/08_01_2024/response_header_availability_being_gajju_07_04_14_1704697454424300.xml', 'totalstay', '2024-01-08 07:04:14', '', '4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f', '0');
[01/08/2024 07:04: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', 'ts/08_01_2024/request_availability_being_gajju_07_04_14_17046974543224270.xml', 'ts/08_01_2024/response_availability_being_gajju_07_04_14_17046974543224270.xml', 'ts/08_01_2024/response_header_availability_being_gajju_07_04_14_17046974543224270.xml', 'totalstay', '2024-01-08 07:04:14', '', '4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f', '0');
[01/08/2024 07:04: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', 'ts/08_01_2024/request_availability_being_gajju_07_04_14_17046974541524280.xml', 'ts/08_01_2024/response_availability_being_gajju_07_04_14_17046974541524280.xml', 'ts/08_01_2024/response_header_availability_being_gajju_07_04_14_17046974541524280.xml', 'totalstay', '2024-01-08 07:04:14', '', '4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f', '0');
[01/08/2024 07:04: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', 'ts/08_01_2024/request_availability_being_gajju_07_04_14_17046974544724281.xml', 'ts/08_01_2024/response_availability_being_gajju_07_04_14_17046974544724281.xml', 'ts/08_01_2024/response_header_availability_being_gajju_07_04_14_17046974544724281.xml', 'totalstay', '2024-01-08 07:04:14', '', '4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f', '0');
[01/08/2024 07:04: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', 'ts/08_01_2024/request_availability_being_gajju_07_04_14_17046974542124310.xml', 'ts/08_01_2024/response_availability_being_gajju_07_04_14_17046974542124310.xml', 'ts/08_01_2024/response_header_availability_being_gajju_07_04_14_17046974542124310.xml', 'totalstay', '2024-01-08 07:04:14', '', '4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f', '0');
[01/08/2024 07:04: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', 'ts/08_01_2024/request_availability_being_gajju_07_04_14_17046974547624301.xml', 'ts/08_01_2024/response_availability_being_gajju_07_04_14_17046974547624301.xml', 'ts/08_01_2024/response_header_availability_being_gajju_07_04_14_17046974547624301.xml', 'totalstay', '2024-01-08 07:04:14', '', '4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f', '0');
[01/08/2024 07:04: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', 'ts/08_01_2024/request_availability_being_gajju_07_04_14_17046974541724271.xml', 'ts/08_01_2024/response_availability_being_gajju_07_04_14_17046974541724271.xml', 'ts/08_01_2024/response_header_availability_being_gajju_07_04_14_17046974541724271.xml', 'totalstay', '2024-01-08 07:04:14', '', '4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f', '0');
[01/08/2024 07:04: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', 'ts/08_01_2024/request_availability_being_gajju_07_04_14_17046974541124311.xml', 'ts/08_01_2024/response_availability_being_gajju_07_04_14_17046974541124311.xml', 'ts/08_01_2024/response_header_availability_being_gajju_07_04_14_17046974541124311.xml', 'totalstay', '2024-01-08 07:04:14', '', '4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f', '0');
[01/08/2024 07:04: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', 'ts/08_01_2024/request_availability_being_gajju_07_04_14_170469745461103840.xml', 'ts/08_01_2024/response_availability_being_gajju_07_04_14_170469745461103840.xml', 'ts/08_01_2024/response_header_availability_being_gajju_07_04_14_170469745461103840.xml', 'totalstay', '2024-01-08 07:04:14', '', '4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f', '0');
[01/08/2024 07:04: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', 'ts/08_01_2024/request_availability_being_gajju_07_04_14_17046974545333730.xml', 'ts/08_01_2024/response_availability_being_gajju_07_04_14_17046974545333730.xml', 'ts/08_01_2024/response_header_availability_being_gajju_07_04_14_17046974545333730.xml', 'totalstay', '2024-01-08 07:04:14', '', '4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f', '0');
[01/08/2024 07:04:14], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=totalstay&sessionid=4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f&xml_user_id=7864&db_caching=1&country_code=UNI&country_name=United+Arab+Emirates&city_code=3236&city_name=Dubai&scurrency_code=2&scurrency_name=USD&erequest=0&total_request=1&hotel_ids=&web_service=no'
            , http_hit_time = '2024-01-08 07:04:14.621'
            , 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.024'
            , error_description = ''
            , memory_used = '1504072'
            WHERE id = '26727';
[01/08/2024 07:04:14], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=totalstay&sessionid=4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f&xml_user_id=7864&db_caching=1&country_code=UNI&country_name=United+Arab+Emirates&city_code=2430&city_name=Dubai&scurrency_code=2&scurrency_name=USD&erequest=0&total_request=2&hotel_ids=&web_service=no'
            , http_hit_time = '2024-01-08 07:04:14.621'
            , 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.025'
            , error_description = ''
            , memory_used = '1504072'
            WHERE id = '26728';
[01/08/2024 07:04:14], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=totalstay&sessionid=4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f&xml_user_id=7864&db_caching=1&country_code=UNI&country_name=United+Arab+Emirates&city_code=2428&city_name=Dubai&scurrency_code=2&scurrency_name=USD&erequest=0&total_request=2&hotel_ids=&web_service=no'
            , http_hit_time = '2024-01-08 07:04:14.621'
            , 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.025'
            , error_description = ''
            , memory_used = '1504072'
            WHERE id = '26730';
[01/08/2024 07:04:14], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=totalstay&sessionid=4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f&xml_user_id=7864&db_caching=1&country_code=UNI&country_name=United+Arab+Emirates&city_code=2427&city_name=Dubai&scurrency_code=2&scurrency_name=USD&erequest=0&total_request=2&hotel_ids=&web_service=no'
            , http_hit_time = '2024-01-08 07:04:14.620'
            , 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.026'
            , error_description = ''
            , memory_used = '1504032'
            WHERE id = '26729';
[01/08/2024 07:04:14], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=totalstay&sessionid=4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f&xml_user_id=7864&db_caching=1&country_code=UNI&country_name=United+Arab+Emirates&city_code=2431&city_name=Dubai&scurrency_code=2&scurrency_name=USD&erequest=0&total_request=2&hotel_ids=&web_service=no'
            , http_hit_time = '2024-01-08 07:04:14.621'
            , 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.025'
            , error_description = ''
            , memory_used = '1504224'
            WHERE id = '26732';
[01/08/2024 07:04:14], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=totalstay&sessionid=4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f&xml_user_id=7864&db_caching=1&country_code=UNI&country_name=United+Arab+Emirates&city_code=3373&city_name=Dubai&scurrency_code=2&scurrency_name=USD&erequest=0&total_request=1&hotel_ids=&web_service=no'
            , http_hit_time = '2024-01-08 07:04:14.621'
            , 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.025'
            , error_description = ''
            , memory_used = '1504072'
            WHERE id = '26736';
[01/08/2024 07:04:14], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=totalstay&sessionid=4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f&xml_user_id=7864&db_caching=1&country_code=UNI&country_name=United+Arab+Emirates&city_code=2427&city_name=Dubai&scurrency_code=2&scurrency_name=USD&erequest=1&total_request=2&hotel_ids=&web_service=no'
            , http_hit_time = '2024-01-08 07:04:14.620'
            , 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.026'
            , error_description = ''
            , memory_used = '1514320'
            WHERE id = '26734';
[01/08/2024 07:04:14], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=totalstay&sessionid=4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f&xml_user_id=7864&db_caching=1&country_code=UNI&country_name=United+Arab+Emirates&city_code=2428&city_name=Dubai&scurrency_code=2&scurrency_name=USD&erequest=1&total_request=2&hotel_ids=&web_service=no'
            , http_hit_time = '2024-01-08 07:04:14.621'
            , 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.025'
            , error_description = ''
            , memory_used = '1514320'
            WHERE id = '26731';
[01/08/2024 07:04:14], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=totalstay&sessionid=4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f&xml_user_id=7864&db_caching=1&country_code=UNI&country_name=United+Arab+Emirates&city_code=2431&city_name=Dubai&scurrency_code=2&scurrency_name=USD&erequest=1&total_request=2&hotel_ids=&web_service=no'
            , http_hit_time = '2024-01-08 07:04:14.621'
            , 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.025'
            , error_description = ''
            , memory_used = '1504072'
            WHERE id = '26735';
[01/08/2024 07:04:14], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=totalstay&sessionid=4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f&xml_user_id=7864&db_caching=1&country_code=UNI&country_name=United+Arab+Emirates&city_code=2430&city_name=Dubai&scurrency_code=2&scurrency_name=USD&erequest=1&total_request=2&hotel_ids=&web_service=no'
            , http_hit_time = '2024-01-08 07:04:14.621'
            , 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.025'
            , error_description = ''
            , memory_used = '1514320'
            WHERE id = '26733';
[01/08/2024 07:04:14], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=totalstay&sessionid=4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f&xml_user_id=7864&db_caching=1&country_code=UNI&country_name=United+Arab+Emirates&city_code=10384&city_name=Dubai&scurrency_code=2&scurrency_name=USD&erequest=0&total_request=1&hotel_ids=&web_service=no'
            , http_hit_time = '2024-01-08 07:04:14.621'
            , 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.026'
            , error_description = ''
            , memory_used = '1514328'
            WHERE id = '26737';
[01/08/2024 07:04: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/08_01_2024/request_availability_being_gajju_07_04_14_1704697454_49.json', 'e1/08_01_2024/response_availability_being_gajju_07_04_14_1704697454_49.json', 'e1/08_01_2024/response_header_availability_being_gajju_07_04_14_1704697454_49.json', 'expedia', '2024-01-08 07:04:14', '', '4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f', '0');
[01/08/2024 07:04:14], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f&xml_user_id=7864&db_caching=1&erequest=2&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F120.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-08 07:04:14.622'
            , 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.165'
            , error_description = ''
            , memory_used = '2194064'
            WHERE id = '26738';
[01/08/2024 07:04: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/08_01_2024/request_availability_being_gajju_07_04_14_1704697454_93.json', 'e1p/08_01_2024/response_availability_being_gajju_07_04_14_1704697454_93.json', 'e1p/08_01_2024/response_header_availability_being_gajju_07_04_14_1704697454_93.json', 'expediapackage', '2024-01-08 07:04:14', '', '4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f', '0');
[01/08/2024 07:04:14], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f&xml_user_id=7864&db_caching=1&erequest=2&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F120.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-08 07:04:14.621'
            , 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.232'
            , error_description = ''
            , memory_used = '2194872'
            WHERE id = '26739';
[01/08/2024 07:04:16], [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/08_01_2024/request_availability_being_gajju_07_04_14_1704697454_55.json', 'e1/08_01_2024/response_availability_being_gajju_07_04_14_1704697454_55.json', 'e1/08_01_2024/response_header_availability_being_gajju_07_04_14_1704697454_55.json', 'expedia', '2024-01-08 07:04:16', '', '4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f', '0');
[01/08/2024 07:04:16], [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/08_01_2024/request_availability_being_gajju_07_04_14_1704697454_56.json', 'e1/08_01_2024/response_availability_being_gajju_07_04_14_1704697454_56.json', 'e1/08_01_2024/response_header_availability_being_gajju_07_04_14_1704697454_56.json', 'expedia', '2024-01-08 07:04:16', '', '4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f', '0');
[01/08/2024 07:04:17], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f&xml_user_id=7864&db_caching=1&erequest=0&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F120.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-08 07:04:14.621'
            , 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.229'
            , error_description = ''
            , memory_used = '195861656'
            WHERE id = '26740';
[01/08/2024 07:04:18], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f&xml_user_id=7864&db_caching=1&erequest=1&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F120.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-08 07:04:14.621'
            , 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.469'
            , error_description = ''
            , memory_used = '170902016'
            WHERE id = '26741';
[01/08/2024 07:04:18], [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/08_01_2024/request_availability_being_gajju_07_04_14_1704697454_74.json', 'e1p/08_01_2024/response_availability_being_gajju_07_04_14_1704697454_74.json', 'e1p/08_01_2024/response_header_availability_being_gajju_07_04_14_1704697454_74.json', 'expediapackage', '2024-01-08 07:04:18', '', '4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f', '0');
[01/08/2024 07:04:18], [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/08_01_2024/request_availability_being_gajju_07_04_14_1704697454_86.json', 'e1p/08_01_2024/response_availability_being_gajju_07_04_14_1704697454_86.json', 'e1p/08_01_2024/response_header_availability_being_gajju_07_04_14_1704697454_86.json', 'expediapackage', '2024-01-08 07:04:18', '', '4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f', '0');
[01/08/2024 07:04:19], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f&xml_user_id=7864&db_caching=1&erequest=0&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F120.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-08 07:04:14.621'
            , 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.993'
            , error_description = ''
            , memory_used = '206330208'
            WHERE id = '26742';
[01/08/2024 07:04:19], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f&xml_user_id=7864&db_caching=1&erequest=1&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F120.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-08 07:04:14.621'
            , 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.192'
            , error_description = ''
            , memory_used = '175975144'
            WHERE id = '26743';
[01/08/2024 07:04:19], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-01-08 07:04:19' WHERE id= '264';
[01/08/2024 07:04:20], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-08 07:04:20' WHERE id= '264';
[01/08/2024 07:04:20], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-08 07:04:20' WHERE id= '264';
[01/08/2024 07:04:22], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-01-08 07:04:22' WHERE id= '264';
[01/08/2024 07:04:28], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-08 07:04:28' WHERE id= '264';
[01/08/2024 07:04:28], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7864' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '28' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/01/24' , departure_date = '2024/01/25' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-01-08 07:04:28' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'INR' , currency_code = 'INR' , web_service = '' ;
[01/08/2024 07:04:28], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-01-08 07:04:28' WHERE id= '264';
[01/08/2024 07:04:28], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'ts/08_01_2024/request_availability_being_gajju_07_04_28_17046974683333730.xml', 'ts/08_01_2024/response_availability_being_gajju_07_04_28_17046974683333730.xml', 'ts/08_01_2024/response_header_availability_being_gajju_07_04_28_17046974683333730.xml', 'totalstay', '2024-01-08 07:04:28', '', '4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f', '0');
[01/08/2024 07:04:28], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'ts/08_01_2024/request_availability_being_gajju_07_04_28_17046974689924270.xml', 'ts/08_01_2024/response_availability_being_gajju_07_04_28_17046974689924270.xml', 'ts/08_01_2024/response_header_availability_being_gajju_07_04_28_17046974689924270.xml', 'totalstay', '2024-01-08 07:04:28', '', '4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f', '0');
[01/08/2024 07:04:28], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'ts/08_01_2024/request_availability_being_gajju_07_04_28_17046974685724280.xml', 'ts/08_01_2024/response_availability_being_gajju_07_04_28_17046974685724280.xml', 'ts/08_01_2024/response_header_availability_being_gajju_07_04_28_17046974685724280.xml', 'totalstay', '2024-01-08 07:04:28', '', '4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f', '0');
[01/08/2024 07:04:28], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'ts/08_01_2024/request_availability_being_gajju_07_04_28_17046974687024311.xml', 'ts/08_01_2024/response_availability_being_gajju_07_04_28_17046974687024311.xml', 'ts/08_01_2024/response_header_availability_being_gajju_07_04_28_17046974687024311.xml', 'totalstay', '2024-01-08 07:04:28', '', '4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f', '0');
[01/08/2024 07:04:28], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'ts/08_01_2024/request_availability_being_gajju_07_04_28_17046974684924310.xml', 'ts/08_01_2024/response_availability_being_gajju_07_04_28_17046974684924310.xml', 'ts/08_01_2024/response_header_availability_being_gajju_07_04_28_17046974684924310.xml', 'totalstay', '2024-01-08 07:04:28', '', '4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f', '0');
[01/08/2024 07:04:28], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'ts/08_01_2024/request_availability_being_gajju_07_04_28_17046974683732360.xml', 'ts/08_01_2024/response_availability_being_gajju_07_04_28_17046974683732360.xml', 'ts/08_01_2024/response_header_availability_being_gajju_07_04_28_17046974683732360.xml', 'totalstay', '2024-01-08 07:04:28', '', '4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f', '0');
[01/08/2024 07:04:28], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'ts/08_01_2024/request_availability_being_gajju_07_04_28_17046974683524301.xml', 'ts/08_01_2024/response_availability_being_gajju_07_04_28_17046974683524301.xml', 'ts/08_01_2024/response_header_availability_being_gajju_07_04_28_17046974683524301.xml', 'totalstay', '2024-01-08 07:04:28', '', '4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f', '0');
[01/08/2024 07:04:28], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'ts/08_01_2024/request_availability_being_gajju_07_04_28_170469746887103840.xml', 'ts/08_01_2024/response_availability_being_gajju_07_04_28_170469746887103840.xml', 'ts/08_01_2024/response_header_availability_being_gajju_07_04_28_170469746887103840.xml', 'totalstay', '2024-01-08 07:04:28', '', '4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f', '0');
[01/08/2024 07:04:28], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'ts/08_01_2024/request_availability_being_gajju_07_04_28_1704697468324281.xml', 'ts/08_01_2024/response_availability_being_gajju_07_04_28_1704697468324281.xml', 'ts/08_01_2024/response_header_availability_being_gajju_07_04_28_1704697468324281.xml', 'totalstay', '2024-01-08 07:04:28', '', '4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f', '0');
[01/08/2024 07:04:28], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'ts/08_01_2024/request_availability_being_gajju_07_04_28_17046974687824300.xml', 'ts/08_01_2024/response_availability_being_gajju_07_04_28_17046974687824300.xml', 'ts/08_01_2024/response_header_availability_being_gajju_07_04_28_17046974687824300.xml', 'totalstay', '2024-01-08 07:04:28', '', '4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f', '0');
[01/08/2024 07:04:28], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'ts/08_01_2024/request_availability_being_gajju_07_04_28_17046974682524271.xml', 'ts/08_01_2024/response_availability_being_gajju_07_04_28_17046974682524271.xml', 'ts/08_01_2024/response_header_availability_being_gajju_07_04_28_17046974682524271.xml', 'totalstay', '2024-01-08 07:04:28', '', '4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f', '0');
[01/08/2024 07:04:28], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=totalstay&sessionid=4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f&xml_user_id=7864&db_caching=1&country_code=UNI&country_name=United+Arab+Emirates&city_code=3373&city_name=Dubai&scurrency_code=2&scurrency_name=USD&erequest=0&total_request=1&hotel_ids=&web_service=no'
            , http_hit_time = '2024-01-08 07:04:28.835'
            , 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.019'
            , error_description = ''
            , memory_used = '1514320'
            WHERE id = '26744';
[01/08/2024 07:04:28], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=totalstay&sessionid=4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f&xml_user_id=7864&db_caching=1&country_code=UNI&country_name=United+Arab+Emirates&city_code=2427&city_name=Dubai&scurrency_code=2&scurrency_name=USD&erequest=0&total_request=2&hotel_ids=&web_service=no'
            , http_hit_time = '2024-01-08 07:04:28.835'
            , 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.021'
            , error_description = ''
            , memory_used = '1504032'
            WHERE id = '26745';
[01/08/2024 07:04:28], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=totalstay&sessionid=4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f&xml_user_id=7864&db_caching=1&country_code=UNI&country_name=United+Arab+Emirates&city_code=2431&city_name=Dubai&scurrency_code=2&scurrency_name=USD&erequest=0&total_request=2&hotel_ids=&web_service=no'
            , http_hit_time = '2024-01-08 07:04:28.835'
            , 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.021'
            , error_description = ''
            , memory_used = '1504072'
            WHERE id = '26747';
[01/08/2024 07:04:28], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=totalstay&sessionid=4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f&xml_user_id=7864&db_caching=1&country_code=UNI&country_name=United+Arab+Emirates&city_code=2430&city_name=Dubai&scurrency_code=2&scurrency_name=USD&erequest=1&total_request=2&hotel_ids=&web_service=no'
            , http_hit_time = '2024-01-08 07:04:28.835'
            , 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.021'
            , error_description = ''
            , memory_used = '1504264'
            WHERE id = '26750';
[01/08/2024 07:04:28], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=totalstay&sessionid=4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f&xml_user_id=7864&db_caching=1&country_code=UNI&country_name=United+Arab+Emirates&city_code=10384&city_name=Dubai&scurrency_code=2&scurrency_name=USD&erequest=0&total_request=1&hotel_ids=&web_service=no'
            , http_hit_time = '2024-01-08 07:04:28.835'
            , 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.021'
            , error_description = ''
            , memory_used = '1514328'
            WHERE id = '26751';
[01/08/2024 07:04:28], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=totalstay&sessionid=4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f&xml_user_id=7864&db_caching=1&country_code=UNI&country_name=United+Arab+Emirates&city_code=2428&city_name=Dubai&scurrency_code=2&scurrency_name=USD&erequest=0&total_request=2&hotel_ids=&web_service=no'
            , http_hit_time = '2024-01-08 07:04:28.835'
            , 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.021'
            , error_description = ''
            , memory_used = '1514288'
            WHERE id = '26746';
[01/08/2024 07:04:28], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=totalstay&sessionid=4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f&xml_user_id=7864&db_caching=1&country_code=UNI&country_name=United+Arab+Emirates&city_code=3236&city_name=Dubai&scurrency_code=2&scurrency_name=USD&erequest=0&total_request=1&hotel_ids=&web_service=no'
            , http_hit_time = '2024-01-08 07:04:28.835'
            , 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.021'
            , error_description = ''
            , memory_used = '1504072'
            WHERE id = '26749';
[01/08/2024 07:04:28], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=totalstay&sessionid=4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f&xml_user_id=7864&db_caching=1&country_code=UNI&country_name=United+Arab+Emirates&city_code=2431&city_name=Dubai&scurrency_code=2&scurrency_name=USD&erequest=1&total_request=2&hotel_ids=&web_service=no'
            , http_hit_time = '2024-01-08 07:04:28.835'
            , 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.021'
            , error_description = ''
            , memory_used = '1514320'
            WHERE id = '26748';
[01/08/2024 07:04:28], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=totalstay&sessionid=4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f&xml_user_id=7864&db_caching=1&country_code=UNI&country_name=United+Arab+Emirates&city_code=2430&city_name=Dubai&scurrency_code=2&scurrency_name=USD&erequest=0&total_request=2&hotel_ids=&web_service=no'
            , http_hit_time = '2024-01-08 07:04:28.835'
            , 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.023'
            , error_description = ''
            , memory_used = '1504072'
            WHERE id = '26753';
[01/08/2024 07:04:28], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=totalstay&sessionid=4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f&xml_user_id=7864&db_caching=1&country_code=UNI&country_name=United+Arab+Emirates&city_code=2427&city_name=Dubai&scurrency_code=2&scurrency_name=USD&erequest=1&total_request=2&hotel_ids=&web_service=no'
            , http_hit_time = '2024-01-08 07:04:28.835'
            , 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.023'
            , error_description = ''
            , memory_used = '1514320'
            WHERE id = '26754';
[01/08/2024 07:04:28], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=totalstay&sessionid=4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f&xml_user_id=7864&db_caching=1&country_code=UNI&country_name=United+Arab+Emirates&city_code=2428&city_name=Dubai&scurrency_code=2&scurrency_name=USD&erequest=1&total_request=2&hotel_ids=&web_service=no'
            , http_hit_time = '2024-01-08 07:04:28.835'
            , 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.023'
            , error_description = ''
            , memory_used = '1514320'
            WHERE id = '26752';
[01/08/2024 07:04:29], [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/08_01_2024/request_availability_being_gajju_07_04_28_1704697468_56.json', 'e1p/08_01_2024/response_availability_being_gajju_07_04_28_1704697468_56.json', 'e1p/08_01_2024/response_header_availability_being_gajju_07_04_28_1704697468_56.json', 'expediapackage', '2024-01-08 07:04:29', '', '4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f', '0');
[01/08/2024 07:04:29], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f&xml_user_id=7864&db_caching=1&erequest=2&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F120.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-08 07:04:28.836'
            , 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.181'
            , error_description = ''
            , memory_used = '2195104'
            WHERE id = '26755';
[01/08/2024 07:04:29], [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/08_01_2024/request_availability_being_gajju_07_04_28_1704697468_35.json', 'e1/08_01_2024/response_availability_being_gajju_07_04_28_1704697468_35.json', 'e1/08_01_2024/response_header_availability_being_gajju_07_04_28_1704697468_35.json', 'expedia', '2024-01-08 07:04:29', '', '4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f', '0');
[01/08/2024 07:04:29], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f&xml_user_id=7864&db_caching=1&erequest=2&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F120.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-08 07:04:28.835'
            , 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.345'
            , error_description = ''
            , memory_used = '2194064'
            WHERE id = '26756';
[01/08/2024 07:04:30], [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/08_01_2024/request_availability_being_gajju_07_04_28_1704697468_3.json', 'e1/08_01_2024/response_availability_being_gajju_07_04_28_1704697468_3.json', 'e1/08_01_2024/response_header_availability_being_gajju_07_04_28_1704697468_3.json', 'expedia', '2024-01-08 07:04:30', '', '4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f', '0');
[01/08/2024 07:04:31], [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/08_01_2024/request_availability_being_gajju_07_04_28_1704697468_88.json', 'e1p/08_01_2024/response_availability_being_gajju_07_04_28_1704697468_88.json', 'e1p/08_01_2024/response_header_availability_being_gajju_07_04_28_1704697468_88.json', 'expediapackage', '2024-01-08 07:04:31', '', '4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f', '0');
[01/08/2024 07:04:31], [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/08_01_2024/request_availability_being_gajju_07_04_28_1704697468_88.json', 'e1/08_01_2024/response_availability_being_gajju_07_04_28_1704697468_88.json', 'e1/08_01_2024/response_header_availability_being_gajju_07_04_28_1704697468_88.json', 'expedia', '2024-01-08 07:04:31', '', '4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f', '0');
[01/08/2024 07:04:31], [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/08_01_2024/request_availability_being_gajju_07_04_28_1704697468_98.json', 'e1p/08_01_2024/response_availability_being_gajju_07_04_28_1704697468_98.json', 'e1p/08_01_2024/response_header_availability_being_gajju_07_04_28_1704697468_98.json', 'expediapackage', '2024-01-08 07:04:31', '', '4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f', '0');
[01/08/2024 07:04:31], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f&xml_user_id=7864&db_caching=1&erequest=0&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F120.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-08 07:04:28.835'
            , 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.061'
            , error_description = ''
            , memory_used = '195845632'
            WHERE id = '26757';
[01/08/2024 07:04:32], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f&xml_user_id=7864&db_caching=1&erequest=1&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F120.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-08 07:04:28.835'
            , 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.540'
            , error_description = ''
            , memory_used = '170823696'
            WHERE id = '26759';
[01/08/2024 07:04:32], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f&xml_user_id=7864&db_caching=1&erequest=1&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F120.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-08 07:04:28.835'
            , 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.557'
            , error_description = ''
            , memory_used = '176214368'
            WHERE id = '26758';
[01/08/2024 07:04:32], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=4ffcb3d0ed420b0aea9c0a57a255d7372cf4eb58f0e4e7da06a2d70db4ad805f&xml_user_id=7864&db_caching=1&erequest=0&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F120.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-08 07:04:28.835'
            , 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.834'
            , error_description = ''
            , memory_used = '206570672'
            WHERE id = '26760';
[01/08/2024 07:04:32], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-08 07:04:32' WHERE id= '264';
[01/08/2024 07:04:34], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-01-08 07:04:34' WHERE id= '264';
[01/08/2024 07:06:59], [file name :-/home/otrams/public_html/beta/index.php],INSERT INTO psa_login_log  SET username = '', user_type = 'A', branch_id = '7', login_datetime = '2024-01-08 07:06:59', ip = '206.72.206.92', action = 'Login' ;
[01/08/2024 07:06:59], [file name :-/home/otrams/public_html/beta/index.php],INSERT INTO psa_login_log  SET username = '', user_type = 'A', branch_id = '7', login_datetime = '2024-01-08 07:06:59', ip = '206.72.206.92', action = 'Login' ;
[01/08/2024 07:10:14], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-08 07:10:14' WHERE id= '260';
[01/08/2024 07:10:14], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-08 07:10:14' WHERE id= '260';
[01/08/2024 07:10:18], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-08 07:10:18' WHERE id= '260';
[01/08/2024 07:10: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/07/30' , departure_date = '2024/07/31' , nights = '1' , nationality = '138' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-01-08 07:10:18' , site_id = '20' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[01/08/2024 07:10:18], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-01-08 07:10:18' WHERE id= '260';
[01/08/2024 07:10: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/08_01_2024/request_availability_Baysan_Tourism_wh_07_10_18_1704697818_72.json', 'e1p/08_01_2024/response_availability_Baysan_Tourism_wh_07_10_18_1704697818_72.json', 'e1p/08_01_2024/response_header_availability_Baysan_Tourism_wh_07_10_18_1704697818_72.json', 'expediapackage', '2024-01-08 07:10:19', '', '7622f4687190cf5a6f9517432bad64953ebcd616015e912ae6f1b48b3cf041cf', '0');
[01/08/2024 07:10:19], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=7622f4687190cf5a6f9517432bad64953ebcd616015e912ae6f1b48b3cf041cf&xml_user_id=7863&db_caching=1&erequest=2&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F120.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=138'
            , http_hit_time = '2024-01-08 07:10:18.962'
            , 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.445'
            , error_description = ''
            , memory_used = '2258488'
            WHERE id = '26761';
[01/08/2024 07:10: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/08_01_2024/request_availability_Baysan_Tourism_wh_07_10_18_1704697818_59.json', 'e1/08_01_2024/response_availability_Baysan_Tourism_wh_07_10_18_1704697818_59.json', 'e1/08_01_2024/response_header_availability_Baysan_Tourism_wh_07_10_18_1704697818_59.json', 'expedia', '2024-01-08 07:10:19', '', '7622f4687190cf5a6f9517432bad64953ebcd616015e912ae6f1b48b3cf041cf', '0');
[01/08/2024 07:10:19], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=7622f4687190cf5a6f9517432bad64953ebcd616015e912ae6f1b48b3cf041cf&xml_user_id=7863&db_caching=1&erequest=2&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F120.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=138'
            , http_hit_time = '2024-01-08 07:10:18.962'
            , 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.463'
            , error_description = ''
            , memory_used = '2257960'
            WHERE id = '26762';
[01/08/2024 07:10: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', 'e1/08_01_2024/request_availability_Baysan_Tourism_wh_07_10_18_1704697818_78.json', 'e1/08_01_2024/response_availability_Baysan_Tourism_wh_07_10_18_1704697818_78.json', 'e1/08_01_2024/response_header_availability_Baysan_Tourism_wh_07_10_18_1704697818_78.json', 'expedia', '2024-01-08 07:10:21', '', '7622f4687190cf5a6f9517432bad64953ebcd616015e912ae6f1b48b3cf041cf', '0');
[01/08/2024 07:10: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', 'e1/08_01_2024/request_availability_Baysan_Tourism_wh_07_10_18_1704697818_53.json', 'e1/08_01_2024/response_availability_Baysan_Tourism_wh_07_10_18_1704697818_53.json', 'e1/08_01_2024/response_header_availability_Baysan_Tourism_wh_07_10_18_1704697818_53.json', 'expedia', '2024-01-08 07:10:21', '', '7622f4687190cf5a6f9517432bad64953ebcd616015e912ae6f1b48b3cf041cf', '0');
[01/08/2024 07:10: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/08_01_2024/request_availability_Baysan_Tourism_wh_07_10_18_1704697818_88.json', 'e1p/08_01_2024/response_availability_Baysan_Tourism_wh_07_10_18_1704697818_88.json', 'e1p/08_01_2024/response_header_availability_Baysan_Tourism_wh_07_10_18_1704697818_88.json', 'expediapackage', '2024-01-08 07:10:21', '', '7622f4687190cf5a6f9517432bad64953ebcd616015e912ae6f1b48b3cf041cf', '0');
[01/08/2024 07:10: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/08_01_2024/request_availability_Baysan_Tourism_wh_07_10_18_1704697818_9.json', 'e1p/08_01_2024/response_availability_Baysan_Tourism_wh_07_10_18_1704697818_9.json', 'e1p/08_01_2024/response_header_availability_Baysan_Tourism_wh_07_10_18_1704697818_9.json', 'expediapackage', '2024-01-08 07:10:21', '', '7622f4687190cf5a6f9517432bad64953ebcd616015e912ae6f1b48b3cf041cf', '0');
[01/08/2024 07:10:22], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=7622f4687190cf5a6f9517432bad64953ebcd616015e912ae6f1b48b3cf041cf&xml_user_id=7863&db_caching=1&erequest=1&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F120.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=138'
            , http_hit_time = '2024-01-08 07:10:18.962'
            , 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.723'
            , error_description = ''
            , memory_used = '167425800'
            WHERE id = '26764';
[01/08/2024 07:10:22], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=7622f4687190cf5a6f9517432bad64953ebcd616015e912ae6f1b48b3cf041cf&xml_user_id=7863&db_caching=1&erequest=0&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F120.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=138'
            , http_hit_time = '2024-01-08 07:10:18.961'
            , 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.892'
            , error_description = ''
            , memory_used = '196854728'
            WHERE id = '26763';
[01/08/2024 07:10:23], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=7622f4687190cf5a6f9517432bad64953ebcd616015e912ae6f1b48b3cf041cf&xml_user_id=7863&db_caching=1&erequest=1&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F120.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=138'
            , http_hit_time = '2024-01-08 07:10:18.962'
            , 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.332'
            , error_description = ''
            , memory_used = '179245544'
            WHERE id = '26766';
[01/08/2024 07:10:23], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=7622f4687190cf5a6f9517432bad64953ebcd616015e912ae6f1b48b3cf041cf&xml_user_id=7863&db_caching=1&erequest=0&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F120.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=138'
            , http_hit_time = '2024-01-08 07:10:18.961'
            , 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.338'
            , error_description = ''
            , memory_used = '210231952'
            WHERE id = '26765';
[01/08/2024 07:10:24], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-01-08 07:10:24' WHERE id= '260';
[01/08/2024 07:10:24], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-08 07:10:24' WHERE id= '260';
[01/08/2024 07:10:24], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-08 07:10:24' WHERE id= '260';
[01/08/2024 07:27:54], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-08 07:27:54',login_attempt=0 where id = '7851';
[01/08/2024 07:27:54], [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-08 07:27:54', ip = '43.239.53.130', action = 'Login' ;
[01/08/2024 07:27:54], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-08 07:27:54' WHERE id= '263';
[01/08/2024 07:27:57], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-08 07:27:57' WHERE id= '263';
[01/08/2024 07:28:01], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-08 07:28:01' WHERE id= '263';
[01/08/2024 07:28:06], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-08 07:28:06' WHERE id= '263';
[01/08/2024 07:28:06], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '27' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/01/11',  departure_date='2024/01/11',  nights='1',  create_date='2024-01-08 :07:28:06',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/08/2024 07:28:06], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'v1/08_01_2024/request_availability_Viator_test_07_28_06_1704698886.json', 'v1/08_01_2024/response_availability_Viator_test_07_28_06_1704698886.json', 'v1/08_01_2024/response_header_availability_Viator_test_07_28_06_1704698886.json', 'viator', '2024-01-08 07:28:06', '', '', '632');
[01/08/2024 07:28:08], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-08 07:28:08' WHERE id= '263';
[01/08/2024 07:28:08], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-08 07:28:08' WHERE id= '263';
[01/08/2024 07:28:13], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-08 07:28:13' WHERE id= '263';
[01/08/2024 07:28:13], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/08_01_2024/request_sight_details_Viator_test_07_28_13_1704698893.json', 'v1/08_01_2024/response_sight_details_Viator_test_07_28_13_1704698893.json', 'v1/08_01_2024/response_header_sight_details_Viator_test_07_28_13_1704698893.json', 'viator', '2024-01-08 07:28:13', '', '', '632');
[01/08/2024 07:28:31], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-08 07:28:31' WHERE id= '263';
[01/08/2024 07:29:51], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-08 07:29:51' WHERE id= '260';
[01/08/2024 07:29:51], [file name :-/home/otrams/public_html/beta/view_map.php],UPDATE user_sessions_ip SET update_date = '2024-01-08 07:29:51' WHERE id= '260';
[01/08/2024 07:35:12], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-08 07:35:12',login_attempt=0 where id = '7866';
[01/08/2024 07:35:12], [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-08 07:35:12', ip = '43.239.53.130', action = 'Login' ;
[01/08/2024 07:35:12], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-08 07:35:12' WHERE id= '261';
[01/08/2024 07:35:17], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-08 07:35:17' WHERE id= '261';
[01/08/2024 07:38:04], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-08 07:38:04' WHERE id= '261';
[01/08/2024 07:38:04], [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-08 07:38:04' , site_id = '20' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[01/08/2024 07:38:06], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-01-08 07:38:06' WHERE id= '261';
[01/08/2024 07:38:06], [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/08_01_2024/request_availability_Baysan_Tourism_wh_07_38_06_1704699486_4.json', 'e1p/08_01_2024/response_availability_Baysan_Tourism_wh_07_38_06_1704699486_4.json', 'e1p/08_01_2024/response_header_availability_Baysan_Tourism_wh_07_38_06_1704699486_4.json', 'expediapackage', '2024-01-08 07:38:06', '', '0eed5e9450ac6c49ce96b242e618f2dd07faa96e8e6f97cf2f782708a3658a56', '0');
[01/08/2024 07:38:06], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=0eed5e9450ac6c49ce96b242e618f2dd07faa96e8e6f97cf2f782708a3658a56&xml_user_id=7863&db_caching=1&erequest=2&total_request=3&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F110.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=138'
            , http_hit_time = '2024-01-08 07:38:06.107'
            , 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.216'
            , error_description = ''
            , memory_used = '2258296'
            WHERE id = '26769';
[01/08/2024 07:38:06], [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/08_01_2024/request_availability_Baysan_Tourism_wh_07_38_06_1704699486_47.json', 'e1/08_01_2024/response_availability_Baysan_Tourism_wh_07_38_06_1704699486_47.json', 'e1/08_01_2024/response_header_availability_Baysan_Tourism_wh_07_38_06_1704699486_47.json', 'expedia', '2024-01-08 07:38:06', '', '0eed5e9450ac6c49ce96b242e618f2dd07faa96e8e6f97cf2f782708a3658a56', '0');
[01/08/2024 07:38:06], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=0eed5e9450ac6c49ce96b242e618f2dd07faa96e8e6f97cf2f782708a3658a56&xml_user_id=7863&db_caching=1&erequest=2&total_request=3&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F110.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=138'
            , http_hit_time = '2024-01-08 07:38:06.108'
            , 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.356'
            , error_description = ''
            , memory_used = '2258144'
            WHERE id = '26770';
[01/08/2024 07:38:07], [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/08_01_2024/request_availability_Baysan_Tourism_wh_07_38_06_1704699486_69.json', 'e1/08_01_2024/response_availability_Baysan_Tourism_wh_07_38_06_1704699486_69.json', 'e1/08_01_2024/response_header_availability_Baysan_Tourism_wh_07_38_06_1704699486_69.json', 'expedia', '2024-01-08 07:38:07', '', '0eed5e9450ac6c49ce96b242e618f2dd07faa96e8e6f97cf2f782708a3658a56', '0');
[01/08/2024 07:38:07], [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/08_01_2024/request_availability_Baysan_Tourism_wh_07_38_06_1704699486_79.json', 'e1/08_01_2024/response_availability_Baysan_Tourism_wh_07_38_06_1704699486_79.json', 'e1/08_01_2024/response_header_availability_Baysan_Tourism_wh_07_38_06_1704699486_79.json', 'expedia', '2024-01-08 07:38:07', '', '0eed5e9450ac6c49ce96b242e618f2dd07faa96e8e6f97cf2f782708a3658a56', '0');
[01/08/2024 07:38:08], [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/08_01_2024/request_availability_Baysan_Tourism_wh_07_38_06_1704699486_14.json', 'e1p/08_01_2024/response_availability_Baysan_Tourism_wh_07_38_06_1704699486_14.json', 'e1p/08_01_2024/response_header_availability_Baysan_Tourism_wh_07_38_06_1704699486_14.json', 'expediapackage', '2024-01-08 07:38:08', '', '0eed5e9450ac6c49ce96b242e618f2dd07faa96e8e6f97cf2f782708a3658a56', '0');
[01/08/2024 07:38:08], [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/08_01_2024/request_availability_Baysan_Tourism_wh_07_38_06_1704699486_53.json', 'e1p/08_01_2024/response_availability_Baysan_Tourism_wh_07_38_06_1704699486_53.json', 'e1p/08_01_2024/response_header_availability_Baysan_Tourism_wh_07_38_06_1704699486_53.json', 'expediapackage', '2024-01-08 07:38:08', '', '0eed5e9450ac6c49ce96b242e618f2dd07faa96e8e6f97cf2f782708a3658a56', '0');
[01/08/2024 07:38:09], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=0eed5e9450ac6c49ce96b242e618f2dd07faa96e8e6f97cf2f782708a3658a56&xml_user_id=7863&db_caching=1&erequest=1&total_request=3&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F110.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=138'
            , http_hit_time = '2024-01-08 07:38:06.108'
            , 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.620'
            , error_description = ''
            , memory_used = '159146824'
            WHERE id = '26771';
[01/08/2024 07:38:10], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=0eed5e9450ac6c49ce96b242e618f2dd07faa96e8e6f97cf2f782708a3658a56&xml_user_id=7863&db_caching=1&erequest=0&total_request=3&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F110.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=138'
            , http_hit_time = '2024-01-08 07:38:06.108'
            , 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.934'
            , error_description = ''
            , memory_used = '182786984'
            WHERE id = '26772';
[01/08/2024 07:38:10], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=0eed5e9450ac6c49ce96b242e618f2dd07faa96e8e6f97cf2f782708a3658a56&xml_user_id=7863&db_caching=1&erequest=1&total_request=3&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F110.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=138'
            , http_hit_time = '2024-01-08 07:38:06.108'
            , 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.257'
            , error_description = ''
            , memory_used = '167485680'
            WHERE id = '26774';
[01/08/2024 07:38:10], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=0eed5e9450ac6c49ce96b242e618f2dd07faa96e8e6f97cf2f782708a3658a56&xml_user_id=7863&db_caching=1&erequest=0&total_request=3&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F110.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=138'
            , http_hit_time = '2024-01-08 07:38:06.108'
            , 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.260'
            , error_description = ''
            , memory_used = '195438680'
            WHERE id = '26773';
[01/08/2024 07:38:11], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-01-08 07:38:11' WHERE id= '261';
[01/08/2024 07:38:11], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-08 07:38:11' WHERE id= '261';
[01/08/2024 07:39:20], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-08 07:39:20',login_attempt=0 where id = '7857';
[01/08/2024 07:39:20], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Deepak_T', user_type = 'A', branch_id = '23', login_datetime = '2024-01-08 07:39:20', ip = '43.239.53.130', action = 'Login' ;
[01/08/2024 07:39:20], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-08 07:39:20' WHERE id= '262';
[01/08/2024 07:39:20], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-08 07:39:20' WHERE id= '263';
[01/08/2024 07:39:26], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-08 07:39:26' WHERE id= '262';
[01/08/2024 07:39:28], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-08 07:39:28' WHERE id= '262';
[01/08/2024 07:39:28], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '23' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/01/09' , departure_date = '2024/01/10' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-01-08 07:39:28' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[01/08/2024 07:39:30], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-01-08 07:39:30' WHERE id= '262';
[01/08/2024 07:39:30], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-08 07:39:30' WHERE id= '262';
[01/08/2024 07:39:31], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-01-08 07:39:31' WHERE id= '262';
[01/08/2024 07:39:34], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-08 07:39:34' WHERE id= '262';
[01/08/2024 07:39:34], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '23' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/01/09' , departure_date = '2024/01/10' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-01-08 07:39:34' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[01/08/2024 07:39:35], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-01-08 07:39:35' WHERE id= '262';
[01/08/2024 07:39:35], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-08 07:39:35' WHERE id= '262';
[01/08/2024 07:39:37], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-01-08 07:39:37' WHERE id= '262';
[01/08/2024 07:39:42], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-08 07:39:42' WHERE id= '262';
[01/08/2024 07:39:42], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '23' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/01/09' , departure_date = '2024/01/10' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-01-08 07:39:42' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[01/08/2024 07:39:42], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-01-08 07:39:42' WHERE id= '262';
[01/08/2024 07:39:43], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-08 07:39:43' WHERE id= '262';
[01/08/2024 07:39:44], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-01-08 07:39:44' WHERE id= '262';
[01/08/2024 07:40:19], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-08 07:40:19' WHERE id= '263';
[01/08/2024 07:43:51], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-08 07:43:51' WHERE id= '263';
[01/08/2024 07:44:41], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-08 07:44:41' WHERE id= '263';
[01/08/2024 07:45:34], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-08 07:45:34' WHERE id= '263';
[01/08/2024 07:49:53], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-08 07:49:53' WHERE id= '260';
[01/08/2024 07:53:27], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-08 07:53:27' WHERE id= '263';
[01/08/2024 07:58:04], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-08 07:58:04' WHERE id= '263';
