[02/12/2024 09:14:03], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-12 09:14:03',login_attempt=0 where id = '7870';
[02/12/2024 09:14:03], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'hotelyards-agent', user_type = 'A', branch_id = '32', login_datetime = '2024-02-12 09:14:03', ip = '43.239.53.130', action = 'Login' ;
[02/12/2024 09:14: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='7867', session_id='8a5a74a9c1babdffc705b5f11499fe72f851003d1b38925032096594031dc096',create_date='2024-02-12 09:14:04', update_date='2024-02-12 09:14:04',domain='hotelyards.astrabookings.com',sub_agent_id='',sub_user_id='';
[02/12/2024 09:14:16], [file name :-/home/otrams/public_html/beta/logout.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:14:16' WHERE id= '545';
[02/12/2024 09:19:10], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-12 09:19:10',login_attempt=0 where id = '7849';
[02/12/2024 09:19:10], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'shiv_qtech', user_type = 'A', branch_id = '24', login_datetime = '2024-02-12 09:19:10', ip = '43.239.53.130', action = 'Login' ;
[02/12/2024 09:19:10], [file name :-/home/otrams/public_html/beta/hotel_search.php],insert into user_sessions_ip SET ip_addr='43.239.53.130', agent_id='7849', session_id='d6410948bbc78584bbc2e9d096d4dedcbf29dbf853aa856ec926139a05f3720b',create_date='2024-02-12 09:19:10', update_date='2024-02-12 09:19:10',domain='beta.astrabookings.com',sub_agent_id='',sub_user_id='';
[02/12/2024 09:19:13], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:19:13' WHERE id= '546';
[02/12/2024 09:19:15], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:19:15' WHERE id= '546';
[02/12/2024 09:19:26], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:19:26' WHERE id= '546';
[02/12/2024 09:19:39], [file name :-/home/otrams/public_html/beta/booking_list_sight.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:19:39' WHERE id= '546';
[02/12/2024 09:19:51], [file name :-/home/otrams/public_html/beta/print_voucher_sight.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:19:51' WHERE id= '546';
[02/12/2024 09:20:07], [file name :-/home/otrams/public_html/beta/print_voucher_sight.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:20:07' WHERE id= '546';
[02/12/2024 09:22:59], [file name :-/home/otrams/public_html/beta/print_invoice.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:22:59' WHERE id= '546';
[02/12/2024 09:23:07], [file name :-/home/otrams/public_html/beta/print_voucher_sight.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:23:07' WHERE id= '546';
[02/12/2024 09:23:09], [file name :-/home/otrams/public_html/beta/agent_registration.php],INSERT INTO agents(ip_addr,admin_id,agency_name,first_name,middle_name,last_name,agent_type,
		sort_type,credit_value,credit_usage,address,city,pincode,country,time_zone_offset,enable_dst,
		phone,mobile,fax,email,website,username,designation,iata_status,iata_number,nature_of_business,
		logo,lead_time,password,currency,status,create_date,modify_date,debug,is_super_user,branch_id,parent_agent,can_book,acc_name,acc_email,acc_phone,man_name,man_email,man_phone,res_name,res_email,comp_reg_no,res_phone,referer)
		VALUES('43.239.53.130', 'qtech', 'qtech', 'deepak', '', 'trivedi', 'CS', '', '', '0', 'dubai', '71650', '23456', '138', '2', '', '91-1234567899', '91-987654321', '', 'deepak.trivedi@qtechosftware.com', '123.coh', 'bahvesh', '', '', '', 'Tour Operator', '', '', '140696a95d1eccc972e476083219014c8553cd19f245ce1a04b27ee9b6e52a2f', '6', 'P', '2024-02-12 09:23:09', '', '', '1', '32', '', '', 'DEEPAK', 'deepak.trivedi@qtechsoftware.com', '123456987654', '', '', '', '', '', '12345', '', 'https://hotelyards.astrabookings.com/agent_registration.php');
[02/12/2024 09:23:09], [file name :-/home/otrams/public_html/beta/agent_registration.php],update agents set site_id ='21',  wh_main_agent ='7867', branch_id ='32', wh_agent ='yes' where id ='7872' ;
[02/12/2024 09:23:11], [file name :-/home/otrams/public_html/beta/print_invoice.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:23:11' WHERE id= '546';
[02/12/2024 09:23:22], [file name :-/home/otrams/public_html/beta/print_voucher_sight.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:23:22' WHERE id= '546';
[02/12/2024 09:23:54], [file name :-/home/otrams/public_html/beta/print_voucher_sight.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:23:54' WHERE id= '546';
[02/12/2024 09:26:46], [file name :-/home/otrams/public_html/beta/booking_list_sight.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:26:46' WHERE id= '546';
[02/12/2024 09:26:53], [file name :-/home/otrams/public_html/beta/print_voucher_sight.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:26:53' WHERE id= '546';
[02/12/2024 09:27:20], [file name :-/home/otrams/public_html/beta/print_voucher_sight.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:27:20' WHERE id= '546';
[02/12/2024 09:28:07], [file name :-/home/otrams/public_html/beta/print_voucher_sight.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:28:07' WHERE id= '546';
[02/12/2024 09:30:18], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-12 09:30:18',login_attempt=0 where id = '7870';
[02/12/2024 09:30:18], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'hotelyards-agent', user_type = 'A', branch_id = '32', login_datetime = '2024-02-12 09:30:18', ip = '43.239.53.130', action = 'Login' ;
[02/12/2024 09:30:19], [file name :-/home/otrams/public_html/beta/hotel_search.php],insert into user_sessions_ip SET ip_addr='43.239.53.130', agent_id='7867', session_id='f0584f1e2960541446dede532d977ab8609e257293c1762adc9d08709d404238',create_date='2024-02-12 09:30:19', update_date='2024-02-12 09:30:19',domain='hotelyards.astrabookings.com',sub_agent_id='',sub_user_id='';
[02/12/2024 09:31:52], [file name :-/home/otrams/public_html/beta/ajax/ajax_child_structure.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:31:52' WHERE id= '547';
[02/12/2024 09:31:52], [file name :-/home/otrams/public_html/beta/ajax/ajax_child_structure.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:31:52' WHERE id= '547';
[02/12/2024 09:31:56], [file name :-/home/otrams/public_html/beta/ajax/ajax_child_structure.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:31:56' WHERE id= '547';
[02/12/2024 09:31:59], [file name :-/home/otrams/public_html/beta/ajax/ajax_child_structure.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:31:59' WHERE id= '547';
[02/12/2024 09:32:01], [file name :-/home/otrams/public_html/beta/ajax/ajax_child_structure.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:32:01' WHERE id= '547';
[02/12/2024 09:32:05], [file name :-/home/otrams/public_html/beta/ajax/ajax_child_structure.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:32:05' WHERE id= '547';
[02/12/2024 09:32:07], [file name :-/home/otrams/public_html/beta/ajax/ajax_child_structure.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:32:07' WHERE id= '547';
[02/12/2024 09:32:35], [file name :-/home/otrams/public_html/beta/ajax/ajax_child_structure.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:32:35' WHERE id= '547';
[02/12/2024 09:32:46], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:32:46' WHERE id= '547';
[02/12/2024 09:33:01], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:33:01' WHERE id= '547';
[02/12/2024 09:36:10], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:36:10' WHERE id= '547';
[02/12/2024 09:36:26], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:36:26' WHERE id= '547';
[02/12/2024 09:37:16], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:37:16' WHERE id= '547';
[02/12/2024 09:37:16], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7870' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '32' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '138' , service_type = 'hotel' , arrival_date = '2024/02/12' , departure_date = '2024/02/13' , nights = '1' , nationality = '95' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-02-12 09:37:16' , site_id = '21' , 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 = '' ;
[02/12/2024 09:37:17], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:37:17' WHERE id= '547';
[02/12/2024 09:37:17], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-12 09:37:17.767'
                , total_duration = '0.029'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-12 09:37:17'
                , session_id = 'f0584f1e2960541446dede532d977ab8609e257293c1762adc9d08709d404238'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2886752';
[02/12/2024 09:37:17], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-12 09:37:17.767'
                , total_duration = '0.030'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-12 09:37:17'
                , session_id = 'f0584f1e2960541446dede532d977ab8609e257293c1762adc9d08709d404238'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2886576';
[02/12/2024 09:37:17], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-12 09:37:17.767'
                , total_duration = '0.030'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-12 09:37:17'
                , session_id = 'f0584f1e2960541446dede532d977ab8609e257293c1762adc9d08709d404238'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2886576';
[02/12/2024 09:37:17], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-12 09:37:17.767'
                , total_duration = '0.030'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-12 09:37:17'
                , session_id = 'f0584f1e2960541446dede532d977ab8609e257293c1762adc9d08709d404238'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2886752';
[02/12/2024 09:37:17], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-12 09:37:17.767'
                , total_duration = '0.030'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-12 09:37:17'
                , session_id = 'f0584f1e2960541446dede532d977ab8609e257293c1762adc9d08709d404238'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2886576';
[02/12/2024 09:37:17], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-12 09:37:17.767'
                , total_duration = '0.032'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-12 09:37:17'
                , session_id = 'f0584f1e2960541446dede532d977ab8609e257293c1762adc9d08709d404238'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2886752';
[02/12/2024 09:37:17], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-12 09:37:17.767'
                , total_duration = '0.084'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-12 09:37:17'
                , session_id = 'f0584f1e2960541446dede532d977ab8609e257293c1762adc9d08709d404238'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2886576';
[02/12/2024 09:37: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/12_02_2024/request_availability_hotel_yards_09_37_17_1707730637_4.json', 'e1/12_02_2024/response_availability_hotel_yards_09_37_17_1707730637_4.json', 'e1/12_02_2024/response_header_availability_hotel_yards_09_37_17_1707730637_4.json', 'expedia', '2024-02-12 09:37:18', '', 'f0584f1e2960541446dede532d977ab8609e257293c1762adc9d08709d404238', '0');
[02/12/2024 09:37:18], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=f0584f1e2960541446dede532d977ab8609e257293c1762adc9d08709d404238&xml_user_id=7867&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=95'
            , http_hit_time = '2024-02-12 09:37:17.767'
            , 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.535'
            , error_description = ''
            , memory_used = '2726360'
            WHERE id = '32854';
[02/12/2024 09:37: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/12_02_2024/request_availability_hotel_yards_09_37_17_1707730637_43.json', 'e1/12_02_2024/response_availability_hotel_yards_09_37_17_1707730637_43.json', 'e1/12_02_2024/response_header_availability_hotel_yards_09_37_17_1707730637_43.json', 'expedia', '2024-02-12 09:37:18', '', 'f0584f1e2960541446dede532d977ab8609e257293c1762adc9d08709d404238', '0');
[02/12/2024 09:37: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/12_02_2024/request_availability_hotel_yards_09_37_17_1707730637_50.json', 'e1/12_02_2024/response_availability_hotel_yards_09_37_17_1707730637_50.json', 'e1/12_02_2024/response_header_availability_hotel_yards_09_37_17_1707730637_50.json', 'expedia', '2024-02-12 09:37:18', '', 'f0584f1e2960541446dede532d977ab8609e257293c1762adc9d08709d404238', '0');
[02/12/2024 09:37:19], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=f0584f1e2960541446dede532d977ab8609e257293c1762adc9d08709d404238&xml_user_id=7867&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=95'
            , http_hit_time = '2024-02-12 09:37:17.767'
            , 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.788'
            , error_description = ''
            , memory_used = '69759720'
            WHERE id = '32856';
[02/12/2024 09:37:19], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=f0584f1e2960541446dede532d977ab8609e257293c1762adc9d08709d404238&xml_user_id=7867&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=95'
            , http_hit_time = '2024-02-12 09:37:17.767'
            , 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.794'
            , error_description = ''
            , memory_used = '73040752'
            WHERE id = '32855';
[02/12/2024 09:37:19], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:37:19' WHERE id= '547';
[02/12/2024 09:38:02], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:38:02' WHERE id= '547';
[02/12/2024 09:38:03], [file name :-/home/otrams/public_html/beta/view_map.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:38:03' WHERE id= '547';
[02/12/2024 09:42:23], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:42:23' WHERE id= '547';
[02/12/2024 09:42:47], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:42:47' WHERE id= '547';
[02/12/2024 09:42:47], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-12 09:42:47',login_attempt=0 where id = '7870';
[02/12/2024 09:42:47], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'hotelyards-agent', user_type = 'A', branch_id = '32', login_datetime = '2024-02-12 09:42:47', ip = '43.239.53.130', action = 'Login' ;
[02/12/2024 09:42:47], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:42:47' WHERE id= '547';
[02/12/2024 09:42:52], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:42:52' WHERE id= '547';
[02/12/2024 09:42:53], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:42:53' WHERE id= '547';
[02/12/2024 09:42:54], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:42:54' WHERE id= '547';
[02/12/2024 09:42:57], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:42:57' WHERE id= '547';
[02/12/2024 09:42:57], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7870' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '32' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '95' , service_type = 'hotel' , arrival_date = '2024/02/12' , departure_date = '2024/02/13' , nights = '1' , nationality = '95' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-02-12 09:42:57' , site_id = '21' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[02/12/2024 09:42:58], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:42:58' WHERE id= '547';
[02/12/2024 09:42:58], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-12 09:42:58.427'
                , total_duration = '0.019'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-12 09:42:58'
                , session_id = 'f0584f1e2960541446dede532d977ab8609e257293c1762adc9d08709d404238'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2886128';
[02/12/2024 09:42:58], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-12 09:42:58.427'
                , total_duration = '0.019'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-12 09:42:58'
                , session_id = 'f0584f1e2960541446dede532d977ab8609e257293c1762adc9d08709d404238'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2886352';
[02/12/2024 09:42:58], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-12 09:42:58.427'
                , total_duration = '0.020'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-12 09:42:58'
                , session_id = 'f0584f1e2960541446dede532d977ab8609e257293c1762adc9d08709d404238'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2886352';
[02/12/2024 09:42:58], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-12 09:42:58.427'
                , total_duration = '0.021'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-12 09:42:58'
                , session_id = 'f0584f1e2960541446dede532d977ab8609e257293c1762adc9d08709d404238'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2886352';
[02/12/2024 09:42:58], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-12 09:42:58.427'
                , total_duration = '0.020'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-12 09:42:58'
                , session_id = 'f0584f1e2960541446dede532d977ab8609e257293c1762adc9d08709d404238'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2886520';
[02/12/2024 09:42:58], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-12 09:42:58.427'
                , total_duration = '0.025'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-12 09:42:58'
                , session_id = 'f0584f1e2960541446dede532d977ab8609e257293c1762adc9d08709d404238'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2886352';
[02/12/2024 09:42: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/12_02_2024/request_availability_hotel_yards_09_42_58_1707730978_34.json', 'e1/12_02_2024/response_availability_hotel_yards_09_42_58_1707730978_34.json', 'e1/12_02_2024/response_header_availability_hotel_yards_09_42_58_1707730978_34.json', 'expedia', '2024-02-12 09:42:58', '', 'f0584f1e2960541446dede532d977ab8609e257293c1762adc9d08709d404238', '0');
[02/12/2024 09:42:58], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=f0584f1e2960541446dede532d977ab8609e257293c1762adc9d08709d404238&xml_user_id=7867&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=95'
            , http_hit_time = '2024-02-12 09:42:58.427'
            , 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.223'
            , error_description = ''
            , memory_used = '2726400'
            WHERE id = '32863';
[02/12/2024 09:42: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/12_02_2024/request_availability_hotel_yards_09_42_58_1707730978_80.json', 'e1/12_02_2024/response_availability_hotel_yards_09_42_58_1707730978_80.json', 'e1/12_02_2024/response_header_availability_hotel_yards_09_42_58_1707730978_80.json', 'expedia', '2024-02-12 09:42:59', '', 'f0584f1e2960541446dede532d977ab8609e257293c1762adc9d08709d404238', '0');
[02/12/2024 09:42: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/12_02_2024/request_availability_hotel_yards_09_42_58_1707730978_34.json', 'e1/12_02_2024/response_availability_hotel_yards_09_42_58_1707730978_34.json', 'e1/12_02_2024/response_header_availability_hotel_yards_09_42_58_1707730978_34.json', 'expedia', '2024-02-12 09:42:59', '', 'f0584f1e2960541446dede532d977ab8609e257293c1762adc9d08709d404238', '0');
[02/12/2024 09:43:00], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=f0584f1e2960541446dede532d977ab8609e257293c1762adc9d08709d404238&xml_user_id=7867&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=95'
            , http_hit_time = '2024-02-12 09:42:58.427'
            , 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.753'
            , error_description = ''
            , memory_used = '72962368'
            WHERE id = '32864';
[02/12/2024 09:43:00], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=f0584f1e2960541446dede532d977ab8609e257293c1762adc9d08709d404238&xml_user_id=7867&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=95'
            , http_hit_time = '2024-02-12 09:42:58.427'
            , 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.984'
            , error_description = ''
            , memory_used = '66784416'
            WHERE id = '32865';
[02/12/2024 09:43:00], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:43:00' WHERE id= '547';
[02/12/2024 09:43:20], [file name :-/home/otrams/public_html/beta/ajax/ajax_child_structure.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:43:20' WHERE id= '547';
[02/12/2024 09:48:57], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-12 09:48:57',login_attempt=0 where id = '7870';
[02/12/2024 09:48:57], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'hotelyards-agent', user_type = 'A', branch_id = '32', login_datetime = '2024-02-12 09:48:57', ip = '43.239.53.130', action = 'Login' ;
[02/12/2024 09:48:57], [file name :-/home/otrams/public_html/beta/hotel_search.php],insert into user_sessions_ip SET ip_addr='43.239.53.130', agent_id='7867', session_id='f16215eb57d694fb51f1293f3e41da0d8d6d523cf3b4407f53188bf6e4a9d25d',create_date='2024-02-12 09:48:57', update_date='2024-02-12 09:48:57',domain='hotelyards.astrabookings.com',sub_agent_id='',sub_user_id='';
[02/12/2024 09:49:06], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:49:06' WHERE id= '548';
[02/12/2024 09:49:20], [file name :-/home/otrams/public_html/beta/my_accounts.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:49:20' WHERE id= '548';
[02/12/2024 09:49:22], [file name :-/home/otrams/public_html/beta/edit_profile.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:49:22' WHERE id= '548';
[02/12/2024 09:49:42], [file name :-/home/otrams/public_html/beta/edit_profile.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:49:42' WHERE id= '548';
[02/12/2024 09:49:45], [file name :-/home/otrams/public_html/beta/agent_registration.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:49:45' WHERE id= '548';
[02/12/2024 09:50:05], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-12 09:50:05',login_attempt=0 where id = '7870';
[02/12/2024 09:50:05], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'hotelyards-agent', user_type = 'A', branch_id = '32', login_datetime = '2024-02-12 09:50:05', ip = '43.239.53.130', action = 'Login' ;
[02/12/2024 09:50:05], [file name :-/home/otrams/public_html/beta/hotel_search.php],insert into user_sessions_ip SET ip_addr='43.239.53.130', agent_id='7867', session_id='06447bb96c064cb448158eb38c5f062c5072c0203f2e8ac17818eac7ac5e636f',create_date='2024-02-12 09:50:05', update_date='2024-02-12 09:50:05',domain='hotelyards.astrabookings.com',sub_agent_id='',sub_user_id='';
[02/12/2024 09:50:11], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:50:11' WHERE id= '549';
[02/12/2024 09:50:14], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:50:14' WHERE id= '549';
[02/12/2024 09:50:42], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:50:42' WHERE id= '547';
[02/12/2024 09:50:42], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7870' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '32' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '95' , service_type = 'hotel' , arrival_date = '2024/02/12' , departure_date = '2024/02/13' , nights = '1' , nationality = '95' , room_types = '1.3' , room_type='[{"numberOfAdults":1,"numberOfChild":3,"ChildAge":"1,1,1"}]' , available='0' , create_date = '2024-02-12 09:50:42' , site_id = '21' , country_code = '138' , city_code = '71649' , ratings = '1.0,2.0,3.0,4.0,5.0' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[02/12/2024 09:50:43], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:50:43' WHERE id= '547';
[02/12/2024 09:50:43], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-12 09:50:43.757'
                , total_duration = '0.020'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-12 09:50:43'
                , session_id = 'f0584f1e2960541446dede532d977ab8609e257293c1762adc9d08709d404238'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2888032';
[02/12/2024 09:50:43], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-12 09:50:43.758'
                , total_duration = '0.021'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-12 09:50:43'
                , session_id = 'f0584f1e2960541446dede532d977ab8609e257293c1762adc9d08709d404238'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2888112';
[02/12/2024 09:50:43], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-12 09:50:43.757'
                , total_duration = '0.022'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-12 09:50:43'
                , session_id = 'f0584f1e2960541446dede532d977ab8609e257293c1762adc9d08709d404238'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2888112';
[02/12/2024 09:50:43], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-12 09:50:43.758'
                , total_duration = '0.022'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-12 09:50:43'
                , session_id = 'f0584f1e2960541446dede532d977ab8609e257293c1762adc9d08709d404238'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2888112';
[02/12/2024 09:50:43], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-12 09:50:43.757'
                , total_duration = '0.023'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-12 09:50:43'
                , session_id = 'f0584f1e2960541446dede532d977ab8609e257293c1762adc9d08709d404238'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2888112';
[02/12/2024 09:50:43], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-12 09:50:43.757'
                , total_duration = '0.031'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-12 09:50:43'
                , session_id = 'f0584f1e2960541446dede532d977ab8609e257293c1762adc9d08709d404238'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2888096';
[02/12/2024 09:50:44], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/12_02_2024/request_availability_hotel_yards_09_50_43_1707731443_56.json', 'e1/12_02_2024/response_availability_hotel_yards_09_50_43_1707731443_56.json', 'e1/12_02_2024/response_header_availability_hotel_yards_09_50_43_1707731443_56.json', 'expedia', '2024-02-12 09:50:44', '', 'f0584f1e2960541446dede532d977ab8609e257293c1762adc9d08709d404238', '0');
[02/12/2024 09:50:44], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/12_02_2024/request_availability_hotel_yards_09_50_43_1707731443_20.json', 'e1/12_02_2024/response_availability_hotel_yards_09_50_43_1707731443_20.json', 'e1/12_02_2024/response_header_availability_hotel_yards_09_50_43_1707731443_20.json', 'expedia', '2024-02-12 09:50:44', '', 'f0584f1e2960541446dede532d977ab8609e257293c1762adc9d08709d404238', '0');
[02/12/2024 09:50:44], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=f0584f1e2960541446dede532d977ab8609e257293c1762adc9d08709d404238&xml_user_id=7867&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F110.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=95'
            , http_hit_time = '2024-02-12 09:50:43.758'
            , 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.761'
            , error_description = ''
            , memory_used = '18650064'
            WHERE id = '32872';
[02/12/2024 09:50:44], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=f0584f1e2960541446dede532d977ab8609e257293c1762adc9d08709d404238&xml_user_id=7867&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F110.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=95'
            , http_hit_time = '2024-02-12 09:50:43.758'
            , 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.784'
            , error_description = ''
            , memory_used = '8778312'
            WHERE id = '32873';
[02/12/2024 09:50:44], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:50:44' WHERE id= '547';
[02/12/2024 09:50:57], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:50:57' WHERE id= '549';
[02/12/2024 09:50:57], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7870' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '32' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/02/28' , departure_date = '2024/02/29' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-02-12 09:50:57' , site_id = '21' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[02/12/2024 09:50:58], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:50:58' WHERE id= '549';
[02/12/2024 09:50:58], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-12 09:50:58.479'
                , total_duration = '0.022'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-12 09:50:58'
                , session_id = '06447bb96c064cb448158eb38c5f062c5072c0203f2e8ac17818eac7ac5e636f'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2886608';
[02/12/2024 09:50:58], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-12 09:50:58.479'
                , total_duration = '0.022'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-12 09:50:58'
                , session_id = '06447bb96c064cb448158eb38c5f062c5072c0203f2e8ac17818eac7ac5e636f'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2886608';
[02/12/2024 09:50:58], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-12 09:50:58.479'
                , total_duration = '0.022'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-12 09:50:58'
                , session_id = '06447bb96c064cb448158eb38c5f062c5072c0203f2e8ac17818eac7ac5e636f'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2886608';
[02/12/2024 09:50:58], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-12 09:50:58.479'
                , total_duration = '0.024'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-12 09:50:58'
                , session_id = '06447bb96c064cb448158eb38c5f062c5072c0203f2e8ac17818eac7ac5e636f'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2886608';
[02/12/2024 09:50:58], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-12 09:50:58.479'
                , total_duration = '0.025'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-12 09:50:58'
                , session_id = '06447bb96c064cb448158eb38c5f062c5072c0203f2e8ac17818eac7ac5e636f'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2886608';
[02/12/2024 09:50:58], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-12 09:50:58.479'
                , total_duration = '0.026'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-12 09:50:58'
                , session_id = '06447bb96c064cb448158eb38c5f062c5072c0203f2e8ac17818eac7ac5e636f'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2886608';
[02/12/2024 09:50: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/12_02_2024/request_availability_hotel_yards_09_50_58_1707731458_45.json', 'e1/12_02_2024/response_availability_hotel_yards_09_50_58_1707731458_45.json', 'e1/12_02_2024/response_header_availability_hotel_yards_09_50_58_1707731458_45.json', 'expedia', '2024-02-12 09:50:58', '', '06447bb96c064cb448158eb38c5f062c5072c0203f2e8ac17818eac7ac5e636f', '0');
[02/12/2024 09:50:58], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=06447bb96c064cb448158eb38c5f062c5072c0203f2e8ac17818eac7ac5e636f&xml_user_id=7867&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=95'
            , http_hit_time = '2024-02-12 09:50:58.479'
            , 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.386'
            , error_description = ''
            , memory_used = '2726200'
            WHERE id = '32880';
[02/12/2024 09:50: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/12_02_2024/request_availability_hotel_yards_09_50_58_1707731458_33.json', 'e1/12_02_2024/response_availability_hotel_yards_09_50_58_1707731458_33.json', 'e1/12_02_2024/response_header_availability_hotel_yards_09_50_58_1707731458_33.json', 'expedia', '2024-02-12 09:50:59', '', '06447bb96c064cb448158eb38c5f062c5072c0203f2e8ac17818eac7ac5e636f', '0');
[02/12/2024 09:51: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/12_02_2024/request_availability_hotel_yards_09_50_58_1707731458_78.json', 'e1/12_02_2024/response_availability_hotel_yards_09_50_58_1707731458_78.json', 'e1/12_02_2024/response_header_availability_hotel_yards_09_50_58_1707731458_78.json', 'expedia', '2024-02-12 09:51:00', '', '06447bb96c064cb448158eb38c5f062c5072c0203f2e8ac17818eac7ac5e636f', '0');
[02/12/2024 09:51:01], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=06447bb96c064cb448158eb38c5f062c5072c0203f2e8ac17818eac7ac5e636f&xml_user_id=7867&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=95'
            , http_hit_time = '2024-02-12 09:50:58.479'
            , 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.439'
            , error_description = ''
            , memory_used = '171390480'
            WHERE id = '32881';
[02/12/2024 09:51:02], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=06447bb96c064cb448158eb38c5f062c5072c0203f2e8ac17818eac7ac5e636f&xml_user_id=7867&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=95'
            , http_hit_time = '2024-02-12 09:50:58.479'
            , 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.773'
            , error_description = ''
            , memory_used = '151631416'
            WHERE id = '32882';
[02/12/2024 09:51:02], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:51:02' WHERE id= '549';
[02/12/2024 09:51:03], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:51:03' WHERE id= '549';
[02/12/2024 09:51:24], [file name :-/home/otrams/public_html/beta/agent_registration.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:51:24' WHERE id= '548';
[02/12/2024 09:51:25], [file name :-/home/otrams/public_html/beta/edit_profile.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:51:25' WHERE id= '548';
[02/12/2024 09:52:14], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:52:14' WHERE id= '548';
[02/12/2024 09:52:38], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:52:38' WHERE id= '547';
[02/12/2024 09:52:52], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:52:52' WHERE id= '547';
[02/12/2024 09:52:52], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7870' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '32' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '427' , service_type = 'hotel' , arrival_date = '2024/02/12' , departure_date = '2024/02/13' , nights = '1' , nationality = '95' , room_types = '1.3' , room_type='[{"numberOfAdults":1,"numberOfChild":3,"ChildAge":"1,1,1"}]' , available='0' , create_date = '2024-02-12 09:52:52' , site_id = '21' , 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 = '' ;
[02/12/2024 09:52:53], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:52:53' WHERE id= '547';
[02/12/2024 09:52:53], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-12 09:52:53.876'
                , total_duration = '0.020'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-12 09:52:53'
                , session_id = 'f0584f1e2960541446dede532d977ab8609e257293c1762adc9d08709d404238'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2887560';
[02/12/2024 09:52:53], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-12 09:52:53.876'
                , total_duration = '0.020'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-12 09:52:53'
                , session_id = 'f0584f1e2960541446dede532d977ab8609e257293c1762adc9d08709d404238'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2887744';
[02/12/2024 09:52:53], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-12 09:52:53.876'
                , total_duration = '0.020'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-12 09:52:53'
                , session_id = 'f0584f1e2960541446dede532d977ab8609e257293c1762adc9d08709d404238'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2887560';
[02/12/2024 09:52:53], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-12 09:52:53.876'
                , total_duration = '0.020'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-12 09:52:53'
                , session_id = 'f0584f1e2960541446dede532d977ab8609e257293c1762adc9d08709d404238'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2887632';
[02/12/2024 09:52:53], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-12 09:52:53.876'
                , total_duration = '0.021'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-12 09:52:53'
                , session_id = 'f0584f1e2960541446dede532d977ab8609e257293c1762adc9d08709d404238'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2887560';
[02/12/2024 09:52:53], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-12 09:52:53.876'
                , total_duration = '0.022'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-12 09:52:53'
                , session_id = 'f0584f1e2960541446dede532d977ab8609e257293c1762adc9d08709d404238'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2887632';
[02/12/2024 09:52:53], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-12 09:52:53.876'
                , total_duration = '0.023'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-12 09:52:53'
                , session_id = 'f0584f1e2960541446dede532d977ab8609e257293c1762adc9d08709d404238'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2887744';
[02/12/2024 09:52:54], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/12_02_2024/request_availability_hotel_yards_09_52_53_1707731573_56.json', 'e1/12_02_2024/response_availability_hotel_yards_09_52_53_1707731573_56.json', 'e1/12_02_2024/response_header_availability_hotel_yards_09_52_53_1707731573_56.json', 'expedia', '2024-02-12 09:52:54', '', 'f0584f1e2960541446dede532d977ab8609e257293c1762adc9d08709d404238', '0');
[02/12/2024 09:52:54], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=f0584f1e2960541446dede532d977ab8609e257293c1762adc9d08709d404238&xml_user_id=7867&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=95'
            , http_hit_time = '2024-02-12 09:52:53.876'
            , 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.242'
            , error_description = ''
            , memory_used = '2728080'
            WHERE id = '32890';
[02/12/2024 09:52:54], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/12_02_2024/request_availability_hotel_yards_09_52_53_1707731573_31.json', 'e1/12_02_2024/response_availability_hotel_yards_09_52_53_1707731573_31.json', 'e1/12_02_2024/response_header_availability_hotel_yards_09_52_53_1707731573_31.json', 'expedia', '2024-02-12 09:52:54', '', 'f0584f1e2960541446dede532d977ab8609e257293c1762adc9d08709d404238', '0');
[02/12/2024 09:52:54], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/12_02_2024/request_availability_hotel_yards_09_52_53_1707731573_87.json', 'e1/12_02_2024/response_availability_hotel_yards_09_52_53_1707731573_87.json', 'e1/12_02_2024/response_header_availability_hotel_yards_09_52_53_1707731573_87.json', 'expedia', '2024-02-12 09:52:54', '', 'f0584f1e2960541446dede532d977ab8609e257293c1762adc9d08709d404238', '0');
[02/12/2024 09:52:54], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=f0584f1e2960541446dede532d977ab8609e257293c1762adc9d08709d404238&xml_user_id=7867&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=95'
            , http_hit_time = '2024-02-12 09:52:53.876'
            , 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.744'
            , error_description = ''
            , memory_used = '13985128'
            WHERE id = '32891';
[02/12/2024 09:52:54], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=f0584f1e2960541446dede532d977ab8609e257293c1762adc9d08709d404238&xml_user_id=7867&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=95'
            , http_hit_time = '2024-02-12 09:52:53.876'
            , 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.776'
            , error_description = ''
            , memory_used = '16399888'
            WHERE id = '32892';
[02/12/2024 09:52:55], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:52:55' WHERE id= '547';
[02/12/2024 09:53:06], [file name :-/home/otrams/public_html/beta/edit_profile.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:53:06' WHERE id= '548';
[02/12/2024 09:53:06], [file name :-/home/otrams/public_html/beta/agent_registration.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:53:06' WHERE id= '548';
[02/12/2024 09:53:11], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:53:11' WHERE id= '547';
[02/12/2024 09:53:34], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:53:34' WHERE id= '547';
[02/12/2024 09:53:34], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7870' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '32' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '95' , service_type = 'hotel' , arrival_date = '2024/02/12' , departure_date = '2024/02/13' , nights = '1' , nationality = '95' , room_types = '1.3' , room_type='[{"numberOfAdults":1,"numberOfChild":3,"ChildAge":"1,1,1"}]' , available='0' , create_date = '2024-02-12 09:53:34' , site_id = '21' , 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 = '' ;
[02/12/2024 09:53:35], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:53:35' WHERE id= '547';
[02/12/2024 09:53:35], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-12 09:53:35.186'
                , total_duration = '0.018'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-12 09:53:35'
                , session_id = 'f0584f1e2960541446dede532d977ab8609e257293c1762adc9d08709d404238'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2887632';
[02/12/2024 09:53:35], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-12 09:53:35.186'
                , total_duration = '0.018'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-12 09:53:35'
                , session_id = 'f0584f1e2960541446dede532d977ab8609e257293c1762adc9d08709d404238'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2887632';
[02/12/2024 09:53:35], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-12 09:53:35.186'
                , total_duration = '0.021'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-12 09:53:35'
                , session_id = 'f0584f1e2960541446dede532d977ab8609e257293c1762adc9d08709d404238'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2887632';
[02/12/2024 09:53:35], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-12 09:53:35.186'
                , total_duration = '0.022'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-12 09:53:35'
                , session_id = 'f0584f1e2960541446dede532d977ab8609e257293c1762adc9d08709d404238'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2887560';
[02/12/2024 09:53:35], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-12 09:53:35.186'
                , total_duration = '0.023'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-12 09:53:35'
                , session_id = 'f0584f1e2960541446dede532d977ab8609e257293c1762adc9d08709d404238'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2887744';
[02/12/2024 09:53:35], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-12 09:53:35.186'
                , total_duration = '0.023'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-12 09:53:35'
                , session_id = 'f0584f1e2960541446dede532d977ab8609e257293c1762adc9d08709d404238'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2887560';
[02/12/2024 09:53:35], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-12 09:53:35.187'
                , total_duration = '0.100'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-12 09:53:35'
                , session_id = 'f0584f1e2960541446dede532d977ab8609e257293c1762adc9d08709d404238'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2887632';
[02/12/2024 09:53: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/12_02_2024/request_availability_hotel_yards_09_53_35_1707731615_84.json', 'e1/12_02_2024/response_availability_hotel_yards_09_53_35_1707731615_84.json', 'e1/12_02_2024/response_header_availability_hotel_yards_09_53_35_1707731615_84.json', 'expedia', '2024-02-12 09:53:35', '', 'f0584f1e2960541446dede532d977ab8609e257293c1762adc9d08709d404238', '0');
[02/12/2024 09:53:35], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=f0584f1e2960541446dede532d977ab8609e257293c1762adc9d08709d404238&xml_user_id=7867&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=95'
            , http_hit_time = '2024-02-12 09:53:35.187'
            , 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.237'
            , error_description = ''
            , memory_used = '2728080'
            WHERE id = '32900';
[02/12/2024 09:53: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/12_02_2024/request_availability_hotel_yards_09_53_35_1707731615_32.json', 'e1/12_02_2024/response_availability_hotel_yards_09_53_35_1707731615_32.json', 'e1/12_02_2024/response_header_availability_hotel_yards_09_53_35_1707731615_32.json', 'expedia', '2024-02-12 09:53:35', '', 'f0584f1e2960541446dede532d977ab8609e257293c1762adc9d08709d404238', '0');
[02/12/2024 09:53: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/12_02_2024/request_availability_hotel_yards_09_53_35_1707731615_59.json', 'e1/12_02_2024/response_availability_hotel_yards_09_53_35_1707731615_59.json', 'e1/12_02_2024/response_header_availability_hotel_yards_09_53_35_1707731615_59.json', 'expedia', '2024-02-12 09:53:35', '', 'f0584f1e2960541446dede532d977ab8609e257293c1762adc9d08709d404238', '0');
[02/12/2024 09:53:35], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=f0584f1e2960541446dede532d977ab8609e257293c1762adc9d08709d404238&xml_user_id=7867&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=95'
            , http_hit_time = '2024-02-12 09:53:35.186'
            , 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.748'
            , error_description = ''
            , memory_used = '13984896'
            WHERE id = '32902';
[02/12/2024 09:53:35], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=f0584f1e2960541446dede532d977ab8609e257293c1762adc9d08709d404238&xml_user_id=7867&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=95'
            , http_hit_time = '2024-02-12 09:53:35.186'
            , 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.760'
            , error_description = ''
            , memory_used = '16400264'
            WHERE id = '32901';
[02/12/2024 09:53:36], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:53:36' WHERE id= '547';
[02/12/2024 09:53:42], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:53:42' WHERE id= '547';
[02/12/2024 09:54:08], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-12 09:54:08',login_attempt=0 where id = '7864';
[02/12/2024 09:54:08], [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-02-12 09:54:08', ip = '43.239.53.130', action = 'Login' ;
[02/12/2024 09:54:08], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:54:08' WHERE id= '546';
[02/12/2024 09:54:13], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:54:13' WHERE id= '546';
[02/12/2024 09:54:19], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:54:19' WHERE id= '546';
[02/12/2024 09:54:19], [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/02/23' , departure_date = '2024/02/24' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-02-12 09:54:19' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'INR' , currency_code = 'INR' , web_service = '' ;
[02/12/2024 09:54:20], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:54:20' WHERE id= '546';
[02/12/2024 09:54: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', 'ts/12_02_2024/request_availability_being_gajju_09_54_21_17077316612724301.xml', 'ts/12_02_2024/response_availability_being_gajju_09_54_21_17077316612724301.xml', 'ts/12_02_2024/response_header_availability_being_gajju_09_54_21_17077316612724301.xml', 'totalstay', '2024-02-12 09:54:21', '', 'd6410948bbc78584bbc2e9d096d4dedcbf29dbf853aa856ec926139a05f3720b', '0');
[02/12/2024 09:54:21], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=totalstay&sessionid=d6410948bbc78584bbc2e9d096d4dedcbf29dbf853aa856ec926139a05f3720b&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-02-12 09:54:21.142'
            , 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.123'
            , error_description = ''
            , memory_used = '2282648'
            WHERE id = '32903';
[02/12/2024 09:54: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', 'ts/12_02_2024/request_availability_being_gajju_09_54_21_17077316612424281.xml', 'ts/12_02_2024/response_availability_being_gajju_09_54_21_17077316612424281.xml', 'ts/12_02_2024/response_header_availability_being_gajju_09_54_21_17077316612424281.xml', 'totalstay', '2024-02-12 09:54:21', '', 'd6410948bbc78584bbc2e9d096d4dedcbf29dbf853aa856ec926139a05f3720b', '0');
[02/12/2024 09:54:21], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=totalstay&sessionid=d6410948bbc78584bbc2e9d096d4dedcbf29dbf853aa856ec926139a05f3720b&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-02-12 09:54:21.141'
            , 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.135'
            , error_description = ''
            , memory_used = '2339376'
            WHERE id = '32904';
[02/12/2024 09:54: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', 'ts/12_02_2024/request_availability_being_gajju_09_54_21_17077316615624271.xml', 'ts/12_02_2024/response_availability_being_gajju_09_54_21_17077316615624271.xml', 'ts/12_02_2024/response_header_availability_being_gajju_09_54_21_17077316615624271.xml', 'totalstay', '2024-02-12 09:54:21', '', 'd6410948bbc78584bbc2e9d096d4dedcbf29dbf853aa856ec926139a05f3720b', '0');
[02/12/2024 09:54:21], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=totalstay&sessionid=d6410948bbc78584bbc2e9d096d4dedcbf29dbf853aa856ec926139a05f3720b&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-02-12 09:54:21.141'
            , 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.156'
            , error_description = ''
            , memory_used = '2295520'
            WHERE id = '32905';
[02/12/2024 09:54: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', 'ts/12_02_2024/request_availability_being_gajju_09_54_21_17077316617724311.xml', 'ts/12_02_2024/response_availability_being_gajju_09_54_21_17077316617724311.xml', 'ts/12_02_2024/response_header_availability_being_gajju_09_54_21_17077316617724311.xml', 'totalstay', '2024-02-12 09:54:21', '', 'd6410948bbc78584bbc2e9d096d4dedcbf29dbf853aa856ec926139a05f3720b', '0');
[02/12/2024 09:54:21], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=totalstay&sessionid=d6410948bbc78584bbc2e9d096d4dedcbf29dbf853aa856ec926139a05f3720b&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-02-12 09:54:21.142'
            , 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.160'
            , error_description = ''
            , memory_used = '2302712'
            WHERE id = '32906';
[02/12/2024 09:54: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', 'ts/12_02_2024/request_availability_being_gajju_09_54_21_17077316612024280.xml', 'ts/12_02_2024/response_availability_being_gajju_09_54_21_17077316612024280.xml', 'ts/12_02_2024/response_header_availability_being_gajju_09_54_21_17077316612024280.xml', 'totalstay', '2024-02-12 09:54:21', '', 'd6410948bbc78584bbc2e9d096d4dedcbf29dbf853aa856ec926139a05f3720b', '0');
[02/12/2024 09:54:21], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=totalstay&sessionid=d6410948bbc78584bbc2e9d096d4dedcbf29dbf853aa856ec926139a05f3720b&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-02-12 09:54:21.141'
            , 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.166'
            , error_description = ''
            , memory_used = '2352240'
            WHERE id = '32907';
[02/12/2024 09:54: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', 'ts/12_02_2024/request_availability_being_gajju_09_54_21_17077316611224300.xml', 'ts/12_02_2024/response_availability_being_gajju_09_54_21_17077316611224300.xml', 'ts/12_02_2024/response_header_availability_being_gajju_09_54_21_17077316611224300.xml', 'totalstay', '2024-02-12 09:54:21', '', 'd6410948bbc78584bbc2e9d096d4dedcbf29dbf853aa856ec926139a05f3720b', '0');
[02/12/2024 09:54:21], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=totalstay&sessionid=d6410948bbc78584bbc2e9d096d4dedcbf29dbf853aa856ec926139a05f3720b&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-02-12 09:54:21.142'
            , 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.172'
            , error_description = ''
            , memory_used = '2352608'
            WHERE id = '32908';
[02/12/2024 09:54: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', 'ts/12_02_2024/request_availability_being_gajju_09_54_21_17077316619632360.xml', 'ts/12_02_2024/response_availability_being_gajju_09_54_21_17077316619632360.xml', 'ts/12_02_2024/response_header_availability_being_gajju_09_54_21_17077316619632360.xml', 'totalstay', '2024-02-12 09:54:21', '', 'd6410948bbc78584bbc2e9d096d4dedcbf29dbf853aa856ec926139a05f3720b', '0');
[02/12/2024 09:54:21], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=totalstay&sessionid=d6410948bbc78584bbc2e9d096d4dedcbf29dbf853aa856ec926139a05f3720b&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-02-12 09:54:21.142'
            , 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.178'
            , error_description = ''
            , memory_used = '2289208'
            WHERE id = '32909';
[02/12/2024 09:54: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', 'ts/12_02_2024/request_availability_being_gajju_09_54_21_17077316617433730.xml', 'ts/12_02_2024/response_availability_being_gajju_09_54_21_17077316617433730.xml', 'ts/12_02_2024/response_header_availability_being_gajju_09_54_21_17077316617433730.xml', 'totalstay', '2024-02-12 09:54:21', '', 'd6410948bbc78584bbc2e9d096d4dedcbf29dbf853aa856ec926139a05f3720b', '0');
[02/12/2024 09:54:21], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=totalstay&sessionid=d6410948bbc78584bbc2e9d096d4dedcbf29dbf853aa856ec926139a05f3720b&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-02-12 09:54:21.141'
            , 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.184'
            , error_description = ''
            , memory_used = '2308920'
            WHERE id = '32910';
[02/12/2024 09:54: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', 'ts/12_02_2024/request_availability_being_gajju_09_54_21_17077316619724310.xml', 'ts/12_02_2024/response_availability_being_gajju_09_54_21_17077316619724310.xml', 'ts/12_02_2024/response_header_availability_being_gajju_09_54_21_17077316619724310.xml', 'totalstay', '2024-02-12 09:54:21', '', 'd6410948bbc78584bbc2e9d096d4dedcbf29dbf853aa856ec926139a05f3720b', '0');
[02/12/2024 09:54:21], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=totalstay&sessionid=d6410948bbc78584bbc2e9d096d4dedcbf29dbf853aa856ec926139a05f3720b&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-02-12 09:54:21.142'
            , 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.189'
            , error_description = ''
            , memory_used = '2352576'
            WHERE id = '32911';
[02/12/2024 09:54: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', 'ts/12_02_2024/request_availability_being_gajju_09_54_21_170773166171103840.xml', 'ts/12_02_2024/response_availability_being_gajju_09_54_21_170773166171103840.xml', 'ts/12_02_2024/response_header_availability_being_gajju_09_54_21_170773166171103840.xml', 'totalstay', '2024-02-12 09:54:21', '', 'd6410948bbc78584bbc2e9d096d4dedcbf29dbf853aa856ec926139a05f3720b', '0');
[02/12/2024 09:54:21], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=totalstay&sessionid=d6410948bbc78584bbc2e9d096d4dedcbf29dbf853aa856ec926139a05f3720b&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-02-12 09:54:21.141'
            , 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.195'
            , error_description = ''
            , memory_used = '2313608'
            WHERE id = '32912';
[02/12/2024 09:54: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', 'ts/12_02_2024/request_availability_being_gajju_09_54_21_17077316613224270.xml', 'ts/12_02_2024/response_availability_being_gajju_09_54_21_17077316613224270.xml', 'ts/12_02_2024/response_header_availability_being_gajju_09_54_21_17077316613224270.xml', 'totalstay', '2024-02-12 09:54:21', '', 'd6410948bbc78584bbc2e9d096d4dedcbf29dbf853aa856ec926139a05f3720b', '0');
[02/12/2024 09:54:21], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=totalstay&sessionid=d6410948bbc78584bbc2e9d096d4dedcbf29dbf853aa856ec926139a05f3720b&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-02-12 09:54:21.141'
            , 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.201'
            , error_description = ''
            , memory_used = '2352584'
            WHERE id = '32913';
[02/12/2024 09:54: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/12_02_2024/request_availability_being_gajju_09_54_21_1707731661_84.json', 'e1p/12_02_2024/response_availability_being_gajju_09_54_21_1707731661_84.json', 'e1p/12_02_2024/response_header_availability_being_gajju_09_54_21_1707731661_84.json', 'expediapackage', '2024-02-12 09:54:21', '', 'd6410948bbc78584bbc2e9d096d4dedcbf29dbf853aa856ec926139a05f3720b', '0');
[02/12/2024 09:54: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/12_02_2024/request_availability_being_gajju_09_54_21_1707731661_39.json', 'e1/12_02_2024/response_availability_being_gajju_09_54_21_1707731661_39.json', 'e1/12_02_2024/response_header_availability_being_gajju_09_54_21_1707731661_39.json', 'expedia', '2024-02-12 09:54:21', '', 'd6410948bbc78584bbc2e9d096d4dedcbf29dbf853aa856ec926139a05f3720b', '0');
[02/12/2024 09:54:21], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=d6410948bbc78584bbc2e9d096d4dedcbf29dbf853aa856ec926139a05f3720b&xml_user_id=7864&db_caching=1&erequest=2&total_request=3&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F113.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-02-12 09:54:21.141'
            , 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.247'
            , error_description = ''
            , memory_used = '2665152'
            WHERE id = '32914';
[02/12/2024 09:54:21], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=d6410948bbc78584bbc2e9d096d4dedcbf29dbf853aa856ec926139a05f3720b&xml_user_id=7864&db_caching=1&erequest=2&total_request=3&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F113.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-02-12 09:54:21.142'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.249'
            , error_description = ''
            , memory_used = '2664496'
            WHERE id = '32915';
[02/12/2024 09:54:22], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/12_02_2024/request_availability_being_gajju_09_54_21_1707731661_73.json', 'e1/12_02_2024/response_availability_being_gajju_09_54_21_1707731661_73.json', 'e1/12_02_2024/response_header_availability_being_gajju_09_54_21_1707731661_73.json', 'expedia', '2024-02-12 09:54:22', '', 'd6410948bbc78584bbc2e9d096d4dedcbf29dbf853aa856ec926139a05f3720b', '0');
[02/12/2024 09:54:23], [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/12_02_2024/request_availability_being_gajju_09_54_21_1707731661_72.json', 'e1/12_02_2024/response_availability_being_gajju_09_54_21_1707731661_72.json', 'e1/12_02_2024/response_header_availability_being_gajju_09_54_21_1707731661_72.json', 'expedia', '2024-02-12 09:54:23', '', 'd6410948bbc78584bbc2e9d096d4dedcbf29dbf853aa856ec926139a05f3720b', '0');
[02/12/2024 09:54:23], [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/12_02_2024/request_availability_being_gajju_09_54_21_1707731661_92.json', 'e1p/12_02_2024/response_availability_being_gajju_09_54_21_1707731661_92.json', 'e1p/12_02_2024/response_header_availability_being_gajju_09_54_21_1707731661_92.json', 'expediapackage', '2024-02-12 09:54:23', '', 'd6410948bbc78584bbc2e9d096d4dedcbf29dbf853aa856ec926139a05f3720b', '0');
[02/12/2024 09:54:24], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=d6410948bbc78584bbc2e9d096d4dedcbf29dbf853aa856ec926139a05f3720b&xml_user_id=7864&db_caching=1&erequest=1&total_request=3&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F113.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-02-12 09:54:21.142'
            , 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.948'
            , error_description = ''
            , memory_used = '134122720'
            WHERE id = '32916';
[02/12/2024 09:54:24], [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/12_02_2024/request_availability_being_gajju_09_54_21_1707731661_19.json', 'e1p/12_02_2024/response_availability_being_gajju_09_54_21_1707731661_19.json', 'e1p/12_02_2024/response_header_availability_being_gajju_09_54_21_1707731661_19.json', 'expediapackage', '2024-02-12 09:54:24', '', 'd6410948bbc78584bbc2e9d096d4dedcbf29dbf853aa856ec926139a05f3720b', '0');
[02/12/2024 09:54:24], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=d6410948bbc78584bbc2e9d096d4dedcbf29dbf853aa856ec926139a05f3720b&xml_user_id=7864&db_caching=1&erequest=0&total_request=3&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F113.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-02-12 09:54:21.142'
            , 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.831'
            , error_description = ''
            , memory_used = '164280256'
            WHERE id = '32917';
[02/12/2024 09:54:25], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=d6410948bbc78584bbc2e9d096d4dedcbf29dbf853aa856ec926139a05f3720b&xml_user_id=7864&db_caching=1&erequest=1&total_request=3&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F113.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-02-12 09:54:21.142'
            , 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.151'
            , error_description = ''
            , memory_used = '139215224'
            WHERE id = '32918';
[02/12/2024 09:54:26], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=d6410948bbc78584bbc2e9d096d4dedcbf29dbf853aa856ec926139a05f3720b&xml_user_id=7864&db_caching=1&erequest=0&total_request=3&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F113.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-02-12 09:54:21.142'
            , 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.363'
            , error_description = ''
            , memory_used = '173015536'
            WHERE id = '32919';
[02/12/2024 09:54:26], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:54:26' WHERE id= '546';
[02/12/2024 09:54:26], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:54:26' WHERE id= '546';
[02/12/2024 09:54:29], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:54:29' WHERE id= '546';
[02/12/2024 09:54:34], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:54:34' WHERE id= '547';
[02/12/2024 09:54:34], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7870' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '32' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '443' , service_type = 'hotel' , arrival_date = '2024/02/12' , departure_date = '2024/02/13' , nights = '1' , nationality = '443' , room_types = '1.3' , room_type='[{"numberOfAdults":1,"numberOfChild":3,"ChildAge":"1,1,1"}]' , available='0' , create_date = '2024-02-12 09:54:34' , site_id = '21' , 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 = '' ;
[02/12/2024 09:54:35], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:54:35' WHERE id= '547';
[02/12/2024 09:54:35], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-12 09:54:35.249'
                , total_duration = '0.021'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-12 09:54:35'
                , session_id = 'f0584f1e2960541446dede532d977ab8609e257293c1762adc9d08709d404238'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2887656';
[02/12/2024 09:54:35], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-12 09:54:35.249'
                , total_duration = '0.021'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-12 09:54:35'
                , session_id = 'f0584f1e2960541446dede532d977ab8609e257293c1762adc9d08709d404238'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2887584';
[02/12/2024 09:54:35], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-12 09:54:35.249'
                , total_duration = '0.021'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-12 09:54:35'
                , session_id = 'f0584f1e2960541446dede532d977ab8609e257293c1762adc9d08709d404238'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2887656';
[02/12/2024 09:54:35], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-12 09:54:35.249'
                , total_duration = '0.022'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-12 09:54:35'
                , session_id = 'f0584f1e2960541446dede532d977ab8609e257293c1762adc9d08709d404238'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2887584';
[02/12/2024 09:54:35], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-12 09:54:35.249'
                , total_duration = '0.022'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-12 09:54:35'
                , session_id = 'f0584f1e2960541446dede532d977ab8609e257293c1762adc9d08709d404238'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2887584';
[02/12/2024 09:54:35], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-12 09:54:35.249'
                , total_duration = '0.022'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-12 09:54:35'
                , session_id = 'f0584f1e2960541446dede532d977ab8609e257293c1762adc9d08709d404238'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2887584';
[02/12/2024 09:54:35], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-12 09:54:35.249'
                , total_duration = '0.024'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-12 09:54:35'
                , session_id = 'f0584f1e2960541446dede532d977ab8609e257293c1762adc9d08709d404238'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2887584';
[02/12/2024 09: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/12_02_2024/request_availability_hotel_yards_09_54_35_1707731675_100.json', 'e1/12_02_2024/response_availability_hotel_yards_09_54_35_1707731675_100.json', 'e1/12_02_2024/response_header_availability_hotel_yards_09_54_35_1707731675_100.json', 'expedia', '2024-02-12 09:54:35', '', 'f0584f1e2960541446dede532d977ab8609e257293c1762adc9d08709d404238', '0');
[02/12/2024 09:54:35], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=f0584f1e2960541446dede532d977ab8609e257293c1762adc9d08709d404238&xml_user_id=7867&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=95'
            , http_hit_time = '2024-02-12 09:54:35.249'
            , 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.301'
            , error_description = ''
            , memory_used = '2728008'
            WHERE id = '32927';
[02/12/2024 09: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/12_02_2024/request_availability_hotel_yards_09_54_35_1707731675_27.json', 'e1/12_02_2024/response_availability_hotel_yards_09_54_35_1707731675_27.json', 'e1/12_02_2024/response_header_availability_hotel_yards_09_54_35_1707731675_27.json', 'expedia', '2024-02-12 09:54:35', '', 'f0584f1e2960541446dede532d977ab8609e257293c1762adc9d08709d404238', '0');
[02/12/2024 09: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/12_02_2024/request_availability_hotel_yards_09_54_35_1707731675_86.json', 'e1/12_02_2024/response_availability_hotel_yards_09_54_35_1707731675_86.json', 'e1/12_02_2024/response_header_availability_hotel_yards_09_54_35_1707731675_86.json', 'expedia', '2024-02-12 09:54:35', '', 'f0584f1e2960541446dede532d977ab8609e257293c1762adc9d08709d404238', '0');
[02/12/2024 09:54:36], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=f0584f1e2960541446dede532d977ab8609e257293c1762adc9d08709d404238&xml_user_id=7867&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=95'
            , http_hit_time = '2024-02-12 09:54:35.249'
            , 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.763'
            , error_description = ''
            , memory_used = '13667576'
            WHERE id = '32929';
[02/12/2024 09:54:36], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=f0584f1e2960541446dede532d977ab8609e257293c1762adc9d08709d404238&xml_user_id=7867&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=95'
            , http_hit_time = '2024-02-12 09:54:35.249'
            , 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.783'
            , error_description = ''
            , memory_used = '16400424'
            WHERE id = '32928';
[02/12/2024 09:54:36], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 09:54:36' WHERE id= '547';
