        , http_hit_time = '2024-05-18 07:55:49.227'
        , request_start_time = '0.012'
        , parsing_start_time = '0.578'
        , mapping_complete_time = '0.119'
        , mongo_start_time = '0.144'
        , search_end_time = '0.039'
        , total_duration = '0.872'
        , error_description = ''
        , memory_used = '10774664'
        WHERE id = '139902470';
[05/18/2024 07:55:50], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT 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_07_55_49_1716018949_5.xml', 'a5/18_05_2024/response_availability_qtech_agent_07_55_49_1716018949_5.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_07_55_49_1716018949_5.xml', 'agoda', '2024-05-18 07:55:50', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9658601');
[05/18/2024 07:55:50], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '16'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=24&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 07:55:49.231'
        , request_start_time = '0.012'
        , parsing_start_time = '0.632'
        , mapping_complete_time = '0.071'
        , mongo_start_time = '0.098'
        , search_end_time = '0.031'
        , total_duration = '0.875'
        , error_description = ''
        , memory_used = '10292320'
        WHERE id = '139902471';
[05/18/2024 07:55:50], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT 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_07_55_49_1716018949_6.xml', 'a5/18_05_2024/response_availability_qtech_agent_07_55_49_1716018949_6.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_07_55_49_1716018949_6.xml', 'agoda', '2024-05-18 07:55:50', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9658601');
[05/18/2024 07:55:50], [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 07:55:49.231'
        , request_start_time = '0.021'
        , parsing_start_time = '0.638'
        , mapping_complete_time = '0.101'
        , mongo_start_time = '0.126'
        , search_end_time = '0.038'
        , total_duration = '0.887'
        , error_description = ''
        , memory_used = '10946776'
        WHERE id = '139902472';
[05/18/2024 07:55:50], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT 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_07_55_49_1716018949_34.xml', 'a5/18_05_2024/response_availability_qtech_agent_07_55_49_1716018949_34.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_07_55_49_1716018949_34.xml', 'agoda', '2024-05-18 07:55:50', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9658601');
[05/18/2024 07:55:50], [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 07:55:49.232'
        , request_start_time = '0.015'
        , parsing_start_time = '0.640'
        , mapping_complete_time = '0.095'
        , mongo_start_time = '0.120'
        , search_end_time = '0.031'
        , total_duration = '0.905'
        , error_description = ''
        , memory_used = '10123424'
        WHERE id = '139902473';
[05/18/2024 07:55:50], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT 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_07_55_49_1716018949_32.xml', 'a5/18_05_2024/response_availability_qtech_agent_07_55_49_1716018949_32.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_07_55_49_1716018949_32.xml', 'agoda', '2024-05-18 07:55:50', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9658601');
[05/18/2024 07:55:50], [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 07:55:49.224'
        , request_start_time = '0.013'
        , parsing_start_time = '0.675'
        , mapping_complete_time = '0.086'
        , mongo_start_time = '0.109'
        , search_end_time = '0.031'
        , total_duration = '0.928'
        , error_description = ''
        , memory_used = '10128496'
        WHERE id = '139902474';
[05/18/2024 07:55:50], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT 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_07_55_49_1716018949_4.xml', 'a5/18_05_2024/response_availability_qtech_agent_07_55_49_1716018949_4.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_07_55_49_1716018949_4.xml', 'agoda', '2024-05-18 07:55:50', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9658601');
[05/18/2024 07:55:50], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT 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_07_55_49_1716018949_33.xml', 'a5/18_05_2024/response_availability_qtech_agent_07_55_49_1716018949_33.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_07_55_49_1716018949_33.xml', 'agoda', '2024-05-18 07:55:50', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9658601');
[05/18/2024 07:55:50], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '17'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=6&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 07:55:49.226'
        , request_start_time = '0.012'
        , parsing_start_time = '0.732'
        , mapping_complete_time = '0.072'
        , mongo_start_time = '0.099'
        , search_end_time = '0.031'
        , total_duration = '0.958'
        , error_description = ''
        , memory_used = '8866040'
        WHERE id = '139902476';
