[05/21/2024 08:01:38], [file name :-/efsdata/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', 'a5/21_05_2024/request_availability_qtech_agent_08_01_38_1716278498_0.xml', 'a5/21_05_2024/response_availability_qtech_agent_08_01_38_1716278498_0.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_08_01_38_1716278498_0.xml', 'agoda', '2024-05-21 08:01:38', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9821154');
[05/21/2024 08:01:38], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=0&total_request=1&hotels_ids=[&quot;936620&quot;]&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 08:01:38.482'
        , request_start_time = '0.017'
        , parsing_start_time = '0.295'
        , mapping_complete_time = '0.025'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.443'
        , error_description = ''
        , memory_used = '4815712'
        WHERE id = '140627872';
[05/21/2024 08:01:38], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '0',
        request_path = '/xml_all.php?userid=1284&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02',
        duration = '1.555',
        merge_duration = '0.014',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '0.75',
        system_load_5_min = '0.71',
        system_load_15_min = '0.84',
        system_memory_usage = '91.43',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '9821154') + '6130112',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '9821154';
[05/21/2024 08:01:56], [file name :-/efsdata/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', 'a5/21_05_2024/request_availability_qtech_agent_08_01_56_1716278516_0.xml', 'a5/21_05_2024/response_availability_qtech_agent_08_01_56_1716278516_0.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_08_01_56_1716278516_0.xml', 'agoda', '2024-05-21 08:01:56', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9821154');
[05/21/2024 08:01:56], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=0&total_request=1&hotels_ids=[%22936620%22]&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 08:01:56.451'
        , request_start_time = '0.016'
        , parsing_start_time = '0.348'
        , mapping_complete_time = '0.015'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.464'
        , error_description = ''
        , memory_used = '4888592'
        WHERE id = '140627972';
[05/21/2024 08:04:26], [file name :-/efsdata/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', 'a5/21_05_2024/request_availability_qtech_agent_08_04_26_1716278666_0.xml', 'a5/21_05_2024/response_availability_qtech_agent_08_04_26_1716278666_0.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_08_04_26_1716278666_0.xml', 'agoda', '2024-05-21 08:04:26', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9821154');
[05/21/2024 08:04:26], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '1'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=0&total_request=1&hotels_ids=[%22936620%22]&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 08:04:26.464'
        , request_start_time = '0.022'
        , parsing_start_time = '0.288'
        , mapping_complete_time = '0.023'
        , mongo_start_time = '0.035'
        , search_end_time = '0.024'
        , total_duration = '0.461'
        , error_description = ''
        , memory_used = '5383144'
        WHERE id = '140630234';
[05/21/2024 08:04:46], [file name :-/efsdata/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', 'a5/21_05_2024/request_availability_qtech_agent_08_04_46_1716278686_0.xml', 'a5/21_05_2024/response_availability_qtech_agent_08_04_46_1716278686_0.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_08_04_46_1716278686_0.xml', 'agoda', '2024-05-21 08:04:46', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9821154');
[05/21/2024 08:04:46], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '1'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=0&total_request=1&hotels_ids=[%22936620%22]&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 08:04:46.330'
        , request_start_time = '0.016'
        , parsing_start_time = '0.314'
        , mapping_complete_time = '0.014'
        , mongo_start_time = '0.024'
        , search_end_time = '0.020'
        , total_duration = '0.447'
        , error_description = ''
        , memory_used = '5384600'
        WHERE id = '140630313';
