[04/15/2024 09:11:58], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-04-15 09:11:58',login_attempt=0 where id = '7857';
[04/15/2024 09:11:58], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Deepak_T', user_type = 'A', branch_id = '23', login_datetime = '2024-04-15 09:11:58', ip = '43.239.53.130', action = 'Login' ;
[04/15/2024 09:11:58], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:11:58' WHERE id= '776';
[04/15/2024 09:12:04], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:12:04' WHERE id= '776';
[04/15/2024 09:12:12], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:12:12' WHERE id= '776';
[04/15/2024 09:12:12], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '23' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/15' , departure_date = '2024/05/18' , nights = '3' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-04-15 09:12:12' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[04/15/2024 09:12:13], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:12:13' WHERE id= '776';
[04/15/2024 09:12:13], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:12:13' WHERE id= '776';
[04/15/2024 09:12:15], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:12:15' WHERE id= '776';
[04/15/2024 09:13:19], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:13:19' WHERE id= '776';
[04/15/2024 09:13:19], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '23' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/15' , departure_date = '2024/05/18' , nights = '3' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-04-15 09:13:19' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[04/15/2024 09:13:19], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:13:19' WHERE id= '776';
[04/15/2024 09:13:20], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:13:20' WHERE id= '776';
[04/15/2024 09:13:22], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:13:22' WHERE id= '776';
[04/15/2024 09:15:13], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-04-15 09:15:13',login_attempt=0 where id = '7857';
[04/15/2024 09:15:13], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Deepak_T', user_type = 'A', branch_id = '23', login_datetime = '2024-04-15 09:15:13', ip = '43.239.53.130', action = 'Login' ;
[04/15/2024 09:15:14], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:15:14' WHERE id= '778';
[04/15/2024 09:15:18], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:15:18' WHERE id= '778';
[04/15/2024 09:15:30], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:15:30' WHERE id= '778';
[04/15/2024 09:15:30], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '23' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/15' , departure_date = '2024/05/18' , nights = '3' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-04-15 09:15:30' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[04/15/2024 09:15:30], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:15:30' WHERE id= '778';
[04/15/2024 09:15:30], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:15:30' WHERE id= '778';
[04/15/2024 09:15:32], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:15:32' WHERE id= '778';
[04/15/2024 09:15:38], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:15:38' WHERE id= '778';
[04/15/2024 09:15:48], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:15:48' WHERE id= '778';
[04/15/2024 09:18:21], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:18:21' WHERE id= '778';
[04/15/2024 09:18:33], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:18:33' WHERE id= '778';
[04/15/2024 09:18:33], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '23' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/15' , departure_date = '2024/05/18' , nights = '3' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-04-15 09:18:33' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[04/15/2024 09:18:33], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:18:33' WHERE id= '778';
[04/15/2024 09:18:34], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:18:34' WHERE id= '778';
[04/15/2024 09:18:36], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:18:36' WHERE id= '778';
[04/15/2024 09:18:48], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:18:48' WHERE id= '778';
[04/15/2024 09:18:50], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:18:50' WHERE id= '778';
[04/15/2024 09:20:06], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:20:06' WHERE id= '778';
[04/15/2024 09:20:09], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:20:09' WHERE id= '778';
[04/15/2024 09:20:14], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:20:14' WHERE id= '778';
[04/15/2024 09:21:56], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:21:56' WHERE id= '778';
[04/15/2024 09:21:56], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '23' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/15' , departure_date = '2024/05/18' , nights = '3' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-04-15 09:21:56' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[04/15/2024 09:21:57], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:21:57' WHERE id= '778';
[04/15/2024 09:21:57], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:21:57' WHERE id= '778';
[04/15/2024 09:21:58], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:21:58' WHERE id= '778';
[04/15/2024 09:21:59], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:21:59' WHERE id= '778';
[04/15/2024 09:22:29], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-04-15 09:22:29',login_attempt=0 where id = '7873';
[04/15/2024 09:22:29], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Gajendra', user_type = 'A', branch_id = '1', login_datetime = '2024-04-15 09:22:29', ip = '43.239.53.130', action = 'Login' ;
[04/15/2024 09:22:29], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:22:29' WHERE id= '774';
[04/15/2024 09:22:38], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:22:38' WHERE id= '774';
[04/15/2024 09:22:38], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:22:38' WHERE id= '774';
[04/15/2024 09:22:43], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:22:43' WHERE id= '774';
[04/15/2024 09:22:43], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7873' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/04/18' , departure_date = '2024/04/19' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-04-15 09:22:43' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[04/15/2024 09:22:44], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:22:44' WHERE id= '774';
[04/15/2024 09:22: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/15_04_2024/request_availability_Gajendra_958_1713172964_28.json', 'e1/15_04_2024/response_availability_Gajendra_958_1713172964_28.json', 'e1/15_04_2024/response_header_availability_Gajendra_958_1713172964_28.json', 'expedia', '2024-04-15 09:22:44', '', 'ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001', '958');
[04/15/2024 09:22:44], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001&xml_user_id=7873&db_caching=1&erequest=2&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-15 09:22:44.671'
        , 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 = '2986616'
        WHERE id = '108684';
[04/15/2024 09:22:45], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/15_04_2024/request_availability_Gajendra_958_1713172964_44.json', 'e1p/15_04_2024/response_availability_Gajendra_958_1713172964_44.json', 'e1p/15_04_2024/response_header_availability_Gajendra_958_1713172964_44.json', 'expediapackage', '2024-04-15 09:22:45', '', 'ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001', '958');
[04/15/2024 09:22:45], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001&xml_user_id=7873&db_caching=1&erequest=2&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-15 09:22:44.671'
        , 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.397'
        , error_description = ''
        , memory_used = '2987640'
        WHERE id = '108685';
[04/15/2024 09:22:45], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/15_04_2024/request_availability_Gajendra_958_1713172964_34.json', 'e1/15_04_2024/response_availability_Gajendra_958_1713172964_34.json', 'e1/15_04_2024/response_header_availability_Gajendra_958_1713172964_34.json', 'expedia', '2024-04-15 09:22:45', '', 'ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001', '958');
[04/15/2024 09:22:45], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/15_04_2024/request_availability_Gajendra_958_1713172964_77.json', 'e1/15_04_2024/response_availability_Gajendra_958_1713172964_77.json', 'e1/15_04_2024/response_header_availability_Gajendra_958_1713172964_77.json', 'expedia', '2024-04-15 09:22:45', '', 'ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001', '958');
[04/15/2024 09:22:46], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/15_04_2024/request_availability_Gajendra_958_1713172964_50.json', 'e1p/15_04_2024/response_availability_Gajendra_958_1713172964_50.json', 'e1p/15_04_2024/response_header_availability_Gajendra_958_1713172964_50.json', 'expediapackage', '2024-04-15 09:22:46', '', 'ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001', '958');
[04/15/2024 09:22:46], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/15_04_2024/request_availability_Gajendra_958_1713172964_28.json', 'e1p/15_04_2024/response_availability_Gajendra_958_1713172964_28.json', 'e1p/15_04_2024/response_header_availability_Gajendra_958_1713172964_28.json', 'expediapackage', '2024-04-15 09:22:46', '', 'ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001', '958');
[04/15/2024 09:22:46], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001&xml_user_id=7873&db_caching=1&erequest=1&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-15 09:22:44.671'
        , 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.167'
        , error_description = ''
        , memory_used = '110573888'
        WHERE id = '108686';
[04/15/2024 09:22:47], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001&xml_user_id=7873&db_caching=1&erequest=0&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-15 09:22:44.671'
        , 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.496'
        , error_description = ''
        , memory_used = '135968056'
        WHERE id = '108687';
[04/15/2024 09:22:47], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001&xml_user_id=7873&db_caching=1&erequest=1&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-15 09:22:44.671'
        , 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.529'
        , error_description = ''
        , memory_used = '117257696'
        WHERE id = '108689';
[04/15/2024 09:22:47], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001&xml_user_id=7873&db_caching=1&erequest=0&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-15 09:22:44.671'
        , 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.605'
        , error_description = ''
        , memory_used = '144330208'
        WHERE id = '108688';
[04/15/2024 09:22:47], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7873&sessionid=ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001',
        duration = '2.866',
        merge_duration = '0.131',
        assigned_supplier_count = '2',
        searched_supplier_count = '2',
        system_load_1_min = '20.19',
        system_load_5_min = '21.37',
        system_load_15_min = '17.89',
        system_memory_usage = '89.41',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '958') + '17672736',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '958';
