                VALUE ('', 'availability', 'd5/16_05_2024/request_availability_paresh_08_20_34_1715847634_25.json', 'd5/16_05_2024/response_availability_paresh_08_20_34_1715847634_25.json', 'd5/16_05_2024/response_header_availability_paresh_08_20_34_1715847634_25.json', 'dida1', '2024-05-16 08:20:40', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535537');
[05/16/2024 08:20:40], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '40'
        , request_url = '/call.php?s=dida&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317&db_caching=1&wh_agent_id=&erequest=14&total_request=17&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 08:20:34.456'
        , request_start_time = '0.026'
        , parsing_start_time = '5.217'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.111'
        , search_end_time = '0.577'
        , total_duration = '6.147'
        , error_description = ''
        , memory_used = '69356760'
        WHERE id = '139482137';
[05/16/2024 08:20:40], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '23'
        , request_url = '/call.php?s=dida&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317&db_caching=1&wh_agent_id=&erequest=16&total_request=17&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 08:20:34.458'
        , request_start_time = '0.038'
        , parsing_start_time = '5.434'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.064'
        , search_end_time = '0.383'
        , total_duration = '6.163'
        , error_description = ''
        , memory_used = '44667680'
        WHERE id = '139482139';
[05/16/2024 08:20:40], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '19'
        , request_url = '/call.php?s=hotelspro&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317&db_caching=1&&erequest=17&total_request=24&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 08:20:34.462'
        , request_start_time = '0.094'
        , parsing_start_time = '5.151'
        , mapping_complete_time = '0.048'
        , mongo_start_time = '0.222'
        , search_end_time = '0.704'
        , total_duration = '6.354'
        , error_description = ''
        , memory_used = '54252464'
        WHERE id = '139482138';
[05/16/2024 08:20:41], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '30'
        , request_url = '/call.php?s=hotelspro&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317&db_caching=1&&erequest=0&total_request=24&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 08:20:34.458'
        , request_start_time = '0.048'
        , parsing_start_time = '5.569'
        , mapping_complete_time = '0.041'
        , mongo_start_time = '0.213'
        , search_end_time = '0.719'
        , total_duration = '6.769'
        , error_description = ''
        , memory_used = '55324096'
        WHERE id = '139482140';
[05/16/2024 08:20:41], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '44'
        , request_url = '/call.php?s=dida&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317&db_caching=1&wh_agent_id=&erequest=1&total_request=17&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 08:20:34.463'
        , request_start_time = '0.023'
        , parsing_start_time = '5.857'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.123'
        , search_end_time = '0.668'
        , total_duration = '6.922'
        , error_description = ''
        , memory_used = '80894936'
        WHERE id = '139482141';
[05/16/2024 08:20:41], [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', 'd5/16_05_2024/request_availability_paresh_08_20_34_1715847634_72.json', 'd5/16_05_2024/response_availability_paresh_08_20_34_1715847634_72.json', 'd5/16_05_2024/response_header_availability_paresh_08_20_34_1715847634_72.json', 'dida6', '2024-05-16 08:20:41', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535537');
[05/16/2024 08:20:41], [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', 'd5/16_05_2024/request_availability_paresh_08_20_34_1715847634_90.json', 'd5/16_05_2024/response_availability_paresh_08_20_34_1715847634_90.json', 'd5/16_05_2024/response_header_availability_paresh_08_20_34_1715847634_90.json', 'dida2', '2024-05-16 08:20:41', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535537');
[05/16/2024 08:20:41], [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', 'd5/16_05_2024/request_availability_paresh_08_20_34_1715847634_52.json', 'd5/16_05_2024/response_availability_paresh_08_20_34_1715847634_52.json', 'd5/16_05_2024/response_header_availability_paresh_08_20_34_1715847634_52.json', 'dida13', '2024-05-16 08:20:41', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535537');
[05/16/2024 08:20:42], [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', 'd5/16_05_2024/request_availability_paresh_08_20_34_1715847634_6.json', 'd5/16_05_2024/response_availability_paresh_08_20_34_1715847634_6.json', 'd5/16_05_2024/response_header_availability_paresh_08_20_34_1715847634_6.json', 'dida7', '2024-05-16 08:20:42', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535537');
[05/16/2024 08:20:42], [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', 'd5/16_05_2024/request_availability_paresh_08_20_34_1715847634_57.json', 'd5/16_05_2024/response_availability_paresh_08_20_34_1715847634_57.json', 'd5/16_05_2024/response_header_availability_paresh_08_20_34_1715847634_57.json', 'dida15', '2024-05-16 08:20:42', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535537');
[05/16/2024 08:20:42], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '46'
        , request_url = '/call.php?s=dida&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317&db_caching=1&wh_agent_id=&erequest=6&total_request=17&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 08:20:34.458'
        , request_start_time = '0.043'
        , parsing_start_time = '6.888'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.161'
        , search_end_time = '0.700'
        , total_duration = '8.044'
        , error_description = ''
        , memory_used = '103954408'
        WHERE id = '139482142';
[05/16/2024 08:20:42], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '42'
        , request_url = '/call.php?s=dida&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317&db_caching=1&wh_agent_id=&erequest=13&total_request=17&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 08:20:34.459'
        , request_start_time = '0.038'
        , parsing_start_time = '7.198'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.153'
        , search_end_time = '0.637'
        , total_duration = '8.233'
        , error_description = ''
        , memory_used = '93172560'
        WHERE id = '139482144';
[05/16/2024 08:20:42], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '45'
        , request_url = '/call.php?s=dida&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317&db_caching=1&wh_agent_id=&erequest=2&total_request=17&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 08:20:34.456'
        , request_start_time = '0.023'
        , parsing_start_time = '6.919'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.144'
        , search_end_time = '0.895'
        , total_duration = '8.256'
        , error_description = ''
        , memory_used = '97339744'
        WHERE id = '139482143';
[05/16/2024 08:20:42], [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', 'd5/16_05_2024/request_availability_paresh_08_20_34_1715847634_87.json', 'd5/16_05_2024/response_availability_paresh_08_20_34_1715847634_87.json', 'd5/16_05_2024/response_header_availability_paresh_08_20_34_1715847634_87.json', 'dida0', '2024-05-16 08:20:42', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535537');
[05/16/2024 08:20:42], [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', 'd5/16_05_2024/request_availability_paresh_08_20_34_1715847634_7.json', 'd5/16_05_2024/response_availability_paresh_08_20_34_1715847634_7.json', 'd5/16_05_2024/response_header_availability_paresh_08_20_34_1715847634_7.json', 'dida8', '2024-05-16 08:20:42', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535537');
[05/16/2024 08:20:42], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '48'
        , request_url = '/call.php?s=dida&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317&db_caching=1&wh_agent_id=&erequest=7&total_request=17&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 08:20:34.465'
        , request_start_time = '0.032'
        , parsing_start_time = '7.401'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.142'
        , search_end_time = '0.651'
        , total_duration = '8.456'
        , error_description = ''
        , memory_used = '97230552'
        WHERE id = '139482146';
[05/16/2024 08:20:43], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '35'
        , request_url = '/call.php?s=dida&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317&db_caching=1&wh_agent_id=&erequest=15&total_request=17&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 08:20:34.458'
        , request_start_time = '0.025'
        , parsing_start_time = '7.648'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.125'
        , search_end_time = '0.630'
        , total_duration = '8.675'
        , error_description = ''
        , memory_used = '81043840'
        WHERE id = '139482147';
[05/16/2024 08:20:43], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '44'
        , request_url = '/call.php?s=dida&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317&db_caching=1&wh_agent_id=&erequest=8&total_request=17&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 08:20:34.461'
        , request_start_time = '0.053'
        , parsing_start_time = '8.147'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.125'
        , search_end_time = '0.619'
        , total_duration = '9.211'
        , error_description = ''
        , memory_used = '83626608'
        WHERE id = '139482151';
[05/16/2024 08:20:43], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '45'
        , request_url = '/call.php?s=dida&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317&db_caching=1&wh_agent_id=&erequest=0&total_request=17&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 08:20:34.458'
        , request_start_time = '0.029'
        , parsing_start_time = '8.173'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.138'
        , search_end_time = '0.746'
        , total_duration = '9.313'
        , error_description = ''
        , memory_used = '92665960'
        WHERE id = '139482150';
[05/16/2024 08:20:44], [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', 'd5/16_05_2024/request_availability_paresh_08_20_34_1715847634_56.json', 'd5/16_05_2024/response_availability_paresh_08_20_34_1715847634_56.json', 'd5/16_05_2024/response_header_availability_paresh_08_20_34_1715847634_56.json', 'dida5', '2024-05-16 08:20:44', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535537');
[05/16/2024 08:20:45], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '48'
        , request_url = '/call.php?s=dida&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317&db_caching=1&wh_agent_id=&erequest=5&total_request=17&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 08:20:34.462'
        , request_start_time = '0.023'
        , parsing_start_time = '9.889'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.227'
        , search_end_time = '0.769'
        , total_duration = '11.118'
        , error_description = ''
        , memory_used = '113353928'
        WHERE id = '139482154';
[05/16/2024 08:20: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', 'd5/16_05_2024/request_availability_paresh_08_20_34_1715847634_73.json', 'd5/16_05_2024/response_availability_paresh_08_20_34_1715847634_73.json', 'd5/16_05_2024/response_header_availability_paresh_08_20_34_1715847634_73.json', 'dida3', '2024-05-16 08:20:46', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535537');
[05/16/2024 08:20: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', 'd5/16_05_2024/request_availability_paresh_08_20_34_1715847634_74.json', 'd5/16_05_2024/response_availability_paresh_08_20_34_1715847634_74.json', 'd5/16_05_2024/response_header_availability_paresh_08_20_34_1715847634_74.json', 'dida4', '2024-05-16 08:20:46', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535537');
[05/16/2024 08:20:47], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '49'
        , request_url = '/call.php?s=dida&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317&db_caching=1&wh_agent_id=&erequest=3&total_request=17&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 08:20:34.462'
        , request_start_time = '0.034'
        , parsing_start_time = '12.016'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.197'
        , search_end_time = '0.849'
        , total_duration = '13.366'
        , error_description = ''
        , memory_used = '134586640'
        WHERE id = '139482165';
[05/16/2024 08:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '48'
        , request_url = '/call.php?s=dida&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317&db_caching=1&wh_agent_id=&erequest=4&total_request=17&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 08:20:34.456'
        , request_start_time = '0.041'
        , parsing_start_time = '12.192'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.320'
        , search_end_time = '0.901'
        , total_duration = '13.709'
        , error_description = ''
        , memory_used = '130247672'
        WHERE id = '139482166';
[05/16/2024 08:20:48], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '1905',
        request_path = '/xml_all.php?userid=317&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02',
        duration = '15.829',
        merge_duration = '0.296',
        assigned_supplier_count = '12',
        searched_supplier_count = '8',
        system_load_1_min = '2.29',
        system_load_5_min = '2.65',
        system_load_15_min = '2.22',
        system_memory_usage = '90.80',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '9535537') + '45005040',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '9535537';
[05/16/2024 08:23:18], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[05/16/2024 08:23:18], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '317',supplier_id = '77' ,status = '1' ,priority = '12' ,lead_time = '48',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/16/2024 08:23:18], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '317',supplier_id = '89' ,status = '' ,priority = '25' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '25';
[05/16/2024 08:23:18], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '317',supplier_id = '76' ,status = '1' ,priority = '' ,lead_time = '48',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/16/2024 08:23:18], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '317',supplier_id = '98' ,status = '1' ,priority = '25' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '25';
[05/16/2024 08:23:18], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '317',supplier_id = '58' ,status = '1' ,priority = '25' ,lead_time = '72',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '25';
[05/16/2024 08:23:18], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '317',supplier_id = '99' ,status = '' ,priority = '5' ,lead_time = '2400',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[05/16/2024 08:23:18], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '317',supplier_id = '86' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/16/2024 08:23:18], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '317',supplier_id = '74' ,status = '1' ,priority = '14' ,lead_time = '48',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[05/16/2024 08:23:18], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '317',supplier_id = '75' ,status = '1' ,priority = '14' ,lead_time = '48',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[05/16/2024 08:23:18], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '317',supplier_id = '96' ,status = '1' ,priority = '25' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '25';
[05/16/2024 08:23:18], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '317',supplier_id = '56' ,status = '1' ,priority = '25' ,lead_time = '72',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '25';
[05/16/2024 08:23:18], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '317',supplier_id = '60' ,status = '1' ,priority = '25' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '25';
[05/16/2024 08:23:18], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '317',supplier_id = '84' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/16/2024 08:23:18], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '317',supplier_id = '67' ,status = '1' ,priority = '5' ,lead_time = '72',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[05/16/2024 08:23:18], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '317',supplier_id = '1' ,status = '1' ,priority = '' ,lead_time = '72',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/16/2024 08:23:19], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '317',supplier_id = '101' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/16/2024 08:23:19], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '317',supplier_id = '73' ,status = '' ,priority = '5' ,lead_time = '72',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[05/16/2024 08:23:19], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '317',supplier_id = '85' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/16/2024 08:23:19], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '317',supplier_id = '100' ,status = '1' ,priority = '25' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '25';
[05/16/2024 08:23:19], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '317',supplier_id = '93' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/16/2024 08:23:19], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '317',supplier_id = '57' ,status = '1' ,priority = '' ,lead_time = '72',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/16/2024 08:23:19], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '317',supplier_id = '97' ,status = '1' ,priority = '15' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '15';
[05/16/2024 08:23:19], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '317',supplier_id = '81' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/16/2024 08:23:19], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '317',supplier_id = '78' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/16/2024 08:23:19], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '317',supplier_id = '83' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/16/2024 08:23:19], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '317',supplier_id = '68' ,status = '' ,priority = '' ,lead_time = '72',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/16/2024 08:23:19], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '317',supplier_id = '90' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/16/2024 08:23:19], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '317',supplier_id = '66' ,status = '' ,priority = '7' ,lead_time = '72',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/16/2024 08:23:19], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '317',supplier_id = '64' ,status = '' ,priority = '' ,lead_time = '72',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/16/2024 08:23:19], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '317',supplier_id = '65' ,status = '' ,priority = '' ,lead_time = '72',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/16/2024 08:23:19], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '317',supplier_id = '69' ,status = '' ,priority = '' ,lead_time = '72',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/16/2024 08:23:19], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'sanketpdesai',`create_date`= '2024-05-16 08:23:19',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;317\&#039;,supplier_id = 77 ,status = \&#039;1\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;48\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;317\&#039;,supplier_id = 89 ,status = \&#039;\&#039; ,priority = \&#039;25\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;25\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;317\&#039;,supplier_id = 76 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;48\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;317\&#039;,supplier_id = 98 ,status = \&#039;1\&#039; ,priority = \&#039;25\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;25\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;317\&#039;,supplier_id = 58 ,status = \&#039;1\&#039; ,priority = \&#039;25\&#039; ,lead_time = \&#039;72\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;25\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;317\&#039;,supplier_id = 99 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;2400\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;317\&#039;,supplier_id = 86 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;317\&#039;,supplier_id = 74 ,status = \&#039;1\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;48\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;317\&#039;,supplier_id = 75 ,status = \&#039;1\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;48\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;317\&#039;,supplier_id = 96 ,status = \&#039;1\&#039; ,priority = \&#039;25\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;25\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;317\&#039;,supplier_id = 56 ,status = \&#039;1\&#039; ,priority = \&#039;25\&#039; ,lead_time = \&#039;72\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;25\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;317\&#039;,supplier_id = 60 ,status = \&#039;1\&#039; ,priority = \&#039;25\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;25\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;317\&#039;,supplier_id = 84 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;317\&#039;,supplier_id = 67 ,status = \&#039;1\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;72\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;317\&#039;,supplier_id = 1 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;72\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;317\&#039;,supplier_id = 101 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;317\&#039;,supplier_id = 73 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;72\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;317\&#039;,supplier_id = 85 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;317\&#039;,supplier_id = 100 ,status = \&#039;1\&#039; ,priority = \&#039;25\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;25\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;317\&#039;,supplier_id = 93 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;317\&#039;,supplier_id = 57 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;72\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;317\&#039;,supplier_id = 97 ,status = \&#039;1\&#039; ,priority = \&#039;15\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;15\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;317\&#039;,supplier_id = 81 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;317\&#039;,supplier_id = 78 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;317\&#039;,supplier_id = 83 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;317\&#039;,supplier_id = 68 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;72\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;317\&#039;,supplier_id = 90 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;317\&#039;,supplier_id = 66 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;72\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;317\&#039;,supplier_id = 64 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;72\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;317\&#039;,supplier_id = 65 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;72\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;317\&#039;,supplier_id = 69 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;72\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;',`log_description`= 'Supplier setting updated  Previous data-- agent_id-317 ## supplier_id- 77 ## company_name - Agoda ## supplier_code-agoda  ## percentage - 0.00 ## lead_time - 48 ==&lt;br&gt;== agent_id-317 ## supplier_id- 76 ## company_name - Darina ## supplier_code-darina  ## percentage - 0.00 ## lead_time - 48 ==&lt;br&gt;== agent_id-317 ## supplier_id- 98 ## company_name - Dida ## supplier_code-dida  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-317 ## supplier_id- 58 ## company_name - Destinations of the world (DOTW) &lt;font color=\&#039;red\&#039;&gt;(Go)&lt;/font&gt; ## supplier_code-dotw  ## percentage - 0.00 ## lead_time - 72 ==&lt;br&gt;== agent_id-317 ## supplier_id- 74 ## company_name - Expedia &lt;font color=\&#039;red\&#039;&gt;(Go)&lt;/font&gt; ## supplier_code-expedia  ## percentage - 0.00 ## lead_time - 48 ==&lt;br&gt;== agent_id-317 ## supplier_id- 75 ## company_name - Expedia Package &lt;font color=\&#039;red\&#039;&gt;(Go)&lt;/font&gt; ## supplier_code-expediapackage  ## percentage - 0.00 ## lead_time - 48 ==&lt;br&gt;== agent_id-317 ## supplier_id- 96 ## company_name - GRNConnect - TGX &lt;font color=\&#039;red\&#039;&gt;(Go)&lt;/font&gt; ## supplier_code-grnconnecttgx  ## percentage - 0.00 ## lead_time - 96 ==&lt;br&gt;== agent_id-317 ## supplier_id- 56 ## company_name - Hotelbeds ## supplier_code-hotelbeds  ## percentage - 0.00 ## lead_time - 72 ==&lt;br&gt;== agent_id-317 ## supplier_id- 60 ## company_name - Hotelspro ## supplier_code-hotelspro  ## percentage - 0.00 ## lead_time - 96 ==&lt;br&gt;== agent_id-317 ## supplier_id- 67 ## company_name - Local System &lt;font color=\&#039;red\&#039;&gt;(Go)&lt;/font&gt; ## supplier_code-localsystem  ## percentage - 0.00 ## lead_time - 72 ==&lt;br&gt;== agent_id-317 ## supplier_id- 1 ## company_name - Miki &lt;font color=\&#039;red\&#039;&gt;(Go)&lt;/font&gt; ## supplier_code-miki  ## percentage - 0.00 ## lead_time - 72 ==&lt;br&gt;== agent_id-317 ## supplier_id- 100 ## company_name - Sun Hotels &lt;font color=\&#039;red\&#039;&gt;(Go)&lt;/font&gt; ## supplier_code-sunhotels  ## percentage - 0.00 ## lead_time - 96 ',`ip`= '43.239.53.130';
[05/16/2024 08:23:32], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '317' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '1' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '114' , service_type = 'hotel' , arrival_date = '2024/05/30' , departure_date = '2024/05/31' , nights = '1' , nationality = '114' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-05-16 08:23:32' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'KWD' , currency_code = 'KWD' , web_service = '0' ;
[05/16/2024 08:23:34], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-05-16 08:23:34.776'
            , total_duration = '0.208'
            , hotel_count = 0
            , source_type = 'hotelbeds'
            , create_date = '2024-05-16 08:23:34'
            , session_id = '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02'
            , agent_logs_id = '9535894'
            , error_description = ''
            , memory_used = '2825640';
