[05/18/2024 10:00:37], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-05-18 10:00:37',login_attempt=0 where id = '1284';
[05/18/2024 10:00:37], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'qtech_agent', user_type = 'A', branch_id = '26', login_datetime = '2024-05-18 10:00:37', ip = '43.239.53.130', action = 'Login' ;
[05/18/2024 10:00:51], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '1284' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '129' , service_type = 'hotel' , arrival_date = '2024/05/30' , departure_date = '2024/05/31' , nights = '1' , nationality = '129' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-05-18 10:00:51' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'INR' , currency_code = 'INR' , web_service = '0' ;
[05/18/2024 10:00:53], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/18_05_2024/request_availability_qtech_agent_10_00_52_1716026452_11.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_00_52_1716026452_11.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_00_52_1716026452_11.xml', 'agoda', '2024-05-18 10:00:53', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9671722');
[05/18/2024 10:00:53], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/18_05_2024/request_availability_qtech_agent_10_00_52_1716026452_8.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_00_52_1716026452_8.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_00_52_1716026452_8.xml', 'agoda', '2024-05-18 10:00:53', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9671722');
[05/18/2024 10:00:53], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '6'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=11&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:00:52.651'
        , request_start_time = '0.028'
        , parsing_start_time = '0.309'
        , mapping_complete_time = '0.023'
        , mongo_start_time = '0.033'
        , search_end_time = '0.025'
        , total_duration = '0.478'
        , error_description = ''
        , memory_used = '5281896'
        WHERE id = '139953907';
[05/18/2024 10:00:53], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '4'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=8&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:00:52.650'
        , request_start_time = '0.033'
        , parsing_start_time = '0.318'
        , mapping_complete_time = '0.025'
        , mongo_start_time = '0.036'
        , search_end_time = '0.021'
        , total_duration = '0.501'
        , error_description = ''
        , memory_used = '5739904'
        WHERE id = '139953908';
[05/18/2024 10:00:53], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'd3/18_05_2024/request_availability_qtech_agent_10_00_52_1716026452_49_4.xml', 'd3/18_05_2024/response_availability_qtech_agent_10_00_52_1716026452_49_4.xml', 'd3/18_05_2024/response_header_availability_qtech_agent_10_00_52_1716026452_49_4.xml', 'darina', '2024-05-18 10:00:53', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9671722');
[05/18/2024 10:00:53], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/18_05_2024/request_availability_qtech_agent_10_00_52_1716026452_9.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_00_52_1716026452_9.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_00_52_1716026452_9.xml', 'agoda', '2024-05-18 10:00:53', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9671722');
[05/18/2024 10:00:53], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/18_05_2024/request_availability_qtech_agent_10_00_52_1716026452_10.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_00_52_1716026452_10.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_00_52_1716026452_10.xml', 'agoda', '2024-05-18 10:00:53', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9671722');
[05/18/2024 10:00:53], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '8'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=9&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:00:52.649'
        , request_start_time = '0.036'
        , parsing_start_time = '0.408'
        , mapping_complete_time = '0.040'
        , mongo_start_time = '0.055'
        , search_end_time = '0.025'
        , total_duration = '0.597'
        , error_description = ''
        , memory_used = '7890696'
        WHERE id = '139953910';
[05/18/2024 10:00:53], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/18_05_2024/request_availability_qtech_agent_10_00_52_1716026452_29.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_00_52_1716026452_29.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_00_52_1716026452_29.xml', 'agoda', '2024-05-18 10:00:53', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9671722');
[05/18/2024 10:00:53], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/18_05_2024/request_availability_qtech_agent_10_00_52_1716026452_15.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_00_52_1716026452_15.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_00_52_1716026452_15.xml', 'agoda', '2024-05-18 10:00:53', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9671722');
[05/18/2024 10:00:53], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/18_05_2024/request_availability_qtech_agent_10_00_52_1716026452_16.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_00_52_1716026452_16.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_00_52_1716026452_16.xml', 'agoda', '2024-05-18 10:00:53', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9671722');
[05/18/2024 10:00:53], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/18_05_2024/request_availability_qtech_agent_10_00_52_1716026452_28.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_00_52_1716026452_28.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_00_52_1716026452_28.xml', 'agoda', '2024-05-18 10:00:53', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9671722');
[05/18/2024 10:00:53], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '8'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=10&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:00:52.644'
        , request_start_time = '0.026'
        , parsing_start_time = '0.412'
        , mapping_complete_time = '0.053'
        , mongo_start_time = '0.068'
        , search_end_time = '0.028'
        , total_duration = '0.648'
        , error_description = ''
        , memory_used = '7164816'
        WHERE id = '139953911';
[05/18/2024 10:00:53], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/18_05_2024/request_availability_qtech_agent_10_00_52_1716026452_14.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_00_52_1716026452_14.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_00_52_1716026452_14.xml', 'agoda', '2024-05-18 10:00:53', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9671722');
[05/18/2024 10:00:53], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '10'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=29&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:00:52.651'
        , request_start_time = '0.030'
        , parsing_start_time = '0.431'
        , mapping_complete_time = '0.061'
        , mongo_start_time = '0.083'
        , search_end_time = '0.029'
        , total_duration = '0.666'
        , error_description = ''
        , memory_used = '8040352'
        WHERE id = '139953912';
[05/18/2024 10:00:53], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/18_05_2024/request_availability_qtech_agent_10_00_52_1716026452_12.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_00_52_1716026452_12.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_00_52_1716026452_12.xml', 'agoda', '2024-05-18 10:00:53', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9671722');
[05/18/2024 10:00:53], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/18_05_2024/request_availability_qtech_agent_10_00_52_1716026452_13.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_00_52_1716026452_13.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_00_52_1716026452_13.xml', 'agoda', '2024-05-18 10:00:53', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9671722');
[05/18/2024 10:00:53], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '11'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=16&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:00:52.650'
        , request_start_time = '0.025'
        , parsing_start_time = '0.462'
        , mapping_complete_time = '0.040'
        , mongo_start_time = '0.058'
        , search_end_time = '0.031'
        , total_duration = '0.676'
        , error_description = ''
        , memory_used = '7212352'
        WHERE id = '139953914';
[05/18/2024 10:00:53], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '8'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=28&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:00:52.650'
        , request_start_time = '0.018'
        , parsing_start_time = '0.461'
        , mapping_complete_time = '0.046'
        , mongo_start_time = '0.065'
        , search_end_time = '0.029'
        , total_duration = '0.692'
        , error_description = ''
        , memory_used = '8414128'
        WHERE id = '139953915';
[05/18/2024 10:00:53], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '14'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=15&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:00:52.642'
        , request_start_time = '0.043'
        , parsing_start_time = '0.478'
        , mapping_complete_time = '0.043'
        , mongo_start_time = '0.061'
        , search_end_time = '0.052'
        , total_duration = '0.706'
        , error_description = ''
        , memory_used = '7698312'
        WHERE id = '139953913';
[05/18/2024 10:00:53], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/18_05_2024/request_availability_qtech_agent_10_00_52_1716026452_23.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_00_52_1716026452_23.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_00_52_1716026452_23.xml', 'agoda', '2024-05-18 10:00:53', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9671722');
[05/18/2024 10:00:53], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '12'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=14&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:00:52.650'
        , request_start_time = '0.023'
        , parsing_start_time = '0.496'
        , mapping_complete_time = '0.050'
        , mongo_start_time = '0.072'
        , search_end_time = '0.030'
        , total_duration = '0.721'
        , error_description = ''
        , memory_used = '7831136'
        WHERE id = '139953916';
[05/18/2024 10:00:53], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/18_05_2024/request_availability_qtech_agent_10_00_52_1716026452_17.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_00_52_1716026452_17.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_00_52_1716026452_17.xml', 'agoda', '2024-05-18 10:00:53', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9671722');
[05/18/2024 10:00:53], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/18_05_2024/request_availability_qtech_agent_10_00_52_1716026452_27.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_00_52_1716026452_27.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_00_52_1716026452_27.xml', 'agoda', '2024-05-18 10:00:53', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9671722');
[05/18/2024 10:00:53], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '9'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=12&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:00:52.641'
        , request_start_time = '0.062'
        , parsing_start_time = '0.469'
        , mapping_complete_time = '0.055'
        , mongo_start_time = '0.072'
        , search_end_time = '0.036'
        , total_duration = '0.745'
        , error_description = ''
        , memory_used = '7799424'
        WHERE id = '139953917';
[05/18/2024 10:00:53], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/18_05_2024/request_availability_qtech_agent_10_00_52_1716026452_19.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_00_52_1716026452_19.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_00_52_1716026452_19.xml', 'agoda', '2024-05-18 10:00:53', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9671722');
[05/18/2024 10:00:53], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/18_05_2024/request_availability_qtech_agent_10_00_52_1716026452_6.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_00_52_1716026452_6.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_00_52_1716026452_6.xml', 'agoda', '2024-05-18 10:00:53', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9671722');
[05/18/2024 10:00:53], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '14'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=13&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:00:52.636'
        , request_start_time = '0.028'
        , parsing_start_time = '0.526'
        , mapping_complete_time = '0.057'
        , mongo_start_time = '0.080'
        , search_end_time = '0.062'
        , total_duration = '0.788'
        , error_description = ''
        , memory_used = '9140280'
        WHERE id = '139953918';
[05/18/2024 10:00:53], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/18_05_2024/request_availability_qtech_agent_10_00_52_1716026452_20.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_00_52_1716026452_20.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_00_52_1716026452_20.xml', 'agoda', '2024-05-18 10:00:53', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9671722');
[05/18/2024 10:00:53], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/18_05_2024/request_availability_qtech_agent_10_00_52_1716026452_33.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_00_52_1716026452_33.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_00_52_1716026452_33.xml', 'agoda', '2024-05-18 10:00:53', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9671722');
[05/18/2024 10:00:53], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/18_05_2024/request_availability_qtech_agent_10_00_52_1716026452_25.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_00_52_1716026452_25.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_00_52_1716026452_25.xml', 'agoda', '2024-05-18 10:00:53', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9671722');
[05/18/2024 10:00:53], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '13'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=23&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:00:52.651'
        , request_start_time = '0.033'
        , parsing_start_time = '0.502'
        , mapping_complete_time = '0.077'
        , mongo_start_time = '0.108'
        , search_end_time = '0.044'
        , total_duration = '0.795'
        , error_description = ''
        , memory_used = '9059928'
        WHERE id = '139953919';
[05/18/2024 10:00:53], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/18_05_2024/request_availability_qtech_agent_10_00_52_1716026452_30.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_00_52_1716026452_30.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_00_52_1716026452_30.xml', 'agoda', '2024-05-18 10:00:53', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9671722');
[05/18/2024 10:00:53], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '14'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=27&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:00:52.650'
        , request_start_time = '0.032'
        , parsing_start_time = '0.510'
        , mapping_complete_time = '0.091'
        , mongo_start_time = '0.121'
        , search_end_time = '0.041'
        , total_duration = '0.807'
        , error_description = ''
        , memory_used = '10296520'
        WHERE id = '139953921';
[05/18/2024 10:00:53], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/18_05_2024/request_availability_qtech_agent_10_00_52_1716026452_5.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_00_52_1716026452_5.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_00_52_1716026452_5.xml', 'agoda', '2024-05-18 10:00:53', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9671722');
[05/18/2024 10:00:53], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '11'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=17&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:00:52.642'
        , request_start_time = '0.049'
        , parsing_start_time = '0.534'
        , mapping_complete_time = '0.089'
        , mongo_start_time = '0.129'
        , search_end_time = '0.061'
        , total_duration = '0.845'
        , error_description = ''
        , memory_used = '9514672'
        WHERE id = '139953920';
