[05/21/2024 09:12:17], [file name :-/efsdata/otrams/public_html/beta/index.php],INSERT INTO psa_login_log  SET username = '', user_type = 'A', branch_id = '12', login_datetime = '2024-05-21 09:12:17', ip = '205.210.31.203', action = 'Login' ;
[05/21/2024 09:13:30], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-05-21 09:13:30',login_attempt=0 where id = '1284';
[05/21/2024 09:13:30], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'qtech_agent', user_type = 'A', branch_id = '26', login_datetime = '2024-05-21 09:13:30', ip = '43.239.53.130', action = 'Login' ;
[05/21/2024 09:17:21], [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/05/29' , departure_date = '2024/05/30' , nights = '1' , nationality = '129' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-05-21 09:17:21' , 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 09:17:23], [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_09_17_23_1716283043_0.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_17_23_1716283043_0.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_17_23_1716283043_0.xml', 'agoda', '2024-05-21 09:17:23', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9832968');
[05/21/2024 09:17:23], [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 09:17:23.431'
        , request_start_time = '0.020'
        , parsing_start_time = '0.303'
        , mapping_complete_time = '0.016'
        , mongo_start_time = '0.028'
        , search_end_time = '0.023'
        , total_duration = '0.444'
        , error_description = ''
        , memory_used = '5662160'
        WHERE id = '140673629';
[05/21/2024 09:17:23], [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.547',
        merge_duration = '0.017',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '5.50',
        system_load_5_min = '11.06',
        system_load_15_min = '7.20',
        system_memory_usage = '91.78',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '9832968') + '6124520',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '9832968';
[05/21/2024 09:17:55], [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_09_17_55_1716283075_0.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_17_55_1716283075_0.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_17_55_1716283075_0.xml', 'agoda', '2024-05-21 09:17:55', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9832968');
[05/21/2024 09:17:55], [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 09:17:51.213'
        , request_start_time = '0.154'
        , parsing_start_time = '0.324'
        , mapping_complete_time = '0.071'
        , mongo_start_time = '0.109'
        , search_end_time = '0.160'
        , total_duration = '4.426'
        , error_description = ''
        , memory_used = '6148176'
        WHERE id = '140674016';
[05/21/2024 09:20:23], [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/05' , departure_date = '2024/06/06' , nights = '1' , nationality = '129' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-05-21 09:20:23' , 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 09:20:25], [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_09_20_25_1716283225_0.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_20_25_1716283225_0.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_20_25_1716283225_0.xml', 'agoda', '2024-05-21 09:20:25', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9833296');
[05/21/2024 09:20:25], [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 09:20:25.461'
        , request_start_time = '0.020'
        , parsing_start_time = '0.292'
        , mapping_complete_time = '0.015'
        , mongo_start_time = '0.027'
        , search_end_time = '0.024'
        , total_duration = '0.430'
        , error_description = ''
        , memory_used = '5288352'
        WHERE id = '140676924';
[05/21/2024 09:20:25], [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.465',
        merge_duration = '0.017',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '21.06',
        system_load_5_min = '19.53',
        system_load_15_min = '11.28',
        system_memory_usage = '93.10',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '9833296') + '6125168',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '9833296';
[05/21/2024 09:22:54], [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_09_22_53_1716283373_0.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_22_53_1716283373_0.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_22_53_1716283373_0.xml', 'agoda', '2024-05-21 09:22:54', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9833296');
[05/21/2024 09:22:54], [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 09:22:53.504'
        , request_start_time = '0.026'
        , parsing_start_time = '0.298'
        , mapping_complete_time = '0.021'
        , mongo_start_time = '0.034'
        , search_end_time = '0.022'
        , total_duration = '0.640'
        , error_description = ''
        , memory_used = '5621880'
        WHERE id = '140678913';
[05/21/2024 09:24:11], [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_09_24_10_1716283450_0.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_24_10_1716283450_0.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_24_10_1716283450_0.xml', 'agoda', '2024-05-21 09:24:11', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9833296');
[05/21/2024 09:24:11], [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 09:24:10.848'
        , request_start_time = '0.020'
        , parsing_start_time = '0.295'
        , mapping_complete_time = '0.018'
        , mongo_start_time = '0.028'
        , search_end_time = '0.020'
        , total_duration = '0.454'
        , error_description = ''
        , memory_used = '5621216'
        WHERE id = '140679927';
[05/21/2024 09:25:12], [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_09_25_11_1716283511_0.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_25_11_1716283511_0.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_25_11_1716283511_0.xml', 'agoda', '2024-05-21 09:25:12', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9833296');
[05/21/2024 09:25:12], [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 09:25:11.762'
        , request_start_time = '0.018'
        , parsing_start_time = '0.345'
        , mapping_complete_time = '0.020'
        , mongo_start_time = '0.030'
        , search_end_time = '0.020'
        , total_duration = '0.487'
        , error_description = ''
        , memory_used = '5621216'
        WHERE id = '140680350';
[05/21/2024 09:27:02], [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_09_27_02_1716283622_0.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_27_02_1716283622_0.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_27_02_1716283622_0.xml', 'agoda', '2024-05-21 09:27:02', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9833296');
[05/21/2024 09:27:03], [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 09:27:02.562'
        , request_start_time = '0.025'
        , parsing_start_time = '0.262'
        , mapping_complete_time = '0.027'
        , mongo_start_time = '0.098'
        , search_end_time = '0.040'
        , total_duration = '0.495'
        , error_description = ''
        , memory_used = '5621592'
        WHERE id = '140681918';
[05/21/2024 09:28:18], [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_09_28_17_1716283697_0.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_28_17_1716283697_0.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_28_17_1716283697_0.xml', 'agoda', '2024-05-21 09:28:18', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9833296');
[05/21/2024 09:28:18], [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 09:28:17.676'
        , request_start_time = '0.018'
        , parsing_start_time = '0.286'
        , mapping_complete_time = '0.021'
        , mongo_start_time = '0.031'
        , search_end_time = '0.021'
        , total_duration = '0.411'
        , error_description = ''
        , memory_used = '5621600'
        WHERE id = '140682923';
[05/21/2024 09:30:02], [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_09_30_02_1716283802_0.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_30_02_1716283802_0.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_30_02_1716283802_0.xml', 'agoda', '2024-05-21 09:30:02', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9833296');
[05/21/2024 09:30:02], [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 09:30:01.961'
        , request_start_time = '0.023'
        , parsing_start_time = '0.280'
        , mapping_complete_time = '0.025'
        , mongo_start_time = '0.039'
        , search_end_time = '0.023'
        , total_duration = '0.434'
        , error_description = ''
        , memory_used = '5621248'
        WHERE id = '140683426';
[05/21/2024 09:30:27], [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 09:30:27' , 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 09:30:30], [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_09_30_29_1716283829_0.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_30_29_1716283829_0.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_30_29_1716283829_0.xml', 'agoda', '2024-05-21 09:30:30', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9834724');
[05/21/2024 09:30:30], [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 09:30:29.910'
        , request_start_time = '0.017'
        , parsing_start_time = '0.293'
        , mapping_complete_time = '0.016'
        , mongo_start_time = '0.027'
        , search_end_time = '0.020'
        , total_duration = '0.411'
        , error_description = ''
        , memory_used = '5287696'
        WHERE id = '140684035';
[05/21/2024 09:30:30], [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.530',
        merge_duration = '0.018',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '11.69',
        system_load_5_min = '12.07',
        system_load_15_min = '11.31',
        system_memory_usage = '91.15',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '9834724') + '6126016',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '9834724';
[05/21/2024 09:30:48], [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_09_30_46_1716283846_0.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_30_46_1716283846_0.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_30_46_1716283846_0.xml', 'agoda', '2024-05-21 09:30:48', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9834724');
[05/21/2024 09:30:48], [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 09:30:45.912'
        , request_start_time = '0.132'
        , parsing_start_time = '1.340'
        , mapping_complete_time = '0.075'
        , mongo_start_time = '0.140'
        , search_end_time = '0.123'
        , total_duration = '2.361'
        , error_description = ''
        , memory_used = '5621624'
        WHERE id = '140684538';
[05/21/2024 09:31: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 = '' , country_of_residence = '129' , service_type = 'hotel' , arrival_date = '2024/06/27' , departure_date = '2024/06/28' , nights = '1' , nationality = '129' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-05-21 09:31: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 09:31:34], [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_09_31_34_1716283894_11.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_31_34_1716283894_11.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_31_34_1716283894_11.xml', 'agoda', '2024-05-21 09:31:34', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9834937');
[05/21/2024 09:31:34], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '5'
        , 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=11&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 09:31:34.35'
        , request_start_time = '0.034'
        , parsing_start_time = '0.427'
        , mapping_complete_time = '0.023'
        , mongo_start_time = '0.038'
        , search_end_time = '0.029'
        , total_duration = '0.643'
        , error_description = ''
        , memory_used = '6847096'
        WHERE id = '140684907';
[05/21/2024 09:31:34], [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_09_31_34_1716283894_8.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_31_34_1716283894_8.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_31_34_1716283894_8.xml', 'agoda', '2024-05-21 09:31:34', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9834937');
[05/21/2024 09:31:34], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '4'
        , 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=8&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 09:31:34.37'
        , request_start_time = '0.028'
        , parsing_start_time = '0.486'
        , mapping_complete_time = '0.026'
        , mongo_start_time = '0.039'
        , search_end_time = '0.026'
        , total_duration = '0.712'
        , error_description = ''
        , memory_used = '7235944'
        WHERE id = '140684908';
[05/21/2024 09:31:34], [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_09_31_34_1716283894_9.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_31_34_1716283894_9.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_31_34_1716283894_9.xml', 'agoda', '2024-05-21 09:31:34', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9834937');
[05/21/2024 09:31:34], [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_09_31_34_1716283894_15.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_31_34_1716283894_15.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_31_34_1716283894_15.xml', 'agoda', '2024-05-21 09:31:34', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9834937');
[05/21/2024 09:31:34], [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_09_31_34_1716283894_10.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_31_34_1716283894_10.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_31_34_1716283894_10.xml', 'agoda', '2024-05-21 09:31:34', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9834937');
[05/21/2024 09:31:34], [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_09_31_34_1716283894_14.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_31_34_1716283894_14.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_31_34_1716283894_14.xml', 'agoda', '2024-05-21 09:31:34', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9834937');
[05/21/2024 09:31:34], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '8'
        , 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=9&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 09:31:34.33'
        , request_start_time = '0.033'
        , parsing_start_time = '0.571'
        , mapping_complete_time = '0.040'
        , mongo_start_time = '0.058'
        , search_end_time = '0.035'
        , total_duration = '0.798'
        , error_description = ''
        , memory_used = '9999704'
        WHERE id = '140684909';
[05/21/2024 09:31:34], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '14'
        , 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=15&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 09:31:34.36'
        , request_start_time = '0.048'
        , parsing_start_time = '0.575'
        , mapping_complete_time = '0.038'
        , mongo_start_time = '0.057'
        , search_end_time = '0.036'
        , total_duration = '0.825'
        , error_description = ''
        , memory_used = '9381504'
        WHERE id = '140684910';
[05/21/2024 09:31:34], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '8'
        , 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=10&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 09:31:34.36'
        , request_start_time = '0.031'
        , parsing_start_time = '0.570'
        , mapping_complete_time = '0.055'
        , mongo_start_time = '0.072'
        , search_end_time = '0.043'
        , total_duration = '0.845'
        , error_description = ''
        , memory_used = '8130656'
        WHERE id = '140684911';
[05/21/2024 09:31:34], [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_09_31_34_1716283894_29.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_31_34_1716283894_29.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_31_34_1716283894_29.xml', 'agoda', '2024-05-21 09:31:34', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9834937');
[05/21/2024 09:31:34], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '11'
        , 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=14&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 09:31:34.35'
        , request_start_time = '0.033'
        , parsing_start_time = '0.612'
        , mapping_complete_time = '0.036'
        , mongo_start_time = '0.053'
        , search_end_time = '0.043'
        , total_duration = '0.865'
        , error_description = ''
        , memory_used = '9151136'
        WHERE id = '140684912';
[05/21/2024 09:31:34], [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_09_31_34_1716283894_12.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_31_34_1716283894_12.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_31_34_1716283894_12.xml', 'agoda', '2024-05-21 09:31:34', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9834937');
[05/21/2024 09:31:34], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '9'
        , 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=29&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 09:31:34.38'
        , request_start_time = '0.040'
        , parsing_start_time = '0.659'
        , mapping_complete_time = '0.043'
        , mongo_start_time = '0.063'
        , search_end_time = '0.038'
        , total_duration = '0.926'
        , error_description = ''
        , memory_used = '10053888'
        WHERE id = '140684913';
[05/21/2024 09:31:34], [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_09_31_34_1716283894_17.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_31_34_1716283894_17.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_31_34_1716283894_17.xml', 'agoda', '2024-05-21 09:31:34', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9834937');
[05/21/2024 09:31:34], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '9'
        , 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=12&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 09:31:34.37'
        , request_start_time = '0.028'
        , parsing_start_time = '0.729'
        , mapping_complete_time = '0.040'
        , mongo_start_time = '0.058'
        , search_end_time = '0.041'
        , total_duration = '0.959'
        , error_description = ''
        , memory_used = '9644696'
        WHERE id = '140684915';
[05/21/2024 09:31:34], [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_09_31_34_1716283894_23.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_31_34_1716283894_23.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_31_34_1716283894_23.xml', 'agoda', '2024-05-21 09:31:34', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9834937');
[05/21/2024 09:31: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_09_31_34_1716283894_27.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_31_34_1716283894_27.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_31_34_1716283894_27.xml', 'agoda', '2024-05-21 09:31:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9834937');
[05/21/2024 09:31: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_09_31_34_1716283894_33.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_31_34_1716283894_33.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_31_34_1716283894_33.xml', 'agoda', '2024-05-21 09:31:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9834937');
[05/21/2024 09:31: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_09_31_34_1716283894_28.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_31_34_1716283894_28.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_31_34_1716283894_28.xml', 'agoda', '2024-05-21 09:31:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9834937');
[05/21/2024 09:31: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_09_31_34_1716283894_19.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_31_34_1716283894_19.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_31_34_1716283894_19.xml', 'agoda', '2024-05-21 09:31:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9834937');
[05/21/2024 09:31: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_09_31_34_1716283894_5.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_31_34_1716283894_5.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_31_34_1716283894_5.xml', 'agoda', '2024-05-21 09:31:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9834937');
[05/21/2024 09:31: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_09_31_34_1716283894_16.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_31_34_1716283894_16.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_31_34_1716283894_16.xml', 'agoda', '2024-05-21 09:31:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9834937');
[05/21/2024 09:31: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_09_31_34_1716283894_13.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_31_34_1716283894_13.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_31_34_1716283894_13.xml', 'agoda', '2024-05-21 09:31:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9834937');
[05/21/2024 09:31: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_09_31_34_1716283894_25.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_31_34_1716283894_25.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_31_34_1716283894_25.xml', 'agoda', '2024-05-21 09:31:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9834937');
[05/21/2024 09:31: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_09_31_34_1716283894_20.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_31_34_1716283894_20.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_31_34_1716283894_20.xml', 'agoda', '2024-05-21 09:31:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9834937');
[05/21/2024 09:31: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_09_31_34_1716283894_4.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_31_34_1716283894_4.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_31_34_1716283894_4.xml', 'agoda', '2024-05-21 09:31:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9834937');
[05/21/2024 09:31: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_09_31_34_1716283894_32.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_31_34_1716283894_32.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_31_34_1716283894_32.xml', 'agoda', '2024-05-21 09:31:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9834937');
[05/21/2024 09:31:35], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '8'
        , 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=28&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 09:31:34.38'
        , request_start_time = '0.038'
        , parsing_start_time = '0.781'
        , mapping_complete_time = '0.056'
        , mongo_start_time = '0.082'
        , search_end_time = '0.091'
        , total_duration = '1.118'
        , error_description = ''
        , memory_used = '10084216'
        WHERE id = '140684920';
[05/21/2024 09:31: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_09_31_34_1716283894_18.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_31_34_1716283894_18.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_31_34_1716283894_18.xml', 'agoda', '2024-05-21 09:31:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9834937');
[05/21/2024 09:31:35], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '11'
        , 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=17&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 09:31:34.37'
        , request_start_time = '0.037'
        , parsing_start_time = '0.731'
        , mapping_complete_time = '0.091'
        , mongo_start_time = '0.120'
        , search_end_time = '0.102'
        , total_duration = '1.124'
        , error_description = ''
        , memory_used = '11028760'
        WHERE id = '140684916';
[05/21/2024 09:31: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_09_31_34_1716283894_3.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_31_34_1716283894_3.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_31_34_1716283894_3.xml', 'agoda', '2024-05-21 09:31:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9834937');
[05/21/2024 09:31: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_09_31_34_1716283894_22.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_31_34_1716283894_22.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_31_34_1716283894_22.xml', 'agoda', '2024-05-21 09:31:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9834937');
[05/21/2024 09:31: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_09_31_34_1716283894_30.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_31_34_1716283894_30.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_31_34_1716283894_30.xml', 'agoda', '2024-05-21 09:31:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9834937');
[05/21/2024 09:31:35], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '13'
        , 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=23&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 09:31:34.38'
        , request_start_time = '0.035'
        , parsing_start_time = '0.757'
        , mapping_complete_time = '0.078'
        , mongo_start_time = '0.110'
        , search_end_time = '0.105'
        , total_duration = '1.128'
        , error_description = ''
        , memory_used = '10722096'
        WHERE id = '140684917';
[05/21/2024 09:31: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_09_31_34_1716283894_24.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_31_34_1716283894_24.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_31_34_1716283894_24.xml', 'agoda', '2024-05-21 09:31:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9834937');
[05/21/2024 09:31:35], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '12'
        , 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=16&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 09:31:34.38'
        , request_start_time = '0.038'
        , parsing_start_time = '0.783'
        , mapping_complete_time = '0.089'
        , mongo_start_time = '0.142'
        , search_end_time = '0.065'
        , total_duration = '1.145'
        , error_description = ''
        , memory_used = '9852328'
        WHERE id = '140684923';
[05/21/2024 09:31: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_09_31_34_1716283894_21.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_31_34_1716283894_21.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_31_34_1716283894_21.xml', 'agoda', '2024-05-21 09:31:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9834937');
[05/21/2024 09:31: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_09_31_34_1716283894_6.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_31_34_1716283894_6.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_31_34_1716283894_6.xml', 'agoda', '2024-05-21 09:31:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9834937');
[05/21/2024 09:31:35], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '14'
        , 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=27&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 09:31:34.41'
        , request_start_time = '0.032'
        , parsing_start_time = '0.742'
        , mapping_complete_time = '0.082'
        , mongo_start_time = '0.114'
        , search_end_time = '0.142'
        , total_duration = '1.163'
        , error_description = ''
        , memory_used = '11832944'
        WHERE id = '140684918';
[05/21/2024 09:31:35], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '24'
        , 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=5&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 09:31:34.37'
        , request_start_time = '0.044'
        , parsing_start_time = '0.794'
        , mapping_complete_time = '0.081'
        , mongo_start_time = '0.140'
        , search_end_time = '0.080'
        , total_duration = '1.170'
        , error_description = ''
        , memory_used = '12391592'
        WHERE id = '140684922';
[05/21/2024 09:31:35], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '24'
        , 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=19&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 09:31:34.38'
        , request_start_time = '0.042'
        , parsing_start_time = '0.788'
        , mapping_complete_time = '0.074'
        , mongo_start_time = '0.142'
        , search_end_time = '0.097'
        , total_duration = '1.175'
        , error_description = ''
        , memory_used = '12320024'
        WHERE id = '140684921';
[05/21/2024 09:31: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_09_31_34_1716283894_26.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_31_34_1716283894_26.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_31_34_1716283894_26.xml', 'agoda', '2024-05-21 09:31:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9834937');
[05/21/2024 09:31: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_09_31_34_1716283894_31.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_31_34_1716283894_31.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_31_34_1716283894_31.xml', 'agoda', '2024-05-21 09:31:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9834937');
[05/21/2024 09:31:35], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '18'
        , 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=33&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 09:31:34.38'
        , request_start_time = '0.043'
        , parsing_start_time = '0.763'
        , mapping_complete_time = '0.075'
        , mongo_start_time = '0.123'
        , search_end_time = '0.144'
        , total_duration = '1.192'
        , error_description = ''
        , memory_used = '12665904'
        WHERE id = '140684919';
[05/21/2024 09:31:35], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '18'
        , 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=25&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 09:31:34.38'
        , request_start_time = '0.032'
        , parsing_start_time = '0.802'
        , mapping_complete_time = '0.126'
        , mongo_start_time = '0.185'
        , search_end_time = '0.091'
        , total_duration = '1.207'
        , error_description = ''
        , memory_used = '13346760'
        WHERE id = '140684925';
[05/21/2024 09:31:35], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '17'
        , 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=13&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 09:31:34.36'
        , request_start_time = '0.029'
        , parsing_start_time = '0.772'
        , mapping_complete_time = '0.106'
        , mongo_start_time = '0.186'
        , search_end_time = '0.091'
        , total_duration = '1.216'
        , error_description = ''
        , memory_used = '11895320'
        WHERE id = '140684924';
[05/21/2024 09:31: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_09_31_34_1716283894_34.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_31_34_1716283894_34.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_31_34_1716283894_34.xml', 'agoda', '2024-05-21 09:31:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9834937');
[05/21/2024 09:31:35], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '21'
        , 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=20&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 09:31:34.40'
        , request_start_time = '0.033'
        , parsing_start_time = '0.821'
        , mapping_complete_time = '0.117'
        , mongo_start_time = '0.162'
        , search_end_time = '0.095'
        , total_duration = '1.237'
        , error_description = ''
        , memory_used = '12460720'
        WHERE id = '140684926';
[05/21/2024 09:31:35], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '21'
        , 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=4&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 09:31:34.33'
        , request_start_time = '0.042'
        , parsing_start_time = '0.855'
        , mapping_complete_time = '0.130'
        , mongo_start_time = '0.170'
        , search_end_time = '0.087'
        , total_duration = '1.252'
        , error_description = ''
        , memory_used = '13944296'
        WHERE id = '140684927';
[05/21/2024 09:31:35], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '16'
        , 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=18&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 09:31:34.42'
        , request_start_time = '0.045'
        , parsing_start_time = '0.869'
        , mapping_complete_time = '0.109'
        , mongo_start_time = '0.149'
        , search_end_time = '0.079'
        , total_duration = '1.250'
        , error_description = ''
        , memory_used = '12699400'
        WHERE id = '140684929';
[05/21/2024 09:31:35], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '24'
        , 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=32&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 09:31:34.37'
        , request_start_time = '0.034'
        , parsing_start_time = '0.838'
        , mapping_complete_time = '0.128'
        , mongo_start_time = '0.171'
        , search_end_time = '0.094'
        , total_duration = '1.268'
        , error_description = ''
        , memory_used = '14399496'
        WHERE id = '140684928';
[05/21/2024 09:31: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_09_31_34_1716283894_0.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_31_34_1716283894_0.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_31_34_1716283894_0.xml', 'agoda', '2024-05-21 09:31:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9834937');
[05/21/2024 09:31:35], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '23'
        , 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=22&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 09:31:34.41'
        , request_start_time = '0.034'
        , parsing_start_time = '0.838'
        , mapping_complete_time = '0.161'
        , mongo_start_time = '0.210'
        , search_end_time = '0.077'
        , total_duration = '1.274'
        , error_description = ''
        , memory_used = '14842936'
        WHERE id = '140684931';
[05/21/2024 09:31: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_09_31_34_1716283894_2.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_31_34_1716283894_2.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_31_34_1716283894_2.xml', 'agoda', '2024-05-21 09:31:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9834937');
[05/21/2024 09:31: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_09_31_34_1716283894_7.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_31_34_1716283894_7.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_31_34_1716283894_7.xml', 'agoda', '2024-05-21 09:31:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9834937');
[05/21/2024 09:31:35], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '16'
        , 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=6&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 09:31:34.37'
        , request_start_time = '0.032'
        , parsing_start_time = '0.872'
        , mapping_complete_time = '0.125'
        , mongo_start_time = '0.178'
        , search_end_time = '0.071'
        , total_duration = '1.291'
        , error_description = ''
        , memory_used = '11323912'
        WHERE id = '140684935';
[05/21/2024 09:31:35], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '15'
        , 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=24&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 09:31:34.36'
        , request_start_time = '0.029'
        , parsing_start_time = '0.853'
        , mapping_complete_time = '0.150'
        , mongo_start_time = '0.210'
        , search_end_time = '0.074'
        , total_duration = '1.296'
        , error_description = ''
        , memory_used = '13368192'
        WHERE id = '140684933';
[05/21/2024 09:31: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_09_31_34_1716283894_1.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_31_34_1716283894_1.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_31_34_1716283894_1.xml', 'agoda', '2024-05-21 09:31:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9834937');
[05/21/2024 09:31:35], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '18'
        , 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=3&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 09:31:34.33'
        , request_start_time = '0.040'
        , parsing_start_time = '0.841'
        , mapping_complete_time = '0.144'
        , mongo_start_time = '0.193'
        , search_end_time = '0.101'
        , total_duration = '1.306'
        , error_description = ''
        , memory_used = '12602568'
        WHERE id = '140684930';
[05/21/2024 09:31:35], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '19'
        , 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=30&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 09:31:34.42'
        , request_start_time = '0.042'
        , parsing_start_time = '0.870'
        , mapping_complete_time = '0.136'
        , mongo_start_time = '0.196'
        , search_end_time = '0.094'
        , total_duration = '1.307'
        , error_description = ''
        , memory_used = '15056648'
        WHERE id = '140684932';
[05/21/2024 09:31:35], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '17'
        , 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=26&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 09:31:34.37'
        , request_start_time = '0.039'
        , parsing_start_time = '0.886'
        , mapping_complete_time = '0.152'
        , mongo_start_time = '0.216'
        , search_end_time = '0.068'
        , total_duration = '1.326'
        , error_description = ''
        , memory_used = '14439288'
        WHERE id = '140684936';
[05/21/2024 09:31:35], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '22'
        , 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=31&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 09:31:34.38'
        , request_start_time = '0.039'
        , parsing_start_time = '0.892'
        , mapping_complete_time = '0.158'
        , mongo_start_time = '0.217'
        , search_end_time = '0.078'
        , total_duration = '1.338'
        , error_description = ''
        , memory_used = '16831256'
        WHERE id = '140684937';
[05/21/2024 09:31:35], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '22'
        , 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=21&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 09:31:34.36'
        , request_start_time = '0.036'
        , parsing_start_time = '0.877'
        , mapping_complete_time = '0.131'
        , mongo_start_time = '0.221'
        , search_end_time = '0.092'
        , total_duration = '1.351'
        , error_description = ''
        , memory_used = '14543104'
        WHERE id = '140684934';
[05/21/2024 09:31:35], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '21'
        , 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=34&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 09:31:34.37'
        , request_start_time = '0.038'
        , parsing_start_time = '0.946'
        , mapping_complete_time = '0.134'
        , mongo_start_time = '0.183'
        , search_end_time = '0.071'
        , total_duration = '1.367'
        , error_description = ''
        , memory_used = '15417184'
        WHERE id = '140684938';
[05/21/2024 09:31:35], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '23'
        , 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=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 09:31:34.37'
        , request_start_time = '0.037'
        , parsing_start_time = '0.987'
        , mapping_complete_time = '0.131'
        , mongo_start_time = '0.167'
        , search_end_time = '0.071'
        , total_duration = '1.392'
        , error_description = ''
        , memory_used = '15827184'
        WHERE id = '140684939';
[05/21/2024 09:31:35], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '17'
        , 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=7&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 09:31:34.35'
        , request_start_time = '0.045'
        , parsing_start_time = '1.043'
        , mapping_complete_time = '0.102'
        , mongo_start_time = '0.140'
        , search_end_time = '0.062'
        , total_duration = '1.401'
        , error_description = ''
        , memory_used = '14149040'
        WHERE id = '140684941';
[05/21/2024 09:31:35], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '25'
        , 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=2&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 09:31:34.33'
        , request_start_time = '0.047'
        , parsing_start_time = '0.989'
        , mapping_complete_time = '0.151'
        , mongo_start_time = '0.184'
        , search_end_time = '0.075'
        , total_duration = '1.406'
        , error_description = ''
        , memory_used = '16029736'
        WHERE id = '140684940';
[05/21/2024 09:31:35], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '24'
        , 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=1&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 09:31:34.32'
        , request_start_time = '0.046'
        , parsing_start_time = '0.998'
        , mapping_complete_time = '0.167'
        , mongo_start_time = '0.206'
        , search_end_time = '0.080'
        , total_duration = '1.447'
        , error_description = ''
        , memory_used = '16130248'
        WHERE id = '140684942';
[05/21/2024 09:31:35], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '569',
        request_path = '/xml_all.php?userid=1284&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02',
        duration = '1.924',
        merge_duration = '0.125',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '8.71',
        system_load_5_min = '11.52',
        system_load_15_min = '11.20',
        system_memory_usage = '92.05',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '9834937') + '20850536',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '9834937';
[05/21/2024 09:34: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 = '' , country_of_residence = '129' , service_type = 'hotel' , arrival_date = '2024/07/04' , departure_date = '2024/07/05' , nights = '1' , nationality = '129' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-05-21 09:34: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 09:34:37], [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_09_34_36_1716284076_11.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_34_36_1716284076_11.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_34_36_1716284076_11.xml', 'agoda', '2024-05-21 09:34:37', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9835171');
[05/21/2024 09:34:37], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '5'
        , 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=11&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 09:34:36.560'
        , request_start_time = '0.098'
        , parsing_start_time = '0.473'
        , mapping_complete_time = '0.032'
        , mongo_start_time = '0.047'
        , search_end_time = '0.030'
        , total_duration = '0.926'
        , error_description = ''
        , memory_used = '7032824'
        WHERE id = '140686078';
[05/21/2024 09:34:37], [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_09_34_36_1716284076_10.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_34_36_1716284076_10.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_34_36_1716284076_10.xml', 'agoda', '2024-05-21 09:34:37', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9835171');
[05/21/2024 09:34:37], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '7'
        , 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=10&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 09:34:36.549'
        , request_start_time = '0.122'
        , parsing_start_time = '0.534'
        , mapping_complete_time = '0.035'
        , mongo_start_time = '0.052'
        , search_end_time = '0.031'
        , total_duration = '1.024'
        , error_description = ''
        , memory_used = '8029056'
        WHERE id = '140686079';
[05/21/2024 09:34:37], [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_09_34_37_1716284077_8.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_34_37_1716284077_8.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_34_37_1716284077_8.xml', 'agoda', '2024-05-21 09:34:37', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9835171');
[05/21/2024 09:34:37], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '4'
        , 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=8&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 09:34:36.549'
        , request_start_time = '0.112'
        , parsing_start_time = '0.477'
        , mapping_complete_time = '0.047'
        , mongo_start_time = '0.064'
        , search_end_time = '0.028'
        , total_duration = '1.100'
        , error_description = ''
        , memory_used = '7448520'
        WHERE id = '140686081';
[05/21/2024 09:34:37], [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_09_34_37_1716284077_9.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_34_37_1716284077_9.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_34_37_1716284077_9.xml', 'agoda', '2024-05-21 09:34:37', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9835171');
[05/21/2024 09:34:37], [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_09_34_37_1716284077_17.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_34_37_1716284077_17.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_34_37_1716284077_17.xml', 'agoda', '2024-05-21 09:34:37', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9835171');
[05/21/2024 09:34:37], [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_09_34_37_1716284077_14.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_34_37_1716284077_14.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_34_37_1716284077_14.xml', 'agoda', '2024-05-21 09:34:37', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9835171');
[05/21/2024 09:34:37], [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_09_34_37_1716284077_15.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_34_37_1716284077_15.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_34_37_1716284077_15.xml', 'agoda', '2024-05-21 09:34:37', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9835171');
[05/21/2024 09:34:37], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '8'
        , 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=9&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 09:34:36.547'
        , request_start_time = '0.103'
        , parsing_start_time = '0.570'
        , mapping_complete_time = '0.069'
        , mongo_start_time = '0.090'
        , search_end_time = '0.051'
        , total_duration = '1.292'
        , error_description = ''
        , memory_used = '9709744'
        WHERE id = '140686088';
[05/21/2024 09:34:37], [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_09_34_37_1716284077_13.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_34_37_1716284077_13.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_34_37_1716284077_13.xml', 'agoda', '2024-05-21 09:34:37', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9835171');
[05/21/2024 09:34:37], [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_09_34_37_1716284077_16.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_34_37_1716284077_16.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_34_37_1716284077_16.xml', 'agoda', '2024-05-21 09:34:37', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9835171');
[05/21/2024 09:34:37], [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_09_34_37_1716284077_28.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_34_37_1716284077_28.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_34_37_1716284077_28.xml', 'agoda', '2024-05-21 09:34:37', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9835171');
[05/21/2024 09:34:37], [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_09_34_37_1716284077_12.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_34_37_1716284077_12.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_34_37_1716284077_12.xml', 'agoda', '2024-05-21 09:34:37', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9835171');
[05/21/2024 09:34:37], [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_09_34_37_1716284077_29.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_34_37_1716284077_29.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_34_37_1716284077_29.xml', 'agoda', '2024-05-21 09:34:37', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9835171');
[05/21/2024 09:34:37], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '11'
        , 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=14&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 09:34:36.560'
        , request_start_time = '0.075'
        , parsing_start_time = '0.759'
        , mapping_complete_time = '0.044'
        , mongo_start_time = '0.081'
        , search_end_time = '0.051'
        , total_duration = '1.372'
        , error_description = ''
        , memory_used = '8733952'
        WHERE id = '140686091';
[05/21/2024 09:34:37], [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_09_34_37_1716284077_27.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_34_37_1716284077_27.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_34_37_1716284077_27.xml', 'agoda', '2024-05-21 09:34:37', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9835171');
[05/21/2024 09:34:37], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '13'
        , 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=15&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 09:34:36.550'
        , request_start_time = '0.130'
        , parsing_start_time = '0.614'
        , mapping_complete_time = '0.084'
        , mongo_start_time = '0.109'
        , search_end_time = '0.053'
        , total_duration = '1.387'
        , error_description = ''
        , memory_used = '9439536'
        WHERE id = '140686092';
[05/21/2024 09:34:37], [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_09_34_37_1716284077_19.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_34_37_1716284077_19.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_34_37_1716284077_19.xml', 'agoda', '2024-05-21 09:34:37', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9835171');
[05/21/2024 09:34:37], [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_09_34_37_1716284077_5.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_34_37_1716284077_5.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_34_37_1716284077_5.xml', 'agoda', '2024-05-21 09:34:37', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9835171');
[05/21/2024 09:34:37], [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_09_34_37_1716284077_7.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_34_37_1716284077_7.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_34_37_1716284077_7.xml', 'agoda', '2024-05-21 09:34:37', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9835171');
[05/21/2024 09:34:37], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '17'
        , 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=13&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 09:34:36.557'
        , request_start_time = '0.105'
        , parsing_start_time = '0.799'
        , mapping_complete_time = '0.109'
        , mongo_start_time = '0.151'
        , search_end_time = '0.067'
        , total_duration = '1.429'
        , error_description = ''
        , memory_used = '12290848'
        WHERE id = '140686094';
[05/21/2024 09:34:37], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '12'
        , 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=16&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 09:34:36.560'
        , request_start_time = '0.155'
        , parsing_start_time = '0.663'
        , mapping_complete_time = '0.091'
        , mongo_start_time = '0.117'
        , search_end_time = '0.067'
        , total_duration = '1.434'
        , error_description = ''
        , memory_used = '10171232'
        WHERE id = '140686095';
[05/21/2024 09:34:38], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '9'
        , 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=12&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 09:34:36.553'
        , request_start_time = '0.112'
        , parsing_start_time = '0.656'
        , mapping_complete_time = '0.063'
        , mongo_start_time = '0.089'
        , search_end_time = '0.054'
        , total_duration = '1.449'
        , error_description = ''
        , memory_used = '9611720'
        WHERE id = '140686098';
[05/21/2024 09:34:38], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '11'
        , 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=17&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 09:34:36.569'
        , request_start_time = '0.147'
        , parsing_start_time = '0.652'
        , mapping_complete_time = '0.075'
        , mongo_start_time = '0.111'
        , search_end_time = '0.131'
        , total_duration = '1.434'
        , error_description = ''
        , memory_used = '15517064'
        WHERE id = '140686090';
[05/21/2024 09:34: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_09_34_37_1716284077_23.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_34_37_1716284077_23.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_34_37_1716284077_23.xml', 'agoda', '2024-05-21 09:34:38', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9835171');
[05/21/2024 09:34: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_09_34_37_1716284077_6.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_34_37_1716284077_6.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_34_37_1716284077_6.xml', 'agoda', '2024-05-21 09:34:38', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9835171');
[05/21/2024 09:34:38], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '9'
        , 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=29&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 09:34:36.647'
        , request_start_time = '0.125'
        , parsing_start_time = '0.708'
        , mapping_complete_time = '0.075'
        , mongo_start_time = '0.111'
        , search_end_time = '0.059'
        , total_duration = '1.383'
        , error_description = ''
        , memory_used = '9981936'
        WHERE id = '140686099';
[05/21/2024 09:34: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_09_34_37_1716284077_24.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_34_37_1716284077_24.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_34_37_1716284077_24.xml', 'agoda', '2024-05-21 09:34:38', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9835171');
[05/21/2024 09:34:38], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '14'
        , 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=27&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 09:34:36.649'
        , request_start_time = '0.122'
        , parsing_start_time = '0.715'
        , mapping_complete_time = '0.088'
        , mongo_start_time = '0.115'
        , search_end_time = '0.054'
        , total_duration = '1.399'
        , error_description = ''
        , memory_used = '11811480'
        WHERE id = '140686100';
[05/21/2024 09:34:38], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '8'
        , 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=28&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 09:34:36.569'
        , request_start_time = '0.135'
        , parsing_start_time = '0.748'
        , mapping_complete_time = '0.064'
        , mongo_start_time = '0.095'
        , search_end_time = '0.107'
        , total_duration = '1.480'
        , error_description = ''
        , memory_used = '14676384'
        WHERE id = '140686096';
[05/21/2024 09:34: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_09_34_37_1716284077_21.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_34_37_1716284077_21.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_34_37_1716284077_21.xml', 'agoda', '2024-05-21 09:34:38', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9835171');
[05/21/2024 09:34: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_09_34_37_1716284077_32.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_34_37_1716284077_32.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_34_37_1716284077_32.xml', 'agoda', '2024-05-21 09:34:38', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9835171');
[05/21/2024 09:34: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_09_34_37_1716284077_20.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_34_37_1716284077_20.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_34_37_1716284077_20.xml', 'agoda', '2024-05-21 09:34:38', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9835171');
[05/21/2024 09:34:38], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '24'
        , 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=19&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 09:34:36.559'
        , request_start_time = '0.168'
        , parsing_start_time = '0.755'
        , mapping_complete_time = '0.084'
        , mongo_start_time = '0.121'
        , search_end_time = '0.083'
        , total_duration = '1.555'
        , error_description = ''
        , memory_used = '12319168'
        WHERE id = '140686101';
[05/21/2024 09:34: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_09_34_37_1716284077_22.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_34_37_1716284077_22.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_34_37_1716284077_22.xml', 'agoda', '2024-05-21 09:34:38', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9835171');
[05/21/2024 09:34:38], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '13'
        , 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=23&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 09:34:36.662'
        , request_start_time = '0.113'
        , parsing_start_time = '0.761'
        , mapping_complete_time = '0.100'
        , mongo_start_time = '0.133'
        , search_end_time = '0.066'
        , total_duration = '1.486'
        , error_description = ''
        , memory_used = '10776600'
        WHERE id = '140686104';
[05/21/2024 09:34: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_09_34_37_1716284077_33.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_34_37_1716284077_33.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_34_37_1716284077_33.xml', 'agoda', '2024-05-21 09:34:38', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9835171');
[05/21/2024 09:34:38], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '16'
        , 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=6&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 09:34:36.653'
        , request_start_time = '0.080'
        , parsing_start_time = '0.857'
        , mapping_complete_time = '0.084'
        , mongo_start_time = '0.112'
        , search_end_time = '0.068'
        , total_duration = '1.493'
        , error_description = ''
        , memory_used = '11168080'
        WHERE id = '140686105';
[05/21/2024 09:34:38], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '17'
        , 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=7&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 09:34:36.552'
        , request_start_time = '0.083'
        , parsing_start_time = '0.889'
        , mapping_complete_time = '0.138'
        , mongo_start_time = '0.176'
        , search_end_time = '0.096'
        , total_duration = '1.610'
        , error_description = ''
        , memory_used = '14196000'
        WHERE id = '140686103';
[05/21/2024 09:34:38], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '15'
        , 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=24&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 09:34:36.648'
        , request_start_time = '0.096'
        , parsing_start_time = '0.768'
        , mapping_complete_time = '0.115'
        , mongo_start_time = '0.159'
        , search_end_time = '0.075'
        , total_duration = '1.528'
        , error_description = ''
        , memory_used = '13397096'
        WHERE id = '140686106';
[05/21/2024 09:34:38], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '24'
        , 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=5&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 09:34:36.559'
        , request_start_time = '0.194'
        , parsing_start_time = '0.875'
        , mapping_complete_time = '0.095'
        , mongo_start_time = '0.130'
        , search_end_time = '0.144'
        , total_duration = '1.634'
        , error_description = ''
        , memory_used = '16721808'
        WHERE id = '140686102';
[05/21/2024 09:34: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_09_34_37_1716284077_4.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_34_37_1716284077_4.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_34_37_1716284077_4.xml', 'agoda', '2024-05-21 09:34:38', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9835171');
[05/21/2024 09:34: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_09_34_37_1716284077_25.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_34_37_1716284077_25.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_34_37_1716284077_25.xml', 'agoda', '2024-05-21 09:34:38', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9835171');
[05/21/2024 09:34: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_09_34_37_1716284077_18.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_34_37_1716284077_18.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_34_37_1716284077_18.xml', 'agoda', '2024-05-21 09:34:38', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9835171');
[05/21/2024 09:34: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_09_34_37_1716284077_34.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_34_37_1716284077_34.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_34_37_1716284077_34.xml', 'agoda', '2024-05-21 09:34:38', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9835171');
[05/21/2024 09:34: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_09_34_37_1716284077_3.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_34_37_1716284077_3.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_34_37_1716284077_3.xml', 'agoda', '2024-05-21 09:34:38', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9835171');
[05/21/2024 09:34: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_09_34_37_1716284077_26.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_34_37_1716284077_26.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_34_37_1716284077_26.xml', 'agoda', '2024-05-21 09:34:38', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9835171');
[05/21/2024 09:34:38], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '22'
        , 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=21&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 09:34:36.662'
        , request_start_time = '0.073'
        , parsing_start_time = '0.939'
        , mapping_complete_time = '0.102'
        , mongo_start_time = '0.147'
        , search_end_time = '0.098'
        , total_duration = '1.570'
        , error_description = ''
        , memory_used = '14787008'
        WHERE id = '140686108';
[05/21/2024 09:34: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_09_34_37_1716284077_30.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_34_37_1716284077_30.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_34_37_1716284077_30.xml', 'agoda', '2024-05-21 09:34:38', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9835171');
[05/21/2024 09:34:38], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '21'
        , 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=20&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 09:34:36.651'
        , request_start_time = '0.102'
        , parsing_start_time = '0.815'
        , mapping_complete_time = '0.103'
        , mongo_start_time = '0.142'
        , search_end_time = '0.095'
        , total_duration = '1.618'
        , error_description = ''
        , memory_used = '12317800'
        WHERE id = '140686110';
[05/21/2024 09:34:38], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '24'
        , 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=32&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 09:34:36.673'
        , request_start_time = '0.123'
        , parsing_start_time = '0.837'
        , mapping_complete_time = '0.147'
        , mongo_start_time = '0.187'
        , search_end_time = '0.095'
        , total_duration = '1.598'
        , error_description = ''
        , memory_used = '14049200'
        WHERE id = '140686109';
[05/21/2024 09:34:38], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '18'
        , 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=33&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 09:34:36.647'
        , request_start_time = '0.069'
        , parsing_start_time = '0.858'
        , mapping_complete_time = '0.110'
        , mongo_start_time = '0.152'
        , search_end_time = '0.067'
        , total_duration = '1.650'
        , error_description = ''
        , memory_used = '12728544'
        WHERE id = '140686112';
[05/21/2024 09:34: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_09_34_37_1716284077_2.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_34_37_1716284077_2.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_34_37_1716284077_2.xml', 'agoda', '2024-05-21 09:34:38', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9835171');
[05/21/2024 09:34:38], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '16'
        , 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=18&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 09:34:36.569'
        , request_start_time = '0.143'
        , parsing_start_time = '0.967'
        , mapping_complete_time = '0.115'
        , mongo_start_time = '0.150'
        , search_end_time = '0.059'
        , total_duration = '1.755'
        , error_description = ''
        , memory_used = '12407560'
        WHERE id = '140686115';
[05/21/2024 09:34:38], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '23'
        , 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=22&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 09:34:36.646'
        , request_start_time = '0.074'
        , parsing_start_time = '0.831'
        , mapping_complete_time = '0.138'
        , mongo_start_time = '0.172'
        , search_end_time = '0.138'
        , total_duration = '1.684'
        , error_description = ''
        , memory_used = '18644856'
        WHERE id = '140686111';
[05/21/2024 09:34:38], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '21'
        , 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=4&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 09:34:36.558'
        , request_start_time = '0.112'
        , parsing_start_time = '1.013'
        , mapping_complete_time = '0.128'
        , mongo_start_time = '0.166'
        , search_end_time = '0.076'
        , total_duration = '1.777'
        , error_description = ''
        , memory_used = '13560200'
        WHERE id = '140686113';
[05/21/2024 09:34:38], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '18'
        , 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=25&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 09:34:36.646'
        , request_start_time = '0.068'
        , parsing_start_time = '0.863'
        , mapping_complete_time = '0.145'
        , mongo_start_time = '0.182'
        , search_end_time = '0.065'
        , total_duration = '1.687'
        , error_description = ''
        , memory_used = '13285888'
        WHERE id = '140686114';
[05/21/2024 09:34:38], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '18'
        , 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=3&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 09:34:36.556'
        , request_start_time = '0.128'
        , parsing_start_time = '1.041'
        , mapping_complete_time = '0.116'
        , mongo_start_time = '0.145'
        , search_end_time = '0.074'
        , total_duration = '1.796'
        , error_description = ''
        , memory_used = '12533168'
        WHERE id = '140686117';
[05/21/2024 09:34:38], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '17'
        , 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=26&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 09:34:36.593'
        , request_start_time = '0.074'
        , parsing_start_time = '0.961'
        , mapping_complete_time = '0.108'
        , mongo_start_time = '0.144'
        , search_end_time = '0.067'
        , total_duration = '1.767'
        , error_description = ''
        , memory_used = '14131312'
        WHERE id = '140686118';
[05/21/2024 09:34:38], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '21'
        , 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=34&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 09:34:36.662'
        , request_start_time = '0.104'
        , parsing_start_time = '0.937'
        , mapping_complete_time = '0.173'
        , mongo_start_time = '0.221'
        , search_end_time = '0.078'
        , total_duration = '1.707'
        , error_description = ''
        , memory_used = '15418248'
        WHERE id = '140686116';
[05/21/2024 09:34: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_09_34_37_1716284077_0.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_34_37_1716284077_0.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_34_37_1716284077_0.xml', 'agoda', '2024-05-21 09:34:38', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9835171');
[05/21/2024 09:34:38], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '18'
        , 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=30&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 09:34:36.614'
        , request_start_time = '0.112'
        , parsing_start_time = '0.967'
        , mapping_complete_time = '0.151'
        , mongo_start_time = '0.190'
        , search_end_time = '0.069'
        , total_duration = '1.763'
        , error_description = ''
        , memory_used = '15361296'
        WHERE id = '140686119';
[05/21/2024 09:34: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_09_34_37_1716284077_31.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_34_37_1716284077_31.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_34_37_1716284077_31.xml', 'agoda', '2024-05-21 09:34:38', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9835171');
[05/21/2024 09:34: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_09_34_37_1716284077_1.xml', 'a5/21_05_2024/response_availability_qtech_agent_09_34_37_1716284077_1.xml', 'a5/21_05_2024/response_header_availability_qtech_agent_09_34_37_1716284077_1.xml', 'agoda', '2024-05-21 09:34:38', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9835171');
[05/21/2024 09:34:38], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '25'
        , 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=2&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 09:34:36.546'
        , request_start_time = '0.135'
        , parsing_start_time = '1.046'
        , mapping_complete_time = '0.178'
        , mongo_start_time = '0.216'
        , search_end_time = '0.061'
        , total_duration = '1.885'
        , error_description = ''
        , memory_used = '15951736'
        WHERE id = '140686121';
[05/21/2024 09:34:38], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '22'
        , 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=31&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 09:34:36.569'
        , request_start_time = '0.160'
        , parsing_start_time = '1.131'
        , mapping_complete_time = '0.137'
        , mongo_start_time = '0.172'
        , search_end_time = '0.082'
        , total_duration = '1.983'
        , error_description = ''
        , memory_used = '15620512'
        WHERE id = '140686125';
[05/21/2024 09:34:38], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '24'
        , 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=1&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 09:34:36.647'
        , request_start_time = '0.120'
        , parsing_start_time = '1.181'
        , mapping_complete_time = '0.109'
        , mongo_start_time = '0.152'
        , search_end_time = '0.090'
        , total_duration = '1.929'
        , error_description = ''
        , memory_used = '16370608'
        WHERE id = '140686126';
[05/21/2024 09:34:38], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '22'
        , 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=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 09:34:36.553'
        , request_start_time = '0.060'
        , parsing_start_time = '0.997'
        , mapping_complete_time = '0.206'
        , mongo_start_time = '0.261'
        , search_end_time = '0.130'
        , total_duration = '2.024'
        , error_description = ''
        , memory_used = '15786064'
        WHERE id = '140686123';
[05/21/2024 09:34:38], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '565',
        request_path = '/xml_all.php?userid=1284&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02',
        duration = '3.954',
        merge_duration = '0.127',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '4.42',
        system_load_5_min = '7.15',
        system_load_15_min = '9.50',
        system_memory_usage = '94.64',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '9835171') + '20701928',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '9835171';