[05/18/2024 07:55:50], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT 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_07_55_49_1716018949_21.xml', 'a5/18_05_2024/response_availability_qtech_agent_07_55_49_1716018949_21.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_07_55_49_1716018949_21.xml', 'agoda', '2024-05-18 07:55:50', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9658601');
[05/18/2024 07:55:50], [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=5&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 07:55:49.229'
        , request_start_time = '0.013'
        , parsing_start_time = '0.735'
        , mapping_complete_time = '0.074'
        , mongo_start_time = '0.104'
        , search_end_time = '0.045'
        , total_duration = '0.967'
        , error_description = ''
        , memory_used = '9850792'
        WHERE id = '139902475';
[05/18/2024 07:55:50], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT 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_07_55_49_1716018949_0.xml', 'a5/18_05_2024/response_availability_qtech_agent_07_55_49_1716018949_0.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_07_55_49_1716018949_0.xml', 'agoda', '2024-05-18 07:55:50', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9658601');
[05/18/2024 07:55:50], [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 07:55:49.227'
        , request_start_time = '0.016'
        , parsing_start_time = '0.722'
        , mapping_complete_time = '0.090'
        , mongo_start_time = '0.120'
        , search_end_time = '0.028'
        , total_duration = '0.989'
        , error_description = ''
        , memory_used = '11726544'
        WHERE id = '139902478';
[05/18/2024 07:55:50], [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 07:55:49.231'
        , request_start_time = '0.020'
        , parsing_start_time = '0.702'
        , mapping_complete_time = '0.126'
        , mongo_start_time = '0.167'
        , search_end_time = '0.042'
        , total_duration = '0.997'
        , error_description = ''
        , memory_used = '12631536'
        WHERE id = '139902477';
[05/18/2024 07:55:50], [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=4&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 07:55:49.227'
        , request_start_time = '0.013'
        , parsing_start_time = '0.708'
        , mapping_complete_time = '0.114'
        , mongo_start_time = '0.142'
        , search_end_time = '0.033'
        , total_duration = '1.007'
        , error_description = ''
        , memory_used = '11304656'
        WHERE id = '139902479';
[05/18/2024 07:55:50], [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=33&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 07:55:49.230'
        , request_start_time = '0.013'
        , parsing_start_time = '0.789'
        , mapping_complete_time = '0.071'
        , mongo_start_time = '0.095'
        , search_end_time = '0.036'
        , total_duration = '1.013'
        , error_description = ''
        , memory_used = '9863000'
        WHERE id = '139902480';
[05/18/2024 07:55:50], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT 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_07_55_49_1716018949_22.xml', 'a5/18_05_2024/response_availability_qtech_agent_07_55_49_1716018949_22.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_07_55_49_1716018949_22.xml', 'agoda', '2024-05-18 07:55:50', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9658601');
[05/18/2024 07:55:50], [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=21&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 07:55:49.224'
        , request_start_time = '0.011'
        , parsing_start_time = '0.740'
        , mapping_complete_time = '0.123'
        , mongo_start_time = '0.151'
        , search_end_time = '0.034'
        , total_duration = '1.036'
        , error_description = ''
        , memory_used = '11428312'
        WHERE id = '139902481';
[05/18/2024 07:55:50], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT 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_07_55_49_1716018949_2.xml', 'a5/18_05_2024/response_availability_qtech_agent_07_55_49_1716018949_2.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_07_55_49_1716018949_2.xml', 'agoda', '2024-05-18 07:55:50', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9658601');
[05/18/2024 07:55:50], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT 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_07_55_49_1716018949_31.xml', 'a5/18_05_2024/response_availability_qtech_agent_07_55_49_1716018949_31.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_07_55_49_1716018949_31.xml', 'agoda', '2024-05-18 07:55:50', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9658601');
[05/18/2024 07:55:50], [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=0&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 07:55:49.227'
        , request_start_time = '0.011'
        , parsing_start_time = '0.747'
        , mapping_complete_time = '0.147'
        , mongo_start_time = '0.179'
        , search_end_time = '0.043'
        , total_duration = '1.080'
        , error_description = ''
        , memory_used = '13235152'
        WHERE id = '139902482';
[05/18/2024 07:55:50], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '23'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=22&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 07:55:49.226'
        , request_start_time = '0.013'
        , parsing_start_time = '0.771'
        , mapping_complete_time = '0.156'
        , mongo_start_time = '0.196'
        , search_end_time = '0.031'
        , total_duration = '1.112'
        , error_description = ''
        , memory_used = '11927648'
        WHERE id = '139902483';
[05/18/2024 07:55:50], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '24'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=2&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 07:55:49.226'
        , request_start_time = '0.012'
        , parsing_start_time = '0.848'
        , mapping_complete_time = '0.103'
        , mongo_start_time = '0.134'
        , search_end_time = '0.035'
        , total_duration = '1.137'
        , error_description = ''
        , memory_used = '13134384'
        WHERE id = '139902484';
[05/18/2024 07:55:50], [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 07:55:49.226'
        , request_start_time = '0.013'
        , parsing_start_time = '0.882'
        , mapping_complete_time = '0.087'
        , mongo_start_time = '0.118'
        , search_end_time = '0.033'
        , total_duration = '1.153'
        , error_description = ''
        , memory_used = '13133312'
        WHERE id = '139902485';
[05/18/2024 07:55:50], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT 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_07_55_49_1716018949_1.xml', 'a5/18_05_2024/response_availability_qtech_agent_07_55_49_1716018949_1.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_07_55_49_1716018949_1.xml', 'agoda', '2024-05-18 07:55:50', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9658601');
[05/18/2024 07:55:50], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT 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_07_55_49_1716018949_3.xml', 'a5/18_05_2024/response_availability_qtech_agent_07_55_49_1716018949_3.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_07_55_49_1716018949_3.xml', 'agoda', '2024-05-18 07:55:50', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9658601');
[05/18/2024 07:55:50], [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=3&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 07:55:49.230'
        , request_start_time = '0.009'
        , parsing_start_time = '1.008'
        , mapping_complete_time = '0.081'
        , mongo_start_time = '0.106'
        , search_end_time = '0.030'
        , total_duration = '1.249'
        , error_description = ''
        , memory_used = '11124360'
        WHERE id = '139902487';
[05/18/2024 07:55:50], [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=1&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 07:55:49.227'
        , request_start_time = '0.014'
        , parsing_start_time = '0.992'
        , mapping_complete_time = '0.096'
        , mongo_start_time = '0.130'
        , search_end_time = '0.047'
        , total_duration = '1.266'
        , error_description = ''
        , memory_used = '13874408'
        WHERE id = '139902486';
[05/18/2024 07:55:50], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '577',
        request_path = '/xml_all.php?userid=1284&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02',
        duration = '1.688',
        merge_duration = '0.127',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '1.94',
        system_load_5_min = '1.53',
        system_load_15_min = '1.13',
        system_memory_usage = '84.95',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '9658601') + '17750168',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '9658601';
[05/18/2024 07:58:29], [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 07:58:29' , 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 07:58:31], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT 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_07_58_30_1716019110_11.xml', 'a5/18_05_2024/response_availability_qtech_agent_07_58_30_1716019110_11.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_07_58_30_1716019110_11.xml', 'agoda', '2024-05-18 07:58:31', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9658708');
[05/18/2024 07:58:31], [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 07:58:30.784'
        , request_start_time = '0.017'
        , parsing_start_time = '0.345'
        , mapping_complete_time = '0.024'
        , mongo_start_time = '0.034'
        , search_end_time = '0.021'
        , total_duration = '0.481'
        , error_description = ''
        , memory_used = '4243320'
        WHERE id = '139902922';
[05/18/2024 07:58:31], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT 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_07_58_30_1716019110_8.xml', 'a5/18_05_2024/response_availability_qtech_agent_07_58_30_1716019110_8.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_07_58_30_1716019110_8.xml', 'agoda', '2024-05-18 07:58:31', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9658708');
[05/18/2024 07:58:31], [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 07:58:30.781'
        , request_start_time = '0.012'
        , parsing_start_time = '0.373'
        , mapping_complete_time = '0.035'
        , mongo_start_time = '0.046'
        , search_end_time = '0.022'
        , total_duration = '0.537'
        , error_description = ''
        , memory_used = '4988616'
        WHERE id = '139902923';
[05/18/2024 07:58:31], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT 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_07_58_30_1716019110_10.xml', 'a5/18_05_2024/response_availability_qtech_agent_07_58_30_1716019110_10.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_07_58_30_1716019110_10.xml', 'agoda', '2024-05-18 07:58:31', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9658708');
[05/18/2024 07:58:31], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT 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_07_58_30_1716019110_9.xml', 'a5/18_05_2024/response_availability_qtech_agent_07_58_30_1716019110_9.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_07_58_30_1716019110_9.xml', 'agoda', '2024-05-18 07:58:31', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9658708');
[05/18/2024 07:58:31], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT 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_07_58_30_1716019110_15.xml', 'a5/18_05_2024/response_availability_qtech_agent_07_58_30_1716019110_15.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_07_58_30_1716019110_15.xml', 'agoda', '2024-05-18 07:58:31', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9658708');
[05/18/2024 07:58:31], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT 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_07_58_30_1716019110_16.xml', 'a5/18_05_2024/response_availability_qtech_agent_07_58_30_1716019110_16.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_07_58_30_1716019110_16.xml', 'agoda', '2024-05-18 07:58:31', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9658708');
[05/18/2024 07:58:31], [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 07:58:30.781'
        , request_start_time = '0.011'
        , parsing_start_time = '0.463'
        , mapping_complete_time = '0.035'
        , mongo_start_time = '0.048'
        , search_end_time = '0.022'
        , total_duration = '0.612'
        , error_description = ''
        , memory_used = '6198344'
        WHERE id = '139902924';
[05/18/2024 07:58:31], [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 07:58:30.777'
        , request_start_time = '0.013'
        , parsing_start_time = '0.433'
        , mapping_complete_time = '0.048'
        , mongo_start_time = '0.063'
        , search_end_time = '0.026'
        , total_duration = '0.628'
        , error_description = ''
        , memory_used = '7160888'
        WHERE id = '139902925';
[05/18/2024 07:58:31], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT 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_07_58_30_1716019110_17.xml', 'a5/18_05_2024/response_availability_qtech_agent_07_58_30_1716019110_17.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_07_58_30_1716019110_17.xml', 'agoda', '2024-05-18 07:58:31', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9658708');
[05/18/2024 07:58:31], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '15'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=15&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 07:58:30.785'
        , request_start_time = '0.011'
        , parsing_start_time = '0.452'
        , mapping_complete_time = '0.037'
        , mongo_start_time = '0.059'
        , search_end_time = '0.025'
        , total_duration = '0.633'
        , error_description = ''
        , memory_used = '6251912'
        WHERE id = '139902926';
[05/18/2024 07:58:31], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT 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_07_58_30_1716019110_29.xml', 'a5/18_05_2024/response_availability_qtech_agent_07_58_30_1716019110_29.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_07_58_30_1716019110_29.xml', 'agoda', '2024-05-18 07:58:31', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9658708');
[05/18/2024 07:58:31], [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 07:58:30.779'
        , request_start_time = '0.018'
        , parsing_start_time = '0.456'
        , mapping_complete_time = '0.042'
        , mongo_start_time = '0.063'
        , search_end_time = '0.027'
        , total_duration = '0.649'
        , error_description = ''
        , memory_used = '6129552'
        WHERE id = '139902927';
[05/18/2024 07:58:31], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT 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_07_58_30_1716019110_12.xml', 'a5/18_05_2024/response_availability_qtech_agent_07_58_30_1716019110_12.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_07_58_30_1716019110_12.xml', 'agoda', '2024-05-18 07:58:31', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9658708');
[05/18/2024 07:58:31], [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 07:58:30.778'
        , request_start_time = '0.011'
        , parsing_start_time = '0.519'
        , mapping_complete_time = '0.055'
        , mongo_start_time = '0.072'
        , search_end_time = '0.025'
        , total_duration = '0.690'
        , error_description = ''
        , memory_used = '8113184'
        WHERE id = '139902928';
[05/18/2024 07:58:31], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT 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_07_58_30_1716019110_14.xml', 'a5/18_05_2024/response_availability_qtech_agent_07_58_30_1716019110_14.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_07_58_30_1716019110_14.xml', 'agoda', '2024-05-18 07:58:31', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9658708');
[05/18/2024 07:58:31], [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 07:58:30.779'
        , request_start_time = '0.013'
        , parsing_start_time = '0.515'
        , mapping_complete_time = '0.052'
        , mongo_start_time = '0.068'
        , search_end_time = '0.024'
        , total_duration = '0.705'
        , error_description = ''
        , memory_used = '6955136'
        WHERE id = '139902929';
[05/18/2024 07:58:31], [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 07:58:30.778'
        , request_start_time = '0.011'
        , parsing_start_time = '0.541'
        , mapping_complete_time = '0.049'
        , mongo_start_time = '0.070'
        , search_end_time = '0.024'
        , total_duration = '0.723'
        , error_description = ''
        , memory_used = '6848312'
        WHERE id = '139902930';
[05/18/2024 07:58:31], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT 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_07_58_30_1716019110_20.xml', 'a5/18_05_2024/response_availability_qtech_agent_07_58_30_1716019110_20.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_07_58_30_1716019110_20.xml', 'agoda', '2024-05-18 07:58:31', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9658708');
[05/18/2024 07:58:31], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT 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_07_58_30_1716019110_28.xml', 'a5/18_05_2024/response_availability_qtech_agent_07_58_30_1716019110_28.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_07_58_30_1716019110_28.xml', 'agoda', '2024-05-18 07:58:31', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9658708');
[05/18/2024 07:58:31], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT 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_07_58_30_1716019110_27.xml', 'a5/18_05_2024/response_availability_qtech_agent_07_58_30_1716019110_27.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_07_58_30_1716019110_27.xml', 'agoda', '2024-05-18 07:58:31', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9658708');
[05/18/2024 07:58:31], [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 07:58:30.777'
        , request_start_time = '0.014'
        , parsing_start_time = '0.569'
        , mapping_complete_time = '0.042'
        , mongo_start_time = '0.057'
        , search_end_time = '0.023'
        , total_duration = '0.752'
        , error_description = ''
        , memory_used = '6991560'
        WHERE id = '139902931';
[05/18/2024 07:58:31], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT 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_07_58_30_1716019110_13.xml', 'a5/18_05_2024/response_availability_qtech_agent_07_58_30_1716019110_13.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_07_58_30_1716019110_13.xml', 'agoda', '2024-05-18 07:58:31', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9658708');
[05/18/2024 07:58:31], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT 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_07_58_30_1716019110_23.xml', 'a5/18_05_2024/response_availability_qtech_agent_07_58_30_1716019110_23.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_07_58_30_1716019110_23.xml', 'agoda', '2024-05-18 07:58:31', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9658708');
[05/18/2024 07:58:31], [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 07:58:30.780'
        , request_start_time = '0.016'
        , parsing_start_time = '0.588'
        , mapping_complete_time = '0.049'
        , mongo_start_time = '0.064'
        , search_end_time = '0.027'
        , total_duration = '0.785'
        , error_description = ''
        , memory_used = '7280128'
        WHERE id = '139902933';
[05/18/2024 07:58:31], [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=20&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 07:58:30.777'
        , request_start_time = '0.018'
        , parsing_start_time = '0.580'
        , mapping_complete_time = '0.068'
        , mongo_start_time = '0.092'
        , search_end_time = '0.036'
        , total_duration = '0.799'
        , error_description = ''
        , memory_used = '9932000'
        WHERE id = '139902932';
[05/18/2024 07:58:31], [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 07:58:30.779'
        , request_start_time = '0.014'
        , parsing_start_time = '0.584'
        , mapping_complete_time = '0.069'
        , mongo_start_time = '0.090'
        , search_end_time = '0.034'
        , total_duration = '0.810'
        , error_description = ''
        , memory_used = '9401880'
        WHERE id = '139902934';
[05/18/2024 07:58:31], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT 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_07_58_30_1716019110_7.xml', 'a5/18_05_2024/response_availability_qtech_agent_07_58_30_1716019110_7.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_07_58_30_1716019110_7.xml', 'agoda', '2024-05-18 07:58:31', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9658708');
[05/18/2024 07:58:31], [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 07:58:30.782'
        , request_start_time = '0.012'
        , parsing_start_time = '0.632'
        , mapping_complete_time = '0.052'
        , mongo_start_time = '0.072'
        , search_end_time = '0.030'
        , total_duration = '0.829'
        , error_description = ''
        , memory_used = '8146528'
        WHERE id = '139902935';
[05/18/2024 07:58:31], [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 07:58:30.778'
        , request_start_time = '0.013'
        , parsing_start_time = '0.658'
        , mapping_complete_time = '0.052'
        , mongo_start_time = '0.071'
        , search_end_time = '0.030'
        , total_duration = '0.844'
        , error_description = ''
        , memory_used = '8072624'
        WHERE id = '139902936';
[05/18/2024 07:58:31], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT 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_07_58_30_1716019110_19.xml', 'a5/18_05_2024/response_availability_qtech_agent_07_58_30_1716019110_19.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_07_58_30_1716019110_19.xml', 'agoda', '2024-05-18 07:58:31', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9658708');
[05/18/2024 07:58:31], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT 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_07_58_30_1716019110_32.xml', 'a5/18_05_2024/response_availability_qtech_agent_07_58_30_1716019110_32.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_07_58_30_1716019110_32.xml', 'agoda', '2024-05-18 07:58:31', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9658708');
[05/18/2024 07:58:31], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT 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_07_58_30_1716019110_25.xml', 'a5/18_05_2024/response_availability_qtech_agent_07_58_30_1716019110_25.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_07_58_30_1716019110_25.xml', 'agoda', '2024-05-18 07:58:31', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9658708');
[05/18/2024 07:58:31], [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 07:58:30.780'
        , request_start_time = '0.010'
        , parsing_start_time = '0.696'
        , mapping_complete_time = '0.069'
        , mongo_start_time = '0.108'
        , search_end_time = '0.033'
        , total_duration = '0.909'
        , error_description = ''
        , memory_used = '10699320'
        WHERE id = '139902937';
[05/18/2024 07:58:31], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT 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_07_58_30_1716019110_30.xml', 'a5/18_05_2024/response_availability_qtech_agent_07_58_30_1716019110_30.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_07_58_30_1716019110_30.xml', 'agoda', '2024-05-18 07:58:31', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9658708');
[05/18/2024 07:58:31], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT 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_07_58_30_1716019110_22.xml', 'a5/18_05_2024/response_availability_qtech_agent_07_58_30_1716019110_22.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_07_58_30_1716019110_22.xml', 'agoda', '2024-05-18 07:58:31', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9658708');
[05/18/2024 07:58:31], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT 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_07_58_30_1716019110_33.xml', 'a5/18_05_2024/response_availability_qtech_agent_07_58_30_1716019110_33.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_07_58_30_1716019110_33.xml', 'agoda', '2024-05-18 07:58:31', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9658708');
[05/18/2024 07:58:31], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT 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_07_58_30_1716019110_18.xml', 'a5/18_05_2024/response_availability_qtech_agent_07_58_30_1716019110_18.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_07_58_30_1716019110_18.xml', 'agoda', '2024-05-18 07:58:31', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9658708');
[05/18/2024 07:58:31], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT 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_07_58_30_1716019110_6.xml', 'a5/18_05_2024/response_availability_qtech_agent_07_58_30_1716019110_6.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_07_58_30_1716019110_6.xml', 'agoda', '2024-05-18 07:58:31', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9658708');
[05/18/2024 07:58:31], [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 07:58:30.776'
        , request_start_time = '0.012'
        , parsing_start_time = '0.666'
        , mapping_complete_time = '0.106'
        , mongo_start_time = '0.140'
        , search_end_time = '0.037'
        , total_duration = '0.944'
        , error_description = ''
        , memory_used = '10007280'
        WHERE id = '139902938';
[05/18/2024 07:58:31], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT 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_07_58_30_1716019110_34.xml', 'a5/18_05_2024/response_availability_qtech_agent_07_58_30_1716019110_34.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_07_58_30_1716019110_34.xml', 'agoda', '2024-05-18 07:58:31', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9658708');
[05/18/2024 07:58:31], [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 07:58:30.779'
        , request_start_time = '0.019'
        , parsing_start_time = '0.719'
        , mapping_complete_time = '0.084'
        , mongo_start_time = '0.116'
        , search_end_time = '0.039'
        , total_duration = '0.948'
        , error_description = ''
        , memory_used = '12102864'
        WHERE id = '139902939';
[05/18/2024 07:58:31], [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 07:58:30.783'
        , request_start_time = '0.014'
        , parsing_start_time = '0.699'
        , mapping_complete_time = '0.081'
        , mongo_start_time = '0.114'
        , search_end_time = '0.040'
        , total_duration = '0.956'
        , error_description = ''
        , memory_used = '10426176'
        WHERE id = '139902940';
[05/18/2024 07:58:31], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT 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_07_58_30_1716019110_26.xml', 'a5/18_05_2024/response_availability_qtech_agent_07_58_30_1716019110_26.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_07_58_30_1716019110_26.xml', 'agoda', '2024-05-18 07:58:31', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9658708');
[05/18/2024 07:58:31], [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 07:58:30.780'
        , request_start_time = '0.012'
        , parsing_start_time = '0.698'
        , mapping_complete_time = '0.127'
        , mongo_start_time = '0.154'
        , search_end_time = '0.032'
        , total_duration = '0.991'
        , error_description = ''
        , memory_used = '11183200'
        WHERE id = '139902941';
[05/18/2024 07:58:31], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '23'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=22&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 07:58:30.778'
        , request_start_time = '0.012'
        , parsing_start_time = '0.702'
        , mapping_complete_time = '0.128'
        , mongo_start_time = '0.157'
        , search_end_time = '0.031'
        , total_duration = '1.000'
        , error_description = ''
        , memory_used = '11990496'
        WHERE id = '139902942';
[05/18/2024 07:58:31], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT 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_07_58_30_1716019110_0.xml', 'a5/18_05_2024/response_availability_qtech_agent_07_58_30_1716019110_0.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_07_58_30_1716019110_0.xml', 'agoda', '2024-05-18 07:58:31', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9658708');
[05/18/2024 07:58:31], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT 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_07_58_30_1716019110_5.xml', 'a5/18_05_2024/response_availability_qtech_agent_07_58_30_1716019110_5.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_07_58_30_1716019110_5.xml', 'agoda', '2024-05-18 07:58:31', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9658708');
[05/18/2024 07:58:31], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT 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_07_58_30_1716019110_24.xml', 'a5/18_05_2024/response_availability_qtech_agent_07_58_30_1716019110_24.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_07_58_30_1716019110_24.xml', 'agoda', '2024-05-18 07:58:31', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9658708');
[05/18/2024 07:58:31], [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=33&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 07:58:30.784'
        , request_start_time = '0.016'
        , parsing_start_time = '0.737'
        , mapping_complete_time = '0.100'
        , mongo_start_time = '0.124'
        , search_end_time = '0.035'
        , total_duration = '1.000'
        , error_description = ''
        , memory_used = '9874360'
        WHERE id = '139902943';
[05/18/2024 07:58:31], [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 07:58:30.784'
        , request_start_time = '0.016'
        , parsing_start_time = '0.722'
        , mapping_complete_time = '0.126'
        , mongo_start_time = '0.150'
        , search_end_time = '0.038'
        , total_duration = '1.011'
        , error_description = ''
        , memory_used = '10128368'
        WHERE id = '139902944';
[05/18/2024 07:58:31], [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 07:58:30.779'
        , request_start_time = '0.014'
        , parsing_start_time = '0.746'
        , mapping_complete_time = '0.127'
        , mongo_start_time = '0.160'
        , search_end_time = '0.029'
        , total_duration = '1.022'
        , error_description = ''
        , memory_used = '12512888'
        WHERE id = '139902946';
[05/18/2024 07:58:31], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT 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_07_58_30_1716019110_21.xml', 'a5/18_05_2024/response_availability_qtech_agent_07_58_30_1716019110_21.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_07_58_30_1716019110_21.xml', 'agoda', '2024-05-18 07:58:31', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9658708');
[05/18/2024 07:58:31], [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=6&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 07:58:30.779'
        , request_start_time = '0.014'
        , parsing_start_time = '0.757'
        , mapping_complete_time = '0.101'
        , mongo_start_time = '0.130'
        , search_end_time = '0.036'
        , total_duration = '1.029'
        , error_description = ''
        , memory_used = '8651400'
        WHERE id = '139902945';
[05/18/2024 07:58:31], [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=26&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 07:58:30.783'
        , request_start_time = '0.013'
        , parsing_start_time = '0.768'
        , mapping_complete_time = '0.119'
        , mongo_start_time = '0.143'
        , search_end_time = '0.035'
        , total_duration = '1.036'
        , error_description = ''
        , memory_used = '10229664'
        WHERE id = '139902947';
[05/18/2024 07:58:31], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT 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_07_58_30_1716019110_4.xml', 'a5/18_05_2024/response_availability_qtech_agent_07_58_30_1716019110_4.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_07_58_30_1716019110_4.xml', 'agoda', '2024-05-18 07:58:31', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9658708');
[05/18/2024 07:58:31], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT 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_07_58_30_1716019110_31.xml', 'a5/18_05_2024/response_availability_qtech_agent_07_58_30_1716019110_31.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_07_58_30_1716019110_31.xml', 'agoda', '2024-05-18 07:58:31', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9658708');
[05/18/2024 07:58:31], [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=5&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 07:58:30.780'
        , request_start_time = '0.013'
        , parsing_start_time = '0.843'
        , mapping_complete_time = '0.075'
        , mongo_start_time = '0.099'
        , search_end_time = '0.032'
        , total_duration = '1.079'
        , error_description = ''
        , memory_used = '9850992'
        WHERE id = '139902949';
[05/18/2024 07:58:31], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT 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_07_58_30_1716019110_2.xml', 'a5/18_05_2024/response_availability_qtech_agent_07_58_30_1716019110_2.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_07_58_30_1716019110_2.xml', 'agoda', '2024-05-18 07:58:31', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9658708');
[05/18/2024 07:58:31], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '16'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=24&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 07:58:30.779'
        , request_start_time = '0.016'
        , parsing_start_time = '0.790'
        , mapping_complete_time = '0.136'
        , mongo_start_time = '0.168'
        , search_end_time = '0.054'
        , total_duration = '1.116'
        , error_description = ''
        , memory_used = '10279448'
        WHERE id = '139902950';
[05/18/2024 07:58:31], [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=0&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 07:58:30.783'
        , request_start_time = '0.011'
        , parsing_start_time = '0.777'
        , mapping_complete_time = '0.162'
        , mongo_start_time = '0.201'
        , search_end_time = '0.065'
        , total_duration = '1.120'
        , error_description = ''
        , memory_used = '13329296'
        WHERE id = '139902948';
[05/18/2024 07:58:31], [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=21&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 07:58:30.777'
        , request_start_time = '0.011'
        , parsing_start_time = '0.851'
        , mapping_complete_time = '0.116'
        , mongo_start_time = '0.148'
        , search_end_time = '0.053'
        , total_duration = '1.134'
        , error_description = ''
        , memory_used = '11546352'
        WHERE id = '139902951';
[05/18/2024 07:58:31], [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=4&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 07:58:30.783'
        , request_start_time = '0.011'
        , parsing_start_time = '0.922'
        , mapping_complete_time = '0.079'
        , mongo_start_time = '0.106'
        , search_end_time = '0.036'
        , total_duration = '1.138'
        , error_description = ''
        , memory_used = '11411944'
        WHERE id = '139902952';
[05/18/2024 07:58:31], [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 07:58:30.784'
        , request_start_time = '0.021'
        , parsing_start_time = '0.855'
        , mapping_complete_time = '0.136'
        , mongo_start_time = '0.166'
        , search_end_time = '0.035'
        , total_duration = '1.149'
        , error_description = ''
        , memory_used = '12969872'
        WHERE id = '139902953';
[05/18/2024 07:58:31], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT 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_07_58_30_1716019110_1.xml', 'a5/18_05_2024/response_availability_qtech_agent_07_58_30_1716019110_1.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_07_58_30_1716019110_1.xml', 'agoda', '2024-05-18 07:58:31', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9658708');
[05/18/2024 07:58:31], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '25'
        , request_url = '/call.php?s=agoda&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=2&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 07:58:30.779'
        , request_start_time = '0.026'
        , parsing_start_time = '0.911'
        , mapping_complete_time = '0.106'
        , mongo_start_time = '0.137'
        , search_end_time = '0.034'
        , total_duration = '1.181'
        , error_description = ''
        , memory_used = '13233008'
        WHERE id = '139902954';
[05/18/2024 07:58:32], [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=1&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 07:58:30.783'
        , request_start_time = '0.018'
        , parsing_start_time = '1.006'
        , mapping_complete_time = '0.097'
        , mongo_start_time = '0.145'
        , search_end_time = '0.061'
        , total_duration = '1.296'
        , error_description = ''
        , memory_used = '14152144'
        WHERE id = '139902955';
[05/18/2024 07:58:32], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT 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_07_58_30_1716019110_3.xml', 'a5/18_05_2024/response_availability_qtech_agent_07_58_30_1716019110_3.xml', 'a5/18_05_2024/response_header_availability_qtech_agent_07_58_30_1716019110_3.xml', 'agoda', '2024-05-18 07:58:32', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9658708');
[05/18/2024 07:58:32], [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=3&total_request=35&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-18 07:58:30.778'
        , request_start_time = '0.016'
        , parsing_start_time = '1.406'
        , mapping_complete_time = '0.098'
        , mongo_start_time = '0.129'
        , search_end_time = '0.043'
        , total_duration = '1.684'
        , error_description = ''
        , memory_used = '13258224'
        WHERE id = '139902977';
[05/18/2024 07:58:32], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '579',
        request_path = '/xml_all.php?userid=1284&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02',
        duration = '2.088',
        merge_duration = '0.121',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '0.56',
        system_load_5_min = '1.09',
        system_load_15_min = '1.03',
        system_memory_usage = '84.87',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '9658708') + '17825128',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '9658708';