[05/18/2024 10:00:53], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/18_05_2024/request_availability_qtech_agent_10_00_52_1716026452_24.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_00_52_1716026452_24.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_00_52_1716026452_24.xml', 'agoda', '2024-05-18 10:00:53', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9671722');
[05/18/2024 10:00:53], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/18_05_2024/request_availability_qtech_agent_10_00_52_1716026452_26.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_00_52_1716026452_26.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_00_52_1716026452_26.xml', 'agoda', '2024-05-18 10:00:53', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9671722');
[05/18/2024 10:00:53], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/18_05_2024/request_availability_qtech_agent_10_00_52_1716026452_7.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_00_52_1716026452_7.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_00_52_1716026452_7.xml', 'agoda', '2024-05-18 10:00:53', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9671722');
[05/18/2024 10:00:53], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/18_05_2024/request_availability_qtech_agent_10_00_52_1716026452_32.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_00_52_1716026452_32.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_00_52_1716026452_32.xml', 'agoda', '2024-05-18 10:00:53', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9671722');
[05/18/2024 10:00:53], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '16'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=6&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:00:52.650'
        , request_start_time = '0.045'
        , parsing_start_time = '0.558'
        , mapping_complete_time = '0.092'
        , mongo_start_time = '0.118'
        , search_end_time = '0.050'
        , total_duration = '0.860'
        , error_description = ''
        , memory_used = '9772112'
        WHERE id = '139953923';
[05/18/2024 10:00:53], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/18_05_2024/request_availability_qtech_agent_10_00_52_1716026452_31.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_00_52_1716026452_31.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_00_52_1716026452_31.xml', 'agoda', '2024-05-18 10:00:53', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9671722');
[05/18/2024 10:00:53], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '18'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=25&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:00:52.649'
        , request_start_time = '0.037'
        , parsing_start_time = '0.571'
        , mapping_complete_time = '0.110'
        , mongo_start_time = '0.146'
        , search_end_time = '0.040'
        , total_duration = '0.882'
        , error_description = ''
        , memory_used = '11476136'
        WHERE id = '139953926';
[05/18/2024 10:00:53], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '20'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=33&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:00:52.636'
        , request_start_time = '0.024'
        , parsing_start_time = '0.616'
        , mapping_complete_time = '0.075'
        , mongo_start_time = '0.113'
        , search_end_time = '0.052'
        , total_duration = '0.902'
        , error_description = ''
        , memory_used = '11359040'
        WHERE id = '139953925';
[05/18/2024 10:00:53], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '34'
        , 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=1284&db_caching=1&wh_agent_id=&erequest=4&total_request=5&hotel_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:00:52.642'
        , request_start_time = '0.147'
        , parsing_start_time = '0.263'
        , mapping_complete_time = '0.063'
        , mongo_start_time = '0.165'
        , search_end_time = '0.229'
        , total_duration = '0.908'
        , error_description = ''
        , memory_used = '14243192'
        WHERE id = '139953909';
[05/18/2024 10:00:53], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'd3/18_05_2024/request_availability_qtech_agent_10_00_52_1716026452_49_0.xml', 'd3/18_05_2024/response_availability_qtech_agent_10_00_52_1716026452_49_0.xml', 'd3/18_05_2024/response_header_availability_qtech_agent_10_00_52_1716026452_49_0.xml', 'darina', '2024-05-18 10:00:53', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9671722');
[05/18/2024 10:00:53], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '24'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=19&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:00:52.642'
        , request_start_time = '0.030'
        , parsing_start_time = '0.519'
        , mapping_complete_time = '0.141'
        , mongo_start_time = '0.182'
        , search_end_time = '0.077'
        , total_duration = '0.915'
        , error_description = ''
        , memory_used = '11097512'
        WHERE id = '139953922';
[05/18/2024 10:00:53], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '23'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=20&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:00:52.642'
        , request_start_time = '0.042'
        , parsing_start_time = '0.570'
        , mapping_complete_time = '0.117'
        , mongo_start_time = '0.179'
        , search_end_time = '0.050'
        , total_duration = '0.920'
        , error_description = ''
        , memory_used = '11324000'
        WHERE id = '139953924';
[05/18/2024 10:00:53], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/18_05_2024/request_availability_qtech_agent_10_00_52_1716026452_22.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_00_52_1716026452_22.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_00_52_1716026452_22.xml', 'agoda', '2024-05-18 10:00:53', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9671722');
[05/18/2024 10:00:53], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '18'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=30&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:00:52.651'
        , request_start_time = '0.041'
        , parsing_start_time = '0.599'
        , mapping_complete_time = '0.105'
        , mongo_start_time = '0.154'
        , search_end_time = '0.060'
        , total_duration = '0.933'
        , error_description = ''
        , memory_used = '12392984'
        WHERE id = '139953927';
[05/18/2024 10:00:53], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/18_05_2024/request_availability_qtech_agent_10_00_52_1716026452_1.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_00_52_1716026452_1.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_00_52_1716026452_1.xml', 'agoda', '2024-05-18 10:00:53', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9671722');
[05/18/2024 10:00:53], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '24'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=5&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:00:52.641'
        , request_start_time = '0.044'
        , parsing_start_time = '0.624'
        , mapping_complete_time = '0.113'
        , mongo_start_time = '0.150'
        , search_end_time = '0.053'
        , total_duration = '0.944'
        , error_description = ''
        , memory_used = '10523576'
        WHERE id = '139953928';
[05/18/2024 10:00:53], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/18_05_2024/request_availability_qtech_agent_10_00_52_1716026452_0.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_00_52_1716026452_0.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_00_52_1716026452_0.xml', 'agoda', '2024-05-18 10:00:53', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9671722');
[05/18/2024 10:00:53], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/18_05_2024/request_availability_qtech_agent_10_00_52_1716026452_21.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_00_52_1716026452_21.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_00_52_1716026452_21.xml', 'agoda', '2024-05-18 10:00:53', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9671722');
[05/18/2024 10:00:53], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '18'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=7&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:00:52.642'
        , request_start_time = '0.037'
        , parsing_start_time = '0.598'
        , mapping_complete_time = '0.147'
        , mongo_start_time = '0.179'
        , search_end_time = '0.036'
        , total_duration = '0.952'
        , error_description = ''
        , memory_used = '11685400'
        WHERE id = '139953932';
[05/18/2024 10:00:53], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/18_05_2024/request_availability_qtech_agent_10_00_52_1716026452_34.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_00_52_1716026452_34.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_00_52_1716026452_34.xml', 'agoda', '2024-05-18 10:00:53', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9671722');
[05/18/2024 10:00:53], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '17'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=26&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:00:52.650'
        , request_start_time = '0.041'
        , parsing_start_time = '0.609'
        , mapping_complete_time = '0.121'
        , mongo_start_time = '0.162'
        , search_end_time = '0.044'
        , total_duration = '0.956'
        , error_description = ''
        , memory_used = '11580008'
        WHERE id = '139953930';
[05/18/2024 10:00:53], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '21'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=31&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:00:52.651'
        , request_start_time = '0.024'
        , parsing_start_time = '0.616'
        , mapping_complete_time = '0.142'
        , mongo_start_time = '0.191'
        , search_end_time = '0.034'
        , total_duration = '0.964'
        , error_description = ''
        , memory_used = '14354984'
        WHERE id = '139953933';
[05/18/2024 10:00:53], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/18_05_2024/request_availability_qtech_agent_10_00_52_1716026452_18.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_00_52_1716026452_18.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_00_52_1716026452_18.xml', 'agoda', '2024-05-18 10:00:53', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9671722');
[05/18/2024 10:00:53], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/18_05_2024/request_availability_qtech_agent_10_00_52_1716026452_3.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_00_52_1716026452_3.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_00_52_1716026452_3.xml', 'agoda', '2024-05-18 10:00:53', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9671722');
[05/18/2024 10:00:53], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '22'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=32&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:00:52.643'
        , request_start_time = '0.037'
        , parsing_start_time = '0.618'
        , mapping_complete_time = '0.163'
        , mongo_start_time = '0.207'
        , search_end_time = '0.046'
        , total_duration = '0.982'
        , error_description = ''
        , memory_used = '13323456'
        WHERE id = '139953931';
[05/18/2024 10:00:53], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '15'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=24&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:00:52.643'
        , request_start_time = '0.035'
        , parsing_start_time = '0.599'
        , mapping_complete_time = '0.132'
        , mongo_start_time = '0.216'
        , search_end_time = '0.036'
        , total_duration = '0.994'
        , error_description = ''
        , memory_used = '11167392'
        WHERE id = '139953929';
[05/18/2024 10:00:53], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/18_05_2024/request_availability_qtech_agent_10_00_52_1716026452_4.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_00_52_1716026452_4.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_00_52_1716026452_4.xml', 'agoda', '2024-05-18 10:00:53', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9671722');
[05/18/2024 10:00:53], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '24'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=21&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:00:52.644'
        , request_start_time = '0.031'
        , parsing_start_time = '0.711'
        , mapping_complete_time = '0.110'
        , mongo_start_time = '0.142'
        , search_end_time = '0.031'
        , total_duration = '1.024'
        , error_description = ''
        , memory_used = '12054288'
        WHERE id = '139953938';
[05/18/2024 10:00:53], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '24'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=22&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:00:52.651'
        , request_start_time = '0.046'
        , parsing_start_time = '0.641'
        , mapping_complete_time = '0.152'
        , mongo_start_time = '0.192'
        , search_end_time = '0.040'
        , total_duration = '1.027'
        , error_description = ''
        , memory_used = '13218256'
        WHERE id = '139953935';
[05/18/2024 10:00:53], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '22'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=34&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:00:52.651'
        , request_start_time = '0.045'
        , parsing_start_time = '0.739'
        , mapping_complete_time = '0.104'
        , mongo_start_time = '0.136'
        , search_end_time = '0.042'
        , total_duration = '1.036'
        , error_description = ''
        , memory_used = '13440912'
        WHERE id = '139953939';
[05/18/2024 10:00:53], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '23'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=0&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:00:52.651'
        , request_start_time = '0.029'
        , parsing_start_time = '0.692'
        , mapping_complete_time = '0.139'
        , mongo_start_time = '0.174'
        , search_end_time = '0.052'
        , total_duration = '1.043'
        , error_description = ''
        , memory_used = '14400432'
        WHERE id = '139953937';
[05/18/2024 10:00:53], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '24'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=1&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:00:52.642'
        , request_start_time = '0.027'
        , parsing_start_time = '0.683'
        , mapping_complete_time = '0.147'
        , mongo_start_time = '0.184'
        , search_end_time = '0.054'
        , total_duration = '1.053'
        , error_description = ''
        , memory_used = '14745600'
        WHERE id = '139953936';
[05/18/2024 10:00:53], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '19'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=3&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:00:52.650'
        , request_start_time = '0.028'
        , parsing_start_time = '0.731'
        , mapping_complete_time = '0.131'
        , mongo_start_time = '0.161'
        , search_end_time = '0.038'
        , total_duration = '1.053'
        , error_description = ''
        , memory_used = '12508072'
        WHERE id = '139953941';
[05/18/2024 10:00:53], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '16'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=18&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:00:52.649'
        , request_start_time = '0.027'
        , parsing_start_time = '0.760'
        , mapping_complete_time = '0.101'
        , mongo_start_time = '0.129'
        , search_end_time = '0.042'
        , total_duration = '1.055'
        , error_description = ''
        , memory_used = '11137296'
        WHERE id = '139953940';
[05/18/2024 10:00:53], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '24'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=4&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:00:52.642'
        , request_start_time = '0.044'
        , parsing_start_time = '0.797'
        , mapping_complete_time = '0.111'
        , mongo_start_time = '0.141'
        , search_end_time = '0.034'
        , total_duration = '1.088'
        , error_description = ''
        , memory_used = '12573616'
        WHERE id = '139953942';