[05/16/2024 08:23:34], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-05-16 08:23:34.777'
            , total_duration = '0.219'
            , hotel_count = 0
            , source_type = 'hotelbeds'
            , create_date = '2024-05-16 08:23:34'
            , session_id = '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02'
            , agent_logs_id = '9535894'
            , error_description = ''
            , memory_used = '2825712';
[05/16/2024 08:23:35], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-05-16 08:23:34.778'
            , total_duration = '0.227'
            , hotel_count = 0
            , source_type = 'hotelbeds'
            , create_date = '2024-05-16 08:23:35'
            , session_id = '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02'
            , agent_logs_id = '9535894'
            , error_description = ''
            , memory_used = '2825712';
[05/16/2024 08:23:34], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-05-16 08:23:34.778'
            , total_duration = '0.220'
            , hotel_count = 0
            , source_type = 'tripathonxml'
            , create_date = '2024-05-16 08:23:34'
            , session_id = '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02'
            , agent_logs_id = '9535894'
            , error_description = ''
            , memory_used = '2664376';
[05/16/2024 08:23:35], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-05-16 08:23:34.779'
            , total_duration = '0.237'
            , hotel_count = 0
            , source_type = 'hotelbeds'
            , create_date = '2024-05-16 08:23:35'
            , session_id = '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02'
            , agent_logs_id = '9535894'
            , error_description = ''
            , memory_used = '2825544';
[05/16/2024 08:23:35], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-05-16 08:23:34.777'
            , total_duration = '0.262'
            , hotel_count = 0
            , source_type = 'hotelbeds'
            , create_date = '2024-05-16 08:23:35'
            , session_id = '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02'
            , agent_logs_id = '9535894'
            , error_description = ''
            , memory_used = '2825640';
[05/16/2024 08:23:35], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-05-16 08:23:34.791'
            , total_duration = '0.251'
            , hotel_count = 0
            , source_type = 'hotelbeds'
            , create_date = '2024-05-16 08:23:35'
            , session_id = '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02'
            , agent_logs_id = '9535894'
            , error_description = ''
            , memory_used = '2825712';
[05/16/2024 08:23:35], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-05-16 08:23:34.778'
            , total_duration = '0.261'
            , hotel_count = 0
            , source_type = 'hotelbeds'
            , create_date = '2024-05-16 08:23:35'
            , session_id = '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02'
            , agent_logs_id = '9535894'
            , error_description = ''
            , memory_used = '2825712';
[05/16/2024 08:23:35], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-05-16 08:23:34.780'
            , total_duration = '0.288'
            , hotel_count = 0
            , source_type = 'tripathonxml'
            , create_date = '2024-05-16 08:23:35'
            , session_id = '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02'
            , agent_logs_id = '9535894'
            , error_description = ''
            , memory_used = '2664376';
[05/16/2024 08:23:35], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-05-16 08:23:34.776'
            , total_duration = '0.352'
            , hotel_count = 0
            , source_type = 'tripathonxml'
            , create_date = '2024-05-16 08:23:35'
            , session_id = '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02'
            , agent_logs_id = '9535894'
            , error_description = ''
            , memory_used = '2664376';
