[05/20/2024 03:29:55], [file name :-/efsdata/otrams/public_html/beta/showRoomDetails.php],UPDATE agent_logs SET
        hotel_count = '756',
        request_path = '/showRoomDetails.php?hotelSessionId=7a58692e-52bb-4881-a350-4e1221810ed5&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317',
        duration = '6.130',
        merge_duration = '0.191',
        assigned_supplier_count = '3',
        searched_supplier_count = '3',
        system_load_1_min = '0.12',
        system_load_5_min = '0.47',
        system_load_15_min = '0.55',
        system_memory_usage = '88.15',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '9742182') + '24457792',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '9742182';
[05/20/2024 03:33:02], [file name :-/efsdata/otrams/public_html/beta/showRoomDetails.php],UPDATE agent_logs SET
        hotel_count = '756',
        request_path = '/showRoomDetails.php?hotelSessionId=d3d5912f-1f8b-48e3-b976-494d609142a8&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=317',
        duration = '5.974',
        merge_duration = '0.188',
        assigned_supplier_count = '3',
        searched_supplier_count = '3',
        system_load_1_min = '0.32',
        system_load_5_min = '0.37',
        system_load_15_min = '0.49',
        system_memory_usage = '88.57',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '9742182') + '24481096',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '9742182';
[05/20/2024 03:29:50], [file name :-/efsdata/otrams/public_html/beta/index.php],INSERT INTO psa_login_log  SET username = '', user_type = 'A', branch_id = '7', login_datetime = '2024-05-20 15:29:50', ip = '51.254.49.106', action = 'Login' ;
[05/20/2024 03:34:42], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-05-20 03:34:42',login_attempt=0 where id = '1284';
[05/20/2024 03:34:42], [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-20 15:34:42', ip = '43.239.53.130', action = 'Login' ;
[05/20/2024 03:35:03], [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-20 15:35:03' , 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/20/2024 03:35:06], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/20_05_2024/request_availability_qtech_agent_15_35_06_1716219306_11.xml', 'a5/20_05_2024/response_availability_qtech_agent_15_35_06_1716219306_11.xml', 'a5/20_05_2024/response_header_availability_qtech_agent_15_35_06_1716219306_11.xml', 'agoda', '2024-05-20 03:35:06', '', '593618ea97450bfcf3a945ac5f0040487d0ad950b86154041629b4ffe0822d5d', '9801040');
[05/20/2024 03:35:06], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/20_05_2024/request_availability_qtech_agent_15_35_06_1716219306_8.xml', 'a5/20_05_2024/response_availability_qtech_agent_15_35_06_1716219306_8.xml', 'a5/20_05_2024/response_header_availability_qtech_agent_15_35_06_1716219306_8.xml', 'agoda', '2024-05-20 03:35:06', '', '593618ea97450bfcf3a945ac5f0040487d0ad950b86154041629b4ffe0822d5d', '9801040');
[05/20/2024 03:35:06], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/20_05_2024/request_availability_qtech_agent_15_35_06_1716219306_10.xml', 'a5/20_05_2024/response_availability_qtech_agent_15_35_06_1716219306_10.xml', 'a5/20_05_2024/response_header_availability_qtech_agent_15_35_06_1716219306_10.xml', 'agoda', '2024-05-20 03:35:06', '', '593618ea97450bfcf3a945ac5f0040487d0ad950b86154041629b4ffe0822d5d', '9801040');
[05/20/2024 03:35:06], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/20_05_2024/request_availability_qtech_agent_15_35_06_1716219306_15.xml', 'a5/20_05_2024/response_availability_qtech_agent_15_35_06_1716219306_15.xml', 'a5/20_05_2024/response_header_availability_qtech_agent_15_35_06_1716219306_15.xml', 'agoda', '2024-05-20 03:35:06', '', '593618ea97450bfcf3a945ac5f0040487d0ad950b86154041629b4ffe0822d5d', '9801040');
[05/20/2024 03:35:06], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '6'
        , request_url = '/call.php?s=agoda&sessionid=593618ea97450bfcf3a945ac5f0040487d0ad950b86154041629b4ffe0822d5d&xml_user_id=1284&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-20 15:35:06.155'
        , request_start_time = '0.025'
        , parsing_start_time = '0.388'
        , mapping_complete_time = '0.023'
        , mongo_start_time = '0.036'
        , search_end_time = '0.049'
        , total_duration = '0.757'
        , error_description = ''
        , memory_used = '8011928'
        WHERE id = '140540268';
[05/20/2024 03:35:06], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '4'
        , request_url = '/call.php?s=agoda&sessionid=593618ea97450bfcf3a945ac5f0040487d0ad950b86154041629b4ffe0822d5d&xml_user_id=1284&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-20 15:35:06.157'
        , request_start_time = '0.028'
        , parsing_start_time = '0.393'
        , mapping_complete_time = '0.029'
        , mongo_start_time = '0.041'
        , search_end_time = '0.042'
        , total_duration = '0.758'
        , error_description = ''
        , memory_used = '8845008'
        WHERE id = '140540269';
[05/20/2024 03:35:06], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/20_05_2024/request_availability_qtech_agent_15_35_06_1716219306_9.xml', 'a5/20_05_2024/response_availability_qtech_agent_15_35_06_1716219306_9.xml', 'a5/20_05_2024/response_header_availability_qtech_agent_15_35_06_1716219306_9.xml', 'agoda', '2024-05-20 03:35:06', '', '593618ea97450bfcf3a945ac5f0040487d0ad950b86154041629b4ffe0822d5d', '9801040');
[05/20/2024 03:35:06], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '9'
        , request_url = '/call.php?s=agoda&sessionid=593618ea97450bfcf3a945ac5f0040487d0ad950b86154041629b4ffe0822d5d&xml_user_id=1284&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-20 15:35:06.158'
        , request_start_time = '0.024'
        , parsing_start_time = '0.450'
        , mapping_complete_time = '0.037'
        , mongo_start_time = '0.053'
        , search_end_time = '0.034'
        , total_duration = '0.780'
        , error_description = ''
        , memory_used = '9814568'
        WHERE id = '140540270';
[05/20/2024 03:35:06], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/20_05_2024/request_availability_qtech_agent_15_35_06_1716219306_29.xml', 'a5/20_05_2024/response_availability_qtech_agent_15_35_06_1716219306_29.xml', 'a5/20_05_2024/response_header_availability_qtech_agent_15_35_06_1716219306_29.xml', 'agoda', '2024-05-20 03:35:06', '', '593618ea97450bfcf3a945ac5f0040487d0ad950b86154041629b4ffe0822d5d', '9801040');
[05/20/2024 03:35:06], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/20_05_2024/request_availability_qtech_agent_15_35_06_1716219306_17.xml', 'a5/20_05_2024/response_availability_qtech_agent_15_35_06_1716219306_17.xml', 'a5/20_05_2024/response_header_availability_qtech_agent_15_35_06_1716219306_17.xml', 'agoda', '2024-05-20 03:35:06', '', '593618ea97450bfcf3a945ac5f0040487d0ad950b86154041629b4ffe0822d5d', '9801040');
[05/20/2024 03:35:06], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'a5/20_05_2024/request_availability_qtech_agent_15_35_06_1716219306_12.xml', 'a5/20_05_2024/response_availability_qtech_agent_15_35_06_1716219306_12.xml', 'a5/20_05_2024/response_header_availability_qtech_agent_15_35_06_1716219306_12.xml', 'agoda', '2024-05-20 03:35:06', '', '593618ea97450bfcf3a945ac5f0040487d0ad950b86154041629b4ffe0822d5d', '9801040');
[05/20/2024 03:35:06], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '15'
        , request_url = '/call.php?s=agoda&sessionid=593618ea97450bfcf3a945ac5f0040487d0ad950b86154041629b4ffe0822d5d&xml_user_id=1284&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-20 15:35:06.161'
        , request_start_time = '0.023'
        , parsing_start_time = '0.462'
        , mapping_complete_time = '0.041'
        , mongo_start_time = '0.061'
        , search_end_time = '0.038'
        , total_duration = '0.813'
        , error_description = ''
        , memory_used = '10867160'
        WHERE id = '140540271';