[04/15/2024 09:22:47], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:22:47' WHERE id= '774';
[04/15/2024 09:22:49], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:22:49' WHERE id= '774';
[04/15/2024 09:23:40], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:23:40' WHERE id= '774';
[04/15/2024 09:23:44], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:23:44' WHERE id= '774';
[04/15/2024 09:26:26], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:26:26' WHERE id= '774';
[04/15/2024 09:26:29], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:26:29' WHERE id= '774';
[04/15/2024 09:26:36], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:26:36' WHERE id= '774';
[04/15/2024 09:26:36], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7873' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/04/18' , departure_date = '2024/04/19' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-04-15 09:26:36' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[04/15/2024 09:26:37], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:26:37' WHERE id= '774';
[04/15/2024 09:26:37], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/15_04_2024/request_availability_Gajendra_959_1713173197_74.json', 'e1p/15_04_2024/response_availability_Gajendra_959_1713173197_74.json', 'e1p/15_04_2024/response_header_availability_Gajendra_959_1713173197_74.json', 'expediapackage', '2024-04-15 09:26:37', '', 'ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001', '959');
[04/15/2024 09:26:37], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001&xml_user_id=7873&db_caching=1&erequest=2&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-15 09:26:37.719'
        , 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.267'
        , error_description = ''
        , memory_used = '2988352'
        WHERE id = '108690';