[05/18/2024 10:00:53], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/18_05_2024/request_availability_qtech_agent_10_00_52_1716026452_2.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_00_52_1716026452_2.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_00_52_1716026452_2.xml', 'agoda', '2024-05-18 10:00:53', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9671722');
[05/18/2024 10:00:53], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'd3/18_05_2024/request_availability_qtech_agent_10_00_52_1716026452_49_1.xml', 'd3/18_05_2024/response_availability_qtech_agent_10_00_52_1716026452_49_1.xml', 'd3/18_05_2024/response_header_availability_qtech_agent_10_00_52_1716026452_49_1.xml', 'darina', '2024-05-18 10:00:53', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9671722');
[05/18/2024 10:00:53], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '26'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=2&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:00:52.641'
        , request_start_time = '0.026'
        , parsing_start_time = '0.909'
        , mapping_complete_time = '0.103'
        , mongo_start_time = '0.134'
        , search_end_time = '0.033'
        , total_duration = '1.207'
        , error_description = ''
        , memory_used = '13779008'
        WHERE id = '139953943';
[05/18/2024 10:00:54], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '87'
        , 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=1284&db_caching=1&wh_agent_id=&erequest=0&total_request=5&hotel_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:00:52.636'
        , request_start_time = '0.146'
        , parsing_start_time = '0.693'
        , mapping_complete_time = '0.157'
        , mongo_start_time = '0.379'
        , search_end_time = '0.174'
        , total_duration = '1.479'
        , error_description = ''
        , memory_used = '27082520'
        WHERE id = '139953934';
[05/18/2024 10:00:54], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '65'
        , 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=1284&db_caching=1&wh_agent_id=&erequest=1&total_request=5&hotel_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:00:52.641'
        , request_start_time = '0.145'
        , parsing_start_time = '0.957'
        , mapping_complete_time = '0.067'
        , mongo_start_time = '0.189'
        , search_end_time = '0.112'
        , total_duration = '1.482'
        , error_description = ''
        , memory_used = '16751800'
        WHERE id = '139953944';
[05/18/2024 10:00:54], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'd3/18_05_2024/request_availability_qtech_agent_10_00_52_1716026452_49_3.xml', 'd3/18_05_2024/response_availability_qtech_agent_10_00_52_1716026452_49_3.xml', 'd3/18_05_2024/response_header_availability_qtech_agent_10_00_52_1716026452_49_3.xml', 'darina', '2024-05-18 10:00:54', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9671722');
[05/18/2024 10:00:54], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'd3/18_05_2024/request_availability_qtech_agent_10_00_52_1716026452_49_2.xml', 'd3/18_05_2024/response_availability_qtech_agent_10_00_52_1716026452_49_2.xml', 'd3/18_05_2024/response_header_availability_qtech_agent_10_00_52_1716026452_49_2.xml', 'darina', '2024-05-18 10:00:54', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9671722');
[05/18/2024 10:00:54], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '73'
        , 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=1284&db_caching=1&wh_agent_id=&erequest=3&total_request=5&hotel_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:00:52.641'
        , request_start_time = '0.141'
        , parsing_start_time = '1.422'
        , mapping_complete_time = '0.093'
        , mongo_start_time = '0.261'
        , search_end_time = '0.138'
        , total_duration = '2.069'
        , error_description = ''
        , memory_used = '21634008'
        WHERE id = '139953945';
[05/18/2024 10:00:55], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '88'
        , 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=1284&db_caching=1&wh_agent_id=&erequest=2&total_request=5&hotel_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:00:52.642'
        , request_start_time = '0.146'
        , parsing_start_time = '1.527'
        , mapping_complete_time = '0.138'
        , mongo_start_time = '0.418'
        , search_end_time = '0.188'
        , total_duration = '2.373'
        , error_description = ''
        , memory_used = '32014768'
        WHERE id = '139953946';
[05/18/2024 10:00:55], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '631',
        request_path = '/xml_all.php?userid=1284&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02',
        duration = '2.917',
        merge_duration = '0.160',
        assigned_supplier_count = '2',
        searched_supplier_count = '2',
        system_load_1_min = '0.68',
        system_load_5_min = '0.59',
        system_load_15_min = '0.97',
        system_memory_usage = '90.40',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '9671722') + '23470480',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '9671722';
[05/18/2024 10:07:03], [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/18_05_2024/request_availability_qtech_agent_10_07_02_1716026822_0.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_07_02_1716026822_0.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_07_02_1716026822_0.xml', 'agoda', '2024-05-18 10:07:03', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9671722');
[05/18/2024 10:07:03], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '1'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=0&total_request=1&hotels_ids=[%22295506%22]&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:07:02.698'
        , request_start_time = '0.067'
        , parsing_start_time = '0.249'
        , mapping_complete_time = '0.022'
        , mongo_start_time = '0.029'
        , search_end_time = '0.000'
        , total_duration = '0.469'
        , error_description = ''
        , memory_used = '4164160'
        WHERE id = '139956422';
[05/18/2024 10:13:00], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/18_05_2024/request_availability_qtech_agent_10_12_59_1716027179_0.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_12_59_1716027179_0.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_12_59_1716027179_0.xml', 'agoda', '2024-05-18 10:13:00', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9671722');
[05/18/2024 10:13:00], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '1'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=0&total_request=1&hotels_ids=[%22295506%22]&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:12:59.804'
        , request_start_time = '0.013'
        , parsing_start_time = '0.266'
        , mapping_complete_time = '0.021'
        , mongo_start_time = '0.029'
        , search_end_time = '0.000'
        , total_duration = '0.364'
        , error_description = ''
        , memory_used = '4168112'
        WHERE id = '139960220';
[05/18/2024 10:14: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', 'a5/18_05_2024/request_availability_qtech_agent_10_14_44_1716027284_0.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_14_44_1716027284_0.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_14_44_1716027284_0.xml', 'agoda', '2024-05-18 10:14:44', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9671722');
[05/18/2024 10:14:44], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '1'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=0&total_request=1&hotels_ids=[%22295506%22]&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:14:43.953'
        , request_start_time = '0.014'
        , parsing_start_time = '0.286'
        , mapping_complete_time = '0.020'
        , mongo_start_time = '0.028'
        , search_end_time = '0.028'
        , total_duration = '0.456'
        , error_description = ''
        , memory_used = '4370528'
        WHERE id = '139960741';
[05/18/2024 10:15:56], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/18_05_2024/request_availability_qtech_agent_10_15_55_1716027355_0.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_15_55_1716027355_0.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_15_55_1716027355_0.xml', 'agoda', '2024-05-18 10:15:56', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9671722');
[05/18/2024 10:15:56], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '1'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=0&total_request=1&hotels_ids=[%22295506%22]&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:15:55.742'
        , request_start_time = '0.014'
        , parsing_start_time = '0.238'
        , mapping_complete_time = '0.027'
        , mongo_start_time = '0.035'
        , search_end_time = '0.000'
        , total_duration = '0.382'
        , error_description = ''
        , memory_used = '4193576'
        WHERE id = '139961143';
[05/18/2024 10:18:08], [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/18_05_2024/request_availability_qtech_agent_10_18_08_1716027488_0.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_18_08_1716027488_0.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_18_08_1716027488_0.xml', 'agoda', '2024-05-18 10:18:08', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9671722');
[05/18/2024 10:18:08], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '1'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=0&total_request=1&hotels_ids=[%22295506%22]&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:18:08.218'
        , request_start_time = '0.027'
        , parsing_start_time = '0.248'
        , mapping_complete_time = '0.027'
        , mongo_start_time = '0.035'
        , search_end_time = '0.029'
        , total_duration = '0.437'
        , error_description = ''
        , memory_used = '4788960'
        WHERE id = '139962502';
[05/18/2024 10:20:15], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '1284' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '129' , service_type = 'hotel' , arrival_date = '2024/05/30' , departure_date = '2024/05/31' , nights = '1' , nationality = '129' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-05-18 10:20:15' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'INR' , currency_code = 'INR' , web_service = '0' ;
[05/18/2024 10:20:16], [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/18_05_2024/request_availability_qtech_agent_10_20_16_1716027616_49_1.xml', 'd3/18_05_2024/response_availability_qtech_agent_10_20_16_1716027616_49_1.xml', 'd3/18_05_2024/response_header_availability_qtech_agent_10_20_16_1716027616_49_1.xml', 'darina', '2024-05-18 10:20:16', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674381');
[05/18/2024 10:20:16], [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/18_05_2024/request_availability_qtech_agent_10_20_16_1716027616_11.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_20_16_1716027616_11.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_20_16_1716027616_11.xml', 'agoda', '2024-05-18 10:20:16', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674381');
[05/18/2024 10:20:17], [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/18_05_2024/request_availability_qtech_agent_10_20_16_1716027616_8.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_20_16_1716027616_8.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_20_16_1716027616_8.xml', 'agoda', '2024-05-18 10:20:17', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674381');
[05/18/2024 10:20:17], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '6'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=11&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:20:16.499'
        , request_start_time = '0.028'
        , parsing_start_time = '0.347'
        , mapping_complete_time = '0.035'
        , mongo_start_time = '0.045'
        , search_end_time = '0.055'
        , total_duration = '0.562'
        , error_description = ''
        , memory_used = '5589768'
        WHERE id = '139963284';
[05/18/2024 10:20:17], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '5'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=8&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:20:16.499'
        , request_start_time = '0.021'
        , parsing_start_time = '0.445'
        , mapping_complete_time = '0.028'
        , mongo_start_time = '0.039'
        , search_end_time = '0.022'
        , total_duration = '0.602'
        , error_description = ''
        , memory_used = '6288384'
        WHERE id = '139963285';
[05/18/2024 10:20:17], [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/18_05_2024/request_availability_qtech_agent_10_20_16_1716027616_15.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_20_16_1716027616_15.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_20_16_1716027616_15.xml', 'agoda', '2024-05-18 10:20:17', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674381');
[05/18/2024 10:20:17], [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/18_05_2024/request_availability_qtech_agent_10_20_16_1716027616_9.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_20_16_1716027616_9.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_20_16_1716027616_9.xml', 'agoda', '2024-05-18 10:20:17', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674381');
[05/18/2024 10:20:17], [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/18_05_2024/request_availability_qtech_agent_10_20_16_1716027616_49_2.xml', 'd3/18_05_2024/response_availability_qtech_agent_10_20_16_1716027616_49_2.xml', 'd3/18_05_2024/response_header_availability_qtech_agent_10_20_16_1716027616_49_2.xml', 'darina', '2024-05-18 10:20:17', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674381');
[05/18/2024 10:20:17], [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/18_05_2024/request_availability_qtech_agent_10_20_16_1716027616_28.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_20_16_1716027616_28.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_20_16_1716027616_28.xml', 'agoda', '2024-05-18 10:20:17', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674381');
[05/18/2024 10:20:17], [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/18_05_2024/request_availability_qtech_agent_10_20_16_1716027616_29.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_20_16_1716027616_29.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_20_16_1716027616_29.xml', 'agoda', '2024-05-18 10:20:17', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674381');
[05/18/2024 10:20:17], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '14'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=15&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:20:16.507'
        , request_start_time = '0.019'
        , parsing_start_time = '0.485'
        , mapping_complete_time = '0.041'
        , mongo_start_time = '0.061'
        , search_end_time = '0.027'
        , total_duration = '0.689'
        , error_description = ''
        , memory_used = '7996624'
        WHERE id = '139963286';
[05/18/2024 10:20:17], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '8'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=9&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:20:16.499'
        , request_start_time = '0.021'
        , parsing_start_time = '0.473'
        , mapping_complete_time = '0.049'
        , mongo_start_time = '0.065'
        , search_end_time = '0.029'
        , total_duration = '0.709'
        , error_description = ''
        , memory_used = '8339016'
        WHERE id = '139963287';
[05/18/2024 10:20:17], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '8'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=28&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:20:16.501'
        , request_start_time = '0.023'
        , parsing_start_time = '0.511'
        , mapping_complete_time = '0.076'
        , mongo_start_time = '0.093'
        , search_end_time = '0.029'
        , total_duration = '0.743'
        , error_description = ''
        , memory_used = '8734288'
        WHERE id = '139963289';