[05/21/2024 08:06:35], [file name :-/efsdata/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', 'a5/21_05_2024/request_availability_qtech_agent_08_06_35_1716278795_0.xml', 'a5/21_05_2024/response_availability_qtech_agent_08_06_35_1716278795_0.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_08_06_35_1716278795_0.xml', 'agoda', '2024-05-21 08:06:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9821154');
[05/21/2024 08:06:35], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '1'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=0&total_request=1&hotels_ids=[%22936620%22]&web_service=no&site_id=&save_log=yes&debug=1'
        , http_hit_time = '2024-05-21 08:06:35.461'
        , request_start_time = '0.015'
        , parsing_start_time = '0.310'
        , mapping_complete_time = '0.020'
        , mongo_start_time = '0.031'
        , search_end_time = '0.000'
        , total_duration = '0.420'
        , error_description = ''
        , memory_used = '4873720'
        WHERE id = '140630630';
[05/21/2024 08:06:49], [file name :-/efsdata/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', 'a5/21_05_2024/request_availability_qtech_agent_08_06_49_1716278809_0.xml', 'a5/21_05_2024/response_availability_qtech_agent_08_06_49_1716278809_0.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_08_06_49_1716278809_0.xml', 'agoda', '2024-05-21 08:06:49', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9821154');
[05/21/2024 08:06:49], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '1'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=0&total_request=1&hotels_ids=[%22936620%22]&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 08:06:49.190'
        , request_start_time = '0.014'
        , parsing_start_time = '0.328'
        , mapping_complete_time = '0.014'
        , mongo_start_time = '0.024'
        , search_end_time = '0.000'
        , total_duration = '0.435'
        , error_description = ''
        , memory_used = '4873744'
        WHERE id = '140630682';
[05/21/2024 08:08:00], [file name :-/efsdata/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', 'a5/21_05_2024/request_availability_qtech_agent_08_07_59_1716278879_0.xml', 'a5/21_05_2024/response_availability_qtech_agent_08_07_59_1716278879_0.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_08_07_59_1716278879_0.xml', 'agoda', '2024-05-21 08:08:00', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9821154');
[05/21/2024 08:08:00], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '1'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=0&total_request=1&hotels_ids=[%22936620%22]&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 08:07:59.572'
        , request_start_time = '0.018'
        , parsing_start_time = '0.338'
        , mapping_complete_time = '0.019'
        , mongo_start_time = '0.029'
        , search_end_time = '0.000'
        , total_duration = '0.485'
        , error_description = ''
        , memory_used = '4872072'
        WHERE id = '140631346';
[05/21/2024 08:09:33], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '1284' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'dubai' , service_name = 'Palazzo Versace Dubai' , country_of_residence = '129' , service_type = 'hotel' , arrival_date = '2024/06/19' , departure_date = '2024/06/20' , nights = '1' , nationality = '129' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-05-21 08:09:33' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'INR' , currency_code = 'INR' , web_service = '0' ;
[05/21/2024 08:09:36], [file name :-/efsdata/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', 'a5/21_05_2024/request_availability_qtech_agent_08_09_36_1716278976_0.xml', 'a5/21_05_2024/response_availability_qtech_agent_08_09_36_1716278976_0.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_08_09_36_1716278976_0.xml', 'agoda', '2024-05-21 08:09:36', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9823764');
[05/21/2024 08:09:36], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '1'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=0&total_request=1&hotels_ids=[&quot;936620&quot;]&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 08:09:36.15'
        , request_start_time = '0.017'
        , parsing_start_time = '0.275'
        , mapping_complete_time = '0.014'
        , mongo_start_time = '0.028'
        , search_end_time = '0.020'
        , total_duration = '0.394'
        , error_description = ''
        , memory_used = '5286768'
        WHERE id = '140632064';
[05/21/2024 08:09:36], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '1',
        request_path = '/xml_all.php?userid=1284&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02',
        duration = '1.476',
        merge_duration = '0.016',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '0.87',
        system_load_5_min = '0.77',
        system_load_15_min = '0.82',
        system_memory_usage = '90.83',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '9823764') + '6125488',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '9823764';
