                VALUE ('', 'availability', 'a5/14_05_2024/request_availability_qtech_agent_16_49_46_1715705386_24.xml', 'a5/14_05_2024/response_availability_qtech_agent_16_49_46_1715705386_24.xml', 'a5/14_05_2024/response_header_availability_qtech_agent_16_49_46_1715705386_24.xml', 'agoda', '2024-05-14 04:49:46', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9455057');
[05/14/2024 04:49:46], [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-14 16:49:45.984'
        , request_start_time = '0.020'
        , parsing_start_time = '0.434'
        , mapping_complete_time = '0.042'
        , mongo_start_time = '0.057'
        , search_end_time = '0.049'
        , total_duration = '0.655'
        , error_description = ''
        , memory_used = '7777744'
        WHERE id = '139180568';
[05/14/2024 04:49:46], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/14_05_2024/request_availability_qtech_agent_16_49_46_1715705386_13.xml', 'a5/14_05_2024/response_availability_qtech_agent_16_49_46_1715705386_13.xml', 'a5/14_05_2024/response_header_availability_qtech_agent_16_49_46_1715705386_13.xml', 'agoda', '2024-05-14 04:49:46', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9455057');
[05/14/2024 04:49:46], [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=12&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-14 16:49:45.984'
        , request_start_time = '0.022'
        , parsing_start_time = '0.432'
        , mapping_complete_time = '0.051'
        , mongo_start_time = '0.069'
        , search_end_time = '0.061'
        , total_duration = '0.677'
        , error_description = ''
        , memory_used = '8424200'
        WHERE id = '139180570';
[05/14/2024 04:49:46], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/14_05_2024/request_availability_qtech_agent_16_49_46_1715705386_27.xml', 'a5/14_05_2024/response_availability_qtech_agent_16_49_46_1715705386_27.xml', 'a5/14_05_2024/response_header_availability_qtech_agent_16_49_46_1715705386_27.xml', 'agoda', '2024-05-14 04:49:46', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9455057');
[05/14/2024 04:49:46], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '10'
        , 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-14 16:49:45.982'
        , request_start_time = '0.013'
        , parsing_start_time = '0.497'
        , mapping_complete_time = '0.052'
        , mongo_start_time = '0.073'
        , search_end_time = '0.061'
        , total_duration = '0.699'
        , error_description = ''
        , memory_used = '9382048'
        WHERE id = '139180572';
[05/14/2024 04:49:46], [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-14 16:49:45.978'
        , request_start_time = '0.017'
        , parsing_start_time = '0.419'
        , mapping_complete_time = '0.060'
        , mongo_start_time = '0.084'
        , search_end_time = '0.085'
        , total_duration = '0.706'
        , error_description = ''
        , memory_used = '9328328'
        WHERE id = '139180569';
[05/14/2024 04:49:46], [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=17&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-14 16:49:45.985'
        , request_start_time = '0.019'
        , parsing_start_time = '0.438'
        , mapping_complete_time = '0.083'
        , mongo_start_time = '0.101'
        , search_end_time = '0.089'
        , total_duration = '0.718'
        , error_description = ''
        , memory_used = '9745776'
        WHERE id = '139180571';
[05/14/2024 04:49:46], [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-14 16:49:45.978'
        , request_start_time = '0.017'
        , parsing_start_time = '0.454'
        , mapping_complete_time = '0.052'
        , mongo_start_time = '0.071'
        , search_end_time = '0.087'
        , total_duration = '0.728'
        , error_description = ''
        , memory_used = '8715944'
        WHERE id = '139180573';
[05/14/2024 04:49:46], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/14_05_2024/request_availability_qtech_agent_16_49_46_1715705386_6.xml', 'a5/14_05_2024/response_availability_qtech_agent_16_49_46_1715705386_6.xml', 'a5/14_05_2024/response_header_availability_qtech_agent_16_49_46_1715705386_6.xml', 'agoda', '2024-05-14 04:49:46', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9455057');
[05/14/2024 04:49:46], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/14_05_2024/request_availability_qtech_agent_16_49_46_1715705386_28.xml', 'a5/14_05_2024/response_availability_qtech_agent_16_49_46_1715705386_28.xml', 'a5/14_05_2024/response_header_availability_qtech_agent_16_49_46_1715705386_28.xml', 'agoda', '2024-05-14 04:49:46', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9455057');
[05/14/2024 04:49:46], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/14_05_2024/request_availability_qtech_agent_16_49_46_1715705386_19.xml', 'a5/14_05_2024/response_availability_qtech_agent_16_49_46_1715705386_19.xml', 'a5/14_05_2024/response_header_availability_qtech_agent_16_49_46_1715705386_19.xml', 'agoda', '2024-05-14 04:49:46', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9455057');
[05/14/2024 04:49:46], [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=16&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-14 16:49:45.983'
        , request_start_time = '0.011'
        , parsing_start_time = '0.493'
        , mapping_complete_time = '0.052'
        , mongo_start_time = '0.071'
        , search_end_time = '0.063'
        , total_duration = '0.745'
        , error_description = ''
        , memory_used = '9308216'
        WHERE id = '139180574';
[05/14/2024 04:49:46], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/14_05_2024/request_availability_qtech_agent_16_49_46_1715705386_23.xml', 'a5/14_05_2024/response_availability_qtech_agent_16_49_46_1715705386_23.xml', 'a5/14_05_2024/response_header_availability_qtech_agent_16_49_46_1715705386_23.xml', 'agoda', '2024-05-14 04:49:46', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9455057');
[05/14/2024 04:49:46], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/14_05_2024/request_availability_qtech_agent_16_49_46_1715705386_18.xml', 'a5/14_05_2024/response_availability_qtech_agent_16_49_46_1715705386_18.xml', 'a5/14_05_2024/response_header_availability_qtech_agent_16_49_46_1715705386_18.xml', 'agoda', '2024-05-14 04:49:46', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9455057');
[05/14/2024 04:49:46], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/14_05_2024/request_availability_qtech_agent_16_49_46_1715705386_32.xml', 'a5/14_05_2024/response_availability_qtech_agent_16_49_46_1715705386_32.xml', 'a5/14_05_2024/response_header_availability_qtech_agent_16_49_46_1715705386_32.xml', 'agoda', '2024-05-14 04:49:46', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9455057');
[05/14/2024 04:49:46], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/14_05_2024/request_availability_qtech_agent_16_49_46_1715705386_20.xml', 'a5/14_05_2024/response_availability_qtech_agent_16_49_46_1715705386_20.xml', 'a5/14_05_2024/response_header_availability_qtech_agent_16_49_46_1715705386_20.xml', 'agoda', '2024-05-14 04:49:46', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9455057');
[05/14/2024 04:49:46], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/14_05_2024/request_availability_qtech_agent_16_49_46_1715705386_30.xml', 'a5/14_05_2024/response_availability_qtech_agent_16_49_46_1715705386_30.xml', 'a5/14_05_2024/response_header_availability_qtech_agent_16_49_46_1715705386_30.xml', 'agoda', '2024-05-14 04:49:46', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9455057');
[05/14/2024 04:49:46], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/14_05_2024/request_availability_qtech_agent_16_49_46_1715705386_25.xml', 'a5/14_05_2024/response_availability_qtech_agent_16_49_46_1715705386_25.xml', 'a5/14_05_2024/response_header_availability_qtech_agent_16_49_46_1715705386_25.xml', 'agoda', '2024-05-14 04:49:46', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9455057');
[05/14/2024 04:49:46], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/14_05_2024/request_availability_qtech_agent_16_49_46_1715705386_7.xml', 'a5/14_05_2024/response_availability_qtech_agent_16_49_46_1715705386_7.xml', 'a5/14_05_2024/response_header_availability_qtech_agent_16_49_46_1715705386_7.xml', 'agoda', '2024-05-14 04:49:46', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9455057');
[05/14/2024 04:49:46], [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=13&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-14 16:49:45.979'
        , request_start_time = '0.016'
        , parsing_start_time = '0.505'
        , mapping_complete_time = '0.064'
        , mongo_start_time = '0.091'
        , search_end_time = '0.133'
        , total_duration = '0.856'
        , error_description = ''
        , memory_used = '11537920'
        WHERE id = '139180576';
[05/14/2024 04:49:46], [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-14 16:49:45.989'
        , request_start_time = '0.020'
        , parsing_start_time = '0.524'
        , mapping_complete_time = '0.076'
        , mongo_start_time = '0.117'
        , search_end_time = '0.146'
        , total_duration = '0.888'
        , error_description = ''
        , memory_used = '13665144'
        WHERE id = '139180577';
[05/14/2024 04:49:46], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/14_05_2024/request_availability_qtech_agent_16_49_46_1715705386_21.xml', 'a5/14_05_2024/response_availability_qtech_agent_16_49_46_1715705386_21.xml', 'a5/14_05_2024/response_header_availability_qtech_agent_16_49_46_1715705386_21.xml', 'agoda', '2024-05-14 04:49:46', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9455057');
[05/14/2024 04:49:46], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/14_05_2024/request_availability_qtech_agent_16_49_46_1715705386_33.xml', 'a5/14_05_2024/response_availability_qtech_agent_16_49_46_1715705386_33.xml', 'a5/14_05_2024/response_header_availability_qtech_agent_16_49_46_1715705386_33.xml', 'agoda', '2024-05-14 04:49:46', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9455057');
[05/14/2024 04:49:46], [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=24&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-14 16:49:45.981'
        , request_start_time = '0.013'
        , parsing_start_time = '0.532'
        , mapping_complete_time = '0.080'
        , mongo_start_time = '0.130'
        , search_end_time = '0.170'
        , total_duration = '0.905'
        , error_description = ''
        , memory_used = '14830424'
        WHERE id = '139180575';
[05/14/2024 04:49:46], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/14_05_2024/request_availability_qtech_agent_16_49_46_1715705386_0.xml', 'a5/14_05_2024/response_availability_qtech_agent_16_49_46_1715705386_0.xml', 'a5/14_05_2024/response_header_availability_qtech_agent_16_49_46_1715705386_0.xml', 'agoda', '2024-05-14 04:49:46', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9455057');
[05/14/2024 04:49:46], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/14_05_2024/request_availability_qtech_agent_16_49_46_1715705386_22.xml', 'a5/14_05_2024/response_availability_qtech_agent_16_49_46_1715705386_22.xml', 'a5/14_05_2024/response_header_availability_qtech_agent_16_49_46_1715705386_22.xml', 'agoda', '2024-05-14 04:49:46', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9455057');
[05/14/2024 04:49:46], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/14_05_2024/request_availability_qtech_agent_16_49_46_1715705386_4.xml', 'a5/14_05_2024/response_availability_qtech_agent_16_49_46_1715705386_4.xml', 'a5/14_05_2024/response_header_availability_qtech_agent_16_49_46_1715705386_4.xml', 'agoda', '2024-05-14 04:49:46', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9455057');
[05/14/2024 04:49:46], [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=6&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-14 16:49:45.983'
        , request_start_time = '0.010'
        , parsing_start_time = '0.569'
        , mapping_complete_time = '0.077'
        , mongo_start_time = '0.108'
        , search_end_time = '0.140'
        , total_duration = '0.921'
        , error_description = ''
        , memory_used = '12514712'
        WHERE id = '139180578';
[05/14/2024 04:49:46], [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=28&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-14 16:49:45.985'
        , request_start_time = '0.015'
        , parsing_start_time = '0.583'
        , mapping_complete_time = '0.088'
        , mongo_start_time = '0.111'
        , search_end_time = '0.154'
        , total_duration = '0.932'
        , error_description = ''
        , memory_used = '10017808'
        WHERE id = '139180579';
[05/14/2024 04:49:46], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/14_05_2024/request_availability_qtech_agent_16_49_46_1715705386_34.xml', 'a5/14_05_2024/response_availability_qtech_agent_16_49_46_1715705386_34.xml', 'a5/14_05_2024/response_header_availability_qtech_agent_16_49_46_1715705386_34.xml', 'agoda', '2024-05-14 04:49:46', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9455057');
[05/14/2024 04:49:46], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/14_05_2024/request_availability_qtech_agent_16_49_46_1715705386_5.xml', 'a5/14_05_2024/response_availability_qtech_agent_16_49_46_1715705386_5.xml', 'a5/14_05_2024/response_header_availability_qtech_agent_16_49_46_1715705386_5.xml', 'agoda', '2024-05-14 04:49:46', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9455057');
[05/14/2024 04:49:46], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/14_05_2024/request_availability_qtech_agent_16_49_46_1715705386_2.xml', 'a5/14_05_2024/response_availability_qtech_agent_16_49_46_1715705386_2.xml', 'a5/14_05_2024/response_header_availability_qtech_agent_16_49_46_1715705386_2.xml', 'agoda', '2024-05-14 04:49:46', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9455057');
[05/14/2024 04:49:46], [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-14 16:49:45.983'
        , request_start_time = '0.013'
        , parsing_start_time = '0.523'
        , mapping_complete_time = '0.121'
        , mongo_start_time = '0.161'
        , search_end_time = '0.161'
        , total_duration = '0.964'
        , error_description = ''
        , memory_used = '13946232'
        WHERE id = '139180580';
[05/14/2024 04:49:46], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/14_05_2024/request_availability_qtech_agent_16_49_46_1715705386_26.xml', 'a5/14_05_2024/response_availability_qtech_agent_16_49_46_1715705386_26.xml', 'a5/14_05_2024/response_header_availability_qtech_agent_16_49_46_1715705386_26.xml', 'agoda', '2024-05-14 04:49:46', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9455057');
[05/14/2024 04:49:46], [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=23&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-14 16:49:45.985'
        , request_start_time = '0.013'
        , parsing_start_time = '0.556'
        , mapping_complete_time = '0.106'
        , mongo_start_time = '0.143'
        , search_end_time = '0.169'
        , total_duration = '0.991'
        , error_description = ''
        , memory_used = '13216904'
        WHERE id = '139180581';
[05/14/2024 04:49:46], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/14_05_2024/request_availability_qtech_agent_16_49_46_1715705386_3.xml', 'a5/14_05_2024/response_availability_qtech_agent_16_49_46_1715705386_3.xml', 'a5/14_05_2024/response_header_availability_qtech_agent_16_49_46_1715705386_3.xml', 'agoda', '2024-05-14 04:49:46', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9455057');
[05/14/2024 04:49:47], [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-14 16:49:45.980'
        , request_start_time = '0.013'
        , parsing_start_time = '0.573'
        , mapping_complete_time = '0.110'
        , mongo_start_time = '0.158'
        , search_end_time = '0.170'
        , total_duration = '1.024'
        , error_description = ''
        , memory_used = '14525360'
        WHERE id = '139180582';
[05/14/2024 04:49:47], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/14_05_2024/request_availability_qtech_agent_16_49_46_1715705386_31.xml', 'a5/14_05_2024/response_availability_qtech_agent_16_49_46_1715705386_31.xml', 'a5/14_05_2024/response_header_availability_qtech_agent_16_49_46_1715705386_31.xml', 'agoda', '2024-05-14 04:49:47', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9455057');
[05/14/2024 04:49:47], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/14_05_2024/request_availability_qtech_agent_16_49_46_1715705386_1.xml', 'a5/14_05_2024/response_availability_qtech_agent_16_49_46_1715705386_1.xml', 'a5/14_05_2024/response_header_availability_qtech_agent_16_49_46_1715705386_1.xml', 'agoda', '2024-05-14 04:49:47', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9455057');
[05/14/2024 04:49:47], [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=20&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-14 16:49:45.985'
        , request_start_time = '0.016'
        , parsing_start_time = '0.621'
        , mapping_complete_time = '0.111'
        , mongo_start_time = '0.195'
        , search_end_time = '0.137'
        , total_duration = '1.062'
        , error_description = ''
        , memory_used = '14301024'
        WHERE id = '139180584';
[05/14/2024 04:49:47], [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-14 16:49:45.990'
        , request_start_time = '0.020'
        , parsing_start_time = '0.605'
        , mapping_complete_time = '0.146'
        , mongo_start_time = '0.221'
        , search_end_time = '0.146'
        , total_duration = '1.072'
        , error_description = ''
        , memory_used = '15588904'
        WHERE id = '139180585';
[05/14/2024 04:49:47], [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=32&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-14 16:49:45.985'
        , request_start_time = '0.013'
        , parsing_start_time = '0.547'
        , mapping_complete_time = '0.164'
        , mongo_start_time = '0.217'
        , search_end_time = '0.186'
        , total_duration = '1.070'
        , error_description = ''
        , memory_used = '16965880'
        WHERE id = '139180583';
[05/14/2024 04:49:47], [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-14 16:49:45.989'
        , request_start_time = '0.015'
        , parsing_start_time = '0.591'
        , mapping_complete_time = '0.177'
        , mongo_start_time = '0.214'
        , search_end_time = '0.159'
        , total_duration = '1.084'
        , error_description = ''
        , memory_used = '15282440'
        WHERE id = '139180586';
[05/14/2024 04:49:47], [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=7&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-14 16:49:45.984'
        , request_start_time = '0.016'
        , parsing_start_time = '0.671'
        , mapping_complete_time = '0.169'
        , mongo_start_time = '0.210'
        , search_end_time = '0.157'
        , total_duration = '1.104'
        , error_description = ''
        , memory_used = '15424336'
        WHERE id = '139180587';
[05/14/2024 04:49:47], [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=4&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-14 16:49:45.989'
        , request_start_time = '0.018'
        , parsing_start_time = '0.723'
        , mapping_complete_time = '0.131'
        , mongo_start_time = '0.183'
        , search_end_time = '0.138'
        , total_duration = '1.123'
        , error_description = ''
        , memory_used = '15620528'
        WHERE id = '139180592';
[05/14/2024 04:49:47], [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=21&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-14 16:49:45.978'
        , request_start_time = '0.013'
        , parsing_start_time = '0.647'
        , mapping_complete_time = '0.164'
        , mongo_start_time = '0.208'
        , search_end_time = '0.168'
        , total_duration = '1.151'
        , error_description = ''
        , memory_used = '18512080'
        WHERE id = '139180588';
[05/14/2024 04:49:47], [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-14 16:49:45.985'
        , request_start_time = '0.013'
        , parsing_start_time = '0.633'
        , mapping_complete_time = '0.189'
        , mongo_start_time = '0.243'
        , search_end_time = '0.166'
        , total_duration = '1.151'
        , error_description = ''
        , memory_used = '13483136'
        WHERE id = '139180590';
[05/14/2024 04:49:47], [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-14 16:49:45.983'
        , request_start_time = '0.013'
        , parsing_start_time = '0.720'
        , mapping_complete_time = '0.133'
        , mongo_start_time = '0.176'
        , search_end_time = '0.148'
        , total_duration = '1.159'
        , error_description = ''
        , memory_used = '14031032'
        WHERE id = '139180594';
[05/14/2024 04:49:47], [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=22&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-14 16:49:45.983'
        , request_start_time = '0.013'
        , parsing_start_time = '0.652'
        , mapping_complete_time = '0.171'
        , mongo_start_time = '0.211'
        , search_end_time = '0.189'
        , total_duration = '1.168'
        , error_description = ''
        , memory_used = '18614768'
        WHERE id = '139180591';
[05/14/2024 04:49:47], [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-14 16:49:45.980'
        , request_start_time = '0.016'
        , parsing_start_time = '0.640'
        , mapping_complete_time = '0.173'
        , mongo_start_time = '0.218'
        , search_end_time = '0.212'
        , total_duration = '1.184'
        , error_description = ''
        , memory_used = '15725648'
        WHERE id = '139180589';
[05/14/2024 04:49:47], [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-14 16:49:45.982'
        , request_start_time = '0.014'
        , parsing_start_time = '0.700'
        , mapping_complete_time = '0.144'
        , mongo_start_time = '0.188'
        , search_end_time = '0.167'
        , total_duration = '1.179'
        , error_description = ''
        , memory_used = '19088112'
        WHERE id = '139180595';
[05/14/2024 04:49:47], [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=34&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-14 16:49:45.982'
        , request_start_time = '0.016'
        , parsing_start_time = '0.675'
        , mapping_complete_time = '0.177'
        , mongo_start_time = '0.221'
        , search_end_time = '0.170'
        , total_duration = '1.182'
        , error_description = ''
        , memory_used = '18886136'
        WHERE id = '139180593';
[05/14/2024 04:49:47], [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=3&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-14 16:49:45.985'
        , request_start_time = '0.013'
        , parsing_start_time = '0.756'
        , mapping_complete_time = '0.165'
        , mongo_start_time = '0.201'
        , search_end_time = '0.143'
        , total_duration = '1.209'
        , error_description = ''
        , memory_used = '16599000'
        WHERE id = '139180597';
[05/14/2024 04:49:47], [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=31&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-14 16:49:45.983'
        , request_start_time = '0.022'
        , parsing_start_time = '0.728'
        , mapping_complete_time = '0.217'
        , mongo_start_time = '0.262'
        , search_end_time = '0.163'
        , total_duration = '1.262'
        , error_description = ''
        , memory_used = '13549128'
        WHERE id = '139180598';
[05/14/2024 04:49:47], [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-14 16:49:45.984'
        , request_start_time = '0.013'
        , parsing_start_time = '0.766'
        , mapping_complete_time = '0.180'
        , mongo_start_time = '0.218'
        , search_end_time = '0.173'
        , total_duration = '1.274'
        , error_description = ''
        , memory_used = '14378320'
        WHERE id = '139180599';
[05/14/2024 04:49:47], [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-14 16:49:45.980'
        , request_start_time = '0.016'
        , parsing_start_time = '0.597'
        , mapping_complete_time = '0.280'
        , mongo_start_time = '0.331'
        , search_end_time = '0.231'
        , total_duration = '1.287'
        , error_description = ''
        , memory_used = '16534576'
        WHERE id = '139180596';
[05/14/2024 04:49:47], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=1284&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02',
        duration = '1.786',
        merge_duration = '0.120',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '1.36',
        system_load_5_min = '2.19',
        system_load_15_min = '3.51',
        system_memory_usage = '95.25',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '9455057') + '17217888',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '9455057';
[05/14/2024 04:55:51], [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/05/29' , departure_date = '2024/05/30' , nights = '1' , nationality = '129' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-05-14 16:55:51' , 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/14/2024 04:55:52], [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/14_05_2024/request_availability_qtech_agent_16_55_52_1715705752_11.xml', 'a5/14_05_2024/response_availability_qtech_agent_16_55_52_1715705752_11.xml', 'a5/14_05_2024/response_header_availability_qtech_agent_16_55_52_1715705752_11.xml', 'agoda', '2024-05-14 04:55:52', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9455407');
[05/14/2024 04:55:52], [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/14_05_2024/request_availability_qtech_agent_16_55_52_1715705752_9.xml', 'a5/14_05_2024/response_availability_qtech_agent_16_55_52_1715705752_9.xml', 'a5/14_05_2024/response_header_availability_qtech_agent_16_55_52_1715705752_9.xml', 'agoda', '2024-05-14 04:55:52', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9455407');
[05/14/2024 04:55:52], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '6'
        , 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-14 16:55:52.402'
        , request_start_time = '0.012'
        , parsing_start_time = '0.337'
        , mapping_complete_time = '0.031'
        , mongo_start_time = '0.044'
        , search_end_time = '0.019'
        , total_duration = '0.562'
        , error_description = ''
        , memory_used = '3713976'
        WHERE id = '139181406';
[05/14/2024 04:55:52], [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/14_05_2024/request_availability_qtech_agent_16_55_52_1715705752_8.xml', 'a5/14_05_2024/response_availability_qtech_agent_16_55_52_1715705752_8.xml', 'a5/14_05_2024/response_header_availability_qtech_agent_16_55_52_1715705752_8.xml', 'agoda', '2024-05-14 04:55:52', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9455407');
[05/14/2024 04:55:52], [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-14 16:55:52.391'
        , request_start_time = '0.021'
        , parsing_start_time = '0.422'
        , mapping_complete_time = '0.053'
        , mongo_start_time = '0.068'
        , search_end_time = '0.020'
        , total_duration = '0.590'
        , error_description = ''
        , memory_used = '6070640'
        WHERE id = '139181407';
[05/14/2024 04:55:53], [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=8&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-14 16:55:52.398'
        , request_start_time = '0.011'
        , parsing_start_time = '0.418'
        , mapping_complete_time = '0.050'
        , mongo_start_time = '0.065'
        , search_end_time = '0.018'
        , total_duration = '0.622'
        , error_description = ''
        , memory_used = '4149336'
        WHERE id = '139181408';
[05/14/2024 04:55:53], [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/14_05_2024/request_availability_qtech_agent_16_55_52_1715705752_17.xml', 'a5/14_05_2024/response_availability_qtech_agent_16_55_52_1715705752_17.xml', 'a5/14_05_2024/response_header_availability_qtech_agent_16_55_52_1715705752_17.xml', 'agoda', '2024-05-14 04:55:53', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9455407');
[05/14/2024 04:55:53], [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/14_05_2024/request_availability_qtech_agent_16_55_52_1715705752_29.xml', 'a5/14_05_2024/response_availability_qtech_agent_16_55_52_1715705752_29.xml', 'a5/14_05_2024/response_header_availability_qtech_agent_16_55_52_1715705752_29.xml', 'agoda', '2024-05-14 04:55:53', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9455407');
[05/14/2024 04:55:53], [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/14_05_2024/request_availability_qtech_agent_16_55_52_1715705752_12.xml', 'a5/14_05_2024/response_availability_qtech_agent_16_55_52_1715705752_12.xml', 'a5/14_05_2024/response_header_availability_qtech_agent_16_55_52_1715705752_12.xml', 'agoda', '2024-05-14 04:55:53', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9455407');
[05/14/2024 04:55:53], [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/14_05_2024/request_availability_qtech_agent_16_55_52_1715705752_14.xml', 'a5/14_05_2024/response_availability_qtech_agent_16_55_52_1715705752_14.xml', 'a5/14_05_2024/response_header_availability_qtech_agent_16_55_52_1715705752_14.xml', 'agoda', '2024-05-14 04:55:53', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9455407');
[05/14/2024 04:55:53], [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/14_05_2024/request_availability_qtech_agent_16_55_52_1715705752_15.xml', 'a5/14_05_2024/response_availability_qtech_agent_16_55_52_1715705752_15.xml', 'a5/14_05_2024/response_header_availability_qtech_agent_16_55_52_1715705752_15.xml', 'agoda', '2024-05-14 04:55:53', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9455407');
[05/14/2024 04:55:53], [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=17&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-14 16:55:52.403'
        , request_start_time = '0.013'
        , parsing_start_time = '0.471'
        , mapping_complete_time = '0.053'
        , mongo_start_time = '0.073'
        , search_end_time = '0.021'
        , total_duration = '0.680'
        , error_description = ''
        , memory_used = '6105824'
        WHERE id = '139181409';
[05/14/2024 04:55:53], [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/14_05_2024/request_availability_qtech_agent_16_55_52_1715705752_16.xml', 'a5/14_05_2024/response_availability_qtech_agent_16_55_52_1715705752_16.xml', 'a5/14_05_2024/response_header_availability_qtech_agent_16_55_52_1715705752_16.xml', 'agoda', '2024-05-14 04:55:53', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9455407');
[05/14/2024 04:55:53], [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/14_05_2024/request_availability_qtech_agent_16_55_52_1715705752_27.xml', 'a5/14_05_2024/response_availability_qtech_agent_16_55_52_1715705752_27.xml', 'a5/14_05_2024/response_header_availability_qtech_agent_16_55_52_1715705752_27.xml', 'agoda', '2024-05-14 04:55:53', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9455407');
[05/14/2024 04:55:53], [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/14_05_2024/request_availability_qtech_agent_16_55_52_1715705752_10.xml', 'a5/14_05_2024/response_availability_qtech_agent_16_55_52_1715705752_10.xml', 'a5/14_05_2024/response_header_availability_qtech_agent_16_55_52_1715705752_10.xml', 'agoda', '2024-05-14 04:55:53', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9455407');
[05/14/2024 04:55:53], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '10'
        , 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-14 16:55:52.399'
        , request_start_time = '0.016'
        , parsing_start_time = '0.440'
        , mapping_complete_time = '0.086'
        , mongo_start_time = '0.110'
        , search_end_time = '0.026'
        , total_duration = '0.721'
        , error_description = ''
        , memory_used = '6049656'
        WHERE id = '139181410';
[05/14/2024 04:55:53], [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=12&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-14 16:55:52.397'
        , request_start_time = '0.013'
        , parsing_start_time = '0.498'
        , mapping_complete_time = '0.048'
        , mongo_start_time = '0.071'
        , search_end_time = '0.022'
        , total_duration = '0.730'
        , error_description = ''
        , memory_used = '5500120'
        WHERE id = '139181411';
[05/14/2024 04:55:53], [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-14 16:55:52.402'
        , request_start_time = '0.010'
        , parsing_start_time = '0.480'
        , mapping_complete_time = '0.077'
        , mongo_start_time = '0.093'
        , search_end_time = '0.030'
        , total_duration = '0.733'
        , error_description = ''
        , memory_used = '5545232'
        WHERE id = '139181412';
[05/14/2024 04:55:53], [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=15&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-14 16:55:52.395'
        , request_start_time = '0.016'
        , parsing_start_time = '0.518'
        , mapping_complete_time = '0.048'
        , mongo_start_time = '0.065'
        , search_end_time = '0.032'
        , total_duration = '0.750'
        , error_description = ''
        , memory_used = '5239904'
        WHERE id = '139181413';
[05/14/2024 04:55:53], [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/14_05_2024/request_availability_qtech_agent_16_55_52_1715705752_23.xml', 'a5/14_05_2024/response_availability_qtech_agent_16_55_52_1715705752_23.xml', 'a5/14_05_2024/response_header_availability_qtech_agent_16_55_52_1715705752_23.xml', 'agoda', '2024-05-14 04:55:53', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9455407');
[05/14/2024 04:55:53], [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-14 16:55:52.396'
        , request_start_time = '0.012'
        , parsing_start_time = '0.510'
        , mapping_complete_time = '0.090'
        , mongo_start_time = '0.110'
        , search_end_time = '0.019'
        , total_duration = '0.764'
        , error_description = ''
        , memory_used = '5153600'
        WHERE id = '139181416';
[05/14/2024 04:55:53], [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/14_05_2024/request_availability_qtech_agent_16_55_52_1715705752_20.xml', 'a5/14_05_2024/response_availability_qtech_agent_16_55_52_1715705752_20.xml', 'a5/14_05_2024/response_header_availability_qtech_agent_16_55_52_1715705752_20.xml', 'agoda', '2024-05-14 04:55:53', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9455407');
[05/14/2024 04:55:53], [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-14 16:55:52.392'
        , request_start_time = '0.019'
        , parsing_start_time = '0.534'
        , mapping_complete_time = '0.102'
        , mongo_start_time = '0.124'
        , search_end_time = '0.029'
        , total_duration = '0.779'
        , error_description = ''
        , memory_used = '8558480'
        WHERE id = '139181415';
[05/14/2024 04:55:53], [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=16&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-14 16:55:52.398'
        , request_start_time = '0.013'
        , parsing_start_time = '0.500'
        , mapping_complete_time = '0.059'
        , mongo_start_time = '0.083'
        , search_end_time = '0.038'
        , total_duration = '0.785'
        , error_description = ''
        , memory_used = '6052224'
        WHERE id = '139181414';
[05/14/2024 04:55:53], [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=23&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-14 16:55:52.391'
        , request_start_time = '0.015'
        , parsing_start_time = '0.603'
        , mapping_complete_time = '0.059'
        , mongo_start_time = '0.080'
        , search_end_time = '0.021'
        , total_duration = '0.820'
        , error_description = ''
        , memory_used = '7377200'
        WHERE id = '139181417';
[05/14/2024 04:55:53], [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/14_05_2024/request_availability_qtech_agent_16_55_52_1715705752_6.xml', 'a5/14_05_2024/response_availability_qtech_agent_16_55_52_1715705752_6.xml', 'a5/14_05_2024/response_header_availability_qtech_agent_16_55_52_1715705752_6.xml', 'agoda', '2024-05-14 04:55:53', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9455407');
[05/14/2024 04:55:53], [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/14_05_2024/request_availability_qtech_agent_16_55_52_1715705752_19.xml', 'a5/14_05_2024/response_availability_qtech_agent_16_55_52_1715705752_19.xml', 'a5/14_05_2024/response_header_availability_qtech_agent_16_55_52_1715705752_19.xml', 'agoda', '2024-05-14 04:55:53', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9455407');
[05/14/2024 04:55:53], [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/14_05_2024/request_availability_qtech_agent_16_55_52_1715705752_5.xml', 'a5/14_05_2024/response_availability_qtech_agent_16_55_52_1715705752_5.xml', 'a5/14_05_2024/response_header_availability_qtech_agent_16_55_52_1715705752_5.xml', 'agoda', '2024-05-14 04:55:53', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9455407');
[05/14/2024 04:55:53], [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=20&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-14 16:55:52.403'
        , request_start_time = '0.011'
        , parsing_start_time = '0.553'
        , mapping_complete_time = '0.073'
        , mongo_start_time = '0.100'
        , search_end_time = '0.039'
        , total_duration = '0.846'
        , error_description = ''
        , memory_used = '8904240'
        WHERE id = '139181418';
[05/14/2024 04:55:53], [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/14_05_2024/request_availability_qtech_agent_16_55_52_1715705752_13.xml', 'a5/14_05_2024/response_availability_qtech_agent_16_55_52_1715705752_13.xml', 'a5/14_05_2024/response_header_availability_qtech_agent_16_55_52_1715705752_13.xml', 'agoda', '2024-05-14 04:55:53', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9455407');
[05/14/2024 04:55:53], [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/14_05_2024/request_availability_qtech_agent_16_55_52_1715705752_26.xml', 'a5/14_05_2024/response_availability_qtech_agent_16_55_52_1715705752_26.xml', 'a5/14_05_2024/response_header_availability_qtech_agent_16_55_52_1715705752_26.xml', 'agoda', '2024-05-14 04:55:53', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9455407');
[05/14/2024 04:55:53], [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/14_05_2024/request_availability_qtech_agent_16_55_52_1715705752_30.xml', 'a5/14_05_2024/response_availability_qtech_agent_16_55_52_1715705752_30.xml', 'a5/14_05_2024/response_header_availability_qtech_agent_16_55_52_1715705752_30.xml', 'agoda', '2024-05-14 04:55:53', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9455407');
[05/14/2024 04:55:53], [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=6&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-14 16:55:52.397'
        , request_start_time = '0.015'
        , parsing_start_time = '0.645'
        , mapping_complete_time = '0.061'
        , mongo_start_time = '0.083'
        , search_end_time = '0.026'
        , total_duration = '0.880'
        , error_description = ''
        , memory_used = '7814312'
        WHERE id = '139181419';
[05/14/2024 04:55:53], [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/14_05_2024/request_availability_qtech_agent_16_55_52_1715705752_7.xml', 'a5/14_05_2024/response_availability_qtech_agent_16_55_52_1715705752_7.xml', 'a5/14_05_2024/response_header_availability_qtech_agent_16_55_52_1715705752_7.xml', 'agoda', '2024-05-14 04:55:53', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9455407');
[05/14/2024 04:55:53], [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/14_05_2024/request_availability_qtech_agent_16_55_52_1715705752_25.xml', 'a5/14_05_2024/response_availability_qtech_agent_16_55_52_1715705752_25.xml', 'a5/14_05_2024/response_header_availability_qtech_agent_16_55_52_1715705752_25.xml', 'agoda', '2024-05-14 04:55:53', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9455407');
[05/14/2024 04:55:53], [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-14 16:55:52.397'
        , request_start_time = '0.016'
        , parsing_start_time = '0.638'
        , mapping_complete_time = '0.110'
        , mongo_start_time = '0.144'
        , search_end_time = '0.029'
        , total_duration = '0.907'
        , error_description = ''
        , memory_used = '8897888'
        WHERE id = '139181420';
[05/14/2024 04:55:53], [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/14_05_2024/request_availability_qtech_agent_16_55_52_1715705752_32.xml', 'a5/14_05_2024/response_availability_qtech_agent_16_55_52_1715705752_32.xml', 'a5/14_05_2024/response_header_availability_qtech_agent_16_55_52_1715705752_32.xml', 'agoda', '2024-05-14 04:55:53', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9455407');
[05/14/2024 04:55:53], [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/14_05_2024/request_availability_qtech_agent_16_55_52_1715705752_4.xml', 'a5/14_05_2024/response_availability_qtech_agent_16_55_52_1715705752_4.xml', 'a5/14_05_2024/response_header_availability_qtech_agent_16_55_52_1715705752_4.xml', 'agoda', '2024-05-14 04:55:53', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9455407');
[05/14/2024 04:55:53], [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-14 16:55:52.402'
        , request_start_time = '0.013'
        , parsing_start_time = '0.648'
        , mapping_complete_time = '0.079'
        , mongo_start_time = '0.116'
        , search_end_time = '0.027'
        , total_duration = '0.915'
        , error_description = ''
        , memory_used = '8903432'
        WHERE id = '139181421';
[05/14/2024 04:55:53], [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/14_05_2024/request_availability_qtech_agent_16_55_52_1715705752_28.xml', 'a5/14_05_2024/response_availability_qtech_agent_16_55_52_1715705752_28.xml', 'a5/14_05_2024/response_header_availability_qtech_agent_16_55_52_1715705752_28.xml', 'agoda', '2024-05-14 04:55:53', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9455407');
[05/14/2024 04:55:53], [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=13&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-14 16:55:52.391'
        , request_start_time = '0.013'
        , parsing_start_time = '0.665'
        , mapping_complete_time = '0.091'
        , mongo_start_time = '0.116'
        , search_end_time = '0.023'
        , total_duration = '0.938'
        , error_description = ''
        , memory_used = '7267936'
        WHERE id = '139181422';
[05/14/2024 04:55:53], [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/14_05_2024/request_availability_qtech_agent_16_55_52_1715705752_18.xml', 'a5/14_05_2024/response_availability_qtech_agent_16_55_52_1715705752_18.xml', 'a5/14_05_2024/response_header_availability_qtech_agent_16_55_52_1715705752_18.xml', 'agoda', '2024-05-14 04:55:53', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9455407');
[05/14/2024 04:55:53], [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-14 16:55:52.401'
        , request_start_time = '0.017'
        , parsing_start_time = '0.675'
        , mapping_complete_time = '0.103'
        , mongo_start_time = '0.140'
        , search_end_time = '0.022'
        , total_duration = '0.945'
        , error_description = ''
        , memory_used = '10180456'
        WHERE id = '139181423';
[05/14/2024 04:55:53], [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/14_05_2024/request_availability_qtech_agent_16_55_52_1715705752_0.xml', 'a5/14_05_2024/response_availability_qtech_agent_16_55_52_1715705752_0.xml', 'a5/14_05_2024/response_header_availability_qtech_agent_16_55_52_1715705752_0.xml', 'agoda', '2024-05-14 04:55:53', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9455407');
[05/14/2024 04:55:53], [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/14_05_2024/request_availability_qtech_agent_16_55_52_1715705752_33.xml', 'a5/14_05_2024/response_availability_qtech_agent_16_55_52_1715705752_33.xml', 'a5/14_05_2024/response_header_availability_qtech_agent_16_55_52_1715705752_33.xml', 'agoda', '2024-05-14 04:55:53', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9455407');
[05/14/2024 04:55:53], [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-14 16:55:52.393'
        , request_start_time = '0.019'
        , parsing_start_time = '0.668'
        , mapping_complete_time = '0.098'
        , mongo_start_time = '0.123'
        , search_end_time = '0.038'
        , total_duration = '0.964'
        , error_description = ''
        , memory_used = '9867904'
        WHERE id = '139181424';
[05/14/2024 04:55:53], [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=7&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-14 16:55:52.391'
        , request_start_time = '0.013'
        , parsing_start_time = '0.657'
        , mapping_complete_time = '0.154'
        , mongo_start_time = '0.198'
        , search_end_time = '0.022'
        , total_duration = '0.975'
        , error_description = ''
        , memory_used = '9496280'
        WHERE id = '139181425';
[05/14/2024 04:55:53], [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-14 16:55:52.398'
        , request_start_time = '0.014'
        , parsing_start_time = '0.672'
        , mapping_complete_time = '0.110'
        , mongo_start_time = '0.143'
        , search_end_time = '0.033'
        , total_duration = '0.980'
        , error_description = ''
        , memory_used = '9425608'
        WHERE id = '139181426';
[05/14/2024 04:55:53], [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/14_05_2024/request_availability_qtech_agent_16_55_52_1715705752_3.xml', 'a5/14_05_2024/response_availability_qtech_agent_16_55_52_1715705752_3.xml', 'a5/14_05_2024/response_header_availability_qtech_agent_16_55_52_1715705752_3.xml', 'agoda', '2024-05-14 04:55:53', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9455407');
[05/14/2024 04:55:53], [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-14 16:55:52.392'
        , request_start_time = '0.015'
        , parsing_start_time = '0.707'
        , mapping_complete_time = '0.116'
        , mongo_start_time = '0.145'
        , search_end_time = '0.031'
        , total_duration = '0.997'
        , error_description = ''
        , memory_used = '10566104'
        WHERE id = '139181427';
[05/14/2024 04:55:53], [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/14_05_2024/request_availability_qtech_agent_16_55_52_1715705752_2.xml', 'a5/14_05_2024/response_availability_qtech_agent_16_55_52_1715705752_2.xml', 'a5/14_05_2024/response_header_availability_qtech_agent_16_55_52_1715705752_2.xml', 'agoda', '2024-05-14 04:55:53', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9455407');
[05/14/2024 04:55:53], [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=28&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-14 16:55:52.403'
        , request_start_time = '0.012'
        , parsing_start_time = '0.615'
        , mapping_complete_time = '0.128'
        , mongo_start_time = '0.160'
        , search_end_time = '0.025'
        , total_duration = '0.999'
        , error_description = ''
        , memory_used = '6488216'
        WHERE id = '139181429';
[05/14/2024 04:55:53], [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/14_05_2024/request_availability_qtech_agent_16_55_52_1715705752_24.xml', 'a5/14_05_2024/response_availability_qtech_agent_16_55_52_1715705752_24.xml', 'a5/14_05_2024/response_header_availability_qtech_agent_16_55_52_1715705752_24.xml', 'agoda', '2024-05-14 04:55:53', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9455407');
[05/14/2024 04:55:53], [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=4&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-14 16:55:52.416'
        , request_start_time = '0.009'
        , parsing_start_time = '0.677'
        , mapping_complete_time = '0.103'
        , mongo_start_time = '0.135'
        , search_end_time = '0.035'
        , total_duration = '0.987'
        , error_description = ''
        , memory_used = '9766352'
        WHERE id = '139181428';
[05/14/2024 04:55:53], [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-14 16:55:52.396'
        , request_start_time = '0.012'
        , parsing_start_time = '0.737'
        , mapping_complete_time = '0.097'
        , mongo_start_time = '0.125'
        , search_end_time = '0.028'
        , total_duration = '1.022'
        , error_description = ''
        , memory_used = '8993808'
        WHERE id = '139181430';
[05/14/2024 04:55:53], [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/14_05_2024/request_availability_qtech_agent_16_55_52_1715705752_34.xml', 'a5/14_05_2024/response_availability_qtech_agent_16_55_52_1715705752_34.xml', 'a5/14_05_2024/response_header_availability_qtech_agent_16_55_52_1715705752_34.xml', 'agoda', '2024-05-14 04:55:53', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9455407');
[05/14/2024 04:55:53], [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-14 16:55:52.398'
        , request_start_time = '0.011'
        , parsing_start_time = '0.720'
        , mapping_complete_time = '0.139'
        , mongo_start_time = '0.171'
        , search_end_time = '0.026'
        , total_duration = '1.035'
        , error_description = ''
        , memory_used = '11791696'
        WHERE id = '139181431';
[05/14/2024 04:55:53], [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-14 16:55:52.393'
        , request_start_time = '0.016'
        , parsing_start_time = '0.741'
        , mapping_complete_time = '0.115'
        , mongo_start_time = '0.149'
        , search_end_time = '0.028'
        , total_duration = '1.050'
        , error_description = ''
        , memory_used = '9822496'
        WHERE id = '139181432';
[05/14/2024 04:55:53], [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/14_05_2024/request_availability_qtech_agent_16_55_52_1715705752_31.xml', 'a5/14_05_2024/response_availability_qtech_agent_16_55_52_1715705752_31.xml', 'a5/14_05_2024/response_header_availability_qtech_agent_16_55_52_1715705752_31.xml', 'agoda', '2024-05-14 04:55:53', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9455407');
[05/14/2024 04:55:53], [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=3&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-14 16:55:52.393'
        , request_start_time = '0.014'
        , parsing_start_time = '0.825'
        , mapping_complete_time = '0.087'
        , mongo_start_time = '0.114'
        , search_end_time = '0.024'
        , total_duration = '1.062'
        , error_description = ''
        , memory_used = '9884752'
        WHERE id = '139181433';
[05/14/2024 04:55:53], [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=2&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-14 16:55:52.421'
        , request_start_time = '0.010'
        , parsing_start_time = '0.774'
        , mapping_complete_time = '0.113'
        , mongo_start_time = '0.141'
        , search_end_time = '0.028'
        , total_duration = '1.047'
        , error_description = ''
        , memory_used = '11435192'
        WHERE id = '139181434';
[05/14/2024 04:55:53], [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/14_05_2024/request_availability_qtech_agent_16_55_52_1715705752_22.xml', 'a5/14_05_2024/response_availability_qtech_agent_16_55_52_1715705752_22.xml', 'a5/14_05_2024/response_header_availability_qtech_agent_16_55_52_1715705752_22.xml', 'agoda', '2024-05-14 04:55:53', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9455407');
[05/14/2024 04:55:53], [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=24&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-14 16:55:52.423'
        , request_start_time = '0.011'
        , parsing_start_time = '0.705'
        , mapping_complete_time = '0.123'
        , mongo_start_time = '0.156'
        , search_end_time = '0.028'
        , total_duration = '1.058'
        , error_description = ''
        , memory_used = '9116568'
        WHERE id = '139181435';
[05/14/2024 04:55:53], [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/14_05_2024/request_availability_qtech_agent_16_55_52_1715705752_21.xml', 'a5/14_05_2024/response_availability_qtech_agent_16_55_52_1715705752_21.xml', 'a5/14_05_2024/response_header_availability_qtech_agent_16_55_52_1715705752_21.xml', 'agoda', '2024-05-14 04:55:53', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9455407');
[05/14/2024 04:55:53], [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=34&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-14 16:55:52.397'
        , request_start_time = '0.019'
        , parsing_start_time = '0.735'
        , mapping_complete_time = '0.180'
        , mongo_start_time = '0.218'
        , search_end_time = '0.028'
        , total_duration = '1.113'
        , error_description = ''
        , memory_used = '11643912'
        WHERE id = '139181436';
[05/14/2024 04:55:53], [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=31&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-14 16:55:52.401'
        , request_start_time = '0.013'
        , parsing_start_time = '0.830'
        , mapping_complete_time = '0.094'
        , mongo_start_time = '0.125'
        , search_end_time = '0.023'
        , total_duration = '1.121'
        , error_description = ''
        , memory_used = '11965064'
        WHERE id = '139181437';
[05/14/2024 04:55:53], [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=21&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-14 16:55:52.391'
        , request_start_time = '0.017'
        , parsing_start_time = '0.859'
        , mapping_complete_time = '0.132'
        , mongo_start_time = '0.166'
        , search_end_time = '0.026'
        , total_duration = '1.184'
        , error_description = ''
        , memory_used = '11585760'
        WHERE id = '139181439';
[05/14/2024 04:55:53], [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/14_05_2024/request_availability_qtech_agent_16_55_52_1715705752_1.xml', 'a5/14_05_2024/response_availability_qtech_agent_16_55_52_1715705752_1.xml', 'a5/14_05_2024/response_header_availability_qtech_agent_16_55_52_1715705752_1.xml', 'agoda', '2024-05-14 04:55:53', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9455407');
[05/14/2024 04:55:53], [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=22&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-14 16:55:52.393'
        , request_start_time = '0.014'
        , parsing_start_time = '0.723'
        , mapping_complete_time = '0.261'
        , mongo_start_time = '0.317'
        , search_end_time = '0.033'
        , total_duration = '1.194'
        , error_description = ''
        , memory_used = '11294760'
        WHERE id = '139181438';
[05/14/2024 04:55:53], [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-14 16:55:52.397'
        , request_start_time = '0.012'
        , parsing_start_time = '1.002'
        , mapping_complete_time = '0.104'
        , mongo_start_time = '0.135'
        , search_end_time = '0.036'
        , total_duration = '1.266'
        , error_description = ''
        , memory_used = '13102312'
        WHERE id = '139181440';
[05/14/2024 04:55:53], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '577',
        request_path = '/xml_all.php?userid=1284&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02',
        duration = '1.612',
        merge_duration = '0.009',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '4.28',
        system_load_5_min = '14.73',
        system_load_15_min = '10.11',
        system_memory_usage = '92.28',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '9455407') + '3383272',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '9455407';