[05/18/2024 10:20:17], [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/18_05_2024/request_availability_qtech_agent_10_20_16_1716027616_12.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_20_16_1716027616_12.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_20_16_1716027616_12.xml', 'agoda', '2024-05-18 10:20:17', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674381');
[05/18/2024 10:20:17], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '10'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=29&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:20:16.501'
        , request_start_time = '0.035'
        , parsing_start_time = '0.475'
        , mapping_complete_time = '0.079'
        , mongo_start_time = '0.101'
        , search_end_time = '0.029'
        , total_duration = '0.756'
        , error_description = ''
        , memory_used = '8355752'
        WHERE id = '139963290';
[05/18/2024 10:20:17], [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/18_05_2024/request_availability_qtech_agent_10_20_16_1716027616_23.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_20_16_1716027616_23.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_20_16_1716027616_23.xml', 'agoda', '2024-05-18 10:20:17', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674381');
[05/18/2024 10:20:17], [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/18_05_2024/request_availability_qtech_agent_10_20_16_1716027616_14.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_20_16_1716027616_14.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_20_16_1716027616_14.xml', 'agoda', '2024-05-18 10:20:17', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674381');
[05/18/2024 10:20:17], [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/18_05_2024/request_availability_qtech_agent_10_20_16_1716027616_10.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_20_16_1716027616_10.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_20_16_1716027616_10.xml', 'agoda', '2024-05-18 10:20:17', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674381');
[05/18/2024 10:20:17], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '65'
        , 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=1284&db_caching=1&wh_agent_id=&erequest=1&total_request=5&hotel_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:20:16.501'
        , request_start_time = '0.134'
        , parsing_start_time = '0.203'
        , mapping_complete_time = '0.069'
        , mongo_start_time = '0.189'
        , search_end_time = '0.142'
        , total_duration = '0.779'
        , error_description = ''
        , memory_used = '17066824'
        WHERE id = '139963283';
[05/18/2024 10:20:17], [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/18_05_2024/request_availability_qtech_agent_10_20_16_1716027616_16.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_20_16_1716027616_16.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_20_16_1716027616_16.xml', 'agoda', '2024-05-18 10:20:17', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674381');
[05/18/2024 10:20:17], [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/18_05_2024/request_availability_qtech_agent_10_20_16_1716027616_17.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_20_16_1716027616_17.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_20_16_1716027616_17.xml', 'agoda', '2024-05-18 10:20:17', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674381');
[05/18/2024 10:20:17], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '9'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=12&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:20:16.499'
        , request_start_time = '0.038'
        , parsing_start_time = '0.568'
        , mapping_complete_time = '0.055'
        , mongo_start_time = '0.075'
        , search_end_time = '0.027'
        , total_duration = '0.814'
        , error_description = ''
        , memory_used = '8013448'
        WHERE id = '139963291';
[05/18/2024 10:20:17], [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/18_05_2024/request_availability_qtech_agent_10_20_16_1716027616_25.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_20_16_1716027616_25.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_20_16_1716027616_25.xml', 'agoda', '2024-05-18 10:20:17', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674381');
[05/18/2024 10:20:17], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '8'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=10&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:20:16.499'
        , request_start_time = '0.032'
        , parsing_start_time = '0.614'
        , mapping_complete_time = '0.052'
        , mongo_start_time = '0.068'
        , search_end_time = '0.019'
        , total_duration = '0.823'
        , error_description = ''
        , memory_used = '7587544'
        WHERE id = '139963294';
[05/18/2024 10:20:17], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '12'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=14&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:20:16.499'
        , request_start_time = '0.025'
        , parsing_start_time = '0.631'
        , mapping_complete_time = '0.058'
        , mongo_start_time = '0.081'
        , search_end_time = '0.025'
        , total_duration = '0.836'
        , error_description = ''
        , memory_used = '8290264'
        WHERE id = '139963293';
[05/18/2024 10:20:17], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '12'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=23&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:20:16.508'
        , request_start_time = '0.024'
        , parsing_start_time = '0.589'
        , mapping_complete_time = '0.064'
        , mongo_start_time = '0.085'
        , search_end_time = '0.034'
        , total_duration = '0.828'
        , error_description = ''
        , memory_used = '9267424'
        WHERE id = '139963292';
[05/18/2024 10:20:17], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '13'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=16&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:20:16.500'
        , request_start_time = '0.022'
        , parsing_start_time = '0.624'
        , mapping_complete_time = '0.068'
        , mongo_start_time = '0.086'
        , search_end_time = '0.028'
        , total_duration = '0.848'
        , error_description = ''
        , memory_used = '7863008'
        WHERE id = '139963295';
[05/18/2024 10:20:17], [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/18_05_2024/request_availability_qtech_agent_10_20_16_1716027616_13.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_20_16_1716027616_13.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_20_16_1716027616_13.xml', 'agoda', '2024-05-18 10:20:17', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674381');
[05/18/2024 10:20:17], [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/18_05_2024/request_availability_qtech_agent_10_20_16_1716027616_27.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_20_16_1716027616_27.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_20_16_1716027616_27.xml', 'agoda', '2024-05-18 10:20:17', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674381');
[05/18/2024 10:20:17], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '11'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=17&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:20:16.500'
        , request_start_time = '0.033'
        , parsing_start_time = '0.627'
        , mapping_complete_time = '0.076'
        , mongo_start_time = '0.101'
        , search_end_time = '0.028'
        , total_duration = '0.870'
        , error_description = ''
        , memory_used = '9796552'
        WHERE id = '139963296';
[05/18/2024 10:20:17], [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/18_05_2024/request_availability_qtech_agent_10_20_16_1716027616_20.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_20_16_1716027616_20.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_20_16_1716027616_20.xml', 'agoda', '2024-05-18 10:20:17', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674381');
[05/18/2024 10:20:17], [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/18_05_2024/request_availability_qtech_agent_10_20_16_1716027616_26.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_20_16_1716027616_26.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_20_16_1716027616_26.xml', 'agoda', '2024-05-18 10:20:17', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674381');
[05/18/2024 10:20:17], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '18'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=25&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:20:16.500'
        , request_start_time = '0.022'
        , parsing_start_time = '0.634'
        , mapping_complete_time = '0.096'
        , mongo_start_time = '0.124'
        , search_end_time = '0.064'
        , total_duration = '0.943'
        , error_description = ''
        , memory_used = '12055664'
        WHERE id = '139963297';
[05/18/2024 10:20:17], [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/18_05_2024/request_availability_qtech_agent_10_20_16_1716027616_24.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_20_16_1716027616_24.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_20_16_1716027616_24.xml', 'agoda', '2024-05-18 10:20:17', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674381');
[05/18/2024 10:20:17], [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/18_05_2024/request_availability_qtech_agent_10_20_16_1716027616_34.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_20_16_1716027616_34.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_20_16_1716027616_34.xml', 'agoda', '2024-05-18 10:20:17', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674381');
[05/18/2024 10:20:17], [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/18_05_2024/request_availability_qtech_agent_10_20_16_1716027616_6.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_20_16_1716027616_6.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_20_16_1716027616_6.xml', 'agoda', '2024-05-18 10:20:17', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674381');
[05/18/2024 10:20:17], [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/18_05_2024/request_availability_qtech_agent_10_20_16_1716027616_33.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_20_16_1716027616_33.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_20_16_1716027616_33.xml', 'agoda', '2024-05-18 10:20:17', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674381');
[05/18/2024 10:20:17], [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/18_05_2024/request_availability_qtech_agent_10_20_16_1716027616_18.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_20_16_1716027616_18.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_20_16_1716027616_18.xml', 'agoda', '2024-05-18 10:20:17', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674381');
[05/18/2024 10:20:17], [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/18_05_2024/request_availability_qtech_agent_10_20_16_1716027616_5.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_20_16_1716027616_5.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_20_16_1716027616_5.xml', 'agoda', '2024-05-18 10:20:17', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674381');
[05/18/2024 10:20:17], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '14'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=13&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:20:16.507'
        , request_start_time = '0.024'
        , parsing_start_time = '0.627'
        , mapping_complete_time = '0.098'
        , mongo_start_time = '0.127'
        , search_end_time = '0.064'
        , total_duration = '0.968'
        , error_description = ''
        , memory_used = '9410080'
        WHERE id = '139963298';
[05/18/2024 10:20:17], [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/18_05_2024/request_availability_qtech_agent_10_20_16_1716027616_19.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_20_16_1716027616_19.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_20_16_1716027616_19.xml', 'agoda', '2024-05-18 10:20:17', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674381');
[05/18/2024 10:20:17], [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/18_05_2024/request_availability_qtech_agent_10_20_16_1716027616_32.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_20_16_1716027616_32.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_20_16_1716027616_32.xml', 'agoda', '2024-05-18 10:20:17', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674381');
[05/18/2024 10:20:17], [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/18_05_2024/request_availability_qtech_agent_10_20_16_1716027616_7.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_20_16_1716027616_7.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_20_16_1716027616_7.xml', 'agoda', '2024-05-18 10:20:17', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674381');
[05/18/2024 10:20:17], [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/18_05_2024/request_availability_qtech_agent_10_20_16_1716027616_0.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_20_16_1716027616_0.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_20_16_1716027616_0.xml', 'agoda', '2024-05-18 10:20:17', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674381');
[05/18/2024 10:20:17], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '14'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=27&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:20:16.501'
        , request_start_time = '0.038'
        , parsing_start_time = '0.623'
        , mapping_complete_time = '0.112'
        , mongo_start_time = '0.202'
        , search_end_time = '0.035'
        , total_duration = '1.011'
        , error_description = ''
        , memory_used = '10585848'
        WHERE id = '139963299';
[05/18/2024 10:20:17], [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/18_05_2024/request_availability_qtech_agent_10_20_16_1716027616_1.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_20_16_1716027616_1.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_20_16_1716027616_1.xml', 'agoda', '2024-05-18 10:20:17', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674381');
[05/18/2024 10:20:17], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '17'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=26&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:20:16.500'
        , request_start_time = '0.023'
        , parsing_start_time = '0.691'
        , mapping_complete_time = '0.114'
        , mongo_start_time = '0.158'
        , search_end_time = '0.040'
        , total_duration = '1.034'
        , error_description = ''
        , memory_used = '11959504'
        WHERE id = '139963301';
[05/18/2024 10:20:17], [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/18_05_2024/request_availability_qtech_agent_10_20_16_1716027616_31.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_20_16_1716027616_31.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_20_16_1716027616_31.xml', 'agoda', '2024-05-18 10:20:17', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674381');
[05/18/2024 10:20:17], [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/18_05_2024/request_availability_qtech_agent_10_20_16_1716027616_3.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_20_16_1716027616_3.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_20_16_1716027616_3.xml', 'agoda', '2024-05-18 10:20:17', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674381');
[05/18/2024 10:20:17], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '15'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=24&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:20:16.501'
        , request_start_time = '0.028'
        , parsing_start_time = '0.713'
        , mapping_complete_time = '0.140'
        , mongo_start_time = '0.174'
        , search_end_time = '0.042'
        , total_duration = '1.052'
        , error_description = ''
        , memory_used = '11513192'
        WHERE id = '139963302';
[05/18/2024 10:20:17], [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/18_05_2024/request_availability_qtech_agent_10_20_16_1716027616_21.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_20_16_1716027616_21.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_20_16_1716027616_21.xml', 'agoda', '2024-05-18 10:20:17', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674381');
[05/18/2024 10:20:17], [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/18_05_2024/request_availability_qtech_agent_10_20_16_1716027616_22.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_20_16_1716027616_22.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_20_16_1716027616_22.xml', 'agoda', '2024-05-18 10:20:17', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674381');
[05/18/2024 10:20:17], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '23'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=20&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:20:16.500'
        , request_start_time = '0.028'
        , parsing_start_time = '0.648'
        , mapping_complete_time = '0.132'
        , mongo_start_time = '0.203'
        , search_end_time = '0.067'
        , total_duration = '1.065'
        , error_description = ''
        , memory_used = '11771152'
        WHERE id = '139963300';
