[11/29/2023 12:01:11], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-11-29 12:01:11' WHERE id= '163';
[11/29/2023 12:01:14], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2023-11-29 12:01:14' WHERE id= '163';
[11/29/2023 12:01:18], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-29 12:01:18' WHERE id= '163';
[11/29/2023 12:02:05], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-11-29 12:02:05' WHERE id= '163';
[11/29/2023 12:02:06], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2023-11-29 12:02:06' WHERE id= '163';
[11/29/2023 12:02:09], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-29 12:02:09' WHERE id= '163';
[11/29/2023 12:02:40], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-11-29 12:02:40' WHERE id= '163';
[11/29/2023 12:02:42], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2023-11-29 12:02:42' WHERE id= '163';
[11/29/2023 12:02:44], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-29 12:02:44' WHERE id= '163';
[11/29/2023 12:02:52], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],UPDATE user_sessions_ip SET update_date = '2023-11-29 12:02:52' WHERE id= '163';
[11/29/2023 12:02:52], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Nihal Hotel', 'dubai', '138', '7864', '', '28', '', 'hoteldetails', '2023-11-29 :12:02:52','');
[11/29/2023 12:02:53], [file name :-/home/otrams/public_html/beta/view_map.php],UPDATE user_sessions_ip SET update_date = '2023-11-29 12:02:53' WHERE id= '163';
[11/29/2023 12:03:24], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-11-29 12:03:24' WHERE id= '163';
[11/29/2023 12:03:26], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2023-11-29 12:03:26' WHERE id= '163';
[11/29/2023 12:03:29], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-29 12:03:29' WHERE id= '163';
[11/29/2023 12:04:32], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-11-29 12:04:32' WHERE id= '163';
[11/29/2023 12:04:34], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2023-11-29 12:04:34' WHERE id= '163';
[11/29/2023 12:04:45], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],UPDATE user_sessions_ip SET update_date = '2023-11-29 12:04:45' WHERE id= '163';
[11/29/2023 12:04:46], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Nihal Hotel', 'dubai', '138', '7864', '', '28', '', 'hoteldetails', '2023-11-29 :12:04:46','');
[11/29/2023 12:04:46], [file name :-/home/otrams/public_html/beta/view_map.php],UPDATE user_sessions_ip SET update_date = '2023-11-29 12:04:46' WHERE id= '163';
[11/29/2023 12:05:25], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-29 12:05:25' WHERE id= '163';
[11/29/2023 12:07:34], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-11-29 12:07:34' WHERE id= '163';
[11/29/2023 12:07:36], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2023-11-29 12:07:36' WHERE id= '163';
[11/29/2023 12:07:41], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-29 12:07:41' WHERE id= '163';
[11/29/2023 12:07:48], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],UPDATE user_sessions_ip SET update_date = '2023-11-29 12:07:48' WHERE id= '163';
[11/29/2023 12:07:48], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Hafez Hotel Apartments', 'dubai', '138', '7864', '', '28', '', 'hoteldetails', '2023-11-29 :12:07:48','');
[11/29/2023 12:07:49], [file name :-/home/otrams/public_html/beta/view_map.php],UPDATE user_sessions_ip SET update_date = '2023-11-29 12:07:49' WHERE id= '163';
[11/29/2023 12:27:50], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-11-29 12:27:50' WHERE id= '163';
[11/29/2023 12:29:18], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2023-11-29 12:29:18',login_attempt=0 where id = '7857';
[11/29/2023 12:29:18], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Deepak_T', user_type = 'A', branch_id = '28', login_datetime = '2023-11-29 12:29:18', ip = '43.239.53.130', action = 'Login' ;
[11/29/2023 12:29:18], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-11-29 12:29:18' WHERE id= '175';
[11/29/2023 12:29:23], [file name :-/home/otrams/public_html/beta/my_accounts.php],UPDATE user_sessions_ip SET update_date = '2023-11-29 12:29:23' WHERE id= '175';
[11/29/2023 12:29:25], [file name :-/home/otrams/public_html/beta/manage_sub_user.php],UPDATE user_sessions_ip SET update_date = '2023-11-29 12:29:25' WHERE id= '175';
[11/29/2023 12:29:29], [file name :-/home/otrams/public_html/beta/manage_sub_user.php],UPDATE user_sessions_ip SET update_date = '2023-11-29 12:29:29' WHERE id= '175';
[11/29/2023 12:29:38], [file name :-/home/otrams/public_html/beta/manage_sub_user.php],UPDATE user_sessions_ip SET update_date = '2023-11-29 12:29:38' WHERE id= '175';
[11/29/2023 12:29:38], [file name :-/home/otrams/public_html/beta/manage_sub_user.php],update sub_user SET first_name='shiv',middle_name='qtech',last_name='chuhan',address='mumbai',city='64440',country='106',phone='    91-92929292929',mobile='    91-92929292929',designation='opreating staff',can_book='',can_voucher='',view_all_bookings='1',allow_book_under_cancellation='',modify_date='2023-11-29 12:29:38',email='shiv.chauhan.shiv@qtechsoftware.com',status='A'where sub_user_id='1';
[11/29/2023 12:29:38], [file name :-/home/otrams/public_html/beta/manage_sub_user.php],UPDATE user_sessions_ip SET update_date = '2023-11-29 12:29:38' WHERE id= '175';
[11/29/2023 12:29:41], [file name :-/home/otrams/public_html/beta/manage_sub_user.php],UPDATE user_sessions_ip SET update_date = '2023-11-29 12:29:41' WHERE id= '175';
[11/29/2023 12:40:46], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-29 12:40:46' WHERE id= '163';
[11/29/2023 12:40:46], [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 = '2023/12/09' , departure_date = '2023/12/10' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2023-11-29 12:40:46' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'INR' , currency_code = 'INR' , web_service = '' ;
[11/29/2023 12:40:46], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2023-11-29 12:40:46' WHERE id= '163';
[11/29/2023 12:40:47], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'ts/29_11_2023/request_availability_being_gajju_12_40_47_17012616476433730.xml', 'ts/29_11_2023/response_availability_being_gajju_12_40_47_17012616476433730.xml', 'ts/29_11_2023/response_header_availability_being_gajju_12_40_47_17012616476433730.xml', 'totalstay', '2023-11-29 12:40:47', '', '831e3efb1284757ae4870650db82416785e6fb92b1b71305617f9aae23242432', '0');
[11/29/2023 12:40:47], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'ts/29_11_2023/request_availability_being_gajju_12_40_47_170126164764103840.xml', 'ts/29_11_2023/response_availability_being_gajju_12_40_47_170126164764103840.xml', 'ts/29_11_2023/response_header_availability_being_gajju_12_40_47_170126164764103840.xml', 'totalstay', '2023-11-29 12:40:47', '', '831e3efb1284757ae4870650db82416785e6fb92b1b71305617f9aae23242432', '0');
[11/29/2023 12:40:47], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'ts/29_11_2023/request_availability_being_gajju_12_40_47_17012616472924280.xml', 'ts/29_11_2023/response_availability_being_gajju_12_40_47_17012616472924280.xml', 'ts/29_11_2023/response_header_availability_being_gajju_12_40_47_17012616472924280.xml', 'totalstay', '2023-11-29 12:40:47', '', '831e3efb1284757ae4870650db82416785e6fb92b1b71305617f9aae23242432', '0');
[11/29/2023 12:40:47], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'ts/29_11_2023/request_availability_being_gajju_12_40_47_17012616473224310.xml', 'ts/29_11_2023/response_availability_being_gajju_12_40_47_17012616473224310.xml', 'ts/29_11_2023/response_header_availability_being_gajju_12_40_47_17012616473224310.xml', 'totalstay', '2023-11-29 12:40:47', '', '831e3efb1284757ae4870650db82416785e6fb92b1b71305617f9aae23242432', '0');
[11/29/2023 12:40:47], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'ts/29_11_2023/request_availability_being_gajju_12_40_47_17012616472324300.xml', 'ts/29_11_2023/response_availability_being_gajju_12_40_47_17012616472324300.xml', 'ts/29_11_2023/response_header_availability_being_gajju_12_40_47_17012616472324300.xml', 'totalstay', '2023-11-29 12:40:47', '', '831e3efb1284757ae4870650db82416785e6fb92b1b71305617f9aae23242432', '0');
[11/29/2023 12:40:47], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'ts/29_11_2023/request_availability_being_gajju_12_40_47_17012616472424311.xml', 'ts/29_11_2023/response_availability_being_gajju_12_40_47_17012616472424311.xml', 'ts/29_11_2023/response_header_availability_being_gajju_12_40_47_17012616472424311.xml', 'totalstay', '2023-11-29 12:40:47', '', '831e3efb1284757ae4870650db82416785e6fb92b1b71305617f9aae23242432', '0');
[11/29/2023 12:40:47], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'ts/29_11_2023/request_availability_being_gajju_12_40_47_17012616478024281.xml', 'ts/29_11_2023/response_availability_being_gajju_12_40_47_17012616478024281.xml', 'ts/29_11_2023/response_header_availability_being_gajju_12_40_47_17012616478024281.xml', 'totalstay', '2023-11-29 12:40:47', '', '831e3efb1284757ae4870650db82416785e6fb92b1b71305617f9aae23242432', '0');
[11/29/2023 12:40:47], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'ts/29_11_2023/request_availability_being_gajju_12_40_47_17012616475624270.xml', 'ts/29_11_2023/response_availability_being_gajju_12_40_47_17012616475624270.xml', 'ts/29_11_2023/response_header_availability_being_gajju_12_40_47_17012616475624270.xml', 'totalstay', '2023-11-29 12:40:47', '', '831e3efb1284757ae4870650db82416785e6fb92b1b71305617f9aae23242432', '0');
[11/29/2023 12:40:47], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=totalstay&sessionid=831e3efb1284757ae4870650db82416785e6fb92b1b71305617f9aae23242432&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 = '2023-11-29 12:40:47.182'
            , 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.033'
            , error_description = ''
            , memory_used = '3549928'
            WHERE id = '15774';