[05/16/2024 08:23:35], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'h2/16_05_2024/request_availability_paresh_08_23_34_1715847814_4_.json', 'h2/16_05_2024/response_availability_paresh_08_23_34_1715847814_4_.json', 'h2/16_05_2024/response_header_availability_paresh_08_23_34_1715847814_4_.json', 'hotelspro', '2024-05-16 08:23:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:35], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'h2/16_05_2024/request_availability_paresh_08_23_35_1715847815_23_.json', 'h2/16_05_2024/response_availability_paresh_08_23_35_1715847815_23_.json', 'h2/16_05_2024/response_header_availability_paresh_08_23_35_1715847815_23_.json', 'hotelspro', '2024-05-16 08:23:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:35], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'h2/16_05_2024/request_availability_paresh_08_23_35_1715847815_20_.json', 'h2/16_05_2024/response_availability_paresh_08_23_35_1715847815_20_.json', 'h2/16_05_2024/response_header_availability_paresh_08_23_35_1715847815_20_.json', 'hotelspro', '2024-05-16 08:23:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:35], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'h2/16_05_2024/request_availability_paresh_08_23_35_1715847815_11_.json', 'h2/16_05_2024/response_availability_paresh_08_23_35_1715847815_11_.json', 'h2/16_05_2024/response_header_availability_paresh_08_23_35_1715847815_11_.json', 'hotelspro', '2024-05-16 08:23:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:35], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=hotelspro&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317&db_caching=1&&erequest=23&total_request=24&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 08:23:34.781'
        , request_start_time = '0.118'
        , parsing_start_time = '0.187'
        , mapping_complete_time = '0.042'
        , mongo_start_time = '0.046'
        , search_end_time = '0.000'
        , total_duration = '0.555'
        , error_description = ''
        , memory_used = '2646680'
        WHERE id = '139483162';
[05/16/2024 08:23:35], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'h2/16_05_2024/request_availability_paresh_08_23_34_1715847814_5_.json', 'h2/16_05_2024/response_availability_paresh_08_23_34_1715847814_5_.json', 'h2/16_05_2024/response_header_availability_paresh_08_23_34_1715847814_5_.json', 'hotelspro', '2024-05-16 08:23:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:35], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'h2/16_05_2024/request_availability_paresh_08_23_35_1715847815_13_.json', 'h2/16_05_2024/response_availability_paresh_08_23_35_1715847815_13_.json', 'h2/16_05_2024/response_header_availability_paresh_08_23_35_1715847815_13_.json', 'hotelspro', '2024-05-16 08:23:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:35], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/16_05_2024/request_availability_paresh_08_23_35_1715847815_11.xml', 'a5/16_05_2024/response_availability_paresh_08_23_35_1715847815_11.xml', 'a5/16_05_2024/response_header_availability_paresh_08_23_35_1715847815_11.xml', 'agoda', '2024-05-16 08:23:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:35], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/16_05_2024/request_availability_paresh_08_23_34_1715847814_9.xml', 'a5/16_05_2024/response_availability_paresh_08_23_34_1715847814_9.xml', 'a5/16_05_2024/response_header_availability_paresh_08_23_34_1715847814_9.xml', 'agoda', '2024-05-16 08:23:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:35], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '12'
        , request_url = '/call.php?s=hotelspro&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317&db_caching=1&&erequest=4&total_request=24&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 08:23:34.778'
        , request_start_time = '0.023'
        , parsing_start_time = '0.240'
        , mapping_complete_time = '0.051'
        , mongo_start_time = '0.134'
        , search_end_time = '0.088'
        , total_duration = '0.638'
        , error_description = ''
        , memory_used = '7448400'
        WHERE id = '139483155';
[05/16/2024 08:23:35], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'h2/16_05_2024/request_availability_paresh_08_23_35_1715847815_22_.json', 'h2/16_05_2024/response_availability_paresh_08_23_35_1715847815_22_.json', 'h2/16_05_2024/response_header_availability_paresh_08_23_35_1715847815_22_.json', 'hotelspro', '2024-05-16 08:23:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:35], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'h2/16_05_2024/request_availability_paresh_08_23_35_1715847815_16_.json', 'h2/16_05_2024/response_availability_paresh_08_23_35_1715847815_16_.json', 'h2/16_05_2024/response_header_availability_paresh_08_23_35_1715847815_16_.json', 'hotelspro', '2024-05-16 08:23:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:35], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'h2/16_05_2024/request_availability_paresh_08_23_35_1715847815_6_.json', 'h2/16_05_2024/response_availability_paresh_08_23_35_1715847815_6_.json', 'h2/16_05_2024/response_header_availability_paresh_08_23_35_1715847815_6_.json', 'hotelspro', '2024-05-16 08:23:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:35], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'h2/16_05_2024/request_availability_paresh_08_23_35_1715847815_14_.json', 'h2/16_05_2024/response_availability_paresh_08_23_35_1715847815_14_.json', 'h2/16_05_2024/response_header_availability_paresh_08_23_35_1715847815_14_.json', 'hotelspro', '2024-05-16 08:23:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:35], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '8'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317&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-16 08:23:34.788'
        , request_start_time = '0.037'
        , parsing_start_time = '0.361'
        , mapping_complete_time = '0.033'
        , mongo_start_time = '0.045'
        , search_end_time = '0.053'
        , total_duration = '0.682'
        , error_description = ''
        , memory_used = '6122184'
        WHERE id = '139483168';
[05/16/2024 08:23:35], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'h2/16_05_2024/request_availability_paresh_08_23_35_1715847815_1_.json', 'h2/16_05_2024/response_availability_paresh_08_23_35_1715847815_1_.json', 'h2/16_05_2024/response_header_availability_paresh_08_23_35_1715847815_1_.json', 'hotelspro', '2024-05-16 08:23:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:35], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/16_05_2024/request_availability_paresh_08_23_35_1715847815_8.xml', 'a5/16_05_2024/response_availability_paresh_08_23_35_1715847815_8.xml', 'a5/16_05_2024/response_header_availability_paresh_08_23_35_1715847815_8.xml', 'agoda', '2024-05-16 08:23:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:35], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'h2/16_05_2024/request_availability_paresh_08_23_35_1715847815_21_.json', 'h2/16_05_2024/response_availability_paresh_08_23_35_1715847815_21_.json', 'h2/16_05_2024/response_header_availability_paresh_08_23_35_1715847815_21_.json', 'hotelspro', '2024-05-16 08:23:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:35], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '3'
        , request_url = '/call.php?s=hotelspro&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317&db_caching=1&&erequest=11&total_request=24&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 08:23:34.785'
        , request_start_time = '0.093'
        , parsing_start_time = '0.202'
        , mapping_complete_time = '0.040'
        , mongo_start_time = '0.081'
        , search_end_time = '0.113'
        , total_duration = '0.704'
        , error_description = ''
        , memory_used = '9334896'
        WHERE id = '139483164';
[05/16/2024 08:23:35], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '8'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317&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-16 08:23:34.785'
        , request_start_time = '0.018'
        , parsing_start_time = '0.372'
        , mapping_complete_time = '0.050'
        , mongo_start_time = '0.067'
        , search_end_time = '0.076'
        , total_duration = '0.726'
        , error_description = ''
        , memory_used = '10219024'
        WHERE id = '139483169';
[05/16/2024 08:23:35], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/16_05_2024/request_availability_paresh_08_23_35_1715847815_15.xml', 'a5/16_05_2024/response_availability_paresh_08_23_35_1715847815_15.xml', 'a5/16_05_2024/response_header_availability_paresh_08_23_35_1715847815_15.xml', 'agoda', '2024-05-16 08:23:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:35], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/16_05_2024/request_availability_paresh_08_23_34_1715847814_29.xml', 'a5/16_05_2024/response_availability_paresh_08_23_34_1715847814_29.xml', 'a5/16_05_2024/response_header_availability_paresh_08_23_34_1715847814_29.xml', 'agoda', '2024-05-16 08:23:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:35], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '14'
        , request_url = '/call.php?s=hotelspro&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317&db_caching=1&&erequest=20&total_request=24&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 08:23:34.781'
        , request_start_time = '0.104'
        , parsing_start_time = '0.229'
        , mapping_complete_time = '0.028'
        , mongo_start_time = '0.074'
        , search_end_time = '0.173'
        , total_duration = '0.774'
        , error_description = ''
        , memory_used = '12184080'
        WHERE id = '139483163';
[05/16/2024 08:23:35], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'h2/16_05_2024/request_availability_paresh_08_23_35_1715847815_17_.json', 'h2/16_05_2024/response_availability_paresh_08_23_35_1715847815_17_.json', 'h2/16_05_2024/response_header_availability_paresh_08_23_35_1715847815_17_.json', 'hotelspro', '2024-05-16 08:23:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:35], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'tr/16_05_2024/request_availability_paresh__3_08_23_34_1715847814.json', 'tr/16_05_2024/response_availability_paresh__3_08_23_34_1715847814.json', 'tr/16_05_2024/response_header_availability_paresh__3_08_23_34_1715847814.json', 'tripathonxml', '2024-05-16 08:23:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:35], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/16_05_2024/request_availability_paresh_08_23_35_1715847815_14.xml', 'a5/16_05_2024/response_availability_paresh_08_23_35_1715847815_14.xml', 'a5/16_05_2024/response_header_availability_paresh_08_23_35_1715847815_14.xml', 'agoda', '2024-05-16 08:23:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:35], [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=317&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-16 08:23:34.781'
        , request_start_time = '0.068'
        , parsing_start_time = '0.353'
        , mapping_complete_time = '0.060'
        , mongo_start_time = '0.072'
        , search_end_time = '0.073'
        , total_duration = '0.797'
        , error_description = ''
        , memory_used = '7302808'
        WHERE id = '139483175';
[05/16/2024 08:23:35], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/16_05_2024/request_availability_paresh_08_23_35_1715847815_12.xml', 'a5/16_05_2024/response_availability_paresh_08_23_35_1715847815_12.xml', 'a5/16_05_2024/response_header_availability_paresh_08_23_35_1715847815_12.xml', 'agoda', '2024-05-16 08:23:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:35], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/16_05_2024/request_availability_paresh_08_23_35_1715847815_10.xml', 'a5/16_05_2024/response_availability_paresh_08_23_35_1715847815_10.xml', 'a5/16_05_2024/response_header_availability_paresh_08_23_35_1715847815_10.xml', 'agoda', '2024-05-16 08:23:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:35], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/16_05_2024/request_availability_paresh_08_23_34_1715847814_17.xml', 'a5/16_05_2024/response_availability_paresh_08_23_34_1715847814_17.xml', 'a5/16_05_2024/response_header_availability_paresh_08_23_34_1715847814_17.xml', 'agoda', '2024-05-16 08:23:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:35], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/16_05_2024/request_availability_paresh_08_23_35_1715847815_13.xml', 'a5/16_05_2024/response_availability_paresh_08_23_35_1715847815_13.xml', 'a5/16_05_2024/response_header_availability_paresh_08_23_35_1715847815_13.xml', 'agoda', '2024-05-16 08:23:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:35], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'h2/16_05_2024/request_availability_paresh_08_23_34_1715847814_7_.json', 'h2/16_05_2024/response_availability_paresh_08_23_34_1715847814_7_.json', 'h2/16_05_2024/response_header_availability_paresh_08_23_34_1715847814_7_.json', 'hotelspro', '2024-05-16 08:23:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:35], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'd3/16_05_2024/request_availability_paresh_08_23_35_1715847815_49_1.xml', 'd3/16_05_2024/response_availability_paresh_08_23_35_1715847815_49_1.xml', 'd3/16_05_2024/response_header_availability_paresh_08_23_35_1715847815_49_1.xml', 'darina', '2024-05-16 08:23:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:35], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/16_05_2024/request_availability_paresh_08_23_35_1715847815_16.xml', 'a5/16_05_2024/response_availability_paresh_08_23_35_1715847815_16.xml', 'a5/16_05_2024/response_header_availability_paresh_08_23_35_1715847815_16.xml', 'agoda', '2024-05-16 08:23:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:35], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/16_05_2024/request_availability_paresh_08_23_35_1715847815_5.xml', 'a5/16_05_2024/response_availability_paresh_08_23_35_1715847815_5.xml', 'a5/16_05_2024/response_header_availability_paresh_08_23_35_1715847815_5.xml', 'agoda', '2024-05-16 08:23:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:35], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/16_05_2024/request_availability_paresh_08_23_35_1715847815_27.xml', 'a5/16_05_2024/response_availability_paresh_08_23_35_1715847815_27.xml', 'a5/16_05_2024/response_header_availability_paresh_08_23_35_1715847815_27.xml', 'agoda', '2024-05-16 08:23:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:35], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/16_05_2024/request_availability_paresh_08_23_35_1715847815_23.xml', 'a5/16_05_2024/response_availability_paresh_08_23_35_1715847815_23.xml', 'a5/16_05_2024/response_header_availability_paresh_08_23_35_1715847815_23.xml', 'agoda', '2024-05-16 08:23:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:35], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '16'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317&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-16 08:23:34.793'
        , request_start_time = '0.050'
        , parsing_start_time = '0.435'
        , mapping_complete_time = '0.046'
        , mongo_start_time = '0.073'
        , search_end_time = '0.170'
        , total_duration = '0.941'
        , error_description = ''
        , memory_used = '9282024'
        WHERE id = '139483177';