[05/18/2024 10:20:17], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '20'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=33&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:20:16.501'
        , request_start_time = '0.023'
        , parsing_start_time = '0.724'
        , mapping_complete_time = '0.149'
        , mongo_start_time = '0.182'
        , search_end_time = '0.039'
        , total_duration = '1.073'
        , error_description = ''
        , memory_used = '11579864'
        WHERE id = '139963305';
[05/18/2024 10:20:17], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '22'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=34&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:20:16.507'
        , request_start_time = '0.028'
        , parsing_start_time = '0.734'
        , mapping_complete_time = '0.131'
        , mongo_start_time = '0.177'
        , search_end_time = '0.050'
        , total_duration = '1.074'
        , error_description = ''
        , memory_used = '14074224'
        WHERE id = '139963303';
[05/18/2024 10:20:17], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '24'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=5&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:20:16.498'
        , request_start_time = '0.024'
        , parsing_start_time = '0.741'
        , mapping_complete_time = '0.120'
        , mongo_start_time = '0.159'
        , search_end_time = '0.047'
        , total_duration = '1.091'
        , error_description = ''
        , memory_used = '10847904'
        WHERE id = '139963307';
[05/18/2024 10:20:17], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '24'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=19&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:20:16.507'
        , request_start_time = '0.038'
        , parsing_start_time = '0.709'
        , mapping_complete_time = '0.152'
        , mongo_start_time = '0.189'
        , search_end_time = '0.054'
        , total_duration = '1.090'
        , error_description = ''
        , memory_used = '11548688'
        WHERE id = '139963308';
[05/18/2024 10:20:17], [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/18_05_2024/request_availability_qtech_agent_10_20_16_1716027616_2.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_20_16_1716027616_2.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_20_16_1716027616_2.xml', 'agoda', '2024-05-18 10:20:17', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674381');
[05/18/2024 10:20:17], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '18'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=7&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:20:16.499'
        , request_start_time = '0.041'
        , parsing_start_time = '0.729'
        , mapping_complete_time = '0.148'
        , mongo_start_time = '0.188'
        , search_end_time = '0.044'
        , total_duration = '1.110'
        , error_description = ''
        , memory_used = '12067888'
        WHERE id = '139963310';
[05/18/2024 10:20:17], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '23'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=32&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:20:16.509'
        , request_start_time = '0.031'
        , parsing_start_time = '0.736'
        , mapping_complete_time = '0.152'
        , mongo_start_time = '0.209'
        , search_end_time = '0.048'
        , total_duration = '1.112'
        , error_description = ''
        , memory_used = '13351744'
        WHERE id = '139963309';
[05/18/2024 10:20:17], [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/18_05_2024/request_availability_qtech_agent_10_20_16_1716027616_4.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_20_16_1716027616_4.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_20_16_1716027616_4.xml', 'agoda', '2024-05-18 10:20:17', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674381');
[05/18/2024 10:20:17], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '16'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=6&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:20:16.508'
        , request_start_time = '0.036'
        , parsing_start_time = '0.727'
        , mapping_complete_time = '0.118'
        , mongo_start_time = '0.155'
        , search_end_time = '0.094'
        , total_duration = '1.114'
        , error_description = ''
        , memory_used = '15112912'
        WHERE id = '139963304';
[05/18/2024 10:20:17], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '16'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=18&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:20:16.500'
        , request_start_time = '0.025'
        , parsing_start_time = '0.748'
        , mapping_complete_time = '0.149'
        , mongo_start_time = '0.183'
        , search_end_time = '0.094'
        , total_duration = '1.136'
        , error_description = ''
        , memory_used = '16324048'
        WHERE id = '139963306';
[05/18/2024 10:20:17], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '23'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=0&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:20:16.508'
        , request_start_time = '0.023'
        , parsing_start_time = '0.752'
        , mapping_complete_time = '0.178'
        , mongo_start_time = '0.224'
        , search_end_time = '0.057'
        , total_duration = '1.128'
        , error_description = ''
        , memory_used = '14755368'
        WHERE id = '139963311';
[05/18/2024 10:20:17], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '21'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=3&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:20:16.501'
        , request_start_time = '0.021'
        , parsing_start_time = '0.821'
        , mapping_complete_time = '0.148'
        , mongo_start_time = '0.182'
        , search_end_time = '0.050'
        , total_duration = '1.147'
        , error_description = ''
        , memory_used = '12727352'
        WHERE id = '139963315';
[05/18/2024 10:20:17], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '21'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=31&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:20:16.507'
        , request_start_time = '0.026'
        , parsing_start_time = '0.743'
        , mapping_complete_time = '0.180'
        , mongo_start_time = '0.224'
        , search_end_time = '0.052'
        , total_duration = '1.141'
        , error_description = ''
        , memory_used = '14639992'
        WHERE id = '139963313';
[05/18/2024 10:20:17], [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/18_05_2024/request_availability_qtech_agent_10_20_16_1716027616_30.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_20_16_1716027616_30.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_20_16_1716027616_30.xml', 'agoda', '2024-05-18 10:20:17', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674381');
[05/18/2024 10:20:17], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '24'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=1&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:20:16.505'
        , request_start_time = '0.026'
        , parsing_start_time = '0.758'
        , mapping_complete_time = '0.175'
        , mongo_start_time = '0.229'
        , search_end_time = '0.061'
        , total_duration = '1.155'
        , error_description = ''
        , memory_used = '15008976'
        WHERE id = '139963312';
[05/18/2024 10:20:17], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '24'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=22&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:20:16.500'
        , request_start_time = '0.029'
        , parsing_start_time = '0.823'
        , mapping_complete_time = '0.158'
        , mongo_start_time = '0.210'
        , search_end_time = '0.042'
        , total_duration = '1.180'
        , error_description = ''
        , memory_used = '13933104'
        WHERE id = '139963317';
[05/18/2024 10:20:17], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '23'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=21&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:20:16.509'
        , request_start_time = '0.038'
        , parsing_start_time = '0.824'
        , mapping_complete_time = '0.111'
        , mongo_start_time = '0.143'
        , search_end_time = '0.090'
        , total_duration = '1.192'
        , error_description = ''
        , memory_used = '17235280'
        WHERE id = '139963316';
[05/18/2024 10:20:17], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '27'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=2&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:20:16.499'
        , request_start_time = '0.021'
        , parsing_start_time = '0.842'
        , mapping_complete_time = '0.145'
        , mongo_start_time = '0.178'
        , search_end_time = '0.034'
        , total_duration = '1.202'
        , error_description = ''
        , memory_used = '14839168'
        WHERE id = '139963318';
[05/18/2024 10:20:17], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '25'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=4&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:20:16.505'
        , request_start_time = '0.021'
        , parsing_start_time = '0.909'
        , mapping_complete_time = '0.111'
        , mongo_start_time = '0.141'
        , search_end_time = '0.038'
        , total_duration = '1.206'
        , error_description = ''
        , memory_used = '13289968'
        WHERE id = '139963319';
[05/18/2024 10:20:17], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '18'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=30&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:20:16.501'
        , request_start_time = '0.025'
        , parsing_start_time = '0.921'
        , mapping_complete_time = '0.125'
        , mongo_start_time = '0.153'
        , search_end_time = '0.036'
        , total_duration = '1.237'
        , error_description = ''
        , memory_used = '13554456'
        WHERE id = '139963320';
[05/18/2024 10:20:17], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '88'
        , 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=1284&db_caching=1&wh_agent_id=&erequest=2&total_request=5&hotel_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:20:16.506'
        , request_start_time = '0.138'
        , parsing_start_time = '0.417'
        , mapping_complete_time = '0.188'
        , mongo_start_time = '0.569'
        , search_end_time = '0.204'
        , total_duration = '1.435'
        , error_description = ''
        , memory_used = '32331136'
        WHERE id = '139963288';
[05/18/2024 10:20:17], [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/18_05_2024/request_availability_qtech_agent_10_20_16_1716027616_49_4.xml', 'd3/18_05_2024/response_availability_qtech_agent_10_20_16_1716027616_49_4.xml', 'd3/18_05_2024/response_header_availability_qtech_agent_10_20_16_1716027616_49_4.xml', 'darina', '2024-05-18 10:20:17', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674381');
[05/18/2024 10:20:18], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'd3/18_05_2024/request_availability_qtech_agent_10_20_16_1716027616_49_3.xml', 'd3/18_05_2024/response_availability_qtech_agent_10_20_16_1716027616_49_3.xml', 'd3/18_05_2024/response_header_availability_qtech_agent_10_20_16_1716027616_49_3.xml', 'darina', '2024-05-18 10:20:18', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674381');
[05/18/2024 10:20:18], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '34'
        , 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=1284&db_caching=1&wh_agent_id=&erequest=4&total_request=5&hotel_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:20:16.501'
        , request_start_time = '0.134'
        , parsing_start_time = '1.218'
        , mapping_complete_time = '0.063'
        , mongo_start_time = '0.164'
        , search_end_time = '0.090'
        , total_duration = '1.727'
        , error_description = ''
        , memory_used = '14549152'
        WHERE id = '139963323';
[05/18/2024 10:20:18], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '73'
        , 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=1284&db_caching=1&wh_agent_id=&erequest=3&total_request=5&hotel_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:20:16.508'
        , request_start_time = '0.137'
        , parsing_start_time = '1.311'
        , mapping_complete_time = '0.098'
        , mongo_start_time = '0.266'
        , search_end_time = '0.166'
        , total_duration = '1.975'
        , error_description = ''
        , memory_used = '21952680'
        WHERE id = '139963324';
[05/18/2024 10:20:19], [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/18_05_2024/request_availability_qtech_agent_10_20_16_1716027616_49_0.xml', 'd3/18_05_2024/response_availability_qtech_agent_10_20_16_1716027616_49_0.xml', 'd3/18_05_2024/response_header_availability_qtech_agent_10_20_16_1716027616_49_0.xml', 'darina', '2024-05-18 10:20:19', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674381');
[05/18/2024 10:20:20], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '87'
        , 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=1284&db_caching=1&wh_agent_id=&erequest=0&total_request=5&hotel_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:20:16.505'
        , request_start_time = '0.125'
        , parsing_start_time = '3.136'
        , mapping_complete_time = '0.120'
        , mongo_start_time = '0.341'
        , search_end_time = '0.179'
        , total_duration = '3.916'
        , error_description = ''
        , memory_used = '27403520'
        WHERE id = '139963328';
[05/18/2024 10:20:20], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '631',
        request_path = '/xml_all.php?userid=1284&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02',
        duration = '4.434',
        merge_duration = '0.162',
        assigned_supplier_count = '2',
        searched_supplier_count = '2',
        system_load_1_min = '1.19',
        system_load_5_min = '1.08',
        system_load_15_min = '1.04',
        system_memory_usage = '89.88',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '9674381') + '23757656',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '9674381';