[04/15/2024 09:26:38], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/15_04_2024/request_availability_Gajendra_959_1713173197_6.json', 'e1/15_04_2024/response_availability_Gajendra_959_1713173197_6.json', 'e1/15_04_2024/response_header_availability_Gajendra_959_1713173197_6.json', 'expedia', '2024-04-15 09:26:38', '', 'ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001', '959');
[04/15/2024 09:26:38], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001&xml_user_id=7873&db_caching=1&erequest=2&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-15 09:26:37.718'
        , 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.290'
        , error_description = ''
        , memory_used = '2987848'
        WHERE id = '108691';
[04/15/2024 09:26:38], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/15_04_2024/request_availability_Gajendra_959_1713173197_11.json', 'e1/15_04_2024/response_availability_Gajendra_959_1713173197_11.json', 'e1/15_04_2024/response_header_availability_Gajendra_959_1713173197_11.json', 'expedia', '2024-04-15 09:26:38', '', 'ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001', '959');
[04/15/2024 09:26:38], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/15_04_2024/request_availability_Gajendra_959_1713173197_95.json', 'e1/15_04_2024/response_availability_Gajendra_959_1713173197_95.json', 'e1/15_04_2024/response_header_availability_Gajendra_959_1713173197_95.json', 'expedia', '2024-04-15 09:26:38', '', 'ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001', '959');
[04/15/2024 09:26:39], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/15_04_2024/request_availability_Gajendra_959_1713173197_63.json', 'e1p/15_04_2024/response_availability_Gajendra_959_1713173197_63.json', 'e1p/15_04_2024/response_header_availability_Gajendra_959_1713173197_63.json', 'expediapackage', '2024-04-15 09:26:39', '', 'ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001', '959');
[04/15/2024 09:26:39], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/15_04_2024/request_availability_Gajendra_959_1713173197_11.json', 'e1p/15_04_2024/response_availability_Gajendra_959_1713173197_11.json', 'e1p/15_04_2024/response_header_availability_Gajendra_959_1713173197_11.json', 'expediapackage', '2024-04-15 09:26:39', '', 'ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001', '959');
[04/15/2024 09:26:39], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001&xml_user_id=7873&db_caching=1&erequest=1&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-15 09:26:37.718'
        , 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.952'
        , error_description = ''
        , memory_used = '110440096'
        WHERE id = '108692';
[04/15/2024 09:26:40], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001&xml_user_id=7873&db_caching=1&erequest=1&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-15 09:26:37.718'
        , 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.507'
        , error_description = ''
        , memory_used = '117191464'
        WHERE id = '108694';
[04/15/2024 09:26:40], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001&xml_user_id=7873&db_caching=1&erequest=0&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-15 09:26:37.718'
        , 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.970'
        , error_description = ''
        , memory_used = '135941424'
        WHERE id = '108693';
[04/15/2024 09:26:40], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001&xml_user_id=7873&db_caching=1&erequest=0&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-15 09:26:37.718'
        , 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.217'
        , error_description = ''
        , memory_used = '144516960'
        WHERE id = '108695';