[11/29/2023 12:40:47], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'ts/29_11_2023/request_availability_being_gajju_12_40_47_17012616472324301.xml', 'ts/29_11_2023/response_availability_being_gajju_12_40_47_17012616472324301.xml', 'ts/29_11_2023/response_header_availability_being_gajju_12_40_47_17012616472324301.xml', 'totalstay', '2023-11-29 12:40:47', '', '831e3efb1284757ae4870650db82416785e6fb92b1b71305617f9aae23242432', '0');
[11/29/2023 12:40:47], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'ts/29_11_2023/request_availability_being_gajju_12_40_47_17012616479932360.xml', 'ts/29_11_2023/response_availability_being_gajju_12_40_47_17012616479932360.xml', 'ts/29_11_2023/response_header_availability_being_gajju_12_40_47_17012616479932360.xml', 'totalstay', '2023-11-29 12:40:47', '', '831e3efb1284757ae4870650db82416785e6fb92b1b71305617f9aae23242432', '0');
[11/29/2023 12:40:47], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'ts/29_11_2023/request_availability_being_gajju_12_40_47_17012616478124271.xml', 'ts/29_11_2023/response_availability_being_gajju_12_40_47_17012616478124271.xml', 'ts/29_11_2023/response_header_availability_being_gajju_12_40_47_17012616478124271.xml', 'totalstay', '2023-11-29 12:40:47', '', '831e3efb1284757ae4870650db82416785e6fb92b1b71305617f9aae23242432', '0');
[11/29/2023 12:40:47], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=totalstay&sessionid=831e3efb1284757ae4870650db82416785e6fb92b1b71305617f9aae23242432&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 = '2023-11-29 12:40:47.182'
            , 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.037'
            , error_description = ''
            , memory_used = '3538584'
            WHERE id = '15775';