[05/21/2024 08:10:05], [file name :-/efsdata/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', 'a5/21_05_2024/request_availability_qtech_agent_08_10_05_1716279005_0.xml', 'a5/21_05_2024/response_availability_qtech_agent_08_10_05_1716279005_0.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_08_10_05_1716279005_0.xml', 'agoda', '2024-05-21 08:10:05', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9823764');
[05/21/2024 08:10:05], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '1'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=0&total_request=1&hotels_ids=[&quot;936620&quot;]&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 08:10:05.471'
        , request_start_time = '0.015'
        , parsing_start_time = '0.302'
        , mapping_complete_time = '0.015'
        , mongo_start_time = '0.025'
        , search_end_time = '0.021'
        , total_duration = '0.417'
        , error_description = ''
        , memory_used = '5621176'
        WHERE id = '140632148';
[05/21/2024 08:13:35], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '1284' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'dubai' , service_name = 'Palazzo Versace Dubai' , country_of_residence = '129' , service_type = 'hotel' , arrival_date = '2024/06/26' , departure_date = '2024/06/27' , nights = '1' , nationality = '129' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-05-21 08:13:35' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'INR' , currency_code = 'INR' , web_service = '0' ;
[05/21/2024 08:13:38], [file name :-/efsdata/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', 'a5/21_05_2024/request_availability_qtech_agent_08_13_37_1716279217_0.xml', 'a5/21_05_2024/response_availability_qtech_agent_08_13_37_1716279217_0.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_08_13_37_1716279217_0.xml', 'agoda', '2024-05-21 08:13:38', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9824123');
[05/21/2024 08:13:38], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '1'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=0&total_request=1&hotels_ids=[&quot;936620&quot;]&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 08:13:37.616'
        , request_start_time = '0.015'
        , parsing_start_time = '0.307'
        , mapping_complete_time = '0.014'
        , mongo_start_time = '0.027'
        , search_end_time = '0.000'
        , total_duration = '0.416'
        , error_description = ''
        , memory_used = '4775392'
        WHERE id = '140633744';
[05/21/2024 08:13:38], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '0',
        request_path = '/xml_all.php?userid=1284&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02',
        duration = '1.495',
        merge_duration = '0.015',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '0.34',
        system_load_5_min = '0.59',
        system_load_15_min = '0.74',
        system_memory_usage = '91.57',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '9824123') + '6103984',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '9824123';
[05/21/2024 08:14:45], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '1284' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'dubai' , service_name = 'Palazzo Versace Dubai' , country_of_residence = '129' , service_type = 'hotel' , arrival_date = '2024/06/26' , departure_date = '2024/06/27' , nights = '1' , nationality = '129' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-05-21 08:14:45' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'INR' , currency_code = 'INR' , web_service = '0' ;
[05/21/2024 08:14:47], [file name :-/efsdata/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', 'a5/21_05_2024/request_availability_qtech_agent_08_14_47_1716279287_0.xml', 'a5/21_05_2024/response_availability_qtech_agent_08_14_47_1716279287_0.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_08_14_47_1716279287_0.xml', 'agoda', '2024-05-21 08:14:47', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9824292');
[05/21/2024 08:14:47], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '1'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=0&total_request=1&hotels_ids=[&quot;936620&quot;]&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 08:14:47.510'
        , request_start_time = '0.015'
        , parsing_start_time = '0.337'
        , mapping_complete_time = '0.015'
        , mongo_start_time = '0.025'
        , search_end_time = '0.020'
        , total_duration = '0.451'
        , error_description = ''
        , memory_used = '5287640'
        WHERE id = '140633995';
[05/21/2024 08:14:47], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '1',
        request_path = '/xml_all.php?userid=1284&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02',
        duration = '1.581',
        merge_duration = '0.017',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '0.42',
        system_load_5_min = '0.56',
        system_load_15_min = '0.71',
        system_memory_usage = '91.85',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '9824292') + '6125040',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '9824292';