[05/18/2024 10:20: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/18_05_2024/request_availability_qtech_agent_10_20_35_1716027635_49_0.xml', 'd3/18_05_2024/response_availability_qtech_agent_10_20_35_1716027635_49_0.xml', 'd3/18_05_2024/response_header_availability_qtech_agent_10_20_35_1716027635_49_0.xml', 'darina', '2024-05-18 10:20:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674381');
[05/18/2024 10:20: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/18_05_2024/request_availability_qtech_agent_10_20_35_1716027635_0.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_20_35_1716027635_0.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_20_35_1716027635_0.xml', 'agoda', '2024-05-18 10:20:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674381');
[05/18/2024 10:20:35], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '1'
        , 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=1284&db_caching=1&wh_agent_id=&erequest=0&total_request=1&hotel_ids=[&quot;320&quot;]&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:20:34.940'
        , request_start_time = '0.116'
        , parsing_start_time = '0.121'
        , mapping_complete_time = '0.016'
        , mongo_start_time = '0.021'
        , search_end_time = '0.019'
        , total_duration = '0.325'
        , error_description = ''
        , memory_used = '3653136'
        WHERE id = '139963385';
[05/18/2024 10:20:35], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '1'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=0&total_request=1&hotels_ids=[&quot;295506&quot;]&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:20:34.941'
        , request_start_time = '0.012'
        , parsing_start_time = '0.232'
        , mapping_complete_time = '0.016'
        , mongo_start_time = '0.023'
        , search_end_time = '0.023'
        , total_duration = '0.351'
        , error_description = ''
        , memory_used = '4713880'
        WHERE id = '139963388';
[05/18/2024 10:25:25], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '1284' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '129' , service_type = 'hotel' , arrival_date = '2024/05/30' , departure_date = '2024/05/31' , nights = '1' , nationality = '129' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-05-18 10:25:25' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'INR' , currency_code = 'INR' , web_service = '0' ;
[05/18/2024 10:25:26], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'd3/18_05_2024/request_availability_qtech_agent_10_25_26_1716027926_49_1.xml', 'd3/18_05_2024/response_availability_qtech_agent_10_25_26_1716027926_49_1.xml', 'd3/18_05_2024/response_header_availability_qtech_agent_10_25_26_1716027926_49_1.xml', 'darina', '2024-05-18 10:25:26', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674834');
[05/18/2024 10:25:26], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/18_05_2024/request_availability_qtech_agent_10_25_26_1716027926_11.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_25_26_1716027926_11.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_25_26_1716027926_11.xml', 'agoda', '2024-05-18 10:25:26', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674834');
[05/18/2024 10:25:26], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'd3/18_05_2024/request_availability_qtech_agent_10_25_26_1716027926_49_3.xml', 'd3/18_05_2024/response_availability_qtech_agent_10_25_26_1716027926_49_3.xml', 'd3/18_05_2024/response_header_availability_qtech_agent_10_25_26_1716027926_49_3.xml', 'darina', '2024-05-18 10:25:26', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674834');
[05/18/2024 10:25:26], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'd3/18_05_2024/request_availability_qtech_agent_10_25_26_1716027926_49_2.xml', 'd3/18_05_2024/response_availability_qtech_agent_10_25_26_1716027926_49_2.xml', 'd3/18_05_2024/response_header_availability_qtech_agent_10_25_26_1716027926_49_2.xml', 'darina', '2024-05-18 10:25:26', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674834');
[05/18/2024 10:25:26], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '6'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=11&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:25:26.117'
        , request_start_time = '0.033'
        , parsing_start_time = '0.291'
        , mapping_complete_time = '0.026'
        , mongo_start_time = '0.036'
        , search_end_time = '0.023'
        , total_duration = '0.473'
        , error_description = ''
        , memory_used = '5557616'
        WHERE id = '139967001';
[05/18/2024 10:25:26], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'd3/18_05_2024/request_availability_qtech_agent_10_25_26_1716027926_49_4.xml', 'd3/18_05_2024/response_availability_qtech_agent_10_25_26_1716027926_49_4.xml', 'd3/18_05_2024/response_header_availability_qtech_agent_10_25_26_1716027926_49_4.xml', 'darina', '2024-05-18 10:25:26', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674834');
[05/18/2024 10:25:26], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'd3/18_05_2024/request_availability_qtech_agent_10_25_26_1716027926_49_0.xml', 'd3/18_05_2024/response_availability_qtech_agent_10_25_26_1716027926_49_0.xml', 'd3/18_05_2024/response_header_availability_qtech_agent_10_25_26_1716027926_49_0.xml', 'darina', '2024-05-18 10:25:26', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674834');
[05/18/2024 10:25:26], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/18_05_2024/request_availability_qtech_agent_10_25_26_1716027926_8.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_25_26_1716027926_8.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_25_26_1716027926_8.xml', 'agoda', '2024-05-18 10:25:26', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674834');
[05/18/2024 10:25:26], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '5'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=8&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:25:26.123'
        , request_start_time = '0.020'
        , parsing_start_time = '0.354'
        , mapping_complete_time = '0.036'
        , mongo_start_time = '0.047'
        , search_end_time = '0.025'
        , total_duration = '0.557'
        , error_description = ''
        , memory_used = '6284096'
        WHERE id = '139967006';
[05/18/2024 10:25:26], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/18_05_2024/request_availability_qtech_agent_10_25_26_1716027926_10.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_25_26_1716027926_10.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_25_26_1716027926_10.xml', 'agoda', '2024-05-18 10:25:26', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674834');
[05/18/2024 10:25:26], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/18_05_2024/request_availability_qtech_agent_10_25_26_1716027926_29.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_25_26_1716027926_29.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_25_26_1716027926_29.xml', 'agoda', '2024-05-18 10:25:26', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674834');
[05/18/2024 10:25:26], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/18_05_2024/request_availability_qtech_agent_10_25_26_1716027926_15.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_25_26_1716027926_15.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_25_26_1716027926_15.xml', 'agoda', '2024-05-18 10:25:26', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674834');
[05/18/2024 10:25:26], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/18_05_2024/request_availability_qtech_agent_10_25_26_1716027926_14.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_25_26_1716027926_14.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_25_26_1716027926_14.xml', 'agoda', '2024-05-18 10:25:26', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674834');
[05/18/2024 10:25:26], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '8'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=10&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:25:26.116'
        , request_start_time = '0.018'
        , parsing_start_time = '0.422'
        , mapping_complete_time = '0.040'
        , mongo_start_time = '0.059'
        , search_end_time = '0.028'
        , total_duration = '0.650'
        , error_description = ''
        , memory_used = '7580784'
        WHERE id = '139967007';
[05/18/2024 10:25:26], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '10'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=29&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:25:26.123'
        , request_start_time = '0.028'
        , parsing_start_time = '0.426'
        , mapping_complete_time = '0.067'
        , mongo_start_time = '0.089'
        , search_end_time = '0.028'
        , total_duration = '0.661'
        , error_description = ''
        , memory_used = '8352552'
        WHERE id = '139967008';
[05/18/2024 10:25:26], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/18_05_2024/request_availability_qtech_agent_10_25_26_1716027926_12.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_25_26_1716027926_12.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_25_26_1716027926_12.xml', 'agoda', '2024-05-18 10:25:26', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674834');
[05/18/2024 10:25:26], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '14'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=15&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:25:26.117'
        , request_start_time = '0.015'
        , parsing_start_time = '0.415'
        , mapping_complete_time = '0.071'
        , mongo_start_time = '0.089'
        , search_end_time = '0.034'
        , total_duration = '0.680'
        , error_description = ''
        , memory_used = '7992216'
        WHERE id = '139967009';
[05/18/2024 10:25:26], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '11'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=14&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:25:26.118'
        , request_start_time = '0.018'
        , parsing_start_time = '0.437'
        , mapping_complete_time = '0.072'
        , mongo_start_time = '0.090'
        , search_end_time = '0.032'
        , total_duration = '0.692'
        , error_description = ''
        , memory_used = '8139384'
        WHERE id = '139967010';
[05/18/2024 10:25:26], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/18_05_2024/request_availability_qtech_agent_10_25_26_1716027926_17.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_25_26_1716027926_17.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_25_26_1716027926_17.xml', 'agoda', '2024-05-18 10:25:26', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674834');
[05/18/2024 10:25:26], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/18_05_2024/request_availability_qtech_agent_10_25_26_1716027926_16.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_25_26_1716027926_16.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_25_26_1716027926_16.xml', 'agoda', '2024-05-18 10:25:26', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674834');
[05/18/2024 10:25:26], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/18_05_2024/request_availability_qtech_agent_10_25_26_1716027926_27.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_25_26_1716027926_27.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_25_26_1716027926_27.xml', 'agoda', '2024-05-18 10:25:26', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674834');
[05/18/2024 10:25:26], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/18_05_2024/request_availability_qtech_agent_10_25_26_1716027926_28.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_25_26_1716027926_28.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_25_26_1716027926_28.xml', 'agoda', '2024-05-18 10:25:26', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674834');
[05/18/2024 10:25:26], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/18_05_2024/request_availability_qtech_agent_10_25_26_1716027926_13.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_25_26_1716027926_13.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_25_26_1716027926_13.xml', 'agoda', '2024-05-18 10:25:26', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674834');
[05/18/2024 10:25:26], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '9'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=12&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:25:26.124'
        , request_start_time = '0.020'
        , parsing_start_time = '0.525'
        , mapping_complete_time = '0.071'
        , mongo_start_time = '0.093'
        , search_end_time = '0.031'
        , total_duration = '0.734'
        , error_description = ''
        , memory_used = '8265616'
        WHERE id = '139967011';
[05/18/2024 10:25:26], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/18_05_2024/request_availability_qtech_agent_10_25_26_1716027926_23.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_25_26_1716027926_23.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_25_26_1716027926_23.xml', 'agoda', '2024-05-18 10:25:26', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674834');
[05/18/2024 10:25:26], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/18_05_2024/request_availability_qtech_agent_10_25_26_1716027926_20.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_25_26_1716027926_20.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_25_26_1716027926_20.xml', 'agoda', '2024-05-18 10:25:26', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674834');
[05/18/2024 10:25:26], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/18_05_2024/request_availability_qtech_agent_10_25_26_1716027926_9.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_25_26_1716027926_9.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_25_26_1716027926_9.xml', 'agoda', '2024-05-18 10:25:26', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674834');
[05/18/2024 10:25:26], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '11'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=17&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:25:26.119'
        , request_start_time = '0.030'
        , parsing_start_time = '0.498'
        , mapping_complete_time = '0.092'
        , mongo_start_time = '0.115'
        , search_end_time = '0.041'
        , total_duration = '0.778'
        , error_description = ''
        , memory_used = '9821952'
        WHERE id = '139967012';
[05/18/2024 10:25:26], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '13'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=16&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:25:26.119'
        , request_start_time = '0.029'
        , parsing_start_time = '0.542'
        , mapping_complete_time = '0.066'
        , mongo_start_time = '0.085'
        , search_end_time = '0.033'
        , total_duration = '0.779'
        , error_description = ''
        , memory_used = '8026392'
        WHERE id = '139967013';
[05/18/2024 10:25:26], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '65'
        , 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=1284&db_caching=1&wh_agent_id=&erequest=1&total_request=5&hotel_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:25:26.115'
        , request_start_time = '0.150'
        , parsing_start_time = '0.181'
        , mapping_complete_time = '0.069'
        , mongo_start_time = '0.224'
        , search_end_time = '0.152'
        , total_duration = '0.799'
        , error_description = ''
        , memory_used = '17062584'
        WHERE id = '139967000';
[05/18/2024 10:25:26], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/18_05_2024/request_availability_qtech_agent_10_25_26_1716027926_19.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_25_26_1716027926_19.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_25_26_1716027926_19.xml', 'agoda', '2024-05-18 10:25:26', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674834');
[05/18/2024 10:25:26], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '8'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=28&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:25:26.119'
        , request_start_time = '0.032'
        , parsing_start_time = '0.552'
        , mapping_complete_time = '0.054'
        , mongo_start_time = '0.075'
        , search_end_time = '0.053'
        , total_duration = '0.813'
        , error_description = ''
        , memory_used = '8717000'
        WHERE id = '139967015';
[05/18/2024 10:25:26], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '14'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=27&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:25:26.119'
        , request_start_time = '0.022'
        , parsing_start_time = '0.560'
        , mapping_complete_time = '0.084'
        , mongo_start_time = '0.109'
        , search_end_time = '0.043'
        , total_duration = '0.816'
        , error_description = ''
        , memory_used = '10779016'
        WHERE id = '139967014';
[05/18/2024 10:25:26], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/18_05_2024/request_availability_qtech_agent_10_25_26_1716027926_6.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_25_26_1716027926_6.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_25_26_1716027926_6.xml', 'agoda', '2024-05-18 10:25:26', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674834');
[05/18/2024 10:25:26], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '34'
        , 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=1284&db_caching=1&wh_agent_id=&erequest=4&total_request=5&hotel_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:25:26.123'
        , request_start_time = '0.139'
        , parsing_start_time = '0.253'
        , mapping_complete_time = '0.068'
        , mongo_start_time = '0.190'
        , search_end_time = '0.145'
        , total_duration = '0.820'
        , error_description = ''
        , memory_used = '14545224'
        WHERE id = '139967004';