[11/29/2023 12:40:47], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=totalstay&sessionid=831e3efb1284757ae4870650db82416785e6fb92b1b71305617f9aae23242432&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 = '2023-11-29 12:40:47.182'
            , 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.040'
            , error_description = ''
            , memory_used = '3539472'
            WHERE id = '15776';
[11/29/2023 12:40:47], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=totalstay&sessionid=831e3efb1284757ae4870650db82416785e6fb92b1b71305617f9aae23242432&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 = '2023-11-29 12:40:47.182'
            , 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.039'
            , error_description = ''
            , memory_used = '3539472'
            WHERE id = '15778';
[11/29/2023 12:40:47], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=totalstay&sessionid=831e3efb1284757ae4870650db82416785e6fb92b1b71305617f9aae23242432&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 = '2023-11-29 12:40:47.182'
            , 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.040'
            , error_description = ''
            , memory_used = '3539472'
            WHERE id = '15781';
[11/29/2023 12:40:47], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=totalstay&sessionid=831e3efb1284757ae4870650db82416785e6fb92b1b71305617f9aae23242432&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 = '2023-11-29 12:40:47.182'
            , 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.039'
            , error_description = ''
            , memory_used = '3549928'
            WHERE id = '15777';
[11/29/2023 12:40:47], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=totalstay&sessionid=831e3efb1284757ae4870650db82416785e6fb92b1b71305617f9aae23242432&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 = '2023-11-29 12:40:47.182'
            , 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.040'
            , error_description = ''
            , memory_used = '3539472'
            WHERE id = '15779';