[05/21/2024 08:20:04], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '1284' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'dubai' , service_name = 'Palazzo Versace Dubai' , country_of_residence = '129' , service_type = 'hotel' , arrival_date = '2024/06/26' , departure_date = '2024/06/27' , nights = '1' , nationality = '129' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-05-21 08:20:04' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'INR' , currency_code = 'INR' , web_service = '0' ;
[05/21/2024 08:20:06], [file name :-/efsdata/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', 'a5/21_05_2024/request_availability_qtech_agent_08_20_06_1716279606_0.xml', 'a5/21_05_2024/response_availability_qtech_agent_08_20_06_1716279606_0.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_08_20_06_1716279606_0.xml', 'agoda', '2024-05-21 08:20:06', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9824812');
[05/21/2024 08:20:06], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '1'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=0&total_request=1&hotels_ids=[&quot;936620&quot;]&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 08:20:06.384'
        , request_start_time = '0.016'
        , parsing_start_time = '0.326'
        , mapping_complete_time = '0.015'
        , mongo_start_time = '0.024'
        , search_end_time = '0.022'
        , total_duration = '0.453'
        , error_description = ''
        , memory_used = '5286912'
        WHERE id = '140635957';
[05/21/2024 08:20:06], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '1',
        request_path = '/xml_all.php?userid=1284&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02',
        duration = '1.541',
        merge_duration = '0.016',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '0.63',
        system_load_5_min = '0.70',
        system_load_15_min = '0.74',
        system_memory_usage = '91.86',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '9824812') + '6124232',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '9824812';
[05/21/2024 08:20:13], [file name :-/efsdata/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', 'a5/21_05_2024/request_availability_qtech_agent_08_20_13_1716279613_0.xml', 'a5/21_05_2024/response_availability_qtech_agent_08_20_13_1716279613_0.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_08_20_13_1716279613_0.xml', 'agoda', '2024-05-21 08:20:13', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9824812');
[05/21/2024 08:20:13], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '1'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=0&total_request=1&hotels_ids=[&quot;936620&quot;]&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 08:20:12.987'
        , request_start_time = '0.015'
        , parsing_start_time = '0.324'
        , mapping_complete_time = '0.015'
        , mongo_start_time = '0.024'
        , search_end_time = '0.022'
        , total_duration = '0.438'
        , error_description = ''
        , memory_used = '5620608'
        WHERE id = '140635960';
[05/21/2024 08:20:47], [file name :-/efsdata/otrams/public_html/beta/retrieve_booking.php],INSERT INTO psa_login_log  SET username = '', user_type = 'A', branch_id = '7', login_datetime = '2024-05-21 08:20:47', ip = '114.119.151.146', action = 'Login' ;
[05/21/2024 08:22:34], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '1284' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'dubai' , service_name = 'Palazzo Versace Dubai' , country_of_residence = '129' , service_type = 'hotel' , arrival_date = '2024/07/03' , departure_date = '2024/07/04' , nights = '1' , nationality = '129' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-05-21 08:22:34' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'INR' , currency_code = 'INR' , web_service = '0' ;
[05/21/2024 08:22:36], [file name :-/efsdata/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', 'a5/21_05_2024/request_availability_qtech_agent_08_22_35_1716279755_0.xml', 'a5/21_05_2024/response_availability_qtech_agent_08_22_35_1716279755_0.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_08_22_35_1716279755_0.xml', 'agoda', '2024-05-21 08:22:36', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9825117');
[05/21/2024 08:22:36], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '1'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=0&total_request=1&hotels_ids=[&quot;936620&quot;]&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 08:22:35.809'
        , request_start_time = '0.017'
        , parsing_start_time = '0.279'
        , mapping_complete_time = '0.014'
        , mongo_start_time = '0.026'
        , search_end_time = '0.020'
        , total_duration = '0.395'
        , error_description = ''
        , memory_used = '5286760'
        WHERE id = '140637085';
[05/21/2024 08:22:36], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '1',
        request_path = '/xml_all.php?userid=1284&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02',
        duration = '1.445',
        merge_duration = '0.016',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '0.43',
        system_load_5_min = '0.53',
        system_load_15_min = '0.66',
        system_memory_usage = '91.95',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '9825117') + '6124168',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '9825117';