[05/18/2024 10:25:26], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/18_05_2024/request_availability_qtech_agent_10_25_26_1716027926_25.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_25_26_1716027926_25.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_25_26_1716027926_25.xml', 'agoda', '2024-05-18 10:25:26', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674834');
[05/18/2024 10:25:26], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '12'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=23&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:25:26.123'
        , request_start_time = '0.026'
        , parsing_start_time = '0.543'
        , mapping_complete_time = '0.098'
        , mongo_start_time = '0.119'
        , search_end_time = '0.045'
        , total_duration = '0.826'
        , error_description = ''
        , memory_used = '9265312'
        WHERE id = '139967017';
[05/18/2024 10:25:26], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '14'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=13&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:25:26.124'
        , request_start_time = '0.048'
        , parsing_start_time = '0.520'
        , mapping_complete_time = '0.082'
        , mongo_start_time = '0.108'
        , search_end_time = '0.070'
        , total_duration = '0.839'
        , error_description = ''
        , memory_used = '9405992'
        WHERE id = '139967016';
[05/18/2024 10:25:26], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/18_05_2024/request_availability_qtech_agent_10_25_26_1716027926_33.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_25_26_1716027926_33.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_25_26_1716027926_33.xml', 'agoda', '2024-05-18 10:25:26', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674834');
[05/18/2024 10:25:26], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '8'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=9&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:25:26.115'
        , request_start_time = '0.050'
        , parsing_start_time = '0.540'
        , mapping_complete_time = '0.100'
        , mongo_start_time = '0.125'
        , search_end_time = '0.052'
        , total_duration = '0.860'
        , error_description = ''
        , memory_used = '8334480'
        WHERE id = '139967019';
[05/18/2024 10:25:26], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/18_05_2024/request_availability_qtech_agent_10_25_26_1716027926_7.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_25_26_1716027926_7.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_25_26_1716027926_7.xml', 'agoda', '2024-05-18 10:25:26', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674834');
[05/18/2024 10:25:26], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/18_05_2024/request_availability_qtech_agent_10_25_26_1716027926_24.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_25_26_1716027926_24.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_25_26_1716027926_24.xml', 'agoda', '2024-05-18 10:25:26', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674834');
[05/18/2024 10:25:26], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/18_05_2024/request_availability_qtech_agent_10_25_26_1716027926_22.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_25_26_1716027926_22.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_25_26_1716027926_22.xml', 'agoda', '2024-05-18 10:25:26', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674834');
[05/18/2024 10:25:26], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/18_05_2024/request_availability_qtech_agent_10_25_26_1716027926_5.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_25_26_1716027926_5.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_25_26_1716027926_5.xml', 'agoda', '2024-05-18 10:25:26', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674834');
[05/18/2024 10:25:27], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '23'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=20&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:25:26.120'
        , request_start_time = '0.025'
        , parsing_start_time = '0.556'
        , mapping_complete_time = '0.143'
        , mongo_start_time = '0.203'
        , search_end_time = '0.045'
        , total_duration = '0.894'
        , error_description = ''
        , memory_used = '11809000'
        WHERE id = '139967018';
[05/18/2024 10:25:27], [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/18_05_2024/request_availability_qtech_agent_10_25_26_1716027926_32.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_25_26_1716027926_32.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_25_26_1716027926_32.xml', 'agoda', '2024-05-18 10:25:27', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674834');
[05/18/2024 10:25:27], [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/18_05_2024/request_availability_qtech_agent_10_25_26_1716027926_30.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_25_26_1716027926_30.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_25_26_1716027926_30.xml', 'agoda', '2024-05-18 10:25:27', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674834');
[05/18/2024 10:25:27], [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/18_05_2024/request_availability_qtech_agent_10_25_26_1716027926_26.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_25_26_1716027926_26.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_25_26_1716027926_26.xml', 'agoda', '2024-05-18 10:25:27', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674834');
[05/18/2024 10:25:27], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '24'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=19&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:25:26.119'
        , request_start_time = '0.028'
        , parsing_start_time = '0.577'
        , mapping_complete_time = '0.129'
        , mongo_start_time = '0.168'
        , search_end_time = '0.075'
        , total_duration = '0.945'
        , error_description = ''
        , memory_used = '11483368'
        WHERE id = '139967020';
[05/18/2024 10:25:27], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '16'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=6&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:25:26.123'
        , request_start_time = '0.023'
        , parsing_start_time = '0.642'
        , mapping_complete_time = '0.111'
        , mongo_start_time = '0.140'
        , search_end_time = '0.064'
        , total_duration = '0.946'
        , error_description = ''
        , memory_used = '10173456'
        WHERE id = '139967021';
[05/18/2024 10:25:27], [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/18_05_2024/request_availability_qtech_agent_10_25_26_1716027926_21.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_25_26_1716027926_21.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_25_26_1716027926_21.xml', 'agoda', '2024-05-18 10:25:27', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674834');
[05/18/2024 10:25:27], [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/18_05_2024/request_availability_qtech_agent_10_25_26_1716027926_18.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_25_26_1716027926_18.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_25_26_1716027926_18.xml', 'agoda', '2024-05-18 10:25:27', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674834');
[05/18/2024 10:25:27], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '20'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=33&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:25:26.119'
        , request_start_time = '0.034'
        , parsing_start_time = '0.612'
        , mapping_complete_time = '0.116'
        , mongo_start_time = '0.154'
        , search_end_time = '0.043'
        , total_duration = '0.960'
        , error_description = ''
        , memory_used = '11290960'
        WHERE id = '139967023';
[05/18/2024 10:25:27], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '15'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=24&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:25:26.122'
        , request_start_time = '0.036'
        , parsing_start_time = '0.651'
        , mapping_complete_time = '0.110'
        , mongo_start_time = '0.148'
        , search_end_time = '0.046'
        , total_duration = '0.968'
        , error_description = ''
        , memory_used = '11640776'
        WHERE id = '139967025';
[05/18/2024 10:25:27], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '18'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=25&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:25:26.119'
        , request_start_time = '0.033'
        , parsing_start_time = '0.577'
        , mapping_complete_time = '0.137'
        , mongo_start_time = '0.169'
        , search_end_time = '0.078'
        , total_duration = '0.972'
        , error_description = ''
        , memory_used = '12052328'
        WHERE id = '139967022';
[05/18/2024 10:25:27], [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/18_05_2024/request_availability_qtech_agent_10_25_26_1716027926_34.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_25_26_1716027926_34.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_25_26_1716027926_34.xml', 'agoda', '2024-05-18 10:25:27', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674834');
[05/18/2024 10:25:27], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '24'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=5&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:25:26.123'
        , request_start_time = '0.030'
        , parsing_start_time = '0.633'
        , mapping_complete_time = '0.149'
        , mongo_start_time = '0.185'
        , search_end_time = '0.048'
        , total_duration = '0.989'
        , error_description = ''
        , memory_used = '10841808'
        WHERE id = '139967027';
[05/18/2024 10:25:27], [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/18_05_2024/request_availability_qtech_agent_10_25_26_1716027926_1.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_25_26_1716027926_1.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_25_26_1716027926_1.xml', 'agoda', '2024-05-18 10:25:27', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674834');
[05/18/2024 10:25:27], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '24'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=22&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:25:26.119'
        , request_start_time = '0.027'
        , parsing_start_time = '0.638'
        , mapping_complete_time = '0.157'
        , mongo_start_time = '0.202'
        , search_end_time = '0.070'
        , total_duration = '1.008'
        , error_description = ''
        , memory_used = '14059792'
        WHERE id = '139967026';
[05/18/2024 10:25:27], [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/18_05_2024/request_availability_qtech_agent_10_25_26_1716027926_0.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_25_26_1716027926_0.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_25_26_1716027926_0.xml', 'agoda', '2024-05-18 10:25:27', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674834');
[05/18/2024 10:25:27], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '23'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=32&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:25:26.122'
        , request_start_time = '0.029'
        , parsing_start_time = '0.664'
        , mapping_complete_time = '0.165'
        , mongo_start_time = '0.197'
        , search_end_time = '0.036'
        , total_duration = '1.015'
        , error_description = ''
        , memory_used = '13292992'
        WHERE id = '139967028';
[05/18/2024 10:25:27], [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/18_05_2024/request_availability_qtech_agent_10_25_26_1716027926_4.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_25_26_1716027926_4.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_25_26_1716027926_4.xml', 'agoda', '2024-05-18 10:25:27', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674834');
[05/18/2024 10:25:27], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '18'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=7&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:25:26.125'
        , request_start_time = '0.017'
        , parsing_start_time = '0.623'
        , mapping_complete_time = '0.136'
        , mongo_start_time = '0.209'
        , search_end_time = '0.067'
        , total_duration = '1.027'
        , error_description = ''
        , memory_used = '11971400'
        WHERE id = '139967024';
[05/18/2024 10:25:27], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '73'
        , 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=1284&db_caching=1&wh_agent_id=&erequest=3&total_request=5&hotel_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:25:26.115'
        , request_start_time = '0.138'
        , parsing_start_time = '0.214'
        , mapping_complete_time = '0.092'
        , mongo_start_time = '0.282'
        , search_end_time = '0.299'
        , total_duration = '1.037'
        , error_description = ''
        , memory_used = '21947896'
        WHERE id = '139967002';
[05/18/2024 10:25:27], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '18'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=30&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:25:26.123'
        , request_start_time = '0.035'
        , parsing_start_time = '0.662'
        , mapping_complete_time = '0.164'
        , mongo_start_time = '0.207'
        , search_end_time = '0.038'
        , total_duration = '1.037'
        , error_description = ''
        , memory_used = '12862544'
        WHERE id = '139967029';
[05/18/2024 10:25:27], [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/18_05_2024/request_availability_qtech_agent_10_25_26_1716027926_3.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_25_26_1716027926_3.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_25_26_1716027926_3.xml', 'agoda', '2024-05-18 10:25:27', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674834');
[05/18/2024 10:25:27], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '17'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=26&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:25:26.119'
        , request_start_time = '0.038'
        , parsing_start_time = '0.721'
        , mapping_complete_time = '0.101'
        , mongo_start_time = '0.141'
        , search_end_time = '0.045'
        , total_duration = '1.051'
        , error_description = ''
        , memory_used = '12201376'
        WHERE id = '139967030';
[05/18/2024 10:25:27], [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/18_05_2024/request_availability_qtech_agent_10_25_26_1716027926_31.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_25_26_1716027926_31.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_25_26_1716027926_31.xml', 'agoda', '2024-05-18 10:25:27', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674834');
[05/18/2024 10:25:27], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '16'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=18&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:25:26.118'
        , request_start_time = '0.031'
        , parsing_start_time = '0.720'
        , mapping_complete_time = '0.145'
        , mongo_start_time = '0.174'
        , search_end_time = '0.034'
        , total_duration = '1.064'
        , error_description = ''
        , memory_used = '11528168'
        WHERE id = '139967032';
[05/18/2024 10:25:27], [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/18_05_2024/request_availability_qtech_agent_10_25_26_1716027926_2.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_25_26_1716027926_2.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_25_26_1716027926_2.xml', 'agoda', '2024-05-18 10:25:27', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674834');
[05/18/2024 10:25:27], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '24'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=21&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:25:26.119'
        , request_start_time = '0.035'
        , parsing_start_time = '0.733'
        , mapping_complete_time = '0.131'
        , mongo_start_time = '0.174'
        , search_end_time = '0.040'
        , total_duration = '1.074'
        , error_description = ''
        , memory_used = '12671544'
        WHERE id = '139967031';
[05/18/2024 10:25:27], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '22'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=34&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:25:26.120'
        , request_start_time = '0.049'
        , parsing_start_time = '0.723'
        , mapping_complete_time = '0.148'
        , mongo_start_time = '0.182'
        , search_end_time = '0.038'
        , total_duration = '1.083'
        , error_description = ''
        , memory_used = '13950992'
        WHERE id = '139967033';