[11/29/2023 12:40:47], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=totalstay&sessionid=831e3efb1284757ae4870650db82416785e6fb92b1b71305617f9aae23242432&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 = '2023-11-29 12:40:47.182'
            , 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.040'
            , error_description = ''
            , memory_used = '3549712'
            WHERE id = '15780';
[11/29/2023 12:40:47], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=totalstay&sessionid=831e3efb1284757ae4870650db82416785e6fb92b1b71305617f9aae23242432&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 = '2023-11-29 12:40:47.182'
            , 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.040'
            , error_description = ''
            , memory_used = '3539472'
            WHERE id = '15782';
[11/29/2023 12:40:47], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=totalstay&sessionid=831e3efb1284757ae4870650db82416785e6fb92b1b71305617f9aae23242432&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 = '2023-11-29 12:40:47.182'
            , 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.041'
            , error_description = ''
            , memory_used = '3539472'
            WHERE id = '15784';
[11/29/2023 12:40:47], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=totalstay&sessionid=831e3efb1284757ae4870650db82416785e6fb92b1b71305617f9aae23242432&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 = '2023-11-29 12:40:47.182'
            , 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.041'
            , error_description = ''
            , memory_used = '3539472'
            WHERE id = '15783';
[11/29/2023 12:40:47], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/29_11_2023/request_availability_being_gajju_12_40_47_1701261647_4.json', 'e1/29_11_2023/response_availability_being_gajju_12_40_47_1701261647_4.json', 'e1/29_11_2023/response_header_availability_being_gajju_12_40_47_1701261647_4.json', 'expedia', '2023-11-29 12:40:47', '', '831e3efb1284757ae4870650db82416785e6fb92b1b71305617f9aae23242432', '0');
[11/29/2023 12:40:47], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=831e3efb1284757ae4870650db82416785e6fb92b1b71305617f9aae23242432&xml_user_id=7864&db_caching=1&erequest=2&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-29 12:40:47.181'
            , 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.206'
            , error_description = ''
            , memory_used = '3327632'
            WHERE id = '15785';
[11/29/2023 12:40:47], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/29_11_2023/request_availability_being_gajju_12_40_47_1701261647_71.json', 'e1p/29_11_2023/response_availability_being_gajju_12_40_47_1701261647_71.json', 'e1p/29_11_2023/response_header_availability_being_gajju_12_40_47_1701261647_71.json', 'expediapackage', '2023-11-29 12:40:47', '', '831e3efb1284757ae4870650db82416785e6fb92b1b71305617f9aae23242432', '0');
[11/29/2023 12:40:47], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=831e3efb1284757ae4870650db82416785e6fb92b1b71305617f9aae23242432&xml_user_id=7864&db_caching=1&erequest=2&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-29 12:40:47.181'
            , 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.289'
            , error_description = ''
            , memory_used = '3328584'
            WHERE id = '15786';