[04/15/2024 09:26:41], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7873&sessionid=ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001',
        duration = '3.567',
        merge_duration = '0.131',
        assigned_supplier_count = '2',
        searched_supplier_count = '2',
        system_load_1_min = '32.40',
        system_load_5_min = '27.75',
        system_load_15_min = '21.40',
        system_memory_usage = '89.97',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '959') + '18263976',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '959';
[04/15/2024 09:26:41], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:26:41' WHERE id= '774';
[04/15/2024 09:26:43], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:26:43' WHERE id= '774';
[04/15/2024 09:27:06], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:27:06' WHERE id= '774';
[04/15/2024 09:27:07], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-04-15 09:27:07',login_attempt=0 where id = '7873';
[04/15/2024 09:27:07], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Gajendra', user_type = 'A', branch_id = '1', login_datetime = '2024-04-15 09:27:07', ip = '43.239.53.130', action = 'Login' ;
[04/15/2024 09:27:07], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:27:07' WHERE id= '774';
[04/15/2024 09:27:14], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:27:14' WHERE id= '774';
[04/15/2024 09:27:16], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:27:16' WHERE id= '774';
[04/15/2024 09:27:21], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:27:21' WHERE id= '774';
[04/15/2024 09:27:21], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7873' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/04/26' , departure_date = '2024/04/27' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-04-15 09:27:21' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[04/15/2024 09:27:21], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:27:21' WHERE id= '774';
[04/15/2024 09:27:22], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/15_04_2024/request_availability_Gajendra_960_1713173242_34.json', 'e1p/15_04_2024/response_availability_Gajendra_960_1713173242_34.json', 'e1p/15_04_2024/response_header_availability_Gajendra_960_1713173242_34.json', 'expediapackage', '2024-04-15 09:27:22', '', 'ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001', '960');
[04/15/2024 09:27:22], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001&xml_user_id=7873&db_caching=1&erequest=2&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-15 09:27:22.81'
        , 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.304'
        , error_description = ''
        , memory_used = '2988696'
        WHERE id = '108696';