[05/20/2024 03:35:06], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '8'
        , request_url = '/call.php?s=agoda&sessionid=593618ea97450bfcf3a945ac5f0040487d0ad950b86154041629b4ffe0822d5d&xml_user_id=1284&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-20 15:35:06.162'
        , request_start_time = '0.018'
        , parsing_start_time = '0.467'
        , mapping_complete_time = '0.049'
        , mongo_start_time = '0.067'
        , search_end_time = '0.038'
        , total_duration = '0.827'
        , error_description = ''
        , memory_used = '10864624'
        WHERE id = '140540272';
[05/20/2024 03:35: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/20_05_2024/request_availability_qtech_agent_15_35_06_1716219306_16.xml', 'a5/20_05_2024/response_availability_qtech_agent_15_35_06_1716219306_16.xml', 'a5/20_05_2024/response_header_availability_qtech_agent_15_35_06_1716219306_16.xml', 'agoda', '2024-05-20 03:35:07', '', '593618ea97450bfcf3a945ac5f0040487d0ad950b86154041629b4ffe0822d5d', '9801040');
[05/20/2024 03:35: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/20_05_2024/request_availability_qtech_agent_15_35_06_1716219306_28.xml', 'a5/20_05_2024/response_availability_qtech_agent_15_35_06_1716219306_28.xml', 'a5/20_05_2024/response_header_availability_qtech_agent_15_35_06_1716219306_28.xml', 'agoda', '2024-05-20 03:35:07', '', '593618ea97450bfcf3a945ac5f0040487d0ad950b86154041629b4ffe0822d5d', '9801040');
[05/20/2024 03:35:07], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '11'
        , request_url = '/call.php?s=agoda&sessionid=593618ea97450bfcf3a945ac5f0040487d0ad950b86154041629b4ffe0822d5d&xml_user_id=1284&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-20 15:35:06.159'
        , request_start_time = '0.030'
        , parsing_start_time = '0.480'
        , mapping_complete_time = '0.044'
        , mongo_start_time = '0.066'
        , search_end_time = '0.040'
        , total_duration = '0.866'
        , error_description = ''
        , memory_used = '11272432'
        WHERE id = '140540273';
[05/20/2024 03:35: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/20_05_2024/request_availability_qtech_agent_15_35_06_1716219306_27.xml', 'a5/20_05_2024/response_availability_qtech_agent_15_35_06_1716219306_27.xml', 'a5/20_05_2024/response_header_availability_qtech_agent_15_35_06_1716219306_27.xml', 'agoda', '2024-05-20 03:35:07', '', '593618ea97450bfcf3a945ac5f0040487d0ad950b86154041629b4ffe0822d5d', '9801040');
[05/20/2024 03:35:07], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '9'
        , request_url = '/call.php?s=agoda&sessionid=593618ea97450bfcf3a945ac5f0040487d0ad950b86154041629b4ffe0822d5d&xml_user_id=1284&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-20 15:35:06.153'
        , request_start_time = '0.029'
        , parsing_start_time = '0.499'
        , mapping_complete_time = '0.040'
        , mongo_start_time = '0.057'
        , search_end_time = '0.038'
        , total_duration = '0.880'
        , error_description = ''
        , memory_used = '10585232'
        WHERE id = '140540275';
[05/20/2024 03:35:07], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '11'
        , request_url = '/call.php?s=agoda&sessionid=593618ea97450bfcf3a945ac5f0040487d0ad950b86154041629b4ffe0822d5d&xml_user_id=1284&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-20 15:35:06.163'
        , request_start_time = '0.025'
        , parsing_start_time = '0.511'
        , mapping_complete_time = '0.048'
        , mongo_start_time = '0.069'
        , search_end_time = '0.045'
        , total_duration = '0.873'
        , error_description = ''
        , memory_used = '11885720'
        WHERE id = '140540274';
[05/20/2024 03:35: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/20_05_2024/request_availability_qtech_agent_15_35_06_1716219306_13.xml', 'a5/20_05_2024/response_availability_qtech_agent_15_35_06_1716219306_13.xml', 'a5/20_05_2024/response_header_availability_qtech_agent_15_35_06_1716219306_13.xml', 'agoda', '2024-05-20 03:35:07', '', '593618ea97450bfcf3a945ac5f0040487d0ad950b86154041629b4ffe0822d5d', '9801040');
[05/20/2024 03:35: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/20_05_2024/request_availability_qtech_agent_15_35_06_1716219306_23.xml', 'a5/20_05_2024/response_availability_qtech_agent_15_35_06_1716219306_23.xml', 'a5/20_05_2024/response_header_availability_qtech_agent_15_35_06_1716219306_23.xml', 'agoda', '2024-05-20 03:35:07', '', '593618ea97450bfcf3a945ac5f0040487d0ad950b86154041629b4ffe0822d5d', '9801040');
[05/20/2024 03:35: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/20_05_2024/request_availability_qtech_agent_15_35_06_1716219306_25.xml', 'a5/20_05_2024/response_availability_qtech_agent_15_35_06_1716219306_25.xml', 'a5/20_05_2024/response_header_availability_qtech_agent_15_35_06_1716219306_25.xml', 'agoda', '2024-05-20 03:35:07', '', '593618ea97450bfcf3a945ac5f0040487d0ad950b86154041629b4ffe0822d5d', '9801040');
[05/20/2024 03:35:07], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '8'
        , request_url = '/call.php?s=agoda&sessionid=593618ea97450bfcf3a945ac5f0040487d0ad950b86154041629b4ffe0822d5d&xml_user_id=1284&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-20 15:35:06.163'
        , request_start_time = '0.031'
        , parsing_start_time = '0.544'
        , mapping_complete_time = '0.071'
        , mongo_start_time = '0.091'
        , search_end_time = '0.043'
        , total_duration = '0.919'
        , error_description = ''
        , memory_used = '11390640'
        WHERE id = '140540277';
[05/20/2024 03:35:07], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '12'
        , request_url = '/call.php?s=agoda&sessionid=593618ea97450bfcf3a945ac5f0040487d0ad950b86154041629b4ffe0822d5d&xml_user_id=1284&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-20 15:35:06.160'
        , request_start_time = '0.029'
        , parsing_start_time = '0.526'
        , mapping_complete_time = '0.053'
        , mongo_start_time = '0.080'
        , search_end_time = '0.052'
        , total_duration = '0.935'
        , error_description = ''
        , memory_used = '11076400'
        WHERE id = '140540276';
[05/20/2024 03:35: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/20_05_2024/request_availability_qtech_agent_15_35_06_1716219306_20.xml', 'a5/20_05_2024/response_availability_qtech_agent_15_35_06_1716219306_20.xml', 'a5/20_05_2024/response_header_availability_qtech_agent_15_35_06_1716219306_20.xml', 'agoda', '2024-05-20 03:35:07', '', '593618ea97450bfcf3a945ac5f0040487d0ad950b86154041629b4ffe0822d5d', '9801040');
[05/20/2024 03:35: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/20_05_2024/request_availability_qtech_agent_15_35_06_1716219306_24.xml', 'a5/20_05_2024/response_availability_qtech_agent_15_35_06_1716219306_24.xml', 'a5/20_05_2024/response_header_availability_qtech_agent_15_35_06_1716219306_24.xml', 'agoda', '2024-05-20 03:35:07', '', '593618ea97450bfcf3a945ac5f0040487d0ad950b86154041629b4ffe0822d5d', '9801040');
[05/20/2024 03:35:07], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '14'
        , request_url = '/call.php?s=agoda&sessionid=593618ea97450bfcf3a945ac5f0040487d0ad950b86154041629b4ffe0822d5d&xml_user_id=1284&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-20 15:35:06.156'
        , request_start_time = '0.025'
        , parsing_start_time = '0.563'
        , mapping_complete_time = '0.077'
        , mongo_start_time = '0.109'
        , search_end_time = '0.049'
        , total_duration = '0.968'
        , error_description = ''
        , memory_used = '13182936'
        WHERE id = '140540278';
[05/20/2024 03:35: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/20_05_2024/request_availability_qtech_agent_15_35_06_1716219306_6.xml', 'a5/20_05_2024/response_availability_qtech_agent_15_35_06_1716219306_6.xml', 'a5/20_05_2024/response_header_availability_qtech_agent_15_35_06_1716219306_6.xml', 'agoda', '2024-05-20 03:35:07', '', '593618ea97450bfcf3a945ac5f0040487d0ad950b86154041629b4ffe0822d5d', '9801040');
[05/20/2024 03:35:07], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '12'
        , request_url = '/call.php?s=agoda&sessionid=593618ea97450bfcf3a945ac5f0040487d0ad950b86154041629b4ffe0822d5d&xml_user_id=1284&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-20 15:35:06.154'
        , request_start_time = '0.033'
        , parsing_start_time = '0.537'
        , mapping_complete_time = '0.075'
        , mongo_start_time = '0.101'
        , search_end_time = '0.050'
        , total_duration = '0.981'
        , error_description = ''
        , memory_used = '11200288'
        WHERE id = '140540280';
[05/20/2024 03:35: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/20_05_2024/request_availability_qtech_agent_15_35_06_1716219306_19.xml', 'a5/20_05_2024/response_availability_qtech_agent_15_35_06_1716219306_19.xml', 'a5/20_05_2024/response_header_availability_qtech_agent_15_35_06_1716219306_19.xml', 'agoda', '2024-05-20 03:35:07', '', '593618ea97450bfcf3a945ac5f0040487d0ad950b86154041629b4ffe0822d5d', '9801040');
[05/20/2024 03:35:07], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '14'
        , request_url = '/call.php?s=agoda&sessionid=593618ea97450bfcf3a945ac5f0040487d0ad950b86154041629b4ffe0822d5d&xml_user_id=1284&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-20 15:35:06.156'
        , request_start_time = '0.021'
        , parsing_start_time = '0.585'
        , mapping_complete_time = '0.047'
        , mongo_start_time = '0.068'
        , search_end_time = '0.095'
        , total_duration = '1.018'
        , error_description = ''
        , memory_used = '16951192'
        WHERE id = '140540279';
[05/20/2024 03:35: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/20_05_2024/request_availability_qtech_agent_15_35_06_1716219306_26.xml', 'a5/20_05_2024/response_availability_qtech_agent_15_35_06_1716219306_26.xml', 'a5/20_05_2024/response_header_availability_qtech_agent_15_35_06_1716219306_26.xml', 'agoda', '2024-05-20 03:35:07', '', '593618ea97450bfcf3a945ac5f0040487d0ad950b86154041629b4ffe0822d5d', '9801040');
[05/20/2024 03:35: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/20_05_2024/request_availability_qtech_agent_15_35_06_1716219306_32.xml', 'a5/20_05_2024/response_availability_qtech_agent_15_35_06_1716219306_32.xml', 'a5/20_05_2024/response_header_availability_qtech_agent_15_35_06_1716219306_32.xml', 'agoda', '2024-05-20 03:35:07', '', '593618ea97450bfcf3a945ac5f0040487d0ad950b86154041629b4ffe0822d5d', '9801040');
[05/20/2024 03:35: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/20_05_2024/request_availability_qtech_agent_15_35_06_1716219306_7.xml', 'a5/20_05_2024/response_availability_qtech_agent_15_35_06_1716219306_7.xml', 'a5/20_05_2024/response_header_availability_qtech_agent_15_35_06_1716219306_7.xml', 'agoda', '2024-05-20 03:35:07', '', '593618ea97450bfcf3a945ac5f0040487d0ad950b86154041629b4ffe0822d5d', '9801040');
[05/20/2024 03:35: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/20_05_2024/request_availability_qtech_agent_15_35_06_1716219306_5.xml', 'a5/20_05_2024/response_availability_qtech_agent_15_35_06_1716219306_5.xml', 'a5/20_05_2024/response_header_availability_qtech_agent_15_35_06_1716219306_5.xml', 'agoda', '2024-05-20 03:35:07', '', '593618ea97450bfcf3a945ac5f0040487d0ad950b86154041629b4ffe0822d5d', '9801040');
[05/20/2024 03:35:07], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '18'
        , request_url = '/call.php?s=agoda&sessionid=593618ea97450bfcf3a945ac5f0040487d0ad950b86154041629b4ffe0822d5d&xml_user_id=1284&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-20 15:35:06.161'
        , request_start_time = '0.024'
        , parsing_start_time = '0.584'
        , mapping_complete_time = '0.083'
        , mongo_start_time = '0.118'
        , search_end_time = '0.081'
        , total_duration = '1.049'
        , error_description = ''
        , memory_used = '14694896'
        WHERE id = '140540281';
[05/20/2024 03:35:07], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '24'
        , request_url = '/call.php?s=agoda&sessionid=593618ea97450bfcf3a945ac5f0040487d0ad950b86154041629b4ffe0822d5d&xml_user_id=1284&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-20 15:35:06.162'
        , request_start_time = '0.036'
        , parsing_start_time = '0.655'
        , mapping_complete_time = '0.070'
        , mongo_start_time = '0.100'
        , search_end_time = '0.067'
        , total_duration = '1.057'
        , error_description = ''
        , memory_used = '14124832'
        WHERE id = '140540282';
[05/20/2024 03:35: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/20_05_2024/request_availability_qtech_agent_15_35_06_1716219306_33.xml', 'a5/20_05_2024/response_availability_qtech_agent_15_35_06_1716219306_33.xml', 'a5/20_05_2024/response_header_availability_qtech_agent_15_35_06_1716219306_33.xml', 'agoda', '2024-05-20 03:35:07', '', '593618ea97450bfcf3a945ac5f0040487d0ad950b86154041629b4ffe0822d5d', '9801040');
[05/20/2024 03:35: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/20_05_2024/request_availability_qtech_agent_15_35_06_1716219306_18.xml', 'a5/20_05_2024/response_availability_qtech_agent_15_35_06_1716219306_18.xml', 'a5/20_05_2024/response_header_availability_qtech_agent_15_35_06_1716219306_18.xml', 'agoda', '2024-05-20 03:35:07', '', '593618ea97450bfcf3a945ac5f0040487d0ad950b86154041629b4ffe0822d5d', '9801040');
[05/20/2024 03:35: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/20_05_2024/request_availability_qtech_agent_15_35_06_1716219306_14.xml', 'a5/20_05_2024/response_availability_qtech_agent_15_35_06_1716219306_14.xml', 'a5/20_05_2024/response_header_availability_qtech_agent_15_35_06_1716219306_14.xml', 'agoda', '2024-05-20 03:35:07', '', '593618ea97450bfcf3a945ac5f0040487d0ad950b86154041629b4ffe0822d5d', '9801040');
[05/20/2024 03:35: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/20_05_2024/request_availability_qtech_agent_15_35_06_1716219306_30.xml', 'a5/20_05_2024/response_availability_qtech_agent_15_35_06_1716219306_30.xml', 'a5/20_05_2024/response_header_availability_qtech_agent_15_35_06_1716219306_30.xml', 'agoda', '2024-05-20 03:35:07', '', '593618ea97450bfcf3a945ac5f0040487d0ad950b86154041629b4ffe0822d5d', '9801040');
[05/20/2024 03:35: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/20_05_2024/request_availability_qtech_agent_15_35_06_1716219306_34.xml', 'a5/20_05_2024/response_availability_qtech_agent_15_35_06_1716219306_34.xml', 'a5/20_05_2024/response_header_availability_qtech_agent_15_35_06_1716219306_34.xml', 'agoda', '2024-05-20 03:35:07', '', '593618ea97450bfcf3a945ac5f0040487d0ad950b86154041629b4ffe0822d5d', '9801040');
[05/20/2024 03:35:07], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '15'
        , request_url = '/call.php?s=agoda&sessionid=593618ea97450bfcf3a945ac5f0040487d0ad950b86154041629b4ffe0822d5d&xml_user_id=1284&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-20 15:35:06.154'
        , request_start_time = '0.021'
        , parsing_start_time = '0.638'
        , mapping_complete_time = '0.085'
        , mongo_start_time = '0.113'
        , search_end_time = '0.093'
        , total_duration = '1.107'
        , error_description = ''
        , memory_used = '12469040'
        WHERE id = '140540284';
[05/20/2024 03:35: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/20_05_2024/request_availability_qtech_agent_15_35_06_1716219306_4.xml', 'a5/20_05_2024/response_availability_qtech_agent_15_35_06_1716219306_4.xml', 'a5/20_05_2024/response_header_availability_qtech_agent_15_35_06_1716219306_4.xml', 'agoda', '2024-05-20 03:35:07', '', '593618ea97450bfcf3a945ac5f0040487d0ad950b86154041629b4ffe0822d5d', '9801040');
[05/20/2024 03:35:07], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '16'
        , request_url = '/call.php?s=agoda&sessionid=593618ea97450bfcf3a945ac5f0040487d0ad950b86154041629b4ffe0822d5d&xml_user_id=1284&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-20 15:35:06.163'
        , request_start_time = '0.024'
        , parsing_start_time = '0.621'
        , mapping_complete_time = '0.102'
        , mongo_start_time = '0.139'
        , search_end_time = '0.115'
        , total_duration = '1.113'
        , error_description = ''
        , memory_used = '14784696'
        WHERE id = '140540283';
[05/20/2024 03:35: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/20_05_2024/request_availability_qtech_agent_15_35_06_1716219306_22.xml', 'a5/20_05_2024/response_availability_qtech_agent_15_35_06_1716219306_22.xml', 'a5/20_05_2024/response_header_availability_qtech_agent_15_35_06_1716219306_22.xml', 'agoda', '2024-05-20 03:35:07', '', '593618ea97450bfcf3a945ac5f0040487d0ad950b86154041629b4ffe0822d5d', '9801040');
[05/20/2024 03:35: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/20_05_2024/request_availability_qtech_agent_15_35_06_1716219306_21.xml', 'a5/20_05_2024/response_availability_qtech_agent_15_35_06_1716219306_21.xml', 'a5/20_05_2024/response_header_availability_qtech_agent_15_35_06_1716219306_21.xml', 'agoda', '2024-05-20 03:35:07', '', '593618ea97450bfcf3a945ac5f0040487d0ad950b86154041629b4ffe0822d5d', '9801040');
[05/20/2024 03:35: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/20_05_2024/request_availability_qtech_agent_15_35_06_1716219306_3.xml', 'a5/20_05_2024/response_availability_qtech_agent_15_35_06_1716219306_3.xml', 'a5/20_05_2024/response_header_availability_qtech_agent_15_35_06_1716219306_3.xml', 'agoda', '2024-05-20 03:35:07', '', '593618ea97450bfcf3a945ac5f0040487d0ad950b86154041629b4ffe0822d5d', '9801040');
[05/20/2024 03:35:07], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '18'
        , request_url = '/call.php?s=agoda&sessionid=593618ea97450bfcf3a945ac5f0040487d0ad950b86154041629b4ffe0822d5d&xml_user_id=1284&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-20 15:35:06.153'
        , request_start_time = '0.031'
        , parsing_start_time = '0.642'
        , mapping_complete_time = '0.121'
        , mongo_start_time = '0.162'
        , search_end_time = '0.082'
        , total_duration = '1.176'
        , error_description = ''
        , memory_used = '14667968'
        WHERE id = '140540286';
[05/20/2024 03:35: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/20_05_2024/request_availability_qtech_agent_15_35_06_1716219306_31.xml', 'a5/20_05_2024/response_availability_qtech_agent_15_35_06_1716219306_31.xml', 'a5/20_05_2024/response_header_availability_qtech_agent_15_35_06_1716219306_31.xml', 'agoda', '2024-05-20 03:35:07', '', '593618ea97450bfcf3a945ac5f0040487d0ad950b86154041629b4ffe0822d5d', '9801040');
[05/20/2024 03:35: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/20_05_2024/request_availability_qtech_agent_15_35_06_1716219306_1.xml', 'a5/20_05_2024/response_availability_qtech_agent_15_35_06_1716219306_1.xml', 'a5/20_05_2024/response_header_availability_qtech_agent_15_35_06_1716219306_1.xml', 'agoda', '2024-05-20 03:35:07', '', '593618ea97450bfcf3a945ac5f0040487d0ad950b86154041629b4ffe0822d5d', '9801040');
[05/20/2024 03:35:07], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '23'
        , request_url = '/call.php?s=agoda&sessionid=593618ea97450bfcf3a945ac5f0040487d0ad950b86154041629b4ffe0822d5d&xml_user_id=1284&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-20 15:35:06.156'
        , request_start_time = '0.042'
        , parsing_start_time = '0.659'
        , mapping_complete_time = '0.139'
        , mongo_start_time = '0.192'
        , search_end_time = '0.082'
        , total_duration = '1.194'
        , error_description = ''
        , memory_used = '15994416'
        WHERE id = '140540287';
[05/20/2024 03:35: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/20_05_2024/request_availability_qtech_agent_15_35_06_1716219306_0.xml', 'a5/20_05_2024/response_availability_qtech_agent_15_35_06_1716219306_0.xml', 'a5/20_05_2024/response_header_availability_qtech_agent_15_35_06_1716219306_0.xml', 'agoda', '2024-05-20 03:35:07', '', '593618ea97450bfcf3a945ac5f0040487d0ad950b86154041629b4ffe0822d5d', '9801040');
[05/20/2024 03:35:07], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '24'
        , request_url = '/call.php?s=agoda&sessionid=593618ea97450bfcf3a945ac5f0040487d0ad950b86154041629b4ffe0822d5d&xml_user_id=1284&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-20 15:35:06.157'
        , request_start_time = '0.021'
        , parsing_start_time = '0.648'
        , mapping_complete_time = '0.128'
        , mongo_start_time = '0.187'
        , search_end_time = '0.113'
        , total_duration = '1.213'
        , error_description = ''
        , memory_used = '18971848'
        WHERE id = '140540285';
[05/20/2024 03:35:07], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '25'
        , request_url = '/call.php?s=agoda&sessionid=593618ea97450bfcf3a945ac5f0040487d0ad950b86154041629b4ffe0822d5d&xml_user_id=1284&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-20 15:35:06.155'
        , request_start_time = '0.028'
        , parsing_start_time = '0.658'
        , mapping_complete_time = '0.123'
        , mongo_start_time = '0.195'
        , search_end_time = '0.075'
        , total_duration = '1.213'
        , error_description = ''
        , memory_used = '13556880'
        WHERE id = '140540289';
[05/20/2024 03:35:07], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '11'
        , request_url = '/call.php?s=agoda&sessionid=593618ea97450bfcf3a945ac5f0040487d0ad950b86154041629b4ffe0822d5d&xml_user_id=1284&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-20 15:35:06.153'
        , request_start_time = '0.032'
        , parsing_start_time = '0.784'
        , mapping_complete_time = '0.056'
        , mongo_start_time = '0.091'
        , search_end_time = '0.062'
        , total_duration = '1.223'
        , error_description = ''
        , memory_used = '10245632'
        WHERE id = '140540292';
[05/20/2024 03:35:07], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '18'
        , request_url = '/call.php?s=agoda&sessionid=593618ea97450bfcf3a945ac5f0040487d0ad950b86154041629b4ffe0822d5d&xml_user_id=1284&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-20 15:35:06.156'
        , request_start_time = '0.029'
        , parsing_start_time = '0.726'
        , mapping_complete_time = '0.103'
        , mongo_start_time = '0.143'
        , search_end_time = '0.075'
        , total_duration = '1.225'
        , error_description = ''
        , memory_used = '14017472'
        WHERE id = '140540290';
[05/20/2024 03:35:07], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '16'
        , request_url = '/call.php?s=agoda&sessionid=593618ea97450bfcf3a945ac5f0040487d0ad950b86154041629b4ffe0822d5d&xml_user_id=1284&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-20 15:35:06.164'
        , request_start_time = '0.029'
        , parsing_start_time = '0.735'
        , mapping_complete_time = '0.127'
        , mongo_start_time = '0.162'
        , search_end_time = '0.072'
        , total_duration = '1.221'
        , error_description = ''
        , memory_used = '14208136'
        WHERE id = '140540291';
[05/20/2024 03:35:07], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '19'
        , request_url = '/call.php?s=agoda&sessionid=593618ea97450bfcf3a945ac5f0040487d0ad950b86154041629b4ffe0822d5d&xml_user_id=1284&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-20 15:35:06.164'
        , request_start_time = '0.020'
        , parsing_start_time = '0.681'
        , mapping_complete_time = '0.137'
        , mongo_start_time = '0.193'
        , search_end_time = '0.129'
        , total_duration = '1.237'
        , error_description = ''
        , memory_used = '19522200'
        WHERE id = '140540288';
[05/20/2024 03:35:07], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '21'
        , request_url = '/call.php?s=agoda&sessionid=593618ea97450bfcf3a945ac5f0040487d0ad950b86154041629b4ffe0822d5d&xml_user_id=1284&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-20 15:35:06.157'
        , request_start_time = '0.026'
        , parsing_start_time = '0.708'
        , mapping_complete_time = '0.158'
        , mongo_start_time = '0.214'
        , search_end_time = '0.075'
        , total_duration = '1.255'
        , error_description = ''
        , memory_used = '17504720'
        WHERE id = '140540294';
[05/20/2024 03:35:07], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '23'
        , request_url = '/call.php?s=agoda&sessionid=593618ea97450bfcf3a945ac5f0040487d0ad950b86154041629b4ffe0822d5d&xml_user_id=1284&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-20 15:35:06.162'
        , request_start_time = '0.030'
        , parsing_start_time = '0.726'
        , mapping_complete_time = '0.142'
        , mongo_start_time = '0.178'
        , search_end_time = '0.088'
        , total_duration = '1.273'
        , error_description = ''
        , memory_used = '15844104'
        WHERE id = '140540297';
[05/20/2024 03:35:07], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '23'
        , request_url = '/call.php?s=agoda&sessionid=593618ea97450bfcf3a945ac5f0040487d0ad950b86154041629b4ffe0822d5d&xml_user_id=1284&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-20 15:35:06.158'
        , request_start_time = '0.035'
        , parsing_start_time = '0.768'
        , mapping_complete_time = '0.143'
        , mongo_start_time = '0.200'
        , search_end_time = '0.083'
        , total_duration = '1.287'
        , error_description = ''
        , memory_used = '16522312'
        WHERE id = '140540296';
[05/20/2024 03:35:07], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '20'
        , request_url = '/call.php?s=agoda&sessionid=593618ea97450bfcf3a945ac5f0040487d0ad950b86154041629b4ffe0822d5d&xml_user_id=1284&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-20 15:35:06.158'
        , request_start_time = '0.019'
        , parsing_start_time = '0.774'
        , mapping_complete_time = '0.145'
        , mongo_start_time = '0.183'
        , search_end_time = '0.085'
        , total_duration = '1.292'
        , error_description = ''
        , memory_used = '15775648'
        WHERE id = '140540298';
[05/20/2024 03:35:07], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '21'
        , request_url = '/call.php?s=agoda&sessionid=593618ea97450bfcf3a945ac5f0040487d0ad950b86154041629b4ffe0822d5d&xml_user_id=1284&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-20 15:35:06.163'
        , request_start_time = '0.029'
        , parsing_start_time = '0.814'
        , mapping_complete_time = '0.109'
        , mongo_start_time = '0.143'
        , search_end_time = '0.061'
        , total_duration = '1.290'
        , error_description = ''
        , memory_used = '17404008'
        WHERE id = '140540299';
[05/20/2024 03:35:07], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '22'
        , request_url = '/call.php?s=agoda&sessionid=593618ea97450bfcf3a945ac5f0040487d0ad950b86154041629b4ffe0822d5d&xml_user_id=1284&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-20 15:35:06.155'
        , request_start_time = '0.029'
        , parsing_start_time = '0.734'
        , mapping_complete_time = '0.119'
        , mongo_start_time = '0.167'
        , search_end_time = '0.140'
        , total_duration = '1.327'
        , error_description = ''
        , memory_used = '19549208'
        WHERE id = '140540295';
[05/20/2024 03:35:07], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '24'
        , request_url = '/call.php?s=agoda&sessionid=593618ea97450bfcf3a945ac5f0040487d0ad950b86154041629b4ffe0822d5d&xml_user_id=1284&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-20 15:35:06.156'
        , request_start_time = '0.022'
        , parsing_start_time = '0.770'
        , mapping_complete_time = '0.171'
        , mongo_start_time = '0.216'
        , search_end_time = '0.070'
        , total_duration = '1.326'
        , error_description = ''
        , memory_used = '17734248'
        WHERE id = '140540300';
[05/20/2024 03:35:07], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '18'
        , request_url = '/call.php?s=agoda&sessionid=593618ea97450bfcf3a945ac5f0040487d0ad950b86154041629b4ffe0822d5d&xml_user_id=1284&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-20 15:35:06.153'
        , request_start_time = '0.031'
        , parsing_start_time = '0.684'
        , mapping_complete_time = '0.192'
        , mongo_start_time = '0.240'
        , search_end_time = '0.187'
        , total_duration = '1.363'
        , error_description = ''
        , memory_used = '20430416'
        WHERE id = '140540293';
[05/20/2024 03:35:07], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '24'
        , request_url = '/call.php?s=agoda&sessionid=593618ea97450bfcf3a945ac5f0040487d0ad950b86154041629b4ffe0822d5d&xml_user_id=1284&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-20 15:35:06.163'
        , request_start_time = '0.024'
        , parsing_start_time = '0.786'
        , mapping_complete_time = '0.151'
        , mongo_start_time = '0.198'
        , search_end_time = '0.090'
        , total_duration = '1.355'
        , error_description = ''
        , memory_used = '16535640'
        WHERE id = '140540301';
[05/20/2024 03:35: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/20_05_2024/request_availability_qtech_agent_15_35_06_1716219306_2.xml', 'a5/20_05_2024/response_availability_qtech_agent_15_35_06_1716219306_2.xml', 'a5/20_05_2024/response_header_availability_qtech_agent_15_35_06_1716219306_2.xml', 'agoda', '2024-05-20 03:35:07', '', '593618ea97450bfcf3a945ac5f0040487d0ad950b86154041629b4ffe0822d5d', '9801040');
[05/20/2024 03:35:07], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '25'
        , request_url = '/call.php?s=agoda&sessionid=593618ea97450bfcf3a945ac5f0040487d0ad950b86154041629b4ffe0822d5d&xml_user_id=1284&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-20 15:35:06.162'
        , request_start_time = '0.021'
        , parsing_start_time = '1.042'
        , mapping_complete_time = '0.115'
        , mongo_start_time = '0.149'
        , search_end_time = '0.062'
        , total_duration = '1.511'
        , error_description = ''
        , memory_used = '17457160'
        WHERE id = '140540302';
[05/20/2024 03:35:07], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '577',
        request_path = '/xml_all.php?userid=1284&sessionid=593618ea97450bfcf3a945ac5f0040487d0ad950b86154041629b4ffe0822d5d',
        duration = '3.224',
        merge_duration = '0.125',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '1.01',
        system_load_5_min = '0.67',
        system_load_15_min = '0.77',
        system_memory_usage = '83.01',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '9801040') + '21049992',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '9801040';
[05/20/2024 03:35:40], [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 = 'monza' , service_name = 'Nine Hotel' , 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-20 15:35:40' , site_id = '' , country_code = '68' , city_code = '54200' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'INR' , currency_code = 'INR' , web_service = '0' ;
[05/20/2024 03:35:42], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '0',
        request_path = '/xml_all.php?userid=1284&sessionid=593618ea97450bfcf3a945ac5f0040487d0ad950b86154041629b4ffe0822d5d',
        duration = '1.103',
        merge_duration = '0.015',
        assigned_supplier_count = '1',
        searched_supplier_count = '',
        system_load_1_min = '0.81',
        system_load_5_min = '0.66',
        system_load_15_min = '0.76',
        system_memory_usage = '83.24',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '9801102') + '6009024',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '9801102';