[11/29/2023 12:40:48], [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/29_11_2023/request_availability_being_gajju_12_40_47_1701261647_74.json', 'e1/29_11_2023/response_availability_being_gajju_12_40_47_1701261647_74.json', 'e1/29_11_2023/response_header_availability_being_gajju_12_40_47_1701261647_74.json', 'expedia', '2023-11-29 12:40:48', '', '831e3efb1284757ae4870650db82416785e6fb92b1b71305617f9aae23242432', '0');
[11/29/2023 12:40:49], [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/29_11_2023/request_availability_being_gajju_12_40_47_1701261647_83.json', 'e1/29_11_2023/response_availability_being_gajju_12_40_47_1701261647_83.json', 'e1/29_11_2023/response_header_availability_being_gajju_12_40_47_1701261647_83.json', 'expedia', '2023-11-29 12:40:49', '', '831e3efb1284757ae4870650db82416785e6fb92b1b71305617f9aae23242432', '0');
[11/29/2023 12:40:49], [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/29_11_2023/request_availability_being_gajju_12_40_47_1701261647_31.json', 'e1p/29_11_2023/response_availability_being_gajju_12_40_47_1701261647_31.json', 'e1p/29_11_2023/response_header_availability_being_gajju_12_40_47_1701261647_31.json', 'expediapackage', '2023-11-29 12:40:49', '', '831e3efb1284757ae4870650db82416785e6fb92b1b71305617f9aae23242432', '0');
[11/29/2023 12:40:49], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=831e3efb1284757ae4870650db82416785e6fb92b1b71305617f9aae23242432&xml_user_id=7864&db_caching=1&erequest=1&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-29 12:40:47.182'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '2.416'
            , error_description = ''
            , memory_used = '137877688'
            WHERE id = '15787';
[11/29/2023 12:40:50], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=831e3efb1284757ae4870650db82416785e6fb92b1b71305617f9aae23242432&xml_user_id=7864&db_caching=1&erequest=0&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-29 12:40:47.182'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '3.408'
            , error_description = ''
            , memory_used = '167971632'
            WHERE id = '15788';
[11/29/2023 12:40:50], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=831e3efb1284757ae4870650db82416785e6fb92b1b71305617f9aae23242432&xml_user_id=7864&db_caching=1&erequest=0&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-29 12:40:47.182'
            , 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.578'
            , error_description = ''
            , memory_used = '179747256'
            WHERE id = '15789';
[11/29/2023 12:40:50], [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/29_11_2023/request_availability_being_gajju_12_40_47_1701261647_53.json', 'e1p/29_11_2023/response_availability_being_gajju_12_40_47_1701261647_53.json', 'e1p/29_11_2023/response_header_availability_being_gajju_12_40_47_1701261647_53.json', 'expediapackage', '2023-11-29 12:40:50', '', '831e3efb1284757ae4870650db82416785e6fb92b1b71305617f9aae23242432', '0');
[11/29/2023 12:40:52], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=831e3efb1284757ae4870650db82416785e6fb92b1b71305617f9aae23242432&xml_user_id=7864&db_caching=1&erequest=1&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-29 12:40:47.182'
            , 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.473'
            , error_description = ''
            , memory_used = '146511080'
            WHERE id = '15790';
[11/29/2023 12:40:52], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2023-11-29 12:40:52' WHERE id= '163';
[11/29/2023 12:40:52], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-11-29 12:40:52' WHERE id= '163';
[11/29/2023 12:40:53], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-11-29 12:40:53' WHERE id= '163';
[11/29/2023 12:40:55], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2023-11-29 12:40:55' WHERE id= '163';
[11/29/2023 12:41:05], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],UPDATE user_sessions_ip SET update_date = '2023-11-29 12:41:05' WHERE id= '163';
[11/29/2023 12:41:05], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Nihal Hotel', 'dubai', '138', '7864', '', '28', '', 'hoteldetails', '2023-11-29 :12:41:05','');
[11/29/2023 12:41:05], [file name :-/home/otrams/public_html/beta/view_map.php],UPDATE user_sessions_ip SET update_date = '2023-11-29 12:41:05' WHERE id= '163';
[11/29/2023 12:41:44], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-29 12:41:44' WHERE id= '163';
[11/29/2023 12:44:23], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-11-29 12:44:23' WHERE id= '163';
[11/29/2023 12:44:27], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2023-11-29 12:44:27' WHERE id= '163';
[11/29/2023 12:44:34], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-11-29 12:44:34' WHERE id= '163';
[11/29/2023 12:44:37], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2023-11-29 12:44:37' WHERE id= '163';
[11/29/2023 12:44:45], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-29 12:44:45' WHERE id= '163';
[11/29/2023 12:47:06], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-11-29 12:47:06' WHERE id= '163';
[11/29/2023 12:47:08], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2023-11-29 12:47:08' WHERE id= '163';
[11/29/2023 12:47:11], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-29 12:47:11' WHERE id= '163';
[11/29/2023 12:47:22], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],UPDATE user_sessions_ip SET update_date = '2023-11-29 12:47:22' WHERE id= '163';
[11/29/2023 12:47:22], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Nihal Hotel', 'dubai', '138', '7864', '', '28', '', 'hoteldetails', '2023-11-29 :12:47:22','');
[11/29/2023 12:47:22], [file name :-/home/otrams/public_html/beta/view_map.php],UPDATE user_sessions_ip SET update_date = '2023-11-29 12:47:22' WHERE id= '163';
[11/29/2023 12:48:29], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-11-29 12:48:29' WHERE id= '163';
[11/29/2023 12:48:31], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2023-11-29 12:48:31' WHERE id= '163';
[11/29/2023 12:50:40], [file name :-/home/otrams/public_html/beta/manage_sub_user.php],UPDATE user_sessions_ip SET update_date = '2023-11-29 12:50:40' WHERE id= '175';
[11/29/2023 12:50:46], [file name :-/home/otrams/public_html/beta/manage_sub_user.php],UPDATE user_sessions_ip SET update_date = '2023-11-29 12:50:46' WHERE id= '175';
[11/29/2023 12:50:46], [file name :-/home/otrams/public_html/beta/manage_sub_user.php],update sub_user SET first_name='shiv',middle_name='qtech',last_name='chuhan',address='mumbai',city='64440',country='106',phone='     91-92929292929',mobile='     91-92929292929',designation='opreating staff',can_book='',can_voucher='',view_all_bookings='1',allow_book_under_cancellation='',modify_date='2023-11-29 12:50:46',email='shiv.chauhan@qtechsoftware.com',status='A'where sub_user_id='1';
[11/29/2023 12:50:47], [file name :-/home/otrams/public_html/beta/manage_sub_user.php],UPDATE user_sessions_ip SET update_date = '2023-11-29 12:50:47' WHERE id= '175';
[11/29/2023 12:50:49], [file name :-/home/otrams/public_html/beta/manage_sub_user.php],UPDATE user_sessions_ip SET update_date = '2023-11-29 12:50:49' WHERE id= '175';
[11/29/2023 12:54:18], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2023-11-29 12:54:18',login_attempt=0 where id = '7857';
[11/29/2023 12:54:18], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Deepak_T', user_type = 'A', branch_id = '28', login_datetime = '2023-11-29 12:54:18', ip = '43.239.53.130', action = 'Login' ;
[11/29/2023 12:54:18], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-11-29 12:54:18' WHERE id= '173';
[11/29/2023 12:54:23], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-29 12:54:23' WHERE id= '173';
[11/29/2023 12:54:34], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-29 12:54:34' WHERE id= '173';
[11/29/2023 12:54: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 = '28' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '434' , service_type = 'hotel' , arrival_date = '2023/12/05' , departure_date = '2023/12/07' , nights = '2' , nationality = '434' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2023-11-29 12:54:34' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '1.0,2.0,3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[11/29/2023 12:54:34], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2023-11-29 12:54:34' WHERE id= '173';
[11/29/2023 12:54:35], [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/29_11_2023/request_availability_Deepak_T_12_54_34_1701262474_40.json', 'e1p/29_11_2023/response_availability_Deepak_T_12_54_34_1701262474_40.json', 'e1p/29_11_2023/response_header_availability_Deepak_T_12_54_34_1701262474_40.json', 'expediapackage', '2023-11-29 12:54:35', '', 'f862aff040025487909d7be65784445233da6c2d25e8b04190b2460e380e86c5', '0');
[11/29/2023 12:54:35], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=f862aff040025487909d7be65784445233da6c2d25e8b04190b2460e380e86c5&xml_user_id=7857&db_caching=1&erequest=2&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-29 12:54:34.890'
            , 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.302'
            , error_description = ''
            , memory_used = '3329096'
            WHERE id = '15808';
[11/29/2023 12:54:35], [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/29_11_2023/request_availability_Deepak_T_12_54_34_1701262474_10.json', 'e1/29_11_2023/response_availability_Deepak_T_12_54_34_1701262474_10.json', 'e1/29_11_2023/response_header_availability_Deepak_T_12_54_34_1701262474_10.json', 'expedia', '2023-11-29 12:54:35', '', 'f862aff040025487909d7be65784445233da6c2d25e8b04190b2460e380e86c5', '0');
[11/29/2023 12:54:35], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=f862aff040025487909d7be65784445233da6c2d25e8b04190b2460e380e86c5&xml_user_id=7857&db_caching=1&erequest=2&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-29 12:54:34.890'
            , 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.357'
            , error_description = ''
            , memory_used = '3328392'
            WHERE id = '15809';
[11/29/2023 12:54:36], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/29_11_2023/request_availability_Deepak_T_12_54_34_1701262474_75.json', 'e1/29_11_2023/response_availability_Deepak_T_12_54_34_1701262474_75.json', 'e1/29_11_2023/response_header_availability_Deepak_T_12_54_34_1701262474_75.json', 'expedia', '2023-11-29 12:54:36', '', 'f862aff040025487909d7be65784445233da6c2d25e8b04190b2460e380e86c5', '0');
[11/29/2023 12:54:36], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/29_11_2023/request_availability_Deepak_T_12_54_34_1701262474_56.json', 'e1/29_11_2023/response_availability_Deepak_T_12_54_34_1701262474_56.json', 'e1/29_11_2023/response_header_availability_Deepak_T_12_54_34_1701262474_56.json', 'expedia', '2023-11-29 12:54:36', '', 'f862aff040025487909d7be65784445233da6c2d25e8b04190b2460e380e86c5', '0');
[11/29/2023 12:54:36], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/29_11_2023/request_availability_Deepak_T_12_54_34_1701262474_33.json', 'e1p/29_11_2023/response_availability_Deepak_T_12_54_34_1701262474_33.json', 'e1p/29_11_2023/response_header_availability_Deepak_T_12_54_34_1701262474_33.json', 'expediapackage', '2023-11-29 12:54:36', '', 'f862aff040025487909d7be65784445233da6c2d25e8b04190b2460e380e86c5', '0');
[11/29/2023 12:54:37], [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/29_11_2023/request_availability_Deepak_T_12_54_34_1701262474_5.json', 'e1p/29_11_2023/response_availability_Deepak_T_12_54_34_1701262474_5.json', 'e1p/29_11_2023/response_header_availability_Deepak_T_12_54_34_1701262474_5.json', 'expediapackage', '2023-11-29 12:54:37', '', 'f862aff040025487909d7be65784445233da6c2d25e8b04190b2460e380e86c5', '0');
[11/29/2023 12:54:37], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=f862aff040025487909d7be65784445233da6c2d25e8b04190b2460e380e86c5&xml_user_id=7857&db_caching=1&erequest=1&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-29 12:54:34.890'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '2.390'
            , error_description = ''
            , memory_used = '131491328'
            WHERE id = '15810';
[11/29/2023 12:54:37], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=f862aff040025487909d7be65784445233da6c2d25e8b04190b2460e380e86c5&xml_user_id=7857&db_caching=1&erequest=0&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-29 12:54:34.890'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '2.919'
            , error_description = ''
            , memory_used = '132319352'
            WHERE id = '15811';
[11/29/2023 12:54:37], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=f862aff040025487909d7be65784445233da6c2d25e8b04190b2460e380e86c5&xml_user_id=7857&db_caching=1&erequest=0&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-29 12:54:34.890'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '2.971'
            , error_description = ''
            , memory_used = '138059744'
            WHERE id = '15812';
[11/29/2023 12:54:38], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=f862aff040025487909d7be65784445233da6c2d25e8b04190b2460e380e86c5&xml_user_id=7857&db_caching=1&erequest=1&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-29 12:54:34.890'
            , 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.318'
            , error_description = ''
            , memory_used = '138801440'
            WHERE id = '15813';
[11/29/2023 12:54:38], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-11-29 12:54:38' WHERE id= '173';
[11/29/2023 12:54:40], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2023-11-29 12:54:40' WHERE id= '173';
[11/29/2023 12:54:43], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-29 12:54:43' WHERE id= '173';
[11/29/2023 12:55:42], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-29 12:55:42' WHERE id= '173';
[11/29/2023 12:55:42], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-29 12:55:42' WHERE id= '173';
[11/29/2023 12:55:43], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-29 12:55:43' WHERE id= '173';
[11/29/2023 12:55:47], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-29 12:55:47' WHERE id= '173';
[11/29/2023 12:55:47], [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 = '28' , ip = '43.239.53.130' , city = 'cairo' , service_name = '' , country_of_residence = '434' , service_type = 'hotel' , arrival_date = '2023/12/05' , departure_date = '2023/12/07' , nights = '2' , nationality = '434' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2023-11-29 12:55:47' , site_id = '' , country_code = '155' , city_code = '72637' , ratings = '1.0,2.0,3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[11/29/2023 12:55:48], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2023-11-29 12:55:48' WHERE id= '173';
[11/29/2023 12:55:48], [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/29_11_2023/request_availability_Deepak_T_12_55_48_1701262548_54.json', 'e1/29_11_2023/response_availability_Deepak_T_12_55_48_1701262548_54.json', 'e1/29_11_2023/response_header_availability_Deepak_T_12_55_48_1701262548_54.json', 'expedia', '2023-11-29 12:55:48', '', 'f862aff040025487909d7be65784445233da6c2d25e8b04190b2460e380e86c5', '0');
[11/29/2023 12:55:48], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=f862aff040025487909d7be65784445233da6c2d25e8b04190b2460e380e86c5&xml_user_id=7857&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-29 12:55:48.786'
            , 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.207'
            , error_description = ''
            , memory_used = '3328704'
            WHERE id = '15814';
[11/29/2023 12:55:49], [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/29_11_2023/request_availability_Deepak_T_12_55_48_1701262548_44.json', 'e1p/29_11_2023/response_availability_Deepak_T_12_55_48_1701262548_44.json', 'e1p/29_11_2023/response_header_availability_Deepak_T_12_55_48_1701262548_44.json', 'expediapackage', '2023-11-29 12:55:49', '', 'f862aff040025487909d7be65784445233da6c2d25e8b04190b2460e380e86c5', '0');
[11/29/2023 12:55:49], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=f862aff040025487909d7be65784445233da6c2d25e8b04190b2460e380e86c5&xml_user_id=7857&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-29 12:55:48.786'
            , 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.361'
            , error_description = ''
            , memory_used = '3329608'
            WHERE id = '15815';
[11/29/2023 12:55:49], [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/29_11_2023/request_availability_Deepak_T_12_55_48_1701262548_30.json', 'e1/29_11_2023/response_availability_Deepak_T_12_55_48_1701262548_30.json', 'e1/29_11_2023/response_header_availability_Deepak_T_12_55_48_1701262548_30.json', 'expedia', '2023-11-29 12:55:49', '', 'f862aff040025487909d7be65784445233da6c2d25e8b04190b2460e380e86c5', '0');
[11/29/2023 12:55:50], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=f862aff040025487909d7be65784445233da6c2d25e8b04190b2460e380e86c5&xml_user_id=7857&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-29 12:55:48.786'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.530'
            , error_description = ''
            , memory_used = '58477624'
            WHERE id = '15816';
[11/29/2023 12:55:50], [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/29_11_2023/request_availability_Deepak_T_12_55_48_1701262548_12.json', 'e1p/29_11_2023/response_availability_Deepak_T_12_55_48_1701262548_12.json', 'e1p/29_11_2023/response_header_availability_Deepak_T_12_55_48_1701262548_12.json', 'expediapackage', '2023-11-29 12:55:50', '', 'f862aff040025487909d7be65784445233da6c2d25e8b04190b2460e380e86c5', '0');
[11/29/2023 12:55:51], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=f862aff040025487909d7be65784445233da6c2d25e8b04190b2460e380e86c5&xml_user_id=7857&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-29 12:55:48.786'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '2.502'
            , error_description = ''
            , memory_used = '65128336'
            WHERE id = '15817';
[11/29/2023 12:55:51], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-11-29 12:55:51' WHERE id= '173';
[11/29/2023 12:55:53], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2023-11-29 12:55:53' WHERE id= '173';
[11/29/2023 12:55:59], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],UPDATE user_sessions_ip SET update_date = '2023-11-29 12:55:59' WHERE id= '173';
[11/29/2023 12:55:59], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Number One Pyramids Hotel', 'cairo', '155', '7857', '', '28', '', 'hoteldetails', '2023-11-29 :12:55:59','');
[11/29/2023 12:55:59], [file name :-/home/otrams/public_html/beta/view_map.php],UPDATE user_sessions_ip SET update_date = '2023-11-29 12:55:59' WHERE id= '173';
[11/29/2023 12:56:17], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-29 12:56:17' WHERE id= '173';