[05/16/2024 08:23:35], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/16_05_2024/request_availability_paresh_08_23_35_1715847815_20.xml', 'a5/16_05_2024/response_availability_paresh_08_23_35_1715847815_20.xml', 'a5/16_05_2024/response_header_availability_paresh_08_23_35_1715847815_20.xml', 'agoda', '2024-05-16 08:23:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:35], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '2'
        , request_url = '/call.php?s=tripathonxml&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317&db_caching=1&web_service=no&site_id=&save_log=yes&city_code=AE_135012_&city_name=Hatta+%28Dubai%29&country_code=AE&country_name=United+Arab+Emirates&multicityreq=3&ws=1&original_source='
        , http_hit_time = '2024-05-16 08:23:34.776'
        , request_start_time = '0.038'
        , parsing_start_time = '0.589'
        , mapping_complete_time = '0.025'
        , mongo_start_time = '0.043'
        , search_end_time = '0.156'
        , total_duration = '0.990'
        , error_description = ''
        , memory_used = '4359008'
        WHERE id = '139483180';
[05/16/2024 08:23:35], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/16_05_2024/request_availability_paresh_08_23_35_1715847815_4.xml', 'a5/16_05_2024/response_availability_paresh_08_23_35_1715847815_4.xml', 'a5/16_05_2024/response_header_availability_paresh_08_23_35_1715847815_4.xml', 'agoda', '2024-05-16 08:23:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:35], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/16_05_2024/request_availability_paresh_08_23_35_1715847815_19.xml', 'a5/16_05_2024/response_availability_paresh_08_23_35_1715847815_19.xml', 'a5/16_05_2024/response_header_availability_paresh_08_23_35_1715847815_19.xml', 'agoda', '2024-05-16 08:23:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:35], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'h2/16_05_2024/request_availability_paresh_08_23_35_1715847815_8_.json', 'h2/16_05_2024/response_availability_paresh_08_23_35_1715847815_8_.json', 'h2/16_05_2024/response_header_availability_paresh_08_23_35_1715847815_8_.json', 'hotelspro', '2024-05-16 08:23:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:35], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'd3/16_05_2024/request_availability_paresh_08_23_35_1715847815_49_0.xml', 'd3/16_05_2024/response_availability_paresh_08_23_35_1715847815_49_0.xml', 'd3/16_05_2024/response_header_availability_paresh_08_23_35_1715847815_49_0.xml', 'darina', '2024-05-16 08:23:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:35], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '11'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317&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-16 08:23:34.792'
        , request_start_time = '0.046'
        , parsing_start_time = '0.486'
        , mapping_complete_time = '0.084'
        , mongo_start_time = '0.118'
        , search_end_time = '0.217'
        , total_duration = '1.007'
        , error_description = ''
        , memory_used = '10736936'
        WHERE id = '139483178';
[05/16/2024 08:23:35], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/16_05_2024/request_availability_paresh_08_23_35_1715847815_30.xml', 'a5/16_05_2024/response_availability_paresh_08_23_35_1715847815_30.xml', 'a5/16_05_2024/response_header_availability_paresh_08_23_35_1715847815_30.xml', 'agoda', '2024-05-16 08:23:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:35], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/16_05_2024/request_availability_paresh_08_23_35_1715847815_26.xml', 'a5/16_05_2024/response_availability_paresh_08_23_35_1715847815_26.xml', 'a5/16_05_2024/response_header_availability_paresh_08_23_35_1715847815_26.xml', 'agoda', '2024-05-16 08:23:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:35], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '8'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317&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-16 08:23:34.787'
        , request_start_time = '0.074'
        , parsing_start_time = '0.470'
        , mapping_complete_time = '0.072'
        , mongo_start_time = '0.109'
        , search_end_time = '0.155'
        , total_duration = '1.026'
        , error_description = ''
        , memory_used = '8964232'
        WHERE id = '139483184';
[05/16/2024 08:23:35], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/16_05_2024/request_availability_paresh_08_23_35_1715847815_6.xml', 'a5/16_05_2024/response_availability_paresh_08_23_35_1715847815_6.xml', 'a5/16_05_2024/response_header_availability_paresh_08_23_35_1715847815_6.xml', 'agoda', '2024-05-16 08:23:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:35], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/16_05_2024/request_availability_paresh_08_23_35_1715847815_18.xml', 'a5/16_05_2024/response_availability_paresh_08_23_35_1715847815_18.xml', 'a5/16_05_2024/response_header_availability_paresh_08_23_35_1715847815_18.xml', 'agoda', '2024-05-16 08:23:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:35], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/16_05_2024/request_availability_paresh_08_23_35_1715847815_28.xml', 'a5/16_05_2024/response_availability_paresh_08_23_35_1715847815_28.xml', 'a5/16_05_2024/response_header_availability_paresh_08_23_35_1715847815_28.xml', 'agoda', '2024-05-16 08:23:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:35], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/16_05_2024/request_availability_paresh_9535894_1715847815_34.json', 'e1/16_05_2024/response_availability_paresh_9535894_1715847815_34.json', 'e1/16_05_2024/response_header_availability_paresh_9535894_1715847815_34.json', 'expedia', '2024-05-16 08:23:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:35], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '11'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317&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-16 08:23:34.791'
        , request_start_time = '0.036'
        , parsing_start_time = '0.506'
        , mapping_complete_time = '0.096'
        , mongo_start_time = '0.123'
        , search_end_time = '0.279'
        , total_duration = '1.137'
        , error_description = ''
        , memory_used = '9576168'
        WHERE id = '139483182';
[05/16/2024 08:23:35], [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=317&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-16 08:23:34.786'
        , request_start_time = '0.064'
        , parsing_start_time = '0.452'
        , mapping_complete_time = '0.080'
        , mongo_start_time = '0.173'
        , search_end_time = '0.247'
        , total_duration = '1.167'
        , error_description = ''
        , memory_used = '9599160'
        WHERE id = '139483183';
[05/16/2024 08:23:35], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/16_05_2024/request_availability_paresh_08_23_34_1715847814_33.xml', 'a5/16_05_2024/response_availability_paresh_08_23_34_1715847814_33.xml', 'a5/16_05_2024/response_header_availability_paresh_08_23_34_1715847814_33.xml', 'agoda', '2024-05-16 08:23:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:35], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/16_05_2024/request_availability_paresh_08_23_35_1715847815_7.xml', 'a5/16_05_2024/response_availability_paresh_08_23_35_1715847815_7.xml', 'a5/16_05_2024/response_header_availability_paresh_08_23_35_1715847815_7.xml', 'agoda', '2024-05-16 08:23:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:35], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/16_05_2024/request_availability_paresh_08_23_34_1715847814_0.xml', 'a5/16_05_2024/response_availability_paresh_08_23_34_1715847814_0.xml', 'a5/16_05_2024/response_header_availability_paresh_08_23_34_1715847814_0.xml', 'agoda', '2024-05-16 08:23:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:35], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/16_05_2024/request_availability_paresh_08_23_35_1715847815_34.xml', 'a5/16_05_2024/response_availability_paresh_08_23_35_1715847815_34.xml', 'a5/16_05_2024/response_header_availability_paresh_08_23_35_1715847815_34.xml', 'agoda', '2024-05-16 08:23:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:36], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/16_05_2024/request_availability_paresh_08_23_35_1715847815_3.xml', 'a5/16_05_2024/response_availability_paresh_08_23_35_1715847815_3.xml', 'a5/16_05_2024/response_header_availability_paresh_08_23_35_1715847815_3.xml', 'agoda', '2024-05-16 08:23:36', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:35], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/16_05_2024/request_availability_paresh_08_23_34_1715847814_31.xml', 'a5/16_05_2024/response_availability_paresh_08_23_34_1715847814_31.xml', 'a5/16_05_2024/response_header_availability_paresh_08_23_34_1715847814_31.xml', 'agoda', '2024-05-16 08:23:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:35], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/16_05_2024/request_availability_paresh_08_23_35_1715847815_21.xml', 'a5/16_05_2024/response_availability_paresh_08_23_35_1715847815_21.xml', 'a5/16_05_2024/response_header_availability_paresh_08_23_35_1715847815_21.xml', 'agoda', '2024-05-16 08:23:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:36], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/16_05_2024/request_availability_paresh_08_23_35_1715847815_24.xml', 'a5/16_05_2024/response_availability_paresh_08_23_35_1715847815_24.xml', 'a5/16_05_2024/response_header_availability_paresh_08_23_35_1715847815_24.xml', 'agoda', '2024-05-16 08:23:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:36], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'h2/16_05_2024/request_availability_paresh_08_23_35_1715847815_10_.json', 'h2/16_05_2024/response_availability_paresh_08_23_35_1715847815_10_.json', 'h2/16_05_2024/response_header_availability_paresh_08_23_35_1715847815_10_.json', 'hotelspro', '2024-05-16 08:23:36', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:36], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '12'
        , request_url = '/call.php?s=hotelspro&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317&db_caching=1&&erequest=21&total_request=24&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 08:23:34.793'
        , request_start_time = '0.085'
        , parsing_start_time = '0.372'
        , mapping_complete_time = '0.027'
        , mongo_start_time = '0.073'
        , search_end_time = '0.491'
        , total_duration = '1.259'
        , error_description = ''
        , memory_used = '11693136'
        WHERE id = '139483176';
[05/16/2024 08:23:36], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/16_05_2024/request_availability_paresh_08_23_35_1715847815_25.xml', 'a5/16_05_2024/response_availability_paresh_08_23_35_1715847815_25.xml', 'a5/16_05_2024/response_header_availability_paresh_08_23_35_1715847815_25.xml', 'agoda', '2024-05-16 08:23:36', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:36], [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=317&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-16 08:23:34.788'
        , request_start_time = '0.025'
        , parsing_start_time = '0.569'
        , mapping_complete_time = '0.109'
        , mongo_start_time = '0.163'
        , search_end_time = '0.394'
        , total_duration = '1.342'
        , error_description = ''
        , memory_used = '11506640'
        WHERE id = '139483185';