[04/15/2024 09:27: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/15_04_2024/request_availability_Gajendra_960_1713173242_95.json', 'e1/15_04_2024/response_availability_Gajendra_960_1713173242_95.json', 'e1/15_04_2024/response_header_availability_Gajendra_960_1713173242_95.json', 'expedia', '2024-04-15 09:27:22', '', 'ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001', '960');
[04/15/2024 09:27:22], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001&xml_user_id=7873&db_caching=1&erequest=2&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-15 09:27:22.76'
        , 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.407'
        , error_description = ''
        , memory_used = '2987680'
        WHERE id = '108697';
[04/15/2024 09:27: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/15_04_2024/request_availability_Gajendra_960_1713173242_98.json', 'e1/15_04_2024/response_availability_Gajendra_960_1713173242_98.json', 'e1/15_04_2024/response_header_availability_Gajendra_960_1713173242_98.json', 'expedia', '2024-04-15 09:27:23', '', 'ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001', '960');
[04/15/2024 09:27: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/15_04_2024/request_availability_Gajendra_960_1713173242_49.json', 'e1/15_04_2024/response_availability_Gajendra_960_1713173242_49.json', 'e1/15_04_2024/response_header_availability_Gajendra_960_1713173242_49.json', 'expedia', '2024-04-15 09:27:23', '', 'ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001', '960');
[04/15/2024 09:27: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/15_04_2024/request_availability_Gajendra_960_1713173242_65.json', 'e1p/15_04_2024/response_availability_Gajendra_960_1713173242_65.json', 'e1p/15_04_2024/response_header_availability_Gajendra_960_1713173242_65.json', 'expediapackage', '2024-04-15 09:27:23', '', 'ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001', '960');
[04/15/2024 09:27: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/15_04_2024/request_availability_Gajendra_960_1713173242_41.json', 'e1p/15_04_2024/response_availability_Gajendra_960_1713173242_41.json', 'e1p/15_04_2024/response_header_availability_Gajendra_960_1713173242_41.json', 'expediapackage', '2024-04-15 09:27:23', '', 'ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001', '960');
[04/15/2024 09:27:25], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001&xml_user_id=7873&db_caching=1&erequest=1&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-15 09:27:22.78'
        , 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.754'
        , error_description = ''
        , memory_used = '156768320'
        WHERE id = '108699';
[04/15/2024 09:27:25], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001&xml_user_id=7873&db_caching=1&erequest=1&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-15 09:27:22.75'
        , 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.884'
        , error_description = ''
        , memory_used = '164685448'
        WHERE id = '108701';
[04/15/2024 09:27:26], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001&xml_user_id=7873&db_caching=1&erequest=0&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-15 09:27:22.75'
        , 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.997'
        , error_description = ''
        , memory_used = '184658320'
        WHERE id = '108698';
[04/15/2024 09:27:26], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001&xml_user_id=7873&db_caching=1&erequest=0&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-15 09:27:22.75'
        , 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.385'
        , error_description = ''
        , memory_used = '195694496'
        WHERE id = '108700';
[04/15/2024 09:27:26], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7873&sessionid=ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001',
        duration = '4.839',
        merge_duration = '0.118',
        assigned_supplier_count = '2',
        searched_supplier_count = '2',
        system_load_1_min = '33.67',
        system_load_5_min = '28.40',
        system_load_15_min = '21.90',
        system_memory_usage = '91.70',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '960') + '18901800',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '960';
[04/15/2024 09:27:26], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:27:26' WHERE id= '774';
[04/15/2024 09:27:26], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:27:26' WHERE id= '774';
[04/15/2024 09:27:27], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:27:27' WHERE id= '774';
[04/15/2024 09:27:32], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:27:32' WHERE id= '774';
[04/15/2024 09:29:28], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:29:28' WHERE id= '778';
[04/15/2024 09:30:31], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:30:31' WHERE id= '778';
[04/15/2024 09:30:59], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:30:59' WHERE id= '778';
[04/15/2024 09:31:10], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:31:10' WHERE id= '774';
[04/15/2024 09:31:10], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-04-15 09:31:10',login_attempt=0 where id = '7873';
[04/15/2024 09:31:10], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Gajendra', user_type = 'A', branch_id = '1', login_datetime = '2024-04-15 09:31:10', ip = '43.239.53.130', action = 'Login' ;
[04/15/2024 09:31:10], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:31:10' WHERE id= '774';
[04/15/2024 09:31:16], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:31:16' WHERE id= '774';
[04/15/2024 09:31:22], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:31:22' WHERE id= '774';
[04/15/2024 09:31:22], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7873' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/04/18' , departure_date = '2024/04/19' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-04-15 09:31:22' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[04/15/2024 09:31:23], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:31:23' WHERE id= '774';
[04/15/2024 09:31: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/15_04_2024/request_availability_Gajendra_961_1713173483_32.json', 'e1/15_04_2024/response_availability_Gajendra_961_1713173483_32.json', 'e1/15_04_2024/response_header_availability_Gajendra_961_1713173483_32.json', 'expedia', '2024-04-15 09:31:23', '', 'ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001', '961');
[04/15/2024 09:31:23], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001&xml_user_id=7873&db_caching=1&erequest=2&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-15 09:31:23.190'
        , 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.275'
        , error_description = ''
        , memory_used = '2987680'
        WHERE id = '108702';
[04/15/2024 09:31: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/15_04_2024/request_availability_Gajendra_961_1713173483_97.json', 'e1p/15_04_2024/response_availability_Gajendra_961_1713173483_97.json', 'e1p/15_04_2024/response_header_availability_Gajendra_961_1713173483_97.json', 'expediapackage', '2024-04-15 09:31:23', '', 'ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001', '961');
[04/15/2024 09:31:23], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001&xml_user_id=7873&db_caching=1&erequest=2&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-15 09:31:23.190'
        , 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.324'
        , error_description = ''
        , memory_used = '2987632'
        WHERE id = '108703';
[04/15/2024 09:31: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', 'e1/15_04_2024/request_availability_Gajendra_961_1713173483_29.json', 'e1/15_04_2024/response_availability_Gajendra_961_1713173483_29.json', 'e1/15_04_2024/response_header_availability_Gajendra_961_1713173483_29.json', 'expedia', '2024-04-15 09:31:24', '', 'ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001', '961');
[04/15/2024 09:31: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', 'e1/15_04_2024/request_availability_Gajendra_961_1713173483_9.json', 'e1/15_04_2024/response_availability_Gajendra_961_1713173483_9.json', 'e1/15_04_2024/response_header_availability_Gajendra_961_1713173483_9.json', 'expedia', '2024-04-15 09:31:24', '', 'ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001', '961');
[04/15/2024 09:31: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/15_04_2024/request_availability_Gajendra_961_1713173483_10.json', 'e1p/15_04_2024/response_availability_Gajendra_961_1713173483_10.json', 'e1p/15_04_2024/response_header_availability_Gajendra_961_1713173483_10.json', 'expediapackage', '2024-04-15 09:31:24', '', 'ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001', '961');
[04/15/2024 09:31: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/15_04_2024/request_availability_Gajendra_961_1713173483_85.json', 'e1p/15_04_2024/response_availability_Gajendra_961_1713173483_85.json', 'e1p/15_04_2024/response_header_availability_Gajendra_961_1713173483_85.json', 'expediapackage', '2024-04-15 09:31:24', '', 'ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001', '961');
[04/15/2024 09:31:25], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001&xml_user_id=7873&db_caching=1&erequest=1&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-15 09:31:23.190'
        , 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.887'
        , error_description = ''
        , memory_used = '110436392'
        WHERE id = '108705';
[04/15/2024 09:31:25], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001&xml_user_id=7873&db_caching=1&erequest=0&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-15 09:31:23.190'
        , 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.940'
        , error_description = ''
        , memory_used = '135944264'
        WHERE id = '108704';
[04/15/2024 09:31:25], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001&xml_user_id=7873&db_caching=1&erequest=1&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-15 09:31:23.190'
        , 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.391'
        , error_description = ''
        , memory_used = '116965216'
        WHERE id = '108707';
[04/15/2024 09:31:25], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001&xml_user_id=7873&db_caching=1&erequest=0&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-15 09:31:23.190'
        , 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.414'
        , error_description = ''
        , memory_used = '144421968'
        WHERE id = '108706';
[04/15/2024 09:31:25], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7873&sessionid=ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001',
        duration = '2.733',
        merge_duration = '0.140',
        assigned_supplier_count = '2',
        searched_supplier_count = '2',
        system_load_1_min = '26.22',
        system_load_5_min = '30.64',
        system_load_15_min = '24.50',
        system_memory_usage = '90.32',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '961') + '19495208',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '961';
[04/15/2024 09:31:26], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:31:26' WHERE id= '774';
[04/15/2024 09:31:28], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:31:28' WHERE id= '774';
[04/15/2024 09:39:10], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:39:10' WHERE id= '778';
[04/15/2024 09:41:04], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:41:04' WHERE id= '778';
[04/15/2024 09:48:10], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:48:10' WHERE id= '778';
[04/15/2024 09:48:36], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:48:36' WHERE id= '778';
[04/15/2024 09:49:23], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:49:23' WHERE id= '774';
[04/15/2024 09:49:26], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:49:26' WHERE id= '774';
[04/15/2024 09:49:44], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:49:44' WHERE id= '778';
[04/15/2024 09:51:12], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:51:12' WHERE id= '774';
[04/15/2024 09:51:14], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:51:14' WHERE id= '774';
[04/15/2024 09:51:22], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:51:22' WHERE id= '778';
[04/15/2024 09:51:54], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:51:54' WHERE id= '774';
[04/15/2024 09:51:56], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:51:56' WHERE id= '774';
[04/15/2024 09:52:24], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:52:24' WHERE id= '774';
[04/15/2024 09:52:27], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:52:27' WHERE id= '774';
[04/15/2024 09:52:46], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:52:46' WHERE id= '778';
[04/15/2024 09:53:35], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:53:35' WHERE id= '774';
[04/15/2024 09:53:39], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:53:39' WHERE id= '774';
[04/15/2024 09:54:58], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:54:58' WHERE id= '778';
[04/15/2024 09:55:09], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:55:09' WHERE id= '774';
[04/15/2024 09:55:12], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:55:12' WHERE id= '774';
[04/15/2024 09:56:27], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:56:27' WHERE id= '778';
[04/15/2024 09:56:34], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:56:34' WHERE id= '774';
[04/15/2024 09:56:37], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:56:37' WHERE id= '774';
[04/15/2024 09:57:25], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:57:25' WHERE id= '774';
[04/15/2024 09:57:30], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:57:30' WHERE id= '774';
[04/15/2024 09:57:37], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:57:37' WHERE id= '778';
[04/15/2024 09:58:35], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:58:35' WHERE id= '774';
[04/15/2024 09:58:39], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:58:39' WHERE id= '774';
[04/15/2024 09:59:09], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:59:09' WHERE id= '778';
[04/15/2024 09:59:29], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:59:29' WHERE id= '774';
[04/15/2024 09:59:32], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 09:59:32' WHERE id= '774';