[05/18/2024 10:25:27], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '24'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=1&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:25:26.115'
        , request_start_time = '0.035'
        , parsing_start_time = '0.728'
        , mapping_complete_time = '0.162'
        , mongo_start_time = '0.197'
        , search_end_time = '0.048'
        , total_duration = '1.107'
        , error_description = ''
        , memory_used = '15292280'
        WHERE id = '139967034';
[05/18/2024 10:25:27], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '25'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=4&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:25:26.115'
        , request_start_time = '0.019'
        , parsing_start_time = '0.777'
        , mapping_complete_time = '0.160'
        , mongo_start_time = '0.198'
        , search_end_time = '0.033'
        , total_duration = '1.120'
        , error_description = ''
        , memory_used = '13439768'
        WHERE id = '139967036';
[05/18/2024 10:25:27], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '23'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=0&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:25:26.115'
        , request_start_time = '0.023'
        , parsing_start_time = '0.737'
        , mapping_complete_time = '0.149'
        , mongo_start_time = '0.182'
        , search_end_time = '0.051'
        , total_duration = '1.127'
        , error_description = ''
        , memory_used = '14825368'
        WHERE id = '139967035';
[05/18/2024 10:25:27], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '21'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=3&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:25:26.115'
        , request_start_time = '0.031'
        , parsing_start_time = '0.774'
        , mapping_complete_time = '0.141'
        , mongo_start_time = '0.170'
        , search_end_time = '0.045'
        , total_duration = '1.137'
        , error_description = ''
        , memory_used = '12608608'
        WHERE id = '139967037';
[05/18/2024 10:25:27], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '21'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=31&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:25:26.124'
        , request_start_time = '0.035'
        , parsing_start_time = '0.818'
        , mapping_complete_time = '0.123'
        , mongo_start_time = '0.158'
        , search_end_time = '0.036'
        , total_duration = '1.140'
        , error_description = ''
        , memory_used = '14692304'
        WHERE id = '139967038';
[05/18/2024 10:25:27], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '26'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=2&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:25:26.123'
        , request_start_time = '0.021'
        , parsing_start_time = '0.826'
        , mapping_complete_time = '0.155'
        , mongo_start_time = '0.190'
        , search_end_time = '0.035'
        , total_duration = '1.154'
        , error_description = ''
        , memory_used = '14693360'
        WHERE id = '139967039';
[05/18/2024 10:25:27], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '87'
        , 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=1284&db_caching=1&wh_agent_id=&erequest=0&total_request=5&hotel_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:25:26.123'
        , request_start_time = '0.135'
        , parsing_start_time = '0.272'
        , mapping_complete_time = '0.112'
        , mongo_start_time = '0.467'
        , search_end_time = '0.199'
        , total_duration = '1.172'
        , error_description = ''
        , memory_used = '27395320'
        WHERE id = '139967005';
[05/18/2024 10:25:27], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '88'
        , 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=1284&db_caching=1&wh_agent_id=&erequest=2&total_request=5&hotel_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:25:26.123'
        , request_start_time = '0.136'
        , parsing_start_time = '0.253'
        , mapping_complete_time = '0.134'
        , mongo_start_time = '0.587'
        , search_end_time = '0.192'
        , total_duration = '1.251'
        , error_description = ''
        , memory_used = '32323776'
        WHERE id = '139967003';
[05/18/2024 10:25:51], [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/18_05_2024/request_availability_qtech_agent_10_25_51_1716027951_0.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_25_51_1716027951_0.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_25_51_1716027951_0.xml', 'agoda', '2024-05-18 10:25:51', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674834');
[05/18/2024 10:25:51], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '2'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=0&total_request=1&hotels_ids=[&quot;4915658&quot;,&quot;34112455&quot;]&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:25:51.312'
        , request_start_time = '0.015'
        , parsing_start_time = '0.256'
        , mapping_complete_time = '0.018'
        , mongo_start_time = '0.026'
        , search_end_time = '0.023'
        , total_duration = '0.405'
        , error_description = ''
        , memory_used = '5073960'
        WHERE id = '139967532';
[05/18/2024 10:26:07], [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/18_05_2024/request_availability_qtech_agent_10_26_06_1716027966_0.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_26_06_1716027966_0.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_26_06_1716027966_0.xml', 'agoda', '2024-05-18 10:26:07', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674834');
[05/18/2024 10:26:07], [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/18_05_2024/request_availability_qtech_agent_10_26_06_1716027966_49_0.xml', 'd3/18_05_2024/response_availability_qtech_agent_10_26_06_1716027966_49_0.xml', 'd3/18_05_2024/response_header_availability_qtech_agent_10_26_06_1716027966_49_0.xml', 'darina', '2024-05-18 10:26:07', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674834');
[05/18/2024 10:26:07], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '1'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=0&total_request=1&hotels_ids=[&quot;295506&quot;]&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:26:06.787'
        , request_start_time = '0.014'
        , parsing_start_time = '0.221'
        , mapping_complete_time = '0.017'
        , mongo_start_time = '0.025'
        , search_end_time = '0.022'
        , total_duration = '0.356'
        , error_description = ''
        , memory_used = '4709840'
        WHERE id = '139967706';
[05/18/2024 10:26:07], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '1'
        , 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=1284&db_caching=1&wh_agent_id=&erequest=0&total_request=1&hotel_ids=[&quot;320&quot;]&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:26:06.788'
        , request_start_time = '0.121'
        , parsing_start_time = '0.147'
        , mapping_complete_time = '0.019'
        , mongo_start_time = '0.023'
        , search_end_time = '0.024'
        , total_duration = '0.366'
        , error_description = ''
        , memory_used = '3649056'
        WHERE id = '139967707';
[05/18/2024 10:26:34], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/18_05_2024/request_availability_qtech_agent_10_26_34_1716027994_0.xml', 'a5/18_05_2024/response_availability_qtech_agent_10_26_34_1716027994_0.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_10_26_34_1716027994_0.xml', 'agoda', '2024-05-18 10:26:34', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9674834');
[05/18/2024 10:26:34], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '1'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=0&total_request=1&hotels_ids=[&quot;90380&quot;]&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 10:26:33.961'
        , request_start_time = '0.013'
        , parsing_start_time = '0.192'
        , mapping_complete_time = '0.022'
        , mongo_start_time = '0.029'
        , search_end_time = '0.021'
        , total_duration = '0.321'
        , error_description = ''
        , memory_used = '4530224'
        WHERE id = '139967852';
[05/18/2024 10:33:27], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[05/18/2024 10:33:27], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '77' ,status = '' ,priority = '9' ,lead_time = '1470',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[05/18/2024 10:33:27], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '89' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[05/18/2024 10:33:27], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '76' ,status = '' ,priority = '9' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[05/18/2024 10:33:27], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '98' ,status = '' ,priority = '9' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[05/18/2024 10:33:27], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '58' ,status = '1' ,priority = '9' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[05/18/2024 10:33:27], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '99' ,status = '' ,priority = '9' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[05/18/2024 10:33:27], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '86' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[05/18/2024 10:33:27], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '74' ,status = '' ,priority = '14' ,lead_time = '48',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[05/18/2024 10:33:27], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '75' ,status = '' ,priority = '14' ,lead_time = '48',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[05/18/2024 10:33:27], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '96' ,status = '' ,priority = '9' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[05/18/2024 10:33:27], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '56' ,status = '' ,priority = '9' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[05/18/2024 10:33:27], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '60' ,status = '' ,priority = '9' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[05/18/2024 10:33:27], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '84' ,status = '' ,priority = '9' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[05/18/2024 10:33:27], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '67' ,status = '' ,priority = '5' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[05/18/2024 10:33:27], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '1' ,status = '' ,priority = '9' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[05/18/2024 10:33:27], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '101' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[05/18/2024 10:33:27], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '73' ,status = '' ,priority = '9' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[05/18/2024 10:33:27], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '85' ,status = '' ,priority = '9' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[05/18/2024 10:33:27], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '100' ,status = '' ,priority = '9' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[05/18/2024 10:33:27], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '93' ,status = '' ,priority = '9' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[05/18/2024 10:33:27], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '57' ,status = '' ,priority = '9' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[05/18/2024 10:33:27], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '97' ,status = '' ,priority = '9' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[05/18/2024 10:33:27], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '81' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[05/18/2024 10:33:27], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '78' ,status = '' ,priority = '9' ,lead_time = '72',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[05/18/2024 10:33:27], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '83' ,status = '' ,priority = '9' ,lead_time = '72',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[05/18/2024 10:33:27], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '68' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[05/18/2024 10:33:27], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '90' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[05/18/2024 10:33:27], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '66' ,status = '' ,priority = '9' ,lead_time = '48',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[05/18/2024 10:33:27], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '64' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[05/18/2024 10:33:27], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '65' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[05/18/2024 10:33:27], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '69' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[05/18/2024 10:33:27], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'sanketpdesai',`create_date`= '2024-05-18 10:33:27',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1284\&#039;,supplier_id = 77 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;1470\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1284\&#039;,supplier_id = 89 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1284\&#039;,supplier_id = 76 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1284\&#039;,supplier_id = 98 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1284\&#039;,supplier_id = 58 ,status = \&#039;1\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1284\&#039;,supplier_id = 99 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1284\&#039;,supplier_id = 86 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1284\&#039;,supplier_id = 74 ,status = \&#039;\&#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;1284\&#039;,supplier_id = 75 ,status = \&#039;\&#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;1284\&#039;,supplier_id = 96 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1284\&#039;,supplier_id = 56 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1284\&#039;,supplier_id = 60 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1284\&#039;,supplier_id = 84 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1284\&#039;,supplier_id = 67 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;96\&#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;1284\&#039;,supplier_id = 1 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1284\&#039;,supplier_id = 101 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1284\&#039;,supplier_id = 73 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1284\&#039;,supplier_id = 85 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1284\&#039;,supplier_id = 100 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1284\&#039;,supplier_id = 93 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1284\&#039;,supplier_id = 57 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1284\&#039;,supplier_id = 97 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1284\&#039;,supplier_id = 81 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1284\&#039;,supplier_id = 78 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;72\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1284\&#039;,supplier_id = 83 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;72\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1284\&#039;,supplier_id = 68 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1284\&#039;,supplier_id = 90 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1284\&#039;,supplier_id = 66 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;48\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1284\&#039;,supplier_id = 64 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1284\&#039;,supplier_id = 65 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1284\&#039;,supplier_id = 69 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;',`log_description`= 'Supplier setting updated  Previous data-- agent_id-1284 ## supplier_id- 77 ## company_name - Agoda ## supplier_code-agoda  ## percentage - 0.00 ## lead_time - 1470 ==&lt;br&gt;== agent_id-1284 ## supplier_id- 76 ## company_name - Darina ## supplier_code-darina  ## percentage - 0.00 ## lead_time - 96 ',`ip`= '43.239.53.130';
[05/18/2024 10:33:43], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '1284' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '129' , service_type = 'hotel' , arrival_date = '2024/05/30' , departure_date = '2024/05/31' , nights = '1' , nationality = '129' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-05-18 10:33:43' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'INR' , currency_code = 'INR' , web_service = '0' ;
[05/18/2024 10:33:51], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '1284' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '129' , service_type = 'hotel' , arrival_date = '2024/05/30' , departure_date = '2024/05/31' , nights = '1' , nationality = '129' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-05-18 10:33:51' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'INR' , currency_code = 'INR' , web_service = '0' ;
[05/18/2024 10:36:46], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '1284' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '129' , service_type = 'hotel' , arrival_date = '2024/05/30' , departure_date = '2024/05/31' , nights = '1' , nationality = '129' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-05-18 10:36:46' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'INR' , currency_code = 'INR' , web_service = '0' ;
[05/18/2024 10:38:01], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '1284' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '129' , service_type = 'hotel' , arrival_date = '2024/05/30' , departure_date = '2024/05/31' , nights = '1' , nationality = '129' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-05-18 10:38:01' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'INR' , currency_code = 'INR' , web_service = '0' ;