[05/16/2024 08:23:36], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/16_05_2024/request_availability_paresh_9535894_1715847815_99.json', 'e1/16_05_2024/response_availability_paresh_9535894_1715847815_99.json', 'e1/16_05_2024/response_header_availability_paresh_9535894_1715847815_99.json', 'expedia', '2024-05-16 08:23:36', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:36], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/16_05_2024/request_availability_paresh_08_23_35_1715847815_22.xml', 'a5/16_05_2024/response_availability_paresh_08_23_35_1715847815_22.xml', 'a5/16_05_2024/response_header_availability_paresh_08_23_35_1715847815_22.xml', 'agoda', '2024-05-16 08:23:36', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:36], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/16_05_2024/request_availability_paresh_08_23_35_1715847815_32.xml', 'a5/16_05_2024/response_availability_paresh_08_23_35_1715847815_32.xml', 'a5/16_05_2024/response_header_availability_paresh_08_23_35_1715847815_32.xml', 'agoda', '2024-05-16 08:23:36', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:36], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/16_05_2024/request_availability_paresh_08_23_35_1715847815_2.xml', 'a5/16_05_2024/response_availability_paresh_08_23_35_1715847815_2.xml', 'a5/16_05_2024/response_header_availability_paresh_08_23_35_1715847815_2.xml', 'agoda', '2024-05-16 08:23:36', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:36], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/16_05_2024/request_availability_paresh_08_23_34_1715847814_1.xml', 'a5/16_05_2024/response_availability_paresh_08_23_34_1715847814_1.xml', 'a5/16_05_2024/response_header_availability_paresh_08_23_34_1715847814_1.xml', 'agoda', '2024-05-16 08:23:36', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:36], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'h2/16_05_2024/request_availability_paresh_08_23_35_1715847815_9_.json', 'h2/16_05_2024/response_availability_paresh_08_23_35_1715847815_9_.json', 'h2/16_05_2024/response_header_availability_paresh_08_23_35_1715847815_9_.json', 'hotelspro', '2024-05-16 08:23:36', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:36], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'h2/16_05_2024/request_availability_paresh_08_23_35_1715847815_12_.json', 'h2/16_05_2024/response_availability_paresh_08_23_35_1715847815_12_.json', 'h2/16_05_2024/response_header_availability_paresh_08_23_35_1715847815_12_.json', 'hotelspro', '2024-05-16 08:23:36', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:36], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/16_05_2024/request_availability_paresh_9535894_1715847815_93.json', 'e1/16_05_2024/response_availability_paresh_9535894_1715847815_93.json', 'e1/16_05_2024/response_header_availability_paresh_9535894_1715847815_93.json', 'expedia', '2024-05-16 08:23:36', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:36], [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=317&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-16 08:23:34.792'
        , request_start_time = '0.090'
        , parsing_start_time = '0.499'
        , mapping_complete_time = '0.147'
        , mongo_start_time = '0.211'
        , search_end_time = '0.379'
        , total_duration = '1.376'
        , error_description = ''
        , memory_used = '10485600'
        WHERE id = '139483189';
[05/16/2024 08:23:36], [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=317&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-16 08:23:34.788'
        , request_start_time = '0.039'
        , parsing_start_time = '0.541'
        , mapping_complete_time = '0.131'
        , mongo_start_time = '0.249'
        , search_end_time = '0.411'
        , total_duration = '1.430'
        , error_description = ''
        , memory_used = '12142272'
        WHERE id = '139483186';
[05/16/2024 08:23:36], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'h2/16_05_2024/request_availability_paresh_08_23_35_1715847815_18_.json', 'h2/16_05_2024/response_availability_paresh_08_23_35_1715847815_18_.json', 'h2/16_05_2024/response_header_availability_paresh_08_23_35_1715847815_18_.json', 'hotelspro', '2024-05-16 08:23:36', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:36], [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=317&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-16 08:23:34.786'
        , request_start_time = '0.048'
        , parsing_start_time = '0.539'
        , mapping_complete_time = '0.140'
        , mongo_start_time = '0.239'
        , search_end_time = '0.473'
        , total_duration = '1.540'
        , error_description = ''
        , memory_used = '14490384'
        WHERE id = '139483191';
[05/16/2024 08:23:36], [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=317&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-16 08:23:34.786'
        , request_start_time = '0.028'
        , parsing_start_time = '0.593'
        , mapping_complete_time = '0.155'
        , mongo_start_time = '0.264'
        , search_end_time = '0.419'
        , total_duration = '1.504'
        , error_description = ''
        , memory_used = '14998272'
        WHERE id = '139483190';
[05/16/2024 08:23:36], [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=317&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-16 08:23:34.791'
        , request_start_time = '0.040'
        , parsing_start_time = '0.650'
        , mapping_complete_time = '0.186'
        , mongo_start_time = '0.336'
        , search_end_time = '0.311'
        , total_duration = '1.535'
        , error_description = ''
        , memory_used = '16691928'
        WHERE id = '139483202';
[05/16/2024 08:23:36], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'h2/16_05_2024/request_availability_paresh_08_23_34_1715847814_0_.json', 'h2/16_05_2024/response_availability_paresh_08_23_34_1715847814_0_.json', 'h2/16_05_2024/response_header_availability_paresh_08_23_34_1715847814_0_.json', 'hotelspro', '2024-05-16 08:23:36', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:36], [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=317&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-16 08:23:34.788'
        , request_start_time = '0.091'
        , parsing_start_time = '0.555'
        , mapping_complete_time = '0.280'
        , mongo_start_time = '0.328'
        , search_end_time = '0.464'
        , total_duration = '1.682'
        , error_description = ''
        , memory_used = '11238664'
        WHERE id = '139483207';
[05/16/2024 08:23:36], [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=317&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-16 08:23:34.788'
        , request_start_time = '0.060'
        , parsing_start_time = '0.580'
        , mapping_complete_time = '0.151'
        , mongo_start_time = '0.269'
        , search_end_time = '0.515'
        , total_duration = '1.636'
        , error_description = ''
        , memory_used = '12427736'
        WHERE id = '139483192';
[05/16/2024 08:23:36], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/16_05_2024/request_availability_paresh_9535894_1715847815_63.json', 'e1/16_05_2024/response_availability_paresh_9535894_1715847815_63.json', 'e1/16_05_2024/response_header_availability_paresh_9535894_1715847815_63.json', 'expedia', '2024-05-16 08:23:36', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:36], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'h2/16_05_2024/request_availability_paresh_08_23_34_1715847814_3_.json', 'h2/16_05_2024/response_availability_paresh_08_23_34_1715847814_3_.json', 'h2/16_05_2024/response_header_availability_paresh_08_23_34_1715847814_3_.json', 'hotelspro', '2024-05-16 08:23:36', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:36], [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=317&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-16 08:23:34.786'
        , request_start_time = '0.031'
        , parsing_start_time = '0.581'
        , mapping_complete_time = '0.222'
        , mongo_start_time = '0.306'
        , search_end_time = '0.574'
        , total_duration = '1.722'
        , error_description = ''
        , memory_used = '15158328'
        WHERE id = '139483198';
[05/16/2024 08:23:36], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'h2/16_05_2024/request_availability_paresh_08_23_34_1715847814_2_.json', 'h2/16_05_2024/response_availability_paresh_08_23_34_1715847814_2_.json', 'h2/16_05_2024/response_header_availability_paresh_08_23_34_1715847814_2_.json', 'hotelspro', '2024-05-16 08:23:36', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:36], [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=317&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-16 08:23:34.788'
        , request_start_time = '0.023'
        , parsing_start_time = '0.599'
        , mapping_complete_time = '0.185'
        , mongo_start_time = '0.261'
        , search_end_time = '0.608'
        , total_duration = '1.722'
        , error_description = ''
        , memory_used = '15881880'
        WHERE id = '139483196';
[05/16/2024 08:23:36], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/16_05_2024/request_availability_paresh_9535894_1715847815_76.json', 'e1p/16_05_2024/response_availability_paresh_9535894_1715847815_76.json', 'e1p/16_05_2024/response_header_availability_paresh_9535894_1715847815_76.json', 'expediapackage', '2024-05-16 08:23:36', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:36], [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=317&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-16 08:23:34.783'
        , request_start_time = '0.068'
        , parsing_start_time = '0.755'
        , mapping_complete_time = '0.197'
        , mongo_start_time = '0.243'
        , search_end_time = '0.597'
        , total_duration = '1.817'
        , error_description = ''
        , memory_used = '15815984'
        WHERE id = '139483206';
[05/16/2024 08:23:36], [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=317&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-16 08:23:34.787'
        , request_start_time = '0.024'
        , parsing_start_time = '0.595'
        , mapping_complete_time = '0.321'
        , mongo_start_time = '0.378'
        , search_end_time = '0.560'
        , total_duration = '1.766'
        , error_description = ''
        , memory_used = '13168000'
        WHERE id = '139483204';
[05/16/2024 08:23:36], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'h2/16_05_2024/request_availability_paresh_08_23_35_1715847815_19_.json', 'h2/16_05_2024/response_availability_paresh_08_23_35_1715847815_19_.json', 'h2/16_05_2024/response_header_availability_paresh_08_23_35_1715847815_19_.json', 'hotelspro', '2024-05-16 08:23:36', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:36], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/16_05_2024/request_availability_paresh_9535894_1715847815_59.json', 'e1p/16_05_2024/response_availability_paresh_9535894_1715847815_59.json', 'e1p/16_05_2024/response_header_availability_paresh_9535894_1715847815_59.json', 'expediapackage', '2024-05-16 08:23:36', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:36], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/16_05_2024/request_availability_paresh_9535894_1715847815_72.json', 'e1/16_05_2024/response_availability_paresh_9535894_1715847815_72.json', 'e1/16_05_2024/response_header_availability_paresh_9535894_1715847815_72.json', 'expedia', '2024-05-16 08:23:36', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:36], [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=317&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-16 08:23:34.783'
        , request_start_time = '0.055'
        , parsing_start_time = '0.636'
        , mapping_complete_time = '0.368'
        , mongo_start_time = '0.431'
        , search_end_time = '0.496'
        , total_duration = '1.838'
        , error_description = ''
        , memory_used = '17058792'
        WHERE id = '139483216';
[05/16/2024 08:23:36], [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=317&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-16 08:23:34.785'
        , request_start_time = '0.034'
        , parsing_start_time = '0.612'
        , mapping_complete_time = '0.193'
        , mongo_start_time = '0.327'
        , search_end_time = '0.661'
        , total_duration = '1.829'
        , error_description = ''
        , memory_used = '18648648'
        WHERE id = '139483197';
[05/16/2024 08:23:36], [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=317&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-16 08:23:34.794'
        , request_start_time = '0.082'
        , parsing_start_time = '0.629'
        , mapping_complete_time = '0.444'
        , mongo_start_time = '0.486'
        , search_end_time = '0.416'
        , total_duration = '1.839'
        , error_description = ''
        , memory_used = '15760912'
        WHERE id = '139483229';
[05/16/2024 08:23:36], [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=317&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-16 08:23:34.776'
        , request_start_time = '0.021'
        , parsing_start_time = '0.730'
        , mapping_complete_time = '0.301'
        , mongo_start_time = '0.384'
        , search_end_time = '0.526'
        , total_duration = '1.865'
        , error_description = ''
        , memory_used = '16534584'
        WHERE id = '139483210';
[05/16/2024 08:23:36], [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=317&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-16 08:23:34.771'
        , request_start_time = '0.033'
        , parsing_start_time = '0.627'
        , mapping_complete_time = '0.187'
        , mongo_start_time = '0.294'
        , search_end_time = '0.731'
        , total_duration = '1.931'
        , error_description = ''
        , memory_used = '17945840'
        WHERE id = '139483201';
[05/16/2024 08:23:36], [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=317&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-16 08:23:34.773'
        , request_start_time = '0.102'
        , parsing_start_time = '0.652'
        , mapping_complete_time = '0.478'
        , mongo_start_time = '0.583'
        , search_end_time = '0.371'
        , total_duration = '1.947'
        , error_description = ''
        , memory_used = '19546984'
        WHERE id = '139483233';
[05/16/2024 08:23:36], [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=317&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-16 08:23:34.783'
        , request_start_time = '0.040'
        , parsing_start_time = '0.829'
        , mapping_complete_time = '0.292'
        , mongo_start_time = '0.362'
        , search_end_time = '0.575'
        , total_duration = '2.013'
        , error_description = ''
        , memory_used = '17490696'
        WHERE id = '139483221';
[05/16/2024 08:23:36], [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=317&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-16 08:23:34.785'
        , request_start_time = '0.021'
        , parsing_start_time = '0.766'
        , mapping_complete_time = '0.311'
        , mongo_start_time = '0.438'
        , search_end_time = '0.646'
        , total_duration = '2.061'
        , error_description = ''
        , memory_used = '15426800'
        WHERE id = '139483217';
[05/16/2024 08:23:36], [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=317&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-16 08:23:34.791'
        , request_start_time = '0.072'
        , parsing_start_time = '0.645'
        , mapping_complete_time = '0.434'
        , mongo_start_time = '0.597'
        , search_end_time = '0.502'
        , total_duration = '2.042'
        , error_description = ''
        , memory_used = '19611520'
        WHERE id = '139483226';
[05/16/2024 08:23:36], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/16_05_2024/request_availability_paresh_9535894_1715847815_44.json', 'e1p/16_05_2024/response_availability_paresh_9535894_1715847815_44.json', 'e1p/16_05_2024/response_header_availability_paresh_9535894_1715847815_44.json', 'expediapackage', '2024-05-16 08:23:36', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:36], [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=317&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-16 08:23:34.791'
        , request_start_time = '0.072'
        , parsing_start_time = '0.665'
        , mapping_complete_time = '0.503'
        , mongo_start_time = '0.578'
        , search_end_time = '0.578'
        , total_duration = '2.104'
        , error_description = ''
        , memory_used = '19827664'
        WHERE id = '139483234';
[05/16/2024 08:23:36], [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=317&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-16 08:23:34.773'
        , request_start_time = '0.020'
        , parsing_start_time = '0.632'
        , mapping_complete_time = '0.519'
        , mongo_start_time = '0.610'
        , search_end_time = '0.600'
        , total_duration = '2.102'
        , error_description = ''
        , memory_used = '19543000'
        WHERE id = '139483220';
[05/16/2024 08:23:36], [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=317&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-16 08:23:34.787'
        , request_start_time = '0.077'
        , parsing_start_time = '0.586'
        , mapping_complete_time = '0.581'
        , mongo_start_time = '0.672'
        , search_end_time = '0.600'
        , total_duration = '2.151'
        , error_description = ''
        , memory_used = '16975096'
        WHERE id = '139483232';
[05/16/2024 08:23:36], [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=317&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-16 08:23:34.791'
        , request_start_time = '0.040'
        , parsing_start_time = '0.785'
        , mapping_complete_time = '0.470'
        , mongo_start_time = '0.557'
        , search_end_time = '0.633'
        , total_duration = '2.182'
        , error_description = ''
        , memory_used = '16235112'
        WHERE id = '139483237';
[05/16/2024 08:23:36], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/16_05_2024/request_availability_paresh_9535894_1715847815_44.json', 'e1p/16_05_2024/response_availability_paresh_9535894_1715847815_44.json', 'e1p/16_05_2024/response_header_availability_paresh_9535894_1715847815_44.json', 'expediapackage', '2024-05-16 08:23:36', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:37], [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=317&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-16 08:23:34.776'
        , request_start_time = '0.045'
        , parsing_start_time = '0.716'
        , mapping_complete_time = '0.455'
        , mongo_start_time = '0.591'
        , search_end_time = '0.752'
        , total_duration = '2.265'
        , error_description = ''
        , memory_used = '15463304'
        WHERE id = '139483225';
[05/16/2024 08:23:37], [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=317&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-16 08:23:34.783'
        , request_start_time = '0.021'
        , parsing_start_time = '0.771'
        , mapping_complete_time = '0.423'
        , mongo_start_time = '0.496'
        , search_end_time = '0.794'
        , total_duration = '2.316'
        , error_description = ''
        , memory_used = '20299624'
        WHERE id = '139483236';
[05/16/2024 08:23:37], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '24'
        , request_url = '/call.php?s=hotelspro&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317&db_caching=1&&erequest=5&total_request=24&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 08:23:34.776'
        , request_start_time = '0.037'
        , parsing_start_time = '0.378'
        , mapping_complete_time = '0.038'
        , mongo_start_time = '0.154'
        , search_end_time = '1.641'
        , total_duration = '2.360'
        , error_description = ''
        , memory_used = '31309208'
        WHERE id = '139483165';
[05/16/2024 08:23:37], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'h2/16_05_2024/request_availability_paresh_08_23_34_1715847814_15_.json', 'h2/16_05_2024/response_availability_paresh_08_23_34_1715847814_15_.json', 'h2/16_05_2024/response_header_availability_paresh_08_23_34_1715847814_15_.json', 'hotelspro', '2024-05-16 08:23:37', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:37], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '19'
        , request_url = '/call.php?s=hotelspro&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317&db_caching=1&&erequest=13&total_request=24&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 08:23:34.779'
        , request_start_time = '0.094'
        , parsing_start_time = '0.282'
        , mapping_complete_time = '0.039'
        , mongo_start_time = '0.270'
        , search_end_time = '1.512'
        , total_duration = '2.355'
        , error_description = ''
        , memory_used = '39051768'
        WHERE id = '139483166';
[05/16/2024 08:23:37], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '21'
        , request_url = '/call.php?s=hotelspro&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317&db_caching=1&&erequest=6&total_request=24&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 08:23:34.779'
        , request_start_time = '0.076'
        , parsing_start_time = '0.320'
        , mapping_complete_time = '0.040'
        , mongo_start_time = '0.166'
        , search_end_time = '1.617'
        , total_duration = '2.431'
        , error_description = ''
        , memory_used = '29539952'
        WHERE id = '139483172';
[05/16/2024 08:23:37], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '18'
        , request_url = '/call.php?s=hotelspro&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317&db_caching=1&&erequest=16&total_request=24&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 08:23:34.785'
        , request_start_time = '0.109'
        , parsing_start_time = '0.316'
        , mapping_complete_time = '0.036'
        , mongo_start_time = '0.138'
        , search_end_time = '1.969'
        , total_duration = '2.745'
        , error_description = ''
        , memory_used = '29431848'
        WHERE id = '139483171';
[05/16/2024 08:23:37], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '17'
        , request_url = '/call.php?s=hotelspro&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317&db_caching=1&&erequest=22&total_request=24&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 08:23:34.779'
        , request_start_time = '0.111'
        , parsing_start_time = '0.284'
        , mapping_complete_time = '0.045'
        , mongo_start_time = '0.197'
        , search_end_time = '2.103'
        , total_duration = '2.927'
        , error_description = ''
        , memory_used = '34379792'
        WHERE id = '139483170';
[05/16/2024 08:23:37], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '50'
        , request_url = '/call.php?s=expedia&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317&db_caching=1&erequest=0&total_request=5&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F125.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=114'
        , http_hit_time = '2024-05-16 08:23:34.785'
        , request_start_time = '0.313'
        , parsing_start_time = '1.274'
        , mapping_complete_time = '0.033'
        , mongo_start_time = '0.508'
        , search_end_time = '0.753'
        , total_duration = '3.084'
        , error_description = ''
        , memory_used = '64489064'
        WHERE id = '139483235';
[05/16/2024 08:23:37], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/16_05_2024/request_availability_paresh_9535894_1715847815_30.json', 'e1p/16_05_2024/response_availability_paresh_9535894_1715847815_30.json', 'e1p/16_05_2024/response_header_availability_paresh_9535894_1715847815_30.json', 'expediapackage', '2024-05-16 08:23:37', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:38], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '35'
        , request_url = '/call.php?s=hotelspro&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317&db_caching=1&&erequest=1&total_request=24&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 08:23:34.778'
        , request_start_time = '0.052'
        , parsing_start_time = '0.349'
        , mapping_complete_time = '0.067'
        , mongo_start_time = '0.390'
        , search_end_time = '2.275'
        , total_duration = '3.323'
        , error_description = ''
        , memory_used = '53328608'
        WHERE id = '139483174';
[05/16/2024 08:23:38], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '14'
        , request_url = '/call.php?s=hotelspro&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317&db_caching=1&&erequest=15&total_request=24&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 08:23:34.794'
        , request_start_time = '0.046'
        , parsing_start_time = '2.120'
        , mapping_complete_time = '0.068'
        , mongo_start_time = '0.184'
        , search_end_time = '0.826'
        , total_duration = '3.323'
        , error_description = ''
        , memory_used = '22597280'
        WHERE id = '139483259';
[05/16/2024 08:23:38], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '23'
        , request_url = '/call.php?s=hotelspro&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317&db_caching=1&&erequest=7&total_request=24&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 08:23:34.779'
        , request_start_time = '0.036'
        , parsing_start_time = '0.624'
        , mapping_complete_time = '0.110'
        , mongo_start_time = '0.490'
        , search_end_time = '2.133'
        , total_duration = '3.468'
        , error_description = ''
        , memory_used = '46271688'
        WHERE id = '139483187';
[05/16/2024 08:23:38], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '58'
        , request_url = '/call.php?s=expedia&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317&db_caching=1&erequest=1&total_request=5&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F125.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=114'
        , http_hit_time = '2024-05-16 08:23:34.780'
        , request_start_time = '0.246'
        , parsing_start_time = '1.073'
        , mapping_complete_time = '0.002'
        , mongo_start_time = '0.485'
        , search_end_time = '1.632'
        , total_duration = '3.698'
        , error_description = ''
        , memory_used = '103208632'
        WHERE id = '139483208';
[05/16/2024 08:23:38], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'd5/16_05_2024/request_availability_paresh_08_23_34_1715847814_97.json', 'd5/16_05_2024/response_availability_paresh_08_23_34_1715847814_97.json', 'd5/16_05_2024/response_header_availability_paresh_08_23_34_1715847814_97.json', 'dida9', '2024-05-16 08:23:38', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:38], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'tr/16_05_2024/request_availability_paresh__0_08_23_35_1715847815.json', 'tr/16_05_2024/response_availability_paresh__0_08_23_35_1715847815.json', 'tr/16_05_2024/response_header_availability_paresh__0_08_23_35_1715847815.json', 'tripathonxml', '2024-05-16 08:23:38', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:38], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '19'
        , request_url = '/call.php?s=hotelspro&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317&db_caching=1&&erequest=17&total_request=24&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 08:23:34.783'
        , request_start_time = '0.110'
        , parsing_start_time = '0.402'
        , mapping_complete_time = '0.061'
        , mongo_start_time = '0.763'
        , search_end_time = '2.405'
        , total_duration = '3.918'
        , error_description = ''
        , memory_used = '54278392'
        WHERE id = '139483179';
[05/16/2024 08:23:38], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '58'
        , request_url = '/call.php?s=expediapackage&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317&db_caching=1&erequest=1&total_request=5&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F125.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=114'
        , http_hit_time = '2024-05-16 08:23:34.785'
        , request_start_time = '0.355'
        , parsing_start_time = '1.573'
        , mapping_complete_time = '0.023'
        , mongo_start_time = '0.469'
        , search_end_time = '1.362'
        , total_duration = '3.996'
        , error_description = ''
        , memory_used = '102514408'
        WHERE id = '139483251';
[05/16/2024 08:23:38], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '26'
        , request_url = '/call.php?s=hotelspro&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317&db_caching=1&&erequest=14&total_request=24&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 08:23:34.779'
        , request_start_time = '0.104'
        , parsing_start_time = '0.342'
        , mapping_complete_time = '0.061'
        , mongo_start_time = '0.478'
        , search_end_time = '2.894'
        , total_duration = '4.014'
        , error_description = ''
        , memory_used = '54996944'
        WHERE id = '139483173';
[05/16/2024 08:23:38], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '30'
        , request_url = '/call.php?s=hotelspro&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317&db_caching=1&&erequest=0&total_request=24&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 08:23:34.778'
        , request_start_time = '0.026'
        , parsing_start_time = '1.232'
        , mapping_complete_time = '0.334'
        , mongo_start_time = '0.993'
        , search_end_time = '1.631'
        , total_duration = '4.041'
        , error_description = ''
        , memory_used = '54582952'
        WHERE id = '139483246';
[05/16/2024 08:23:38], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '30'
        , request_url = '/call.php?s=hotelspro&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317&db_caching=1&&erequest=18&total_request=24&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 08:23:34.783'
        , request_start_time = '0.141'
        , parsing_start_time = '0.911'
        , mapping_complete_time = '0.343'
        , mongo_start_time = '1.034'
        , search_end_time = '1.871'
        , total_duration = '4.156'
        , error_description = ''
        , memory_used = '63767360'
        WHERE id = '139483243';
[05/16/2024 08:23:39], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '20'
        , request_url = '/call.php?s=dida&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317&db_caching=1&wh_agent_id=&erequest=9&total_request=17&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 08:23:34.776'
        , request_start_time = '0.032'
        , parsing_start_time = '3.816'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.060'
        , search_end_time = '0.273'
        , total_duration = '4.320'
        , error_description = ''
        , memory_used = '21818776'
        WHERE id = '139483268';
[05/16/2024 08:23:39], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '29'
        , request_url = '/call.php?s=hotelspro&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317&db_caching=1&&erequest=10&total_request=24&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 08:23:34.785'
        , request_start_time = '0.105'
        , parsing_start_time = '0.802'
        , mapping_complete_time = '0.281'
        , mongo_start_time = '0.676'
        , search_end_time = '2.586'
        , total_duration = '4.390'
        , error_description = ''
        , memory_used = '63985256'
        WHERE id = '139483230';
[05/16/2024 08:23:39], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '145'
        , request_url = '/call.php?s=darina&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&darina_country=UAE&darina_city=DXB&darina_country_id=12&darina_city_id=49&xml_user_id=317&db_caching=1&wh_agent_id=&erequest=1&total_request=2&hotel_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 08:23:34.791'
        , request_start_time = '0.332'
        , parsing_start_time = '0.300'
        , mapping_complete_time = '0.664'
        , mongo_start_time = '1.482'
        , search_end_time = '2.285'
        , total_duration = '4.625'
        , error_description = ''
        , memory_used = '80846512'
        WHERE id = '139483188';
[05/16/2024 08:23:39], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '82'
        , request_url = '/call.php?s=expedia&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317&db_caching=1&erequest=4&total_request=5&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F125.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=114'
        , http_hit_time = '2024-05-16 08:23:34.786'
        , request_start_time = '0.508'
        , parsing_start_time = '1.685'
        , mapping_complete_time = '0.002'
        , mongo_start_time = '0.439'
        , search_end_time = '2.013'
        , total_duration = '4.920'
        , error_description = ''
        , memory_used = '146451536'
        WHERE id = '139483255';
[05/16/2024 08:23:39], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '76'
        , request_url = '/call.php?s=expediapackage&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317&db_caching=1&erequest=3&total_request=5&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F125.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=114'
        , http_hit_time = '2024-05-16 08:23:34.787'
        , request_start_time = '0.479'
        , parsing_start_time = '2.028'
        , mapping_complete_time = '0.007'
        , mongo_start_time = '0.290'
        , search_end_time = '1.869'
        , total_duration = '4.927'
        , error_description = ''
        , memory_used = '143335536'
        WHERE id = '139483258';
[05/16/2024 08:23:39], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '23'
        , request_url = '/call.php?s=hotelspro&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317&db_caching=1&&erequest=12&total_request=24&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 08:23:34.786'
        , request_start_time = '0.099'
        , parsing_start_time = '0.880'
        , mapping_complete_time = '0.257'
        , mongo_start_time = '1.353'
        , search_end_time = '2.376'
        , total_duration = '4.931'
        , error_description = ''
        , memory_used = '79037888'
        WHERE id = '139483239';
[05/16/2024 08:23:39], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '76'
        , request_url = '/call.php?s=expedia&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317&db_caching=1&erequest=3&total_request=5&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F125.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=114'
        , http_hit_time = '2024-05-16 08:23:34.783'
        , request_start_time = '0.435'
        , parsing_start_time = '1.621'
        , mapping_complete_time = '0.002'
        , mongo_start_time = '0.458'
        , search_end_time = '2.234'
        , total_duration = '4.965'
        , error_description = ''
        , memory_used = '134143872'
        WHERE id = '139483247';
[05/16/2024 08:23:39], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '82'
        , request_url = '/call.php?s=expediapackage&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317&db_caching=1&erequest=4&total_request=5&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F125.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=114'
        , http_hit_time = '2024-05-16 08:23:34.791'
        , request_start_time = '0.578'
        , parsing_start_time = '1.813'
        , mapping_complete_time = '0.002'
        , mongo_start_time = '0.324'
        , search_end_time = '2.050'
        , total_duration = '5.004'
        , error_description = ''
        , memory_used = '152406456'
        WHERE id = '139483257';
[05/16/2024 08:23:40], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '36'
        , request_url = '/call.php?s=hotelspro&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317&db_caching=1&&erequest=9&total_request=24&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 08:23:34.793'
        , request_start_time = '0.147'
        , parsing_start_time = '0.816'
        , mapping_complete_time = '0.271'
        , mongo_start_time = '0.779'
        , search_end_time = '3.266'
        , total_duration = '5.222'
        , error_description = ''
        , memory_used = '78663656'
        WHERE id = '139483238';
[05/16/2024 08:23:40], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '80'
        , request_url = '/call.php?s=expedia&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317&db_caching=1&erequest=2&total_request=5&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F125.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=114'
        , http_hit_time = '2024-05-16 08:23:34.781'
        , request_start_time = '0.316'
        , parsing_start_time = '1.616'
        , mapping_complete_time = '0.004'
        , mongo_start_time = '0.614'
        , search_end_time = '2.462'
        , total_duration = '5.284'
        , error_description = ''
        , memory_used = '167625736'
        WHERE id = '139483240';
[05/16/2024 08:23:40], [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', 't1/16_05_2024/request_availability_paresh_08_23_35_1715847815_8201.xml', 't1/16_05_2024/response_availability_paresh_08_23_35_1715847815_8201.xml', 't1/16_05_2024/response_header_availability_paresh_08_23_35_1715847815_8201.xml', 'travco', '2024-05-16 08:23:40', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:40], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '28'
        , request_url = '/call.php?s=hotelspro&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317&db_caching=1&&erequest=3&total_request=24&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 08:23:34.786'
        , request_start_time = '0.023'
        , parsing_start_time = '1.294'
        , mapping_complete_time = '0.300'
        , mongo_start_time = '1.054'
        , search_end_time = '2.882'
        , total_duration = '5.412'
        , error_description = ''
        , memory_used = '80042856'
        WHERE id = '139483248';
[05/16/2024 08:23:40], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '30'
        , request_url = '/call.php?s=hotelspro&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317&db_caching=1&&erequest=2&total_request=24&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 08:23:34.777'
        , request_start_time = '0.029'
        , parsing_start_time = '1.320'
        , mapping_complete_time = '0.323'
        , mongo_start_time = '1.064'
        , search_end_time = '2.854'
        , total_duration = '5.432'
        , error_description = ''
        , memory_used = '85286024'
        WHERE id = '139483250';
[05/16/2024 08:23:40], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '31'
        , request_url = '/call.php?s=hotelspro&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317&db_caching=1&&erequest=19&total_request=24&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 08:23:34.783'
        , request_start_time = '0.063'
        , parsing_start_time = '1.352'
        , mapping_complete_time = '0.255'
        , mongo_start_time = '1.095'
        , search_end_time = '2.725'
        , total_duration = '5.498'
        , error_description = ''
        , memory_used = '78108176'
        WHERE id = '139483252';
[05/16/2024 08:23:40], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '50'
        , request_url = '/call.php?s=travco&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317&db_caching=1&wh_agent_id=&erequest=0&total_request=2&hotels_ids=&city_code=DXB&country_code=ARE&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 08:23:34.777'
        , request_start_time = '0.259'
        , parsing_start_time = '4.978'
        , mapping_complete_time = '0.078'
        , mongo_start_time = '0.113'
        , search_end_time = '0.003'
        , total_duration = '5.507'
        , error_description = ''
        , memory_used = '6654896'
        WHERE id = '139483284';
[05/16/2024 08:23:40], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '50'
        , request_url = '/call.php?s=expediapackage&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317&db_caching=1&erequest=0&total_request=5&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F125.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=114'
        , http_hit_time = '2024-05-16 08:23:34.786'
        , request_start_time = '0.239'
        , parsing_start_time = '3.127'
        , mapping_complete_time = '0.002'
        , mongo_start_time = '0.524'
        , search_end_time = '1.403'
        , total_duration = '5.513'
        , error_description = ''
        , memory_used = '66451648'
        WHERE id = '139483254';
[05/16/2024 08:23:40], [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', 't1/16_05_2024/request_availability_paresh_08_23_35_1715847815_7843.xml', 't1/16_05_2024/response_availability_paresh_08_23_35_1715847815_7843.xml', 't1/16_05_2024/response_header_availability_paresh_08_23_35_1715847815_7843.xml', 'travco', '2024-05-16 08:23:40', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:40], [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', 'd5/16_05_2024/request_availability_paresh_08_23_34_1715847814_47.json', 'd5/16_05_2024/response_availability_paresh_08_23_34_1715847814_47.json', 'd5/16_05_2024/response_header_availability_paresh_08_23_34_1715847814_47.json', 'dida14', '2024-05-16 08:23:40', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:40], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '18'
        , request_url = '/call.php?s=travco&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317&db_caching=1&wh_agent_id=&erequest=1&total_request=2&hotels_ids=&city_code=DXB&country_code=ARE&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 08:23:34.781'
        , request_start_time = '0.352'
        , parsing_start_time = '5.125'
        , mapping_complete_time = '0.033'
        , mongo_start_time = '0.055'
        , search_end_time = '0.002'
        , total_duration = '5.719'
        , error_description = ''
        , memory_used = '4237848'
        WHERE id = '139483290';
[05/16/2024 08:23:40], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '31'
        , request_url = '/call.php?s=hotelspro&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317&db_caching=1&&erequest=8&total_request=24&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 08:23:34.783'
        , request_start_time = '0.100'
        , parsing_start_time = '0.509'
        , mapping_complete_time = '0.204'
        , mongo_start_time = '1.804'
        , search_end_time = '3.234'
        , total_duration = '5.909'
        , error_description = ''
        , memory_used = '113452184'
        WHERE id = '139483199';
[05/16/2024 08:23:40], [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', 'd5/16_05_2024/request_availability_paresh_08_23_34_1715847814_24.json', 'd5/16_05_2024/response_availability_paresh_08_23_34_1715847814_24.json', 'd5/16_05_2024/response_header_availability_paresh_08_23_34_1715847814_24.json', 'dida10', '2024-05-16 08:23:40', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:40], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '198'
        , request_url = '/call.php?s=darina&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&darina_country=UAE&darina_city=DXB&darina_country_id=12&darina_city_id=49&xml_user_id=317&db_caching=1&wh_agent_id=&erequest=0&total_request=2&hotel_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 08:23:34.774'
        , request_start_time = '0.302'
        , parsing_start_time = '0.370'
        , mapping_complete_time = '0.848'
        , mongo_start_time = '1.831'
        , search_end_time = '3.220'
        , total_duration = '6.000'
        , error_description = ''
        , memory_used = '97024376'
        WHERE id = '139483200';
[05/16/2024 08:23:40], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '80'
        , request_url = '/call.php?s=expediapackage&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317&db_caching=1&erequest=2&total_request=5&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F125.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=114'
        , http_hit_time = '2024-05-16 08:23:34.780'
        , request_start_time = '0.395'
        , parsing_start_time = '3.076'
        , mapping_complete_time = '0.022'
        , mongo_start_time = '0.641'
        , search_end_time = '1.783'
        , total_duration = '6.148'
        , error_description = ''
        , memory_used = '172433376'
        WHERE id = '139483265';
[05/16/2024 08:23:40], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '13'
        , request_url = '/call.php?s=dida&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317&db_caching=1&wh_agent_id=&erequest=10&total_request=17&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 08:23:34.779'
        , request_start_time = '0.016'
        , parsing_start_time = '5.804'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.044'
        , search_end_time = '0.150'
        , total_duration = '6.182'
        , error_description = ''
        , memory_used = '22085920'
        WHERE id = '139483297';
[05/16/2024 08:23:41], [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', 'd5/16_05_2024/request_availability_paresh_08_23_35_1715847815_3.json', 'd5/16_05_2024/response_availability_paresh_08_23_35_1715847815_3.json', 'd5/16_05_2024/response_header_availability_paresh_08_23_35_1715847815_3.json', 'dida12', '2024-05-16 08:23:41', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:41], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '40'
        , request_url = '/call.php?s=dida&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317&db_caching=1&wh_agent_id=&erequest=14&total_request=17&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 08:23:34.775'
        , request_start_time = '0.025'
        , parsing_start_time = '5.630'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.126'
        , search_end_time = '0.564'
        , total_duration = '6.529'
        , error_description = ''
        , memory_used = '68966080'
        WHERE id = '139483292';
[05/16/2024 08:23:41], [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', 'd5/16_05_2024/request_availability_paresh_08_23_35_1715847815_1.json', 'd5/16_05_2024/response_availability_paresh_08_23_35_1715847815_1.json', 'd5/16_05_2024/response_header_availability_paresh_08_23_35_1715847815_1.json', 'dida11', '2024-05-16 08:23:41', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:41], [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', 'd5/16_05_2024/request_availability_paresh_08_23_35_1715847815_79.json', 'd5/16_05_2024/response_availability_paresh_08_23_35_1715847815_79.json', 'd5/16_05_2024/response_header_availability_paresh_08_23_35_1715847815_79.json', 'dida0', '2024-05-16 08:23:41', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:41], [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', 'd5/16_05_2024/request_availability_paresh_08_23_35_1715847815_12.json', 'd5/16_05_2024/response_availability_paresh_08_23_35_1715847815_12.json', 'd5/16_05_2024/response_header_availability_paresh_08_23_35_1715847815_12.json', 'dida16', '2024-05-16 08:23:41', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:41], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '37'
        , request_url = '/call.php?s=dida&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317&db_caching=1&wh_agent_id=&erequest=12&total_request=17&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 08:23:34.775'
        , request_start_time = '0.037'
        , parsing_start_time = '6.237'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.091'
        , search_end_time = '0.413'
        , total_duration = '6.986'
        , error_description = ''
        , memory_used = '57899584'
        WHERE id = '139483299';
[05/16/2024 08:23:41], [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', 'd5/16_05_2024/request_availability_paresh_08_23_35_1715847815_94.json', 'd5/16_05_2024/response_availability_paresh_08_23_35_1715847815_94.json', 'd5/16_05_2024/response_header_availability_paresh_08_23_35_1715847815_94.json', 'dida2', '2024-05-16 08:23:41', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:42], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '29'
        , request_url = '/call.php?s=dida&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317&db_caching=1&wh_agent_id=&erequest=11&total_request=17&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 08:23:34.775'
        , request_start_time = '0.043'
        , parsing_start_time = '6.363'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.144'
        , search_end_time = '0.426'
        , total_duration = '7.233'
        , error_description = ''
        , memory_used = '59300864'
        WHERE id = '139483300';
[05/16/2024 08:23:42], [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', 'd5/16_05_2024/request_availability_paresh_08_23_35_1715847815_79.json', 'd5/16_05_2024/response_availability_paresh_08_23_35_1715847815_79.json', 'd5/16_05_2024/response_header_availability_paresh_08_23_35_1715847815_79.json', 'dida7', '2024-05-16 08:23:42', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:42], [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', 'd5/16_05_2024/request_availability_paresh_08_23_35_1715847815_37.json', 'd5/16_05_2024/response_availability_paresh_08_23_35_1715847815_37.json', 'd5/16_05_2024/response_header_availability_paresh_08_23_35_1715847815_37.json', 'dida8', '2024-05-16 08:23:42', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:42], [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', 'd5/16_05_2024/request_availability_paresh_08_23_35_1715847815_2.json', 'd5/16_05_2024/response_availability_paresh_08_23_35_1715847815_2.json', 'd5/16_05_2024/response_header_availability_paresh_08_23_35_1715847815_2.json', 'dida15', '2024-05-16 08:23:42', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:42], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '23'
        , request_url = '/call.php?s=dida&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317&db_caching=1&wh_agent_id=&erequest=16&total_request=17&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 08:23:34.787'
        , request_start_time = '0.037'
        , parsing_start_time = '6.760'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.074'
        , search_end_time = '0.422'
        , total_duration = '7.515'
        , error_description = ''
        , memory_used = '44538280'
        WHERE id = '139483305';
[05/16/2024 08:23:42], [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', 'd5/16_05_2024/request_availability_paresh_08_23_35_1715847815_82.json', 'd5/16_05_2024/response_availability_paresh_08_23_35_1715847815_82.json', 'd5/16_05_2024/response_header_availability_paresh_08_23_35_1715847815_82.json', 'dida6', '2024-05-16 08:23:42', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:42], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '45'
        , request_url = '/call.php?s=dida&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317&db_caching=1&wh_agent_id=&erequest=0&total_request=17&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 08:23:34.783'
        , request_start_time = '0.053'
        , parsing_start_time = '6.640'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.141'
        , search_end_time = '0.733'
        , total_duration = '7.806'
        , error_description = ''
        , memory_used = '94492184'
        WHERE id = '139483304';
[05/16/2024 08:23:42], [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', 'd5/16_05_2024/request_availability_paresh_08_23_35_1715847815_5.json', 'd5/16_05_2024/response_availability_paresh_08_23_35_1715847815_5.json', 'd5/16_05_2024/response_header_availability_paresh_08_23_35_1715847815_5.json', 'dida1', '2024-05-16 08:23:42', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:43], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '44'
        , request_url = '/call.php?s=dida&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317&db_caching=1&wh_agent_id=&erequest=8&total_request=17&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 08:23:34.777'
        , request_start_time = '0.037'
        , parsing_start_time = '7.114'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.155'
        , search_end_time = '0.685'
        , total_duration = '8.225'
        , error_description = ''
        , memory_used = '84291152'
        WHERE id = '139483309';
[05/16/2024 08:23:43], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '48'
        , request_url = '/call.php?s=dida&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317&db_caching=1&wh_agent_id=&erequest=7&total_request=17&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 08:23:34.776'
        , request_start_time = '0.042'
        , parsing_start_time = '7.140'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.184'
        , search_end_time = '0.654'
        , total_duration = '8.288'
        , error_description = ''
        , memory_used = '97447112'
        WHERE id = '139483308';
[05/16/2024 08:23:43], [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', 'd5/16_05_2024/request_availability_paresh_08_23_35_1715847815_89.json', 'd5/16_05_2024/response_availability_paresh_08_23_35_1715847815_89.json', 'd5/16_05_2024/response_header_availability_paresh_08_23_35_1715847815_89.json', 'dida5', '2024-05-16 08:23:43', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:43], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '45'
        , request_url = '/call.php?s=dida&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317&db_caching=1&wh_agent_id=&erequest=2&total_request=17&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 08:23:34.776'
        , request_start_time = '0.032'
        , parsing_start_time = '6.902'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.195'
        , search_end_time = '1.002'
        , total_duration = '8.377'
        , error_description = ''
        , memory_used = '96996720'
        WHERE id = '139483306';
[05/16/2024 08:23:43], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '35'
        , request_url = '/call.php?s=dida&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317&db_caching=1&wh_agent_id=&erequest=15&total_request=17&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 08:23:34.785'
        , request_start_time = '0.055'
        , parsing_start_time = '7.185'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.202'
        , search_end_time = '0.800'
        , total_duration = '8.476'
        , error_description = ''
        , memory_used = '80483872'
        WHERE id = '139483310';
[05/16/2024 08:23:43], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '44'
        , request_url = '/call.php?s=dida&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317&db_caching=1&wh_agent_id=&erequest=1&total_request=17&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 08:23:34.771'
        , request_start_time = '0.057'
        , parsing_start_time = '7.658'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.119'
        , search_end_time = '0.552'
        , total_duration = '8.641'
        , error_description = ''
        , memory_used = '79919152'
        WHERE id = '139483313';
[05/16/2024 08:23:43], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '46'
        , request_url = '/call.php?s=dida&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317&db_caching=1&wh_agent_id=&erequest=6&total_request=17&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 08:23:34.776'
        , request_start_time = '0.058'
        , parsing_start_time = '7.534'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.156'
        , search_end_time = '0.919'
        , total_duration = '8.891'
        , error_description = ''
        , memory_used = '103090640'
        WHERE id = '139483311';
[05/16/2024 08:23:44], [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', 'd5/16_05_2024/request_availability_paresh_08_23_34_1715847814_37.json', 'd5/16_05_2024/response_availability_paresh_08_23_34_1715847814_37.json', 'd5/16_05_2024/response_header_availability_paresh_08_23_34_1715847814_37.json', 'dida13', '2024-05-16 08:23:44', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:44], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '48'
        , request_url = '/call.php?s=dida&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317&db_caching=1&wh_agent_id=&erequest=5&total_request=17&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 08:23:34.773'
        , request_start_time = '0.029'
        , parsing_start_time = '8.210'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.179'
        , search_end_time = '0.956'
        , total_duration = '9.633'
        , error_description = ''
        , memory_used = '114754768'
        WHERE id = '139483314';
[05/16/2024 08:23:45], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '42'
        , request_url = '/call.php?s=dida&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317&db_caching=1&wh_agent_id=&erequest=13&total_request=17&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 08:23:34.777'
        , request_start_time = '0.025'
        , parsing_start_time = '9.254'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.140'
        , search_end_time = '0.632'
        , total_duration = '10.263'
        , error_description = ''
        , memory_used = '93650544'
        WHERE id = '139483316';
[05/16/2024 08:23:45], [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', 'd5/16_05_2024/request_availability_paresh_08_23_35_1715847815_44.json', 'd5/16_05_2024/response_availability_paresh_08_23_35_1715847815_44.json', 'd5/16_05_2024/response_header_availability_paresh_08_23_35_1715847815_44.json', 'dida3', '2024-05-16 08:23:45', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:45], [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', 'd5/16_05_2024/request_availability_paresh_08_23_34_1715847814_78.json', 'd5/16_05_2024/response_availability_paresh_08_23_34_1715847814_78.json', 'd5/16_05_2024/response_header_availability_paresh_08_23_34_1715847814_78.json', 'dida4', '2024-05-16 08:23:45', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9535894');
[05/16/2024 08:23:46], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '49'
        , request_url = '/call.php?s=dida&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317&db_caching=1&wh_agent_id=&erequest=3&total_request=17&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 08:23:34.771'
        , request_start_time = '0.025'
        , parsing_start_time = '10.448'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.204'
        , search_end_time = '1.021'
        , total_duration = '12.005'
        , error_description = ''
        , memory_used = '137906104'
        WHERE id = '139483320';
[05/16/2024 08:23:47], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '48'
        , request_url = '/call.php?s=dida&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317&db_caching=1&wh_agent_id=&erequest=4&total_request=17&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 08:23:34.773'
        , request_start_time = '0.024'
        , parsing_start_time = '10.987'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.194'
        , search_end_time = '0.847'
        , total_duration = '12.269'
        , error_description = ''
        , memory_used = '128302936'
        WHERE id = '139483326';
[05/16/2024 08:24:07], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '713'
        , request_url = '/call.php?s=tripathonxml&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317&db_caching=1&web_service=no&site_id=&save_log=yes&city_code=97001&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&multicityreq=0&ws=1&original_source='
        , http_hit_time = '2024-05-16 08:23:34.786'
        , request_start_time = '0.024'
        , parsing_start_time = '3.617'
        , mapping_complete_time = '0.912'
        , mongo_start_time = '4.784'
        , search_end_time = '23.547'
        , total_duration = '32.518'
        , error_description = ''
        , memory_used = '630936352'
        WHERE id = '139483269';
[05/16/2024 08:24:07], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '2425',
        request_path = '/xml_all.php?userid=317&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02',
        duration = '35.014',
        merge_duration = '0.347',
        assigned_supplier_count = '15',
        searched_supplier_count = '10',
        system_load_1_min = '0.70',
        system_load_5_min = '1.83',
        system_load_15_min = '1.98',
        system_memory_usage = '90.69',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '9535894') + '52476392',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '9535894';
