[09/23/2024 02:04:41], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-09-23 14:04:41.441'
            , total_duration = '0.116'
            , hotel_count = 0
            , source_type = 'agoda'
            , create_date = '2024-09-23 02:04:41'
            , session_id = '24062320240913204818945651649'
            , agent_logs_id = ''
            , error_description = ''
            , memory_used = '2934480';
[09/23/2024 02:20:30], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-09-23 02:20:30',login_attempt=0 where id = '2406';
[09/23/2024 02:20:30], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Qtech_pranali', user_type = 'A', branch_id = '26', login_datetime = '2024-09-23 14:20:30', ip = '43.239.53.130', action = 'Login' ;
[09/23/2024 02:20:46], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '2406' , 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 = '106' , service_type = 'hotel' , arrival_date = '2024/10/31' , departure_date = '2024/11/01' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-09-23 14:20:46' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[09/23/2024 02:20:47], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_2406_24062320240914204612500422642', session_id='24062320240914204612500422642', Collection_create_time='2024-09-23 14:20:47';
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'a5/23_09_2024/request_availability_Qtech_pranali_14_20_48_1727101248_2.json', 'a5/23_09_2024/response_availability_Qtech_pranali_14_20_48_1727101248_2.json', 'a5/23_09_2024/response_header_availability_Qtech_pranali_14_20_48_1727101248_2.json', 'agoda', '2024-09-23 02:20:48', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/23_09_2024/response_availability_Qtech_pranali_14_20_48_1727101248_2.json');
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-09-23 02:20:48', '', '24062320240914204612500422642', '16479389', 'localsystem/response_placeholder.xml');
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062320240914204612500422642&xml_user_id=2406&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=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:20:48.191'
        , request_start_time = '0.037'
        , parsing_start_time = '0.095'
        , mapping_complete_time = '0.067'
        , mongo_start_time = '0.079'
        , search_end_time = '0.000'
        , total_duration = '0.270'
        , error_description = ''
        , memory_used = '2971720'
        WHERE id = '187276589';
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-09-23 02:20:48', '', '24062320240914204612500422642', '16479389', 'localsystem/response_placeholder.xml');
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-09-23 02:20:48', '', '24062320240914204612500422642', '16479389', 'localsystem/response_placeholder.xml');
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-09-23 02:20:48', '', '24062320240914204612500422642', '16479389', 'localsystem/response_placeholder.xml');
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-09-23 02:20:48', '', '24062320240914204612500422642', '16479389', 'localsystem/response_placeholder.xml');
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-09-23 02:20:48', '', '24062320240914204612500422642', '16479389', 'localsystem/response_placeholder.xml');
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-09-23 02:20:48', '', '24062320240914204612500422642', '16479389', 'localsystem/response_placeholder.xml');
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-09-23 02:20:48', '', '24062320240914204612500422642', '16479389', 'localsystem/response_placeholder.xml');
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'a5/23_09_2024/request_availability_Qtech_pranali_14_20_48_1727101248_6.json', 'a5/23_09_2024/response_availability_Qtech_pranali_14_20_48_1727101248_6.json', 'a5/23_09_2024/response_header_availability_Qtech_pranali_14_20_48_1727101248_6.json', 'agoda', '2024-09-23 02:20:48', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/23_09_2024/response_availability_Qtech_pranali_14_20_48_1727101248_6.json');
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-09-23 02:20:48', '', '24062320240914204612500422642', '16479389', 'localsystem/response_placeholder.xml');
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-09-23 02:20:48', '', '24062320240914204612500422642', '16479389', 'localsystem/response_placeholder.xml');
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-09-23 02:20:48', '', '24062320240914204612500422642', '16479389', 'localsystem/response_placeholder.xml');
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-09-23 02:20:48', '', '24062320240914204612500422642', '16479389', 'localsystem/response_placeholder.xml');
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'a5/23_09_2024/request_availability_Qtech_pranali_14_20_48_1727101248_4.json', 'a5/23_09_2024/response_availability_Qtech_pranali_14_20_48_1727101248_4.json', 'a5/23_09_2024/response_header_availability_Qtech_pranali_14_20_48_1727101248_4.json', 'agoda', '2024-09-23 02:20:48', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/23_09_2024/response_availability_Qtech_pranali_14_20_48_1727101248_4.json');
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-09-23 02:20:48', '', '24062320240914204612500422642', '16479389', 'localsystem/response_placeholder.xml');
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-09-23 02:20:48', '', '24062320240914204612500422642', '16479389', 'localsystem/response_placeholder.xml');
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-09-23 02:20:48', '', '24062320240914204612500422642', '16479389', 'localsystem/response_placeholder.xml');
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-09-23 02:20:48', '', '24062320240914204612500422642', '16479389', 'localsystem/response_placeholder.xml');
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-09-23 02:20:48', '', '24062320240914204612500422642', '16479389', 'localsystem/response_placeholder.xml');
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'a5/23_09_2024/request_availability_Qtech_pranali_14_20_48_1727101248_5.json', 'a5/23_09_2024/response_availability_Qtech_pranali_14_20_48_1727101248_5.json', 'a5/23_09_2024/response_header_availability_Qtech_pranali_14_20_48_1727101248_5.json', 'agoda', '2024-09-23 02:20:48', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/23_09_2024/response_availability_Qtech_pranali_14_20_48_1727101248_5.json');
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-09-23 02:20:48', '', '24062320240914204612500422642', '16479389', 'localsystem/response_placeholder.xml');
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-09-23 02:20:48', '', '24062320240914204612500422642', '16479389', 'localsystem/response_placeholder.xml');
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-09-23 02:20:48', '', '24062320240914204612500422642', '16479389', 'localsystem/response_placeholder.xml');
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-09-23 02:20:48', '', '24062320240914204612500422642', '16479389', 'localsystem/response_placeholder.xml');
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'a5/23_09_2024/request_availability_Qtech_pranali_14_20_48_1727101248_0.json', 'a5/23_09_2024/response_availability_Qtech_pranali_14_20_48_1727101248_0.json', 'a5/23_09_2024/response_header_availability_Qtech_pranali_14_20_48_1727101248_0.json', 'agoda', '2024-09-23 02:20:48', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/23_09_2024/response_availability_Qtech_pranali_14_20_48_1727101248_0.json');
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-09-23 02:20:48', '', '24062320240914204612500422642', '16479389', 'localsystem/response_placeholder.xml');
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-09-23 02:20:48', '', '24062320240914204612500422642', '16479389', 'localsystem/response_placeholder.xml');
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-09-23 02:20:48', '', '24062320240914204612500422642', '16479389', 'localsystem/response_placeholder.xml');
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'a5/23_09_2024/request_availability_Qtech_pranali_14_20_48_1727101248_9.json', 'a5/23_09_2024/response_availability_Qtech_pranali_14_20_48_1727101248_9.json', 'a5/23_09_2024/response_header_availability_Qtech_pranali_14_20_48_1727101248_9.json', 'agoda', '2024-09-23 02:20:48', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/23_09_2024/response_availability_Qtech_pranali_14_20_48_1727101248_9.json');
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'a5/23_09_2024/request_availability_Qtech_pranali_14_20_48_1727101248_1.json', 'a5/23_09_2024/response_availability_Qtech_pranali_14_20_48_1727101248_1.json', 'a5/23_09_2024/response_header_availability_Qtech_pranali_14_20_48_1727101248_1.json', 'agoda', '2024-09-23 02:20:48', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/23_09_2024/response_availability_Qtech_pranali_14_20_48_1727101248_1.json');
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'a5/23_09_2024/request_availability_Qtech_pranali_14_20_48_1727101248_7.json', 'a5/23_09_2024/response_availability_Qtech_pranali_14_20_48_1727101248_7.json', 'a5/23_09_2024/response_header_availability_Qtech_pranali_14_20_48_1727101248_7.json', 'agoda', '2024-09-23 02:20:48', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/23_09_2024/response_availability_Qtech_pranali_14_20_48_1727101248_7.json');
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-09-23 02:20:48', '', '24062320240914204612500422642', '16479389', 'localsystem/response_placeholder.xml');
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-09-23 02:20:48', '', '24062320240914204612500422642', '16479389', 'localsystem/response_placeholder.xml');
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'a5/23_09_2024/request_availability_Qtech_pranali_14_20_48_1727101248_10.json', 'a5/23_09_2024/response_availability_Qtech_pranali_14_20_48_1727101248_10.json', 'a5/23_09_2024/response_header_availability_Qtech_pranali_14_20_48_1727101248_10.json', 'agoda', '2024-09-23 02:20:48', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/23_09_2024/response_availability_Qtech_pranali_14_20_48_1727101248_10.json');
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'a5/23_09_2024/request_availability_Qtech_pranali_14_20_48_1727101248_3.json', 'a5/23_09_2024/response_availability_Qtech_pranali_14_20_48_1727101248_3.json', 'a5/23_09_2024/response_header_availability_Qtech_pranali_14_20_48_1727101248_3.json', 'agoda', '2024-09-23 02:20:48', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/23_09_2024/response_availability_Qtech_pranali_14_20_48_1727101248_3.json');
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'a5/23_09_2024/request_availability_Qtech_pranali_14_20_48_1727101248_11.json', 'a5/23_09_2024/response_availability_Qtech_pranali_14_20_48_1727101248_11.json', 'a5/23_09_2024/response_header_availability_Qtech_pranali_14_20_48_1727101248_11.json', 'agoda', '2024-09-23 02:20:48', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/23_09_2024/response_availability_Qtech_pranali_14_20_48_1727101248_11.json');
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'a5/23_09_2024/request_availability_Qtech_pranali_14_20_48_1727101248_8.json', 'a5/23_09_2024/response_availability_Qtech_pranali_14_20_48_1727101248_8.json', 'a5/23_09_2024/response_header_availability_Qtech_pranali_14_20_48_1727101248_8.json', 'agoda', '2024-09-23 02:20:48', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/23_09_2024/response_availability_Qtech_pranali_14_20_48_1727101248_8.json');
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'a5/23_09_2024/request_availability_Qtech_pranali_14_20_48_1727101248_13.json', 'a5/23_09_2024/response_availability_Qtech_pranali_14_20_48_1727101248_13.json', 'a5/23_09_2024/response_header_availability_Qtech_pranali_14_20_48_1727101248_13.json', 'agoda', '2024-09-23 02:20:48', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/23_09_2024/response_availability_Qtech_pranali_14_20_48_1727101248_13.json');
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062320240914204612500422642&xml_user_id=2406&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=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:20:48.203'
        , request_start_time = '0.033'
        , parsing_start_time = '0.118'
        , mapping_complete_time = '0.166'
        , mongo_start_time = '0.189'
        , search_end_time = '0.000'
        , total_duration = '0.400'
        , error_description = ''
        , memory_used = '2971704'
        WHERE id = '187276598';
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'a5/23_09_2024/request_availability_Qtech_pranali_14_20_48_1727101248_16.json', 'a5/23_09_2024/response_availability_Qtech_pranali_14_20_48_1727101248_16.json', 'a5/23_09_2024/response_header_availability_Qtech_pranali_14_20_48_1727101248_16.json', 'agoda', '2024-09-23 02:20:48', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/23_09_2024/response_availability_Qtech_pranali_14_20_48_1727101248_16.json');
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'a5/23_09_2024/request_availability_Qtech_pranali_14_20_48_1727101248_12.json', 'a5/23_09_2024/response_availability_Qtech_pranali_14_20_48_1727101248_12.json', 'a5/23_09_2024/response_header_availability_Qtech_pranali_14_20_48_1727101248_12.json', 'agoda', '2024-09-23 02:20:48', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/23_09_2024/response_availability_Qtech_pranali_14_20_48_1727101248_12.json');
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062320240914204612500422642&xml_user_id=2406&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=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:20:48.197'
        , request_start_time = '0.034'
        , parsing_start_time = '0.102'
        , mapping_complete_time = '0.204'
        , mongo_start_time = '0.223'
        , search_end_time = '0.000'
        , total_duration = '0.412'
        , error_description = ''
        , memory_used = '2971720'
        WHERE id = '187276605';
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'a5/23_09_2024/request_availability_Qtech_pranali_14_20_48_1727101248_18.json', 'a5/23_09_2024/response_availability_Qtech_pranali_14_20_48_1727101248_18.json', 'a5/23_09_2024/response_header_availability_Qtech_pranali_14_20_48_1727101248_18.json', 'agoda', '2024-09-23 02:20:48', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/23_09_2024/response_availability_Qtech_pranali_14_20_48_1727101248_18.json');
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'a5/23_09_2024/request_availability_Qtech_pranali_14_20_48_1727101248_14.json', 'a5/23_09_2024/response_availability_Qtech_pranali_14_20_48_1727101248_14.json', 'a5/23_09_2024/response_header_availability_Qtech_pranali_14_20_48_1727101248_14.json', 'agoda', '2024-09-23 02:20:48', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/23_09_2024/response_availability_Qtech_pranali_14_20_48_1727101248_14.json');
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062320240914204612500422642&xml_user_id=2406&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=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:20:48.187'
        , request_start_time = '0.060'
        , parsing_start_time = '0.113'
        , mapping_complete_time = '0.176'
        , mongo_start_time = '0.205'
        , search_end_time = '0.000'
        , total_duration = '0.427'
        , error_description = ''
        , memory_used = '2970992'
        WHERE id = '187276611';
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062320240914204612500422642&xml_user_id=2406&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=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:20:48.200'
        , request_start_time = '0.029'
        , parsing_start_time = '0.099'
        , mapping_complete_time = '0.193'
        , mongo_start_time = '0.221'
        , search_end_time = '0.000'
        , total_duration = '0.413'
        , error_description = ''
        , memory_used = '2971712'
        WHERE id = '187276607';
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062320240914204612500422642&xml_user_id=2406&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=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:20:48.188'
        , request_start_time = '0.055'
        , parsing_start_time = '0.130'
        , mapping_complete_time = '0.169'
        , mongo_start_time = '0.194'
        , search_end_time = '0.000'
        , total_duration = '0.430'
        , error_description = ''
        , memory_used = '2971720'
        WHERE id = '187276618';
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'a5/23_09_2024/request_availability_Qtech_pranali_14_20_48_1727101248_17.json', 'a5/23_09_2024/response_availability_Qtech_pranali_14_20_48_1727101248_17.json', 'a5/23_09_2024/response_header_availability_Qtech_pranali_14_20_48_1727101248_17.json', 'agoda', '2024-09-23 02:20:48', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/23_09_2024/response_availability_Qtech_pranali_14_20_48_1727101248_17.json');
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'a5/23_09_2024/request_availability_Qtech_pranali_14_20_48_1727101248_15.json', 'a5/23_09_2024/response_availability_Qtech_pranali_14_20_48_1727101248_15.json', 'a5/23_09_2024/response_header_availability_Qtech_pranali_14_20_48_1727101248_15.json', 'agoda', '2024-09-23 02:20:48', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/23_09_2024/response_availability_Qtech_pranali_14_20_48_1727101248_15.json');
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062320240914204612500422642&xml_user_id=2406&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=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:20:48.213'
        , request_start_time = '0.026'
        , parsing_start_time = '0.173'
        , mapping_complete_time = '0.112'
        , mongo_start_time = '0.142'
        , search_end_time = '0.000'
        , total_duration = '0.415'
        , error_description = ''
        , memory_used = '2971792'
        WHERE id = '187276619';
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'a5/23_09_2024/request_availability_Qtech_pranali_14_20_48_1727101248_28.json', 'a5/23_09_2024/response_availability_Qtech_pranali_14_20_48_1727101248_28.json', 'a5/23_09_2024/response_header_availability_Qtech_pranali_14_20_48_1727101248_28.json', 'agoda', '2024-09-23 02:20:48', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/23_09_2024/response_availability_Qtech_pranali_14_20_48_1727101248_28.json');
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'a5/23_09_2024/request_availability_Qtech_pranali_14_20_48_1727101248_20.json', 'a5/23_09_2024/response_availability_Qtech_pranali_14_20_48_1727101248_20.json', 'a5/23_09_2024/response_header_availability_Qtech_pranali_14_20_48_1727101248_20.json', 'agoda', '2024-09-23 02:20:48', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/23_09_2024/response_availability_Qtech_pranali_14_20_48_1727101248_20.json');
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'a5/23_09_2024/request_availability_Qtech_pranali_14_20_48_1727101248_21.json', 'a5/23_09_2024/response_availability_Qtech_pranali_14_20_48_1727101248_21.json', 'a5/23_09_2024/response_header_availability_Qtech_pranali_14_20_48_1727101248_21.json', 'agoda', '2024-09-23 02:20:48', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/23_09_2024/response_availability_Qtech_pranali_14_20_48_1727101248_21.json');
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'a5/23_09_2024/request_availability_Qtech_pranali_14_20_48_1727101248_24.json', 'a5/23_09_2024/response_availability_Qtech_pranali_14_20_48_1727101248_24.json', 'a5/23_09_2024/response_header_availability_Qtech_pranali_14_20_48_1727101248_24.json', 'agoda', '2024-09-23 02:20:48', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/23_09_2024/response_availability_Qtech_pranali_14_20_48_1727101248_24.json');
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062320240914204612500422642&xml_user_id=2406&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=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:20:48.210'
        , request_start_time = '0.046'
        , parsing_start_time = '0.132'
        , mapping_complete_time = '0.180'
        , mongo_start_time = '0.212'
        , search_end_time = '0.000'
        , total_duration = '0.445'
        , error_description = ''
        , memory_used = '2971704'
        WHERE id = '187276620';
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'a5/23_09_2024/request_availability_Qtech_pranali_14_20_48_1727101248_33.json', 'a5/23_09_2024/response_availability_Qtech_pranali_14_20_48_1727101248_33.json', 'a5/23_09_2024/response_header_availability_Qtech_pranali_14_20_48_1727101248_33.json', 'agoda', '2024-09-23 02:20:48', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/23_09_2024/response_availability_Qtech_pranali_14_20_48_1727101248_33.json');
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062320240914204612500422642&xml_user_id=2406&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=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:20:48.217'
        , request_start_time = '0.031'
        , parsing_start_time = '0.123'
        , mapping_complete_time = '0.179'
        , mongo_start_time = '0.215'
        , search_end_time = '0.000'
        , total_duration = '0.441'
        , error_description = ''
        , memory_used = '2971800'
        WHERE id = '187276623';
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'a5/23_09_2024/request_availability_Qtech_pranali_14_20_48_1727101248_25.json', 'a5/23_09_2024/response_availability_Qtech_pranali_14_20_48_1727101248_25.json', 'a5/23_09_2024/response_header_availability_Qtech_pranali_14_20_48_1727101248_25.json', 'agoda', '2024-09-23 02:20:48', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/23_09_2024/response_availability_Qtech_pranali_14_20_48_1727101248_25.json');
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'a5/23_09_2024/request_availability_Qtech_pranali_14_20_48_1727101248_23.json', 'a5/23_09_2024/response_availability_Qtech_pranali_14_20_48_1727101248_23.json', 'a5/23_09_2024/response_header_availability_Qtech_pranali_14_20_48_1727101248_23.json', 'agoda', '2024-09-23 02:20:48', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/23_09_2024/response_availability_Qtech_pranali_14_20_48_1727101248_23.json');
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'a5/23_09_2024/request_availability_Qtech_pranali_14_20_48_1727101248_22.json', 'a5/23_09_2024/response_availability_Qtech_pranali_14_20_48_1727101248_22.json', 'a5/23_09_2024/response_header_availability_Qtech_pranali_14_20_48_1727101248_22.json', 'agoda', '2024-09-23 02:20:48', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/23_09_2024/response_availability_Qtech_pranali_14_20_48_1727101248_22.json');
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'a5/23_09_2024/request_availability_Qtech_pranali_14_20_48_1727101248_27.json', 'a5/23_09_2024/response_availability_Qtech_pranali_14_20_48_1727101248_27.json', 'a5/23_09_2024/response_header_availability_Qtech_pranali_14_20_48_1727101248_27.json', 'agoda', '2024-09-23 02:20:48', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/23_09_2024/response_availability_Qtech_pranali_14_20_48_1727101248_27.json');
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'a5/23_09_2024/request_availability_Qtech_pranali_14_20_48_1727101248_26.json', 'a5/23_09_2024/response_availability_Qtech_pranali_14_20_48_1727101248_26.json', 'a5/23_09_2024/response_header_availability_Qtech_pranali_14_20_48_1727101248_26.json', 'agoda', '2024-09-23 02:20:48', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/23_09_2024/response_availability_Qtech_pranali_14_20_48_1727101248_26.json');
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'a5/23_09_2024/request_availability_Qtech_pranali_14_20_48_1727101248_31.json', 'a5/23_09_2024/response_availability_Qtech_pranali_14_20_48_1727101248_31.json', 'a5/23_09_2024/response_header_availability_Qtech_pranali_14_20_48_1727101248_31.json', 'agoda', '2024-09-23 02:20:48', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/23_09_2024/response_availability_Qtech_pranali_14_20_48_1727101248_31.json');
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062320240914204612500422642&xml_user_id=2406&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=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:20:48.219'
        , request_start_time = '0.022'
        , parsing_start_time = '0.159'
        , mapping_complete_time = '0.190'
        , mongo_start_time = '0.212'
        , search_end_time = '0.000'
        , total_duration = '0.461'
        , error_description = ''
        , memory_used = '2971816'
        WHERE id = '187276625';
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'a5/23_09_2024/request_availability_Qtech_pranali_14_20_48_1727101248_29.json', 'a5/23_09_2024/response_availability_Qtech_pranali_14_20_48_1727101248_29.json', 'a5/23_09_2024/response_header_availability_Qtech_pranali_14_20_48_1727101248_29.json', 'agoda', '2024-09-23 02:20:48', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/23_09_2024/response_availability_Qtech_pranali_14_20_48_1727101248_29.json');
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062320240914204612500422642&xml_user_id=2406&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=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:20:48.211'
        , request_start_time = '0.035'
        , parsing_start_time = '0.170'
        , mapping_complete_time = '0.183'
        , mongo_start_time = '0.216'
        , search_end_time = '0.000'
        , total_duration = '0.476'
        , error_description = ''
        , memory_used = '2971752'
        WHERE id = '187276626';
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062320240914204612500422642&xml_user_id=2406&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=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:20:48.223'
        , request_start_time = '0.028'
        , parsing_start_time = '0.177'
        , mapping_complete_time = '0.159'
        , mongo_start_time = '0.186'
        , search_end_time = '0.000'
        , total_duration = '0.464'
        , error_description = ''
        , memory_used = '2971800'
        WHERE id = '187276627';
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062320240914204612500422642&xml_user_id=2406&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=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:20:48.194'
        , request_start_time = '0.050'
        , parsing_start_time = '0.161'
        , mapping_complete_time = '0.198'
        , mongo_start_time = '0.230'
        , search_end_time = '0.000'
        , total_duration = '0.492'
        , error_description = ''
        , memory_used = '2971720'
        WHERE id = '187276624';
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'a5/23_09_2024/request_availability_Qtech_pranali_14_20_48_1727101248_32.json', 'a5/23_09_2024/response_availability_Qtech_pranali_14_20_48_1727101248_32.json', 'a5/23_09_2024/response_header_availability_Qtech_pranali_14_20_48_1727101248_32.json', 'agoda', '2024-09-23 02:20:48', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/23_09_2024/response_availability_Qtech_pranali_14_20_48_1727101248_32.json');
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'a5/23_09_2024/request_availability_Qtech_pranali_14_20_48_1727101248_30.json', 'a5/23_09_2024/response_availability_Qtech_pranali_14_20_48_1727101248_30.json', 'a5/23_09_2024/response_header_availability_Qtech_pranali_14_20_48_1727101248_30.json', 'agoda', '2024-09-23 02:20:48', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/23_09_2024/response_availability_Qtech_pranali_14_20_48_1727101248_30.json');
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'a5/23_09_2024/request_availability_Qtech_pranali_14_20_48_1727101248_19.json', 'a5/23_09_2024/response_availability_Qtech_pranali_14_20_48_1727101248_19.json', 'a5/23_09_2024/response_header_availability_Qtech_pranali_14_20_48_1727101248_19.json', 'agoda', '2024-09-23 02:20:48', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/23_09_2024/response_availability_Qtech_pranali_14_20_48_1727101248_19.json');
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062320240914204612500422642&xml_user_id=2406&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=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:20:48.234'
        , request_start_time = '0.039'
        , parsing_start_time = '0.169'
        , mapping_complete_time = '0.165'
        , mongo_start_time = '0.183'
        , search_end_time = '0.000'
        , total_duration = '0.473'
        , error_description = ''
        , memory_used = '2971816'
        WHERE id = '187276629';
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062320240914204612500422642&xml_user_id=2406&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=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:20:48.222'
        , request_start_time = '0.033'
        , parsing_start_time = '0.184'
        , mapping_complete_time = '0.162'
        , mongo_start_time = '0.188'
        , search_end_time = '0.000'
        , total_duration = '0.493'
        , error_description = ''
        , memory_used = '2971800'
        WHERE id = '187276628';
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062320240914204612500422642&xml_user_id=2406&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=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:20:48.240'
        , request_start_time = '0.033'
        , parsing_start_time = '0.175'
        , mapping_complete_time = '0.162'
        , mongo_start_time = '0.189'
        , search_end_time = '0.000'
        , total_duration = '0.476'
        , error_description = ''
        , memory_used = '2971744'
        WHERE id = '187276630';
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062320240914204612500422642&xml_user_id=2406&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=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:20:48.228'
        , request_start_time = '0.035'
        , parsing_start_time = '0.190'
        , mapping_complete_time = '0.157'
        , mongo_start_time = '0.186'
        , search_end_time = '0.000'
        , total_duration = '0.491'
        , error_description = ''
        , memory_used = '2971800'
        WHERE id = '187276631';
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062320240914204612500422642&xml_user_id=2406&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=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:20:48.242'
        , request_start_time = '0.039'
        , parsing_start_time = '0.193'
        , mapping_complete_time = '0.144'
        , mongo_start_time = '0.166'
        , search_end_time = '0.000'
        , total_duration = '0.479'
        , error_description = ''
        , memory_used = '2971848'
        WHERE id = '187276636';
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062320240914204612500422642&xml_user_id=2406&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=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:20:48.281'
        , request_start_time = '0.035'
        , parsing_start_time = '0.201'
        , mapping_complete_time = '0.107'
        , mongo_start_time = '0.123'
        , search_end_time = '0.000'
        , total_duration = '0.444'
        , error_description = ''
        , memory_used = '2971816'
        WHERE id = '187276643';
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062320240914204612500422642&xml_user_id=2406&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=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:20:48.254'
        , request_start_time = '0.043'
        , parsing_start_time = '0.186'
        , mapping_complete_time = '0.142'
        , mongo_start_time = '0.157'
        , search_end_time = '0.000'
        , total_duration = '0.470'
        , error_description = ''
        , memory_used = '2971824'
        WHERE id = '187276637';
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062320240914204612500422642&xml_user_id=2406&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=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:20:48.238'
        , request_start_time = '0.036'
        , parsing_start_time = '0.178'
        , mapping_complete_time = '0.167'
        , mongo_start_time = '0.189'
        , search_end_time = '0.000'
        , total_duration = '0.485'
        , error_description = ''
        , memory_used = '2971768'
        WHERE id = '187276634';
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062320240914204612500422642&xml_user_id=2406&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=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:20:48.294'
        , request_start_time = '0.077'
        , parsing_start_time = '0.084'
        , mapping_complete_time = '0.137'
        , mongo_start_time = '0.152'
        , search_end_time = '0.000'
        , total_duration = '0.431'
        , error_description = ''
        , memory_used = '2971032'
        WHERE id = '187276638';
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062320240914204612500422642&xml_user_id=2406&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=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:20:48.246'
        , request_start_time = '0.031'
        , parsing_start_time = '0.200'
        , mapping_complete_time = '0.122'
        , mongo_start_time = '0.138'
        , search_end_time = '0.000'
        , total_duration = '0.479'
        , error_description = ''
        , memory_used = '2971752'
        WHERE id = '187276640';
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062320240914204612500422642&xml_user_id=2406&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=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:20:48.244'
        , request_start_time = '0.042'
        , parsing_start_time = '0.179'
        , mapping_complete_time = '0.151'
        , mongo_start_time = '0.171'
        , search_end_time = '0.000'
        , total_duration = '0.484'
        , error_description = ''
        , memory_used = '2971752'
        WHERE id = '187276635';
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062320240914204612500422642&xml_user_id=2406&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=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:20:48.249'
        , request_start_time = '0.033'
        , parsing_start_time = '0.203'
        , mapping_complete_time = '0.133'
        , mongo_start_time = '0.146'
        , search_end_time = '0.000'
        , total_duration = '0.481'
        , error_description = ''
        , memory_used = '2971520'
        WHERE id = '187276641';
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062320240914204612500422642&xml_user_id=2406&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=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:20:48.285'
        , request_start_time = '0.027'
        , parsing_start_time = '0.131'
        , mapping_complete_time = '0.156'
        , mongo_start_time = '0.183'
        , search_end_time = '0.000'
        , total_duration = '0.443'
        , error_description = ''
        , memory_used = '2971800'
        WHERE id = '187276633';
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062320240914204612500422642&xml_user_id=2406&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=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:20:48.263'
        , request_start_time = '0.032'
        , parsing_start_time = '0.197'
        , mapping_complete_time = '0.134'
        , mongo_start_time = '0.145'
        , search_end_time = '0.000'
        , total_duration = '0.466'
        , error_description = ''
        , memory_used = '2971864'
        WHERE id = '187276639';
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062320240914204612500422642&xml_user_id=2406&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=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:20:48.235'
        , request_start_time = '0.037'
        , parsing_start_time = '0.181'
        , mapping_complete_time = '0.166'
        , mongo_start_time = '0.200'
        , search_end_time = '0.000'
        , total_duration = '0.503'
        , error_description = ''
        , memory_used = '2971752'
        WHERE id = '187276632';
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062320240914204612500422642&xml_user_id=2406&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=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:20:48.281'
        , request_start_time = '0.032'
        , parsing_start_time = '0.197'
        , mapping_complete_time = '0.112'
        , mongo_start_time = '0.142'
        , search_end_time = '0.000'
        , total_duration = '0.468'
        , error_description = ''
        , memory_used = '2971456'
        WHERE id = '187276642';
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062320240914204612500422642&xml_user_id=2406&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=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:20:48.286'
        , request_start_time = '0.028'
        , parsing_start_time = '0.199'
        , mapping_complete_time = '0.121'
        , mongo_start_time = '0.138'
        , search_end_time = '0.000'
        , total_duration = '0.462'
        , error_description = ''
        , memory_used = '2971752'
        WHERE id = '187276645';
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062320240914204612500422642&xml_user_id=2406&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=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:20:48.243'
        , request_start_time = '0.066'
        , parsing_start_time = '0.154'
        , mapping_complete_time = '0.049'
        , mongo_start_time = '0.060'
        , search_end_time = '0.000'
        , total_duration = '0.510'
        , error_description = ''
        , memory_used = '2971408'
        WHERE id = '187276648';
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062320240914204612500422642&xml_user_id=2406&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=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:20:48.287'
        , request_start_time = '0.069'
        , parsing_start_time = '0.197'
        , mapping_complete_time = '0.063'
        , mongo_start_time = '0.089'
        , search_end_time = '0.000'
        , total_duration = '0.470'
        , error_description = ''
        , memory_used = '2971392'
        WHERE id = '187276647';
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062320240914204612500422642&xml_user_id=2406&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=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:20:48.289'
        , request_start_time = '0.069'
        , parsing_start_time = '0.192'
        , mapping_complete_time = '0.068'
        , mongo_start_time = '0.094'
        , search_end_time = '0.000'
        , total_duration = '0.469'
        , error_description = ''
        , memory_used = '2971792'
        WHERE id = '187276646';
[09/23/2024 02:20:48], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062320240914204612500422642&xml_user_id=2406&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=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:20:48.281'
        , request_start_time = '0.052'
        , parsing_start_time = '0.186'
        , mapping_complete_time = '0.108'
        , mongo_start_time = '0.134'
        , search_end_time = '0.001'
        , total_duration = '0.477'
        , error_description = ''
        , memory_used = '2971768'
        WHERE id = '187276644';
[09/23/2024 02:20:49], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=localsystem&sessionid=24062320240914204612500422642&xml_user_id=2406&request_no=14&local_hotel_code=48173&#039;,&#039;48174&#039;,&#039;48190&#039;,&#039;48192&#039;,&#039;48196&#039;,&#039;48197&#039;,&#039;48200&#039;,&#039;48209&#039;,&#039;48212&#039;,&#039;48219&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:20:48.359'
        , request_start_time = '0.470'
        , parsing_start_time = '0.054'
        , mapping_complete_time = '0.057'
        , mongo_start_time = '0.057'
        , search_end_time = '0.000'
        , total_duration = '0.694'
        , error_description = ''
        , memory_used = '13087832'
        WHERE id = '187276599';
[09/23/2024 02:20:49], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=localsystem&sessionid=24062320240914204612500422642&xml_user_id=2406&request_no=2&local_hotel_code=19659&#039;,&#039;19660&#039;,&#039;19661&#039;,&#039;19662&#039;,&#039;19663&#039;,&#039;19664&#039;,&#039;19665&#039;,&#039;19666&#039;,&#039;19667&#039;,&#039;19668&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:20:48.336'
        , request_start_time = '0.363'
        , parsing_start_time = '0.215'
        , mapping_complete_time = '0.068'
        , mongo_start_time = '0.068'
        , search_end_time = '0.000'
        , total_duration = '0.764'
        , error_description = ''
        , memory_used = '13130064'
        WHERE id = '187276592';
[09/23/2024 02:20:49], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=localsystem&sessionid=24062320240914204612500422642&xml_user_id=2406&request_no=13&local_hotel_code=48137&#039;,&#039;48138&#039;,&#039;48141&#039;,&#039;48148&#039;,&#039;48154&#039;,&#039;48155&#039;,&#039;48159&#039;,&#039;48161&#039;,&#039;48164&#039;,&#039;48172&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:20:48.356'
        , request_start_time = '0.583'
        , parsing_start_time = '0.091'
        , mapping_complete_time = '0.014'
        , mongo_start_time = '0.015'
        , search_end_time = '0.000'
        , total_duration = '0.789'
        , error_description = ''
        , memory_used = '13087832'
        WHERE id = '187276595';
[09/23/2024 02:20:49], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=localsystem&sessionid=24062320240914204612500422642&xml_user_id=2406&request_no=19&local_hotel_code=48404&#039;,&#039;48406&#039;,&#039;48410&#039;,&#039;48413&#039;,&#039;48416&#039;,&#039;48417&#039;,&#039;48419&#039;,&#039;48422&#039;,&#039;48426&#039;,&#039;48427&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:20:48.405'
        , request_start_time = '0.639'
        , parsing_start_time = '0.088'
        , mapping_complete_time = '0.026'
        , mongo_start_time = '0.027'
        , search_end_time = '0.000'
        , total_duration = '0.832'
        , error_description = ''
        , memory_used = '13087832'
        WHERE id = '187276614';
[09/23/2024 02:20:49], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=localsystem&sessionid=24062320240914204612500422642&xml_user_id=2406&request_no=4&local_hotel_code=19679&#039;,&#039;19680&#039;,&#039;19681&#039;,&#039;19682&#039;,&#039;19683&#039;,&#039;19684&#039;,&#039;19685&#039;,&#039;19686&#039;,&#039;19687&#039;,&#039;47435&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:20:48.355'
        , request_start_time = '0.655'
        , parsing_start_time = '0.141'
        , mapping_complete_time = '0.019'
        , mongo_start_time = '0.019'
        , search_end_time = '0.000'
        , total_duration = '0.951'
        , error_description = ''
        , memory_used = '13124040'
        WHERE id = '187276610';
[09/23/2024 02:20:49], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=localsystem&sessionid=24062320240914204612500422642&xml_user_id=2406&request_no=12&local_hotel_code=48099&#039;,&#039;48106&#039;,&#039;48115&#039;,&#039;48116&#039;,&#039;48118&#039;,&#039;48126&#039;,&#039;48127&#039;,&#039;48128&#039;,&#039;48130&#039;,&#039;48135&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:20:48.351'
        , request_start_time = '0.657'
        , parsing_start_time = '0.161'
        , mapping_complete_time = '0.029'
        , mongo_start_time = '0.030'
        , search_end_time = '0.000'
        , total_duration = '0.968'
        , error_description = ''
        , memory_used = '13087832'
        WHERE id = '187276613';
[09/23/2024 02:20:49], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=localsystem&sessionid=24062320240914204612500422642&xml_user_id=2406&request_no=5&local_hotel_code=47436&#039;,&#039;47440&#039;,&#039;47451&#039;,&#039;47452&#039;,&#039;47454&#039;,&#039;47465&#039;,&#039;47468&#039;,&#039;47470&#039;,&#039;47471&#039;,&#039;47472&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:20:48.352'
        , request_start_time = '0.669'
        , parsing_start_time = '0.168'
        , mapping_complete_time = '0.020'
        , mongo_start_time = '0.020'
        , search_end_time = '0.004'
        , total_duration = '0.987'
        , error_description = ''
        , memory_used = '13124040'
        WHERE id = '187276615';
[09/23/2024 02:20:49], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=localsystem&sessionid=24062320240914204612500422642&xml_user_id=2406&request_no=25&local_hotel_code=48607&#039;,&#039;48609&#039;,&#039;48610&#039;,&#039;48612&#039;,&#039;48613&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:20:48.395'
        , request_start_time = '0.672'
        , parsing_start_time = '0.219'
        , mapping_complete_time = '0.037'
        , mongo_start_time = '0.037'
        , search_end_time = '0.000'
        , total_duration = '0.990'
        , error_description = ''
        , memory_used = '4927944'
        WHERE id = '187276596';
[09/23/2024 02:20:49], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=localsystem&sessionid=24062320240914204612500422642&xml_user_id=2406&request_no=8&local_hotel_code=47581&#039;,&#039;47582&#039;,&#039;47583&#039;,&#039;47585&#039;,&#039;47586&#039;,&#039;47594&#039;,&#039;47600&#039;,&#039;47674&#039;,&#039;47680&#039;,&#039;47685&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:20:48.352'
        , request_start_time = '0.738'
        , parsing_start_time = '0.162'
        , mapping_complete_time = '0.024'
        , mongo_start_time = '0.024'
        , search_end_time = '0.000'
        , total_duration = '1.044'
        , error_description = ''
        , memory_used = '13087720'
        WHERE id = '187276601';
[09/23/2024 02:20:49], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=localsystem&sessionid=24062320240914204612500422642&xml_user_id=2406&request_no=0&local_hotel_code=0&#039;,&#039;19640&#039;,&#039;19641&#039;,&#039;19642&#039;,&#039;19643&#039;,&#039;19644&#039;,&#039;19645&#039;,&#039;19646&#039;,&#039;19647&#039;,&#039;19648&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:20:48.321'
        , request_start_time = '0.657'
        , parsing_start_time = '0.327'
        , mapping_complete_time = '0.012'
        , mongo_start_time = '0.012'
        , search_end_time = '0.000'
        , total_duration = '1.098'
        , error_description = ''
        , memory_used = '11967776'
        WHERE id = '187276590';
[09/23/2024 02:20:49], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '1'
        , request_url = '/call.php?s=localsystem&sessionid=24062320240914204612500422642&xml_user_id=2406&request_no=9&local_hotel_code=47686&#039;,&#039;47836&#039;,&#039;47931&#039;,&#039;47975&#039;,&#039;47986&#039;,&#039;47990&#039;,&#039;47992&#039;,&#039;47996&#039;,&#039;47997&#039;,&#039;47998&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:20:48.350'
        , request_start_time = '0.669'
        , parsing_start_time = '0.155'
        , mapping_complete_time = '0.060'
        , mongo_start_time = '0.061'
        , search_end_time = '0.072'
        , total_duration = '1.065'
        , error_description = ''
        , memory_used = '13087720'
        WHERE id = '187276602';
[09/23/2024 02:20:49], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=localsystem&sessionid=24062320240914204612500422642&xml_user_id=2406&request_no=1&local_hotel_code=19649&#039;,&#039;19650&#039;,&#039;19651&#039;,&#039;19652&#039;,&#039;19653&#039;,&#039;19654&#039;,&#039;19655&#039;,&#039;19656&#039;,&#039;19657&#039;,&#039;19658&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:20:48.344'
        , request_start_time = '0.804'
        , parsing_start_time = '0.140'
        , mapping_complete_time = '0.027'
        , mongo_start_time = '0.027'
        , search_end_time = '0.000'
        , total_duration = '1.098'
        , error_description = ''
        , memory_used = '13128112'
        WHERE id = '187276604';
[09/23/2024 02:20:49], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '1'
        , request_url = '/call.php?s=localsystem&sessionid=24062320240914204612500422642&xml_user_id=2406&request_no=11&local_hotel_code=48050&#039;,&#039;48053&#039;,&#039;48061&#039;,&#039;48072&#039;,&#039;48083&#039;,&#039;48084&#039;,&#039;48087&#039;,&#039;48090&#039;,&#039;48093&#039;,&#039;48096&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:20:48.353'
        , request_start_time = '0.616'
        , parsing_start_time = '0.221'
        , mapping_complete_time = '0.042'
        , mongo_start_time = '0.047'
        , search_end_time = '0.080'
        , total_duration = '1.096'
        , error_description = ''
        , memory_used = '13087832'
        WHERE id = '187276609';
[09/23/2024 02:20:49], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '1'
        , request_url = '/call.php?s=localsystem&sessionid=24062320240914204612500422642&xml_user_id=2406&request_no=3&local_hotel_code=19669&#039;,&#039;19670&#039;,&#039;19671&#039;,&#039;19672&#039;,&#039;19673&#039;,&#039;19674&#039;,&#039;19675&#039;,&#039;19676&#039;,&#039;19677&#039;,&#039;19678&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:20:48.343'
        , request_start_time = '0.635'
        , parsing_start_time = '0.305'
        , mapping_complete_time = '0.053'
        , mongo_start_time = '0.054'
        , search_end_time = '0.065'
        , total_duration = '1.161'
        , error_description = ''
        , memory_used = '13123928'
        WHERE id = '187276594';
[09/23/2024 02:20:49], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '1'
        , request_url = '/call.php?s=localsystem&sessionid=24062320240914204612500422642&xml_user_id=2406&request_no=15&local_hotel_code=48220&#039;,&#039;48222&#039;,&#039;48224&#039;,&#039;48234&#039;,&#039;48235&#039;,&#039;48238&#039;,&#039;48241&#039;,&#039;48245&#039;,&#039;48246&#039;,&#039;48247&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:20:48.377'
        , request_start_time = '0.625'
        , parsing_start_time = '0.300'
        , mapping_complete_time = '0.083'
        , mongo_start_time = '0.083'
        , search_end_time = '0.059'
        , total_duration = '1.136'
        , error_description = ''
        , memory_used = '13087832'
        WHERE id = '187276593';
[09/23/2024 02:20:49], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '1'
        , request_url = '/call.php?s=localsystem&sessionid=24062320240914204612500422642&xml_user_id=2406&request_no=6&local_hotel_code=47475&#039;,&#039;47476&#039;,&#039;47477&#039;,&#039;47482&#039;,&#039;47487&#039;,&#039;47489&#039;,&#039;47491&#039;,&#039;47496&#039;,&#039;47497&#039;,&#039;47498&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:20:48.355'
        , request_start_time = '0.650'
        , parsing_start_time = '0.228'
        , mapping_complete_time = '0.164'
        , mongo_start_time = '0.164'
        , search_end_time = '0.018'
        , total_duration = '1.173'
        , error_description = ''
        , memory_used = '11957600'
        WHERE id = '187276597';
[09/23/2024 02:20:49], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '1'
        , request_url = '/call.php?s=localsystem&sessionid=24062320240914204612500422642&xml_user_id=2406&request_no=10&local_hotel_code=48000&#039;,&#039;48002&#039;,&#039;48003&#039;,&#039;48007&#039;,&#039;48031&#039;,&#039;48037&#039;,&#039;48038&#039;,&#039;48039&#039;,&#039;48040&#039;,&#039;48041&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:20:48.356'
        , request_start_time = '0.759'
        , parsing_start_time = '0.217'
        , mapping_complete_time = '0.105'
        , mongo_start_time = '0.106'
        , search_end_time = '0.025'
        , total_duration = '1.181'
        , error_description = ''
        , memory_used = '13087832'
        WHERE id = '187276591';
[09/23/2024 02:20:49], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '1'
        , request_url = '/call.php?s=localsystem&sessionid=24062320240914204612500422642&xml_user_id=2406&request_no=21&local_hotel_code=48492&#039;,&#039;48499&#039;,&#039;48510&#039;,&#039;48511&#039;,&#039;48512&#039;,&#039;48514&#039;,&#039;48518&#039;,&#039;48527&#039;,&#039;48529&#039;,&#039;48532&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:20:48.400'
        , request_start_time = '0.668'
        , parsing_start_time = '0.358'
        , mapping_complete_time = '0.019'
        , mongo_start_time = '0.020'
        , search_end_time = '0.032'
        , total_duration = '1.155'
        , error_description = ''
        , memory_used = '13087832'
        WHERE id = '187276603';
[09/23/2024 02:20:49], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '3'
        , request_url = '/call.php?s=localsystem&sessionid=24062320240914204612500422642&xml_user_id=2406&request_no=22&local_hotel_code=48533&#039;,&#039;48544&#039;,&#039;48553&#039;,&#039;48555&#039;,&#039;48557&#039;,&#039;48558&#039;,&#039;48559&#039;,&#039;48560&#039;,&#039;48561&#039;,&#039;48562&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:20:48.400'
        , request_start_time = '0.618'
        , parsing_start_time = '0.409'
        , mapping_complete_time = '0.023'
        , mongo_start_time = '0.023'
        , search_end_time = '0.029'
        , total_duration = '1.156'
        , error_description = ''
        , memory_used = '13087832'
        WHERE id = '187276600';
[09/23/2024 02:20:49], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '1'
        , request_url = '/call.php?s=localsystem&sessionid=24062320240914204612500422642&xml_user_id=2406&request_no=7&local_hotel_code=47499&#039;,&#039;47501&#039;,&#039;47505&#039;,&#039;47510&#039;,&#039;47512&#039;,&#039;47513&#039;,&#039;47541&#039;,&#039;47575&#039;,&#039;47576&#039;,&#039;47579&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:20:48.356'
        , request_start_time = '0.593'
        , parsing_start_time = '0.478'
        , mapping_complete_time = '0.023'
        , mongo_start_time = '0.023'
        , search_end_time = '0.016'
        , total_duration = '1.232'
        , error_description = ''
        , memory_used = '13087720'
        WHERE id = '187276606';
[09/23/2024 02:20:49], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '1'
        , request_url = '/call.php?s=localsystem&sessionid=24062320240914204612500422642&xml_user_id=2406&request_no=16&local_hotel_code=48248&#039;,&#039;48250&#039;,&#039;48257&#039;,&#039;48258&#039;,&#039;48259&#039;,&#039;48260&#039;,&#039;48261&#039;,&#039;48262&#039;,&#039;48263&#039;,&#039;48270&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:20:48.374'
        , request_start_time = '0.785'
        , parsing_start_time = '0.310'
        , mapping_complete_time = '0.026'
        , mongo_start_time = '0.026'
        , search_end_time = '0.022'
        , total_duration = '1.260'
        , error_description = ''
        , memory_used = '13087832'
        WHERE id = '187276617';
[09/23/2024 02:20:49], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '1'
        , request_url = '/call.php?s=localsystem&sessionid=24062320240914204612500422642&xml_user_id=2406&request_no=20&local_hotel_code=48431&#039;,&#039;48435&#039;,&#039;48441&#039;,&#039;48442&#039;,&#039;48447&#039;,&#039;48448&#039;,&#039;48456&#039;,&#039;48473&#039;,&#039;48474&#039;,&#039;48486&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:20:48.384'
        , request_start_time = '0.798'
        , parsing_start_time = '0.403'
        , mapping_complete_time = '0.033'
        , mongo_start_time = '0.034'
        , search_end_time = '0.015'
        , total_duration = '1.343'
        , error_description = ''
        , memory_used = '13087832'
        WHERE id = '187276608';
[09/23/2024 02:20:49], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '2'
        , request_url = '/call.php?s=localsystem&sessionid=24062320240914204612500422642&xml_user_id=2406&request_no=17&local_hotel_code=48272&#039;,&#039;48276&#039;,&#039;48277&#039;,&#039;48279&#039;,&#039;48280&#039;,&#039;48283&#039;,&#039;48287&#039;,&#039;48291&#039;,&#039;48292&#039;,&#039;48293&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:20:48.385'
        , request_start_time = '0.790'
        , parsing_start_time = '0.473'
        , mapping_complete_time = '0.024'
        , mongo_start_time = '0.024'
        , search_end_time = '0.014'
        , total_duration = '1.401'
        , error_description = ''
        , memory_used = '13087832'
        WHERE id = '187276616';
[09/23/2024 02:20:49], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '4'
        , request_url = '/call.php?s=localsystem&sessionid=24062320240914204612500422642&xml_user_id=2406&request_no=24&local_hotel_code=48575&#039;,&#039;48576&#039;,&#039;48589&#039;,&#039;48590&#039;,&#039;48592&#039;,&#039;48593&#039;,&#039;48596&#039;,&#039;48597&#039;,&#039;48598&#039;,&#039;48599&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:20:48.393'
        , request_start_time = '0.621'
        , parsing_start_time = '0.695'
        , mapping_complete_time = '0.045'
        , mongo_start_time = '0.046'
        , search_end_time = '0.016'
        , total_duration = '1.476'
        , error_description = ''
        , memory_used = '13087832'
        WHERE id = '187276612';
[09/23/2024 02:20:49], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '7'
        , request_url = '/call.php?s=localsystem&sessionid=24062320240914204612500422642&xml_user_id=2406&request_no=23&local_hotel_code=48563&#039;,&#039;48564&#039;,&#039;48565&#039;,&#039;48566&#039;,&#039;48567&#039;,&#039;48568&#039;,&#039;48569&#039;,&#039;48572&#039;,&#039;48573&#039;,&#039;48574&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:20:48.385'
        , request_start_time = '0.646'
        , parsing_start_time = '0.747'
        , mapping_complete_time = '0.059'
        , mongo_start_time = '0.060'
        , search_end_time = '0.016'
        , total_duration = '1.593'
        , error_description = ''
        , memory_used = '13087720'
        WHERE id = '187276621';
[09/23/2024 02:20:50], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '4'
        , request_url = '/call.php?s=localsystem&sessionid=24062320240914204612500422642&xml_user_id=2406&request_no=18&local_hotel_code=48294&#039;,&#039;48298&#039;,&#039;48300&#039;,&#039;48303&#039;,&#039;48304&#039;,&#039;48312&#039;,&#039;48383&#039;,&#039;48384&#039;,&#039;48391&#039;,&#039;48403&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:20:48.395'
        , request_start_time = '0.612'
        , parsing_start_time = '0.841'
        , mapping_complete_time = '0.041'
        , mongo_start_time = '0.042'
        , search_end_time = '0.016'
        , total_duration = '1.625'
        , error_description = ''
        , memory_used = '13087832'
        WHERE id = '187276622';
[09/23/2024 02:20:56], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/23_09_2024/request_availability_Qtech_pranali_14_20_49_17271012499.json', 'rh/23_09_2024/response_availability_Qtech_pranali_14_20_49_17271012499.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_14_20_49_17271012499.json', 'ratehawk', '2024-09-23 02:20:56', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_14_20_49_17271012499.json');
[09/23/2024 02:20:56], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '37'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240914204612500422642&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=9&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:20:48.312'
        , request_start_time = '1.257'
        , parsing_start_time = '6.812'
        , mapping_complete_time = '0.089'
        , mongo_start_time = '0.150'
        , search_end_time = '0.104'
        , total_duration = '8.436'
        , error_description = ''
        , memory_used = '59560280'
        WHERE id = '187276649';
[09/23/2024 02:20:56], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/23_09_2024/request_availability_Qtech_pranali_14_20_49_172710124911.json', 'rh/23_09_2024/response_availability_Qtech_pranali_14_20_49_172710124911.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_14_20_49_172710124911.json', 'ratehawk', '2024-09-23 02:20:56', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_14_20_49_172710124911.json');
[09/23/2024 02:20:56], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/23_09_2024/request_availability_Qtech_pranali_14_20_49_17271012498.json', 'rh/23_09_2024/response_availability_Qtech_pranali_14_20_49_17271012498.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_14_20_49_17271012498.json', 'ratehawk', '2024-09-23 02:20:56', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_14_20_49_17271012498.json');
[09/23/2024 02:20:56], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '20'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240914204612500422642&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=11&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:20:48.309'
        , request_start_time = '1.248'
        , parsing_start_time = '7.184'
        , mapping_complete_time = '0.044'
        , mongo_start_time = '0.078'
        , search_end_time = '0.053'
        , total_duration = '8.666'
        , error_description = ''
        , memory_used = '26569104'
        WHERE id = '187276650';
[09/23/2024 02:20:57], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/23_09_2024/request_availability_Qtech_pranali_14_20_49_17271012497.json', 'rh/23_09_2024/response_availability_Qtech_pranali_14_20_49_17271012497.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_14_20_49_17271012497.json', 'ratehawk', '2024-09-23 02:20:57', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_14_20_49_17271012497.json');
[09/23/2024 02:20:57], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/23_09_2024/request_availability_Qtech_pranali_14_20_48_17271012480.json', 'rh/23_09_2024/response_availability_Qtech_pranali_14_20_48_17271012480.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_14_20_48_17271012480.json', 'ratehawk', '2024-09-23 02:20:57', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_14_20_48_17271012480.json');
[09/23/2024 02:20:57], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '35'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240914204612500422642&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=8&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:20:48.311'
        , request_start_time = '1.234'
        , parsing_start_time = '7.267'
        , mapping_complete_time = '0.089'
        , mongo_start_time = '0.147'
        , search_end_time = '0.095'
        , total_duration = '8.854'
        , error_description = ''
        , memory_used = '59784120'
        WHERE id = '187276651';
[09/23/2024 02:20:57], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '37'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240914204612500422642&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=7&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:20:48.301'
        , request_start_time = '1.049'
        , parsing_start_time = '7.655'
        , mapping_complete_time = '0.078'
        , mongo_start_time = '0.143'
        , search_end_time = '0.098'
        , total_duration = '9.041'
        , error_description = ''
        , memory_used = '65665320'
        WHERE id = '187276652';
[09/23/2024 02:20:57], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '69'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240914204612500422642&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=0&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:20:48.286'
        , request_start_time = '0.099'
        , parsing_start_time = '8.603'
        , mapping_complete_time = '0.157'
        , mongo_start_time = '0.300'
        , search_end_time = '0.166'
        , total_duration = '9.295'
        , error_description = ''
        , memory_used = '105226744'
        WHERE id = '187276653';
[09/23/2024 02:20:57], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/23_09_2024/request_availability_Qtech_pranali_14_20_49_17271012494.json', 'rh/23_09_2024/response_availability_Qtech_pranali_14_20_49_17271012494.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_14_20_49_17271012494.json', 'ratehawk', '2024-09-23 02:20:57', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_14_20_49_17271012494.json');
[09/23/2024 02:20:58], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '42'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240914204612500422642&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=4&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:20:48.293'
        , request_start_time = '1.039'
        , parsing_start_time = '8.376'
        , mapping_complete_time = '0.124'
        , mongo_start_time = '0.198'
        , search_end_time = '0.099'
        , total_duration = '9.817'
        , error_description = ''
        , memory_used = '84131368'
        WHERE id = '187276654';
[09/23/2024 02:21:03], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/23_09_2024/request_availability_Qtech_pranali_14_20_48_17271012481.json', 'rh/23_09_2024/response_availability_Qtech_pranali_14_20_48_17271012481.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_14_20_48_17271012481.json', 'ratehawk', '2024-09-23 02:21:03', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_14_20_48_17271012481.json');
[09/23/2024 02:21:03], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/23_09_2024/request_availability_Qtech_pranali_14_20_49_172710124910.json', 'rh/23_09_2024/response_availability_Qtech_pranali_14_20_49_172710124910.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_14_20_49_172710124910.json', 'ratehawk', '2024-09-23 02:21:03', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_14_20_49_172710124910.json');
[09/23/2024 02:21:03], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '20'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240914204612500422642&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=10&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:20:48.311'
        , request_start_time = '1.037'
        , parsing_start_time = '14.439'
        , mapping_complete_time = '0.036'
        , mongo_start_time = '0.064'
        , search_end_time = '0.038'
        , total_duration = '15.680'
        , error_description = ''
        , memory_used = '17848016'
        WHERE id = '187276656';
[09/23/2024 02:21:04], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/23_09_2024/request_availability_Qtech_pranali_14_20_49_17271012495.json', 'rh/23_09_2024/response_availability_Qtech_pranali_14_20_49_17271012495.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_14_20_49_17271012495.json', 'ratehawk', '2024-09-23 02:21:04', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_14_20_49_17271012495.json');
[09/23/2024 02:21:04], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/23_09_2024/request_availability_Qtech_pranali_14_20_49_172710124912.json', 'rh/23_09_2024/response_availability_Qtech_pranali_14_20_49_172710124912.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_14_20_49_172710124912.json', 'ratehawk', '2024-09-23 02:21:04', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_14_20_49_172710124912.json');
[09/23/2024 02:21:04], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '23'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240914204612500422642&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=5&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:20:48.301'
        , request_start_time = '1.130'
        , parsing_start_time = '14.472'
        , mapping_complete_time = '0.067'
        , mongo_start_time = '0.109'
        , search_end_time = '0.062'
        , total_duration = '15.888'
        , error_description = ''
        , memory_used = '43538072'
        WHERE id = '187276657';
[09/23/2024 02:21:04], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '31'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240914204612500422642&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=12&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:20:48.317'
        , request_start_time = '1.061'
        , parsing_start_time = '14.625'
        , mapping_complete_time = '0.064'
        , mongo_start_time = '0.115'
        , search_end_time = '0.072'
        , total_duration = '15.979'
        , error_description = ''
        , memory_used = '40453920'
        WHERE id = '187276658';
[09/23/2024 02:21:04], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/23_09_2024/request_availability_Qtech_pranali_14_20_49_17271012496.json', 'rh/23_09_2024/response_availability_Qtech_pranali_14_20_49_17271012496.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_14_20_49_17271012496.json', 'ratehawk', '2024-09-23 02:21:04', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_14_20_49_17271012496.json');
[09/23/2024 02:21:04], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '35'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240914204612500422642&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=6&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:20:48.303'
        , request_start_time = '1.092'
        , parsing_start_time = '14.877'
        , mapping_complete_time = '0.086'
        , mongo_start_time = '0.150'
        , search_end_time = '0.097'
        , total_duration = '16.342'
        , error_description = ''
        , memory_used = '59103776'
        WHERE id = '187276659';
[09/23/2024 02:21:04], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/23_09_2024/request_availability_Qtech_pranali_14_20_49_17271012493.json', 'rh/23_09_2024/response_availability_Qtech_pranali_14_20_49_17271012493.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_14_20_49_17271012493.json', 'ratehawk', '2024-09-23 02:21:04', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_14_20_49_17271012493.json');
[09/23/2024 02:21:04], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '137'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240914204612500422642&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=1&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:20:48.291'
        , request_start_time = '0.410'
        , parsing_start_time = '14.887'
        , mapping_complete_time = '0.312'
        , mongo_start_time = '0.689'
        , search_end_time = '0.360'
        , total_duration = '16.509'
        , error_description = ''
        , memory_used = '219713128'
        WHERE id = '187276655';
[09/23/2024 02:21:05], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '51'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240914204612500422642&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=3&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:20:48.301'
        , request_start_time = '0.942'
        , parsing_start_time = '15.391'
        , mapping_complete_time = '0.111'
        , mongo_start_time = '0.191'
        , search_end_time = '0.201'
        , total_duration = '16.834'
        , error_description = ''
        , memory_used = '75416112'
        WHERE id = '187276660';
[09/23/2024 02:21:05], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/23_09_2024/request_availability_Qtech_pranali_14_20_49_17271012492.json', 'rh/23_09_2024/response_availability_Qtech_pranali_14_20_49_17271012492.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_14_20_49_17271012492.json', 'ratehawk', '2024-09-23 02:21:05', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_14_20_49_17271012492.json');
[09/23/2024 02:21:06], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '105'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240914204612500422642&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=2&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:20:48.292'
        , request_start_time = '0.935'
        , parsing_start_time = '16.051'
        , mapping_complete_time = '0.254'
        , mongo_start_time = '0.526'
        , search_end_time = '0.293'
        , total_duration = '17.945'
        , error_description = ''
        , memory_used = '183566960'
        WHERE id = '187276661';
[09/23/2024 02:21:08], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '621',
        request_path = '/xml_all.php?userid=2406&sessionid=24062320240914204612500422642',
        duration = '20.580',
        merge_duration = '0.117',
        assigned_supplier_count = '3',
        searched_supplier_count = '3',
        system_load_1_min = '0.74',
        system_load_5_min = '2.79',
        system_load_15_min = '4.67',
        system_memory_usage = '33.59',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '16479389') + '7273000',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '16479389';
[09/23/2024 02:21:08], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_2406_24062320240914204612500422642', session_id='24062320240914204612500422642', Collection_create_time='2024-09-23 14:21:08';
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'a5/23_09_2024/request_availability_Qtech_pranali_14_21_09_1727101269_3.json', 'a5/23_09_2024/response_availability_Qtech_pranali_14_21_09_1727101269_3.json', 'a5/23_09_2024/response_header_availability_Qtech_pranali_14_21_09_1727101269_3.json', 'agoda', '2024-09-23 02:21:09', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/23_09_2024/response_availability_Qtech_pranali_14_21_09_1727101269_3.json');
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062320240914204612500422642&xml_user_id=2406&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=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:21:09.113'
        , request_start_time = '0.026'
        , parsing_start_time = '0.092'
        , mapping_complete_time = '0.037'
        , mongo_start_time = '0.048'
        , search_end_time = '0.001'
        , total_duration = '0.202'
        , error_description = ''
        , memory_used = '2971720'
        WHERE id = '187276662';
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'a5/23_09_2024/request_availability_Qtech_pranali_14_21_09_1727101269_0.json', 'a5/23_09_2024/response_availability_Qtech_pranali_14_21_09_1727101269_0.json', 'a5/23_09_2024/response_header_availability_Qtech_pranali_14_21_09_1727101269_0.json', 'agoda', '2024-09-23 02:21:09', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/23_09_2024/response_availability_Qtech_pranali_14_21_09_1727101269_0.json');
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'a5/23_09_2024/request_availability_Qtech_pranali_14_21_09_1727101269_1.json', 'a5/23_09_2024/response_availability_Qtech_pranali_14_21_09_1727101269_1.json', 'a5/23_09_2024/response_header_availability_Qtech_pranali_14_21_09_1727101269_1.json', 'agoda', '2024-09-23 02:21:09', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/23_09_2024/response_availability_Qtech_pranali_14_21_09_1727101269_1.json');
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'a5/23_09_2024/request_availability_Qtech_pranali_14_21_09_1727101269_2.json', 'a5/23_09_2024/response_availability_Qtech_pranali_14_21_09_1727101269_2.json', 'a5/23_09_2024/response_header_availability_Qtech_pranali_14_21_09_1727101269_2.json', 'agoda', '2024-09-23 02:21:09', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/23_09_2024/response_availability_Qtech_pranali_14_21_09_1727101269_2.json');
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-09-23 02:21:09', '', '24062320240914204612500422642', '16479389', 'localsystem/response_placeholder.xml');
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'a5/23_09_2024/request_availability_Qtech_pranali_14_21_09_1727101269_4.json', 'a5/23_09_2024/response_availability_Qtech_pranali_14_21_09_1727101269_4.json', 'a5/23_09_2024/response_header_availability_Qtech_pranali_14_21_09_1727101269_4.json', 'agoda', '2024-09-23 02:21:09', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/23_09_2024/response_availability_Qtech_pranali_14_21_09_1727101269_4.json');
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062320240914204612500422642&xml_user_id=2406&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=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:21:09.107'
        , request_start_time = '0.019'
        , parsing_start_time = '0.086'
        , mapping_complete_time = '0.118'
        , mongo_start_time = '0.142'
        , search_end_time = '0.000'
        , total_duration = '0.280'
        , error_description = ''
        , memory_used = '2971328'
        WHERE id = '187276663';
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'a5/23_09_2024/request_availability_Qtech_pranali_14_21_09_1727101269_10.json', 'a5/23_09_2024/response_availability_Qtech_pranali_14_21_09_1727101269_10.json', 'a5/23_09_2024/response_header_availability_Qtech_pranali_14_21_09_1727101269_10.json', 'agoda', '2024-09-23 02:21:09', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/23_09_2024/response_availability_Qtech_pranali_14_21_09_1727101269_10.json');
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'a5/23_09_2024/request_availability_Qtech_pranali_14_21_09_1727101269_8.json', 'a5/23_09_2024/response_availability_Qtech_pranali_14_21_09_1727101269_8.json', 'a5/23_09_2024/response_header_availability_Qtech_pranali_14_21_09_1727101269_8.json', 'agoda', '2024-09-23 02:21:09', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/23_09_2024/response_availability_Qtech_pranali_14_21_09_1727101269_8.json');
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-09-23 02:21:09', '', '24062320240914204612500422642', '16479389', 'localsystem/response_placeholder.xml');
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-09-23 02:21:09', '', '24062320240914204612500422642', '16479389', 'localsystem/response_placeholder.xml');
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-09-23 02:21:09', '', '24062320240914204612500422642', '16479389', 'localsystem/response_placeholder.xml');
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'a5/23_09_2024/request_availability_Qtech_pranali_14_21_09_1727101269_9.json', 'a5/23_09_2024/response_availability_Qtech_pranali_14_21_09_1727101269_9.json', 'a5/23_09_2024/response_header_availability_Qtech_pranali_14_21_09_1727101269_9.json', 'agoda', '2024-09-23 02:21:09', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/23_09_2024/response_availability_Qtech_pranali_14_21_09_1727101269_9.json');
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062320240914204612500422642&xml_user_id=2406&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=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:21:09.110'
        , request_start_time = '0.023'
        , parsing_start_time = '0.085'
        , mapping_complete_time = '0.140'
        , mongo_start_time = '0.159'
        , search_end_time = '0.001'
        , total_duration = '0.298'
        , error_description = ''
        , memory_used = '2971720'
        WHERE id = '187276664';
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-09-23 02:21:09', '', '24062320240914204612500422642', '16479389', 'localsystem/response_placeholder.xml');
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-09-23 02:21:09', '', '24062320240914204612500422642', '16479389', 'localsystem/response_placeholder.xml');
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-09-23 02:21:09', '', '24062320240914204612500422642', '16479389', 'localsystem/response_placeholder.xml');
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-09-23 02:21:09', '', '24062320240914204612500422642', '16479389', 'localsystem/response_placeholder.xml');
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-09-23 02:21:09', '', '24062320240914204612500422642', '16479389', 'localsystem/response_placeholder.xml');
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-09-23 02:21:09', '', '24062320240914204612500422642', '16479389', 'localsystem/response_placeholder.xml');
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-09-23 02:21:09', '', '24062320240914204612500422642', '16479389', 'localsystem/response_placeholder.xml');
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-09-23 02:21:09', '', '24062320240914204612500422642', '16479389', 'localsystem/response_placeholder.xml');
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-09-23 02:21:09', '', '24062320240914204612500422642', '16479389', 'localsystem/response_placeholder.xml');
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-09-23 02:21:09', '', '24062320240914204612500422642', '16479389', 'localsystem/response_placeholder.xml');
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-09-23 02:21:09', '', '24062320240914204612500422642', '16479389', 'localsystem/response_placeholder.xml');
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-09-23 02:21:09', '', '24062320240914204612500422642', '16479389', 'localsystem/response_placeholder.xml');
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-09-23 02:21:09', '', '24062320240914204612500422642', '16479389', 'localsystem/response_placeholder.xml');
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-09-23 02:21:09', '', '24062320240914204612500422642', '16479389', 'localsystem/response_placeholder.xml');
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'a5/23_09_2024/request_availability_Qtech_pranali_14_21_09_1727101269_5.json', 'a5/23_09_2024/response_availability_Qtech_pranali_14_21_09_1727101269_5.json', 'a5/23_09_2024/response_header_availability_Qtech_pranali_14_21_09_1727101269_5.json', 'agoda', '2024-09-23 02:21:09', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/23_09_2024/response_availability_Qtech_pranali_14_21_09_1727101269_5.json');
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062320240914204612500422642&xml_user_id=2406&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=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:21:09.111'
        , request_start_time = '0.022'
        , parsing_start_time = '0.101'
        , mapping_complete_time = '0.117'
        , mongo_start_time = '0.141'
        , search_end_time = '0.012'
        , total_duration = '0.314'
        , error_description = ''
        , memory_used = '2971720'
        WHERE id = '187276665';
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-09-23 02:21:09', '', '24062320240914204612500422642', '16479389', 'localsystem/response_placeholder.xml');
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'a5/23_09_2024/request_availability_Qtech_pranali_14_21_09_1727101269_6.json', 'a5/23_09_2024/response_availability_Qtech_pranali_14_21_09_1727101269_6.json', 'a5/23_09_2024/response_header_availability_Qtech_pranali_14_21_09_1727101269_6.json', 'agoda', '2024-09-23 02:21:09', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/23_09_2024/response_availability_Qtech_pranali_14_21_09_1727101269_6.json');
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-09-23 02:21:09', '', '24062320240914204612500422642', '16479389', 'localsystem/response_placeholder.xml');
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-09-23 02:21:09', '', '24062320240914204612500422642', '16479389', 'localsystem/response_placeholder.xml');
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-09-23 02:21:09', '', '24062320240914204612500422642', '16479389', 'localsystem/response_placeholder.xml');
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-09-23 02:21:09', '', '24062320240914204612500422642', '16479389', 'localsystem/response_placeholder.xml');
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-09-23 02:21:09', '', '24062320240914204612500422642', '16479389', 'localsystem/response_placeholder.xml');
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'a5/23_09_2024/request_availability_Qtech_pranali_14_21_09_1727101269_7.json', 'a5/23_09_2024/response_availability_Qtech_pranali_14_21_09_1727101269_7.json', 'a5/23_09_2024/response_header_availability_Qtech_pranali_14_21_09_1727101269_7.json', 'agoda', '2024-09-23 02:21:09', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/23_09_2024/response_availability_Qtech_pranali_14_21_09_1727101269_7.json');
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062320240914204612500422642&xml_user_id=2406&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=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:21:09.116'
        , request_start_time = '0.023'
        , parsing_start_time = '0.110'
        , mapping_complete_time = '0.139'
        , mongo_start_time = '0.165'
        , search_end_time = '0.000'
        , total_duration = '0.333'
        , error_description = ''
        , memory_used = '2971720'
        WHERE id = '187276667';
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-09-23 02:21:09', '', '24062320240914204612500422642', '16479389', 'localsystem/response_placeholder.xml');
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'a5/23_09_2024/request_availability_Qtech_pranali_14_21_09_1727101269_12.json', 'a5/23_09_2024/response_availability_Qtech_pranali_14_21_09_1727101269_12.json', 'a5/23_09_2024/response_header_availability_Qtech_pranali_14_21_09_1727101269_12.json', 'agoda', '2024-09-23 02:21:09', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/23_09_2024/response_availability_Qtech_pranali_14_21_09_1727101269_12.json');
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-09-23 02:21:09', '', '24062320240914204612500422642', '16479389', 'localsystem/response_placeholder.xml');
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'a5/23_09_2024/request_availability_Qtech_pranali_14_21_09_1727101269_17.json', 'a5/23_09_2024/response_availability_Qtech_pranali_14_21_09_1727101269_17.json', 'a5/23_09_2024/response_header_availability_Qtech_pranali_14_21_09_1727101269_17.json', 'agoda', '2024-09-23 02:21:09', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/23_09_2024/response_availability_Qtech_pranali_14_21_09_1727101269_17.json');
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'a5/23_09_2024/request_availability_Qtech_pranali_14_21_09_1727101269_13.json', 'a5/23_09_2024/response_availability_Qtech_pranali_14_21_09_1727101269_13.json', 'a5/23_09_2024/response_header_availability_Qtech_pranali_14_21_09_1727101269_13.json', 'agoda', '2024-09-23 02:21:09', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/23_09_2024/response_availability_Qtech_pranali_14_21_09_1727101269_13.json');
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062320240914204612500422642&xml_user_id=2406&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=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:21:09.128'
        , request_start_time = '0.024'
        , parsing_start_time = '0.098'
        , mapping_complete_time = '0.154'
        , mongo_start_time = '0.178'
        , search_end_time = '0.000'
        , total_duration = '0.348'
        , error_description = ''
        , memory_used = '2971792'
        WHERE id = '187276673';
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062320240914204612500422642&xml_user_id=2406&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=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:21:09.126'
        , request_start_time = '0.027'
        , parsing_start_time = '0.098'
        , mapping_complete_time = '0.166'
        , mongo_start_time = '0.184'
        , search_end_time = '0.000'
        , total_duration = '0.343'
        , error_description = ''
        , memory_used = '2971752'
        WHERE id = '187276669';
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'a5/23_09_2024/request_availability_Qtech_pranali_14_21_09_1727101269_11.json', 'a5/23_09_2024/response_availability_Qtech_pranali_14_21_09_1727101269_11.json', 'a5/23_09_2024/response_header_availability_Qtech_pranali_14_21_09_1727101269_11.json', 'agoda', '2024-09-23 02:21:09', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/23_09_2024/response_availability_Qtech_pranali_14_21_09_1727101269_11.json');
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062320240914204612500422642&xml_user_id=2406&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=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:21:09.130'
        , request_start_time = '0.023'
        , parsing_start_time = '0.131'
        , mapping_complete_time = '0.109'
        , mongo_start_time = '0.158'
        , search_end_time = '0.000'
        , total_duration = '0.358'
        , error_description = ''
        , memory_used = '2971800'
        WHERE id = '187276668';
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'a5/23_09_2024/request_availability_Qtech_pranali_14_21_09_1727101269_16.json', 'a5/23_09_2024/response_availability_Qtech_pranali_14_21_09_1727101269_16.json', 'a5/23_09_2024/response_header_availability_Qtech_pranali_14_21_09_1727101269_16.json', 'agoda', '2024-09-23 02:21:09', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/23_09_2024/response_availability_Qtech_pranali_14_21_09_1727101269_16.json');
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'a5/23_09_2024/request_availability_Qtech_pranali_14_21_09_1727101269_25.json', 'a5/23_09_2024/response_availability_Qtech_pranali_14_21_09_1727101269_25.json', 'a5/23_09_2024/response_header_availability_Qtech_pranali_14_21_09_1727101269_25.json', 'agoda', '2024-09-23 02:21:09', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/23_09_2024/response_availability_Qtech_pranali_14_21_09_1727101269_25.json');
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'a5/23_09_2024/request_availability_Qtech_pranali_14_21_09_1727101269_14.json', 'a5/23_09_2024/response_availability_Qtech_pranali_14_21_09_1727101269_14.json', 'a5/23_09_2024/response_header_availability_Qtech_pranali_14_21_09_1727101269_14.json', 'agoda', '2024-09-23 02:21:09', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/23_09_2024/response_availability_Qtech_pranali_14_21_09_1727101269_14.json');
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'a5/23_09_2024/request_availability_Qtech_pranali_14_21_09_1727101269_15.json', 'a5/23_09_2024/response_availability_Qtech_pranali_14_21_09_1727101269_15.json', 'a5/23_09_2024/response_header_availability_Qtech_pranali_14_21_09_1727101269_15.json', 'agoda', '2024-09-23 02:21:09', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/23_09_2024/response_availability_Qtech_pranali_14_21_09_1727101269_15.json');
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'a5/23_09_2024/request_availability_Qtech_pranali_14_21_09_1727101269_21.json', 'a5/23_09_2024/response_availability_Qtech_pranali_14_21_09_1727101269_21.json', 'a5/23_09_2024/response_header_availability_Qtech_pranali_14_21_09_1727101269_21.json', 'agoda', '2024-09-23 02:21:09', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/23_09_2024/response_availability_Qtech_pranali_14_21_09_1727101269_21.json');
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'a5/23_09_2024/request_availability_Qtech_pranali_14_21_09_1727101269_24.json', 'a5/23_09_2024/response_availability_Qtech_pranali_14_21_09_1727101269_24.json', 'a5/23_09_2024/response_header_availability_Qtech_pranali_14_21_09_1727101269_24.json', 'agoda', '2024-09-23 02:21:09', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/23_09_2024/response_availability_Qtech_pranali_14_21_09_1727101269_24.json');
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'a5/23_09_2024/request_availability_Qtech_pranali_14_21_09_1727101269_23.json', 'a5/23_09_2024/response_availability_Qtech_pranali_14_21_09_1727101269_23.json', 'a5/23_09_2024/response_header_availability_Qtech_pranali_14_21_09_1727101269_23.json', 'agoda', '2024-09-23 02:21:09', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/23_09_2024/response_availability_Qtech_pranali_14_21_09_1727101269_23.json');
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'a5/23_09_2024/request_availability_Qtech_pranali_14_21_09_1727101269_20.json', 'a5/23_09_2024/response_availability_Qtech_pranali_14_21_09_1727101269_20.json', 'a5/23_09_2024/response_header_availability_Qtech_pranali_14_21_09_1727101269_20.json', 'agoda', '2024-09-23 02:21:09', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/23_09_2024/response_availability_Qtech_pranali_14_21_09_1727101269_20.json');
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'a5/23_09_2024/request_availability_Qtech_pranali_14_21_09_1727101269_18.json', 'a5/23_09_2024/response_availability_Qtech_pranali_14_21_09_1727101269_18.json', 'a5/23_09_2024/response_header_availability_Qtech_pranali_14_21_09_1727101269_18.json', 'agoda', '2024-09-23 02:21:09', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/23_09_2024/response_availability_Qtech_pranali_14_21_09_1727101269_18.json');
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'a5/23_09_2024/request_availability_Qtech_pranali_14_21_09_1727101269_19.json', 'a5/23_09_2024/response_availability_Qtech_pranali_14_21_09_1727101269_19.json', 'a5/23_09_2024/response_header_availability_Qtech_pranali_14_21_09_1727101269_19.json', 'agoda', '2024-09-23 02:21:09', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/23_09_2024/response_availability_Qtech_pranali_14_21_09_1727101269_19.json');
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'a5/23_09_2024/request_availability_Qtech_pranali_14_21_09_1727101269_27.json', 'a5/23_09_2024/response_availability_Qtech_pranali_14_21_09_1727101269_27.json', 'a5/23_09_2024/response_header_availability_Qtech_pranali_14_21_09_1727101269_27.json', 'agoda', '2024-09-23 02:21:09', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/23_09_2024/response_availability_Qtech_pranali_14_21_09_1727101269_27.json');
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062320240914204612500422642&xml_user_id=2406&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=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:21:09.122'
        , request_start_time = '0.022'
        , parsing_start_time = '0.121'
        , mapping_complete_time = '0.225'
        , mongo_start_time = '0.239'
        , search_end_time = '0.000'
        , total_duration = '0.421'
        , error_description = ''
        , memory_used = '2971704'
        WHERE id = '187276693';
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062320240914204612500422642&xml_user_id=2406&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=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:21:09.135'
        , request_start_time = '0.026'
        , parsing_start_time = '0.108'
        , mapping_complete_time = '0.220'
        , mongo_start_time = '0.232'
        , search_end_time = '0.000'
        , total_duration = '0.414'
        , error_description = ''
        , memory_used = '2971800'
        WHERE id = '187276700';
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'a5/23_09_2024/request_availability_Qtech_pranali_14_21_09_1727101269_22.json', 'a5/23_09_2024/response_availability_Qtech_pranali_14_21_09_1727101269_22.json', 'a5/23_09_2024/response_header_availability_Qtech_pranali_14_21_09_1727101269_22.json', 'agoda', '2024-09-23 02:21:09', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/23_09_2024/response_availability_Qtech_pranali_14_21_09_1727101269_22.json');
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'a5/23_09_2024/request_availability_Qtech_pranali_14_21_09_1727101269_29.json', 'a5/23_09_2024/response_availability_Qtech_pranali_14_21_09_1727101269_29.json', 'a5/23_09_2024/response_header_availability_Qtech_pranali_14_21_09_1727101269_29.json', 'agoda', '2024-09-23 02:21:09', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/23_09_2024/response_availability_Qtech_pranali_14_21_09_1727101269_29.json');
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'a5/23_09_2024/request_availability_Qtech_pranali_14_21_09_1727101269_28.json', 'a5/23_09_2024/response_availability_Qtech_pranali_14_21_09_1727101269_28.json', 'a5/23_09_2024/response_header_availability_Qtech_pranali_14_21_09_1727101269_28.json', 'agoda', '2024-09-23 02:21:09', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/23_09_2024/response_availability_Qtech_pranali_14_21_09_1727101269_28.json');
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062320240914204612500422642&xml_user_id=2406&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=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:21:09.124'
        , request_start_time = '0.026'
        , parsing_start_time = '0.124'
        , mapping_complete_time = '0.216'
        , mongo_start_time = '0.244'
        , search_end_time = '0.000'
        , total_duration = '0.434'
        , error_description = ''
        , memory_used = '2971704'
        WHERE id = '187276695';
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'a5/23_09_2024/request_availability_Qtech_pranali_14_21_09_1727101269_30.json', 'a5/23_09_2024/response_availability_Qtech_pranali_14_21_09_1727101269_30.json', 'a5/23_09_2024/response_header_availability_Qtech_pranali_14_21_09_1727101269_30.json', 'agoda', '2024-09-23 02:21:09', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/23_09_2024/response_availability_Qtech_pranali_14_21_09_1727101269_30.json');
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062320240914204612500422642&xml_user_id=2406&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=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:21:09.119'
        , request_start_time = '0.021'
        , parsing_start_time = '0.123'
        , mapping_complete_time = '0.228'
        , mongo_start_time = '0.257'
        , search_end_time = '0.000'
        , total_duration = '0.440'
        , error_description = ''
        , memory_used = '2971712'
        WHERE id = '187276677';
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'a5/23_09_2024/request_availability_Qtech_pranali_14_21_09_1727101269_32.json', 'a5/23_09_2024/response_availability_Qtech_pranali_14_21_09_1727101269_32.json', 'a5/23_09_2024/response_header_availability_Qtech_pranali_14_21_09_1727101269_32.json', 'agoda', '2024-09-23 02:21:09', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/23_09_2024/response_availability_Qtech_pranali_14_21_09_1727101269_32.json');
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062320240914204612500422642&xml_user_id=2406&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=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:21:09.169'
        , request_start_time = '0.037'
        , parsing_start_time = '0.162'
        , mapping_complete_time = '0.113'
        , mongo_start_time = '0.126'
        , search_end_time = '0.000'
        , total_duration = '0.399'
        , error_description = ''
        , memory_used = '2971824'
        WHERE id = '187276707';
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'a5/23_09_2024/request_availability_Qtech_pranali_14_21_09_1727101269_26.json', 'a5/23_09_2024/response_availability_Qtech_pranali_14_21_09_1727101269_26.json', 'a5/23_09_2024/response_header_availability_Qtech_pranali_14_21_09_1727101269_26.json', 'agoda', '2024-09-23 02:21:09', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/23_09_2024/response_availability_Qtech_pranali_14_21_09_1727101269_26.json');
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'a5/23_09_2024/request_availability_Qtech_pranali_14_21_09_1727101269_31.json', 'a5/23_09_2024/response_availability_Qtech_pranali_14_21_09_1727101269_31.json', 'a5/23_09_2024/response_header_availability_Qtech_pranali_14_21_09_1727101269_31.json', 'agoda', '2024-09-23 02:21:09', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/23_09_2024/response_availability_Qtech_pranali_14_21_09_1727101269_31.json');
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062320240914204612500422642&xml_user_id=2406&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=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:21:09.164'
        , request_start_time = '0.026'
        , parsing_start_time = '0.168'
        , mapping_complete_time = '0.123'
        , mongo_start_time = '0.135'
        , search_end_time = '0.000'
        , total_duration = '0.404'
        , error_description = ''
        , memory_used = '2971752'
        WHERE id = '187276708';
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062320240914204612500422642&xml_user_id=2406&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=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:21:09.155'
        , request_start_time = '0.031'
        , parsing_start_time = '0.159'
        , mapping_complete_time = '0.126'
        , mongo_start_time = '0.160'
        , search_end_time = '0.000'
        , total_duration = '0.422'
        , error_description = ''
        , memory_used = '2971752'
        WHERE id = '187276705';
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062320240914204612500422642&xml_user_id=2406&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=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:21:09.136'
        , request_start_time = '0.028'
        , parsing_start_time = '0.151'
        , mapping_complete_time = '0.171'
        , mongo_start_time = '0.208'
        , search_end_time = '0.000'
        , total_duration = '0.437'
        , error_description = ''
        , memory_used = '2971800'
        WHERE id = '187276699';
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'a5/23_09_2024/request_availability_Qtech_pranali_14_21_09_1727101269_33.json', 'a5/23_09_2024/response_availability_Qtech_pranali_14_21_09_1727101269_33.json', 'a5/23_09_2024/response_header_availability_Qtech_pranali_14_21_09_1727101269_33.json', 'agoda', '2024-09-23 02:21:09', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/23_09_2024/response_availability_Qtech_pranali_14_21_09_1727101269_33.json');
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062320240914204612500422642&xml_user_id=2406&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=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:21:09.148'
        , request_start_time = '0.057'
        , parsing_start_time = '0.165'
        , mapping_complete_time = '0.114'
        , mongo_start_time = '0.148'
        , search_end_time = '0.000'
        , total_duration = '0.427'
        , error_description = ''
        , memory_used = '2971880'
        WHERE id = '187276704';
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062320240914204612500422642&xml_user_id=2406&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=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:21:09.135'
        , request_start_time = '0.034'
        , parsing_start_time = '0.152'
        , mapping_complete_time = '0.152'
        , mongo_start_time = '0.189'
        , search_end_time = '0.000'
        , total_duration = '0.438'
        , error_description = ''
        , memory_used = '2971816'
        WHERE id = '187276702';
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062320240914204612500422642&xml_user_id=2406&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=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:21:09.174'
        , request_start_time = '0.038'
        , parsing_start_time = '0.131'
        , mapping_complete_time = '0.142'
        , mongo_start_time = '0.164'
        , search_end_time = '0.000'
        , total_duration = '0.404'
        , error_description = ''
        , memory_used = '2971752'
        WHERE id = '187276706';
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062320240914204612500422642&xml_user_id=2406&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=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:21:09.166'
        , request_start_time = '0.035'
        , parsing_start_time = '0.170'
        , mapping_complete_time = '0.121'
        , mongo_start_time = '0.145'
        , search_end_time = '0.000'
        , total_duration = '0.423'
        , error_description = ''
        , memory_used = '2971440'
        WHERE id = '187276709';
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062320240914204612500422642&xml_user_id=2406&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=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:21:09.151'
        , request_start_time = '0.041'
        , parsing_start_time = '0.164'
        , mapping_complete_time = '0.118'
        , mongo_start_time = '0.134'
        , search_end_time = '0.000'
        , total_duration = '0.430'
        , error_description = ''
        , memory_used = '2971744'
        WHERE id = '187276711';
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062320240914204612500422642&xml_user_id=2406&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=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:21:09.154'
        , request_start_time = '0.042'
        , parsing_start_time = '0.178'
        , mapping_complete_time = '0.123'
        , mongo_start_time = '0.137'
        , search_end_time = '0.000'
        , total_duration = '0.428'
        , error_description = ''
        , memory_used = '2971848'
        WHERE id = '187276710';
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062320240914204612500422642&xml_user_id=2406&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=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:21:09.151'
        , request_start_time = '0.027'
        , parsing_start_time = '0.108'
        , mapping_complete_time = '0.194'
        , mongo_start_time = '0.247'
        , search_end_time = '0.000'
        , total_duration = '0.437'
        , error_description = ''
        , memory_used = '2971768'
        WHERE id = '187276701';
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062320240914204612500422642&xml_user_id=2406&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=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:21:09.146'
        , request_start_time = '0.027'
        , parsing_start_time = '0.152'
        , mapping_complete_time = '0.155'
        , mongo_start_time = '0.207'
        , search_end_time = '0.000'
        , total_duration = '0.449'
        , error_description = ''
        , memory_used = '2971816'
        WHERE id = '187276703';
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062320240914204612500422642&xml_user_id=2406&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=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:21:09.170'
        , request_start_time = '0.047'
        , parsing_start_time = '0.188'
        , mapping_complete_time = '0.091'
        , mongo_start_time = '0.128'
        , search_end_time = '0.000'
        , total_duration = '0.438'
        , error_description = ''
        , memory_used = '2971408'
        WHERE id = '187276712';
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062320240914204612500422642&xml_user_id=2406&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=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:21:09.163'
        , request_start_time = '0.038'
        , parsing_start_time = '0.194'
        , mapping_complete_time = '0.085'
        , mongo_start_time = '0.123'
        , search_end_time = '0.001'
        , total_duration = '0.445'
        , error_description = ''
        , memory_used = '2971864'
        WHERE id = '187276713';
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062320240914204612500422642&xml_user_id=2406&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=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:21:09.178'
        , request_start_time = '0.035'
        , parsing_start_time = '0.186'
        , mapping_complete_time = '0.099'
        , mongo_start_time = '0.133'
        , search_end_time = '0.001'
        , total_duration = '0.440'
        , error_description = ''
        , memory_used = '2971816'
        WHERE id = '187276714';
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062320240914204612500422642&xml_user_id=2406&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=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:21:09.180'
        , request_start_time = '0.029'
        , parsing_start_time = '0.205'
        , mapping_complete_time = '0.070'
        , mongo_start_time = '0.099'
        , search_end_time = '0.000'
        , total_duration = '0.438'
        , error_description = ''
        , memory_used = '2971800'
        WHERE id = '187276716';
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062320240914204612500422642&xml_user_id=2406&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=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:21:09.203'
        , request_start_time = '0.033'
        , parsing_start_time = '0.204'
        , mapping_complete_time = '0.089'
        , mongo_start_time = '0.100'
        , search_end_time = '0.000'
        , total_duration = '0.426'
        , error_description = ''
        , memory_used = '2971792'
        WHERE id = '187276718';
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062320240914204612500422642&xml_user_id=2406&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=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:21:09.180'
        , request_start_time = '0.028'
        , parsing_start_time = '0.200'
        , mapping_complete_time = '0.075'
        , mongo_start_time = '0.128'
        , search_end_time = '0.000'
        , total_duration = '0.459'
        , error_description = ''
        , memory_used = '2971768'
        WHERE id = '187276715';
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062320240914204612500422642&xml_user_id=2406&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=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:21:09.183'
        , request_start_time = '0.028'
        , parsing_start_time = '0.210'
        , mapping_complete_time = '0.091'
        , mongo_start_time = '0.113'
        , search_end_time = '0.000'
        , total_duration = '0.452'
        , error_description = ''
        , memory_used = '2971392'
        WHERE id = '187276717';
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062320240914204612500422642&xml_user_id=2406&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=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:21:09.193'
        , request_start_time = '0.030'
        , parsing_start_time = '0.207'
        , mapping_complete_time = '0.097'
        , mongo_start_time = '0.120'
        , search_end_time = '0.001'
        , total_duration = '0.454'
        , error_description = ''
        , memory_used = '2971752'
        WHERE id = '187276719';
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062320240914204612500422642&xml_user_id=2406&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=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:21:09.208'
        , request_start_time = '0.094'
        , parsing_start_time = '0.156'
        , mapping_complete_time = '0.057'
        , mongo_start_time = '0.091'
        , search_end_time = '0.000'
        , total_duration = '0.451'
        , error_description = ''
        , memory_used = '2971032'
        WHERE id = '187276720';
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062320240914204612500422642&xml_user_id=2406&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=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:21:09.178'
        , request_start_time = '0.029'
        , parsing_start_time = '0.215'
        , mapping_complete_time = '0.118'
        , mongo_start_time = '0.160'
        , search_end_time = '0.000'
        , total_duration = '0.510'
        , error_description = ''
        , memory_used = '2971536'
        WHERE id = '187276721';
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=localsystem&sessionid=24062320240914204612500422642&xml_user_id=2406&request_no=8&local_hotel_code=47581&#039;,&#039;47582&#039;,&#039;47583&#039;,&#039;47585&#039;,&#039;47586&#039;,&#039;47594&#039;,&#039;47600&#039;,&#039;47674&#039;,&#039;47680&#039;,&#039;47685&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:21:09.260'
        , request_start_time = '0.461'
        , parsing_start_time = '0.063'
        , mapping_complete_time = '0.046'
        , mongo_start_time = '0.047'
        , search_end_time = '0.000'
        , total_duration = '0.671'
        , error_description = ''
        , memory_used = '13087720'
        WHERE id = '187276671';
[09/23/2024 02:21:09], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=localsystem&sessionid=24062320240914204612500422642&xml_user_id=2406&request_no=25&local_hotel_code=48607&#039;,&#039;48609&#039;,&#039;48610&#039;,&#039;48612&#039;,&#039;48613&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:21:09.298'
        , request_start_time = '0.433'
        , parsing_start_time = '0.188'
        , mapping_complete_time = '0.009'
        , mongo_start_time = '0.010'
        , search_end_time = '0.000'
        , total_duration = '0.699'
        , error_description = ''
        , memory_used = '4927944'
        WHERE id = '187276672';
[09/23/2024 02:21:10], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=localsystem&sessionid=24062320240914204612500422642&xml_user_id=2406&request_no=0&local_hotel_code=0&#039;,&#039;19640&#039;,&#039;19641&#039;,&#039;19642&#039;,&#039;19643&#039;,&#039;19644&#039;,&#039;19645&#039;,&#039;19646&#039;,&#039;19647&#039;,&#039;19648&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:21:09.232'
        , request_start_time = '0.396'
        , parsing_start_time = '0.365'
        , mapping_complete_time = '0.021'
        , mongo_start_time = '0.022'
        , search_end_time = '0.000'
        , total_duration = '0.884'
        , error_description = ''
        , memory_used = '11967776'
        WHERE id = '187276666';
[09/23/2024 02:21:10], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=localsystem&sessionid=24062320240914204612500422642&xml_user_id=2406&request_no=13&local_hotel_code=48137&#039;,&#039;48138&#039;,&#039;48141&#039;,&#039;48148&#039;,&#039;48154&#039;,&#039;48155&#039;,&#039;48159&#039;,&#039;48161&#039;,&#039;48164&#039;,&#039;48172&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:21:09.273'
        , request_start_time = '0.728'
        , parsing_start_time = '0.083'
        , mapping_complete_time = '0.033'
        , mongo_start_time = '0.034'
        , search_end_time = '0.001'
        , total_duration = '0.942'
        , error_description = ''
        , memory_used = '13087832'
        WHERE id = '187276687';
[09/23/2024 02:21:10], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=localsystem&sessionid=24062320240914204612500422642&xml_user_id=2406&request_no=12&local_hotel_code=48099&#039;,&#039;48106&#039;,&#039;48115&#039;,&#039;48116&#039;,&#039;48118&#039;,&#039;48126&#039;,&#039;48127&#039;,&#039;48128&#039;,&#039;48130&#039;,&#039;48135&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:21:09.285'
        , request_start_time = '0.564'
        , parsing_start_time = '0.189'
        , mapping_complete_time = '0.088'
        , mongo_start_time = '0.088'
        , search_end_time = '0.000'
        , total_duration = '0.955'
        , error_description = ''
        , memory_used = '13087832'
        WHERE id = '187276698';
[09/23/2024 02:21:10], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '3'
        , request_url = '/call.php?s=localsystem&sessionid=24062320240914204612500422642&xml_user_id=2406&request_no=22&local_hotel_code=48533&#039;,&#039;48544&#039;,&#039;48553&#039;,&#039;48555&#039;,&#039;48557&#039;,&#039;48558&#039;,&#039;48559&#039;,&#039;48560&#039;,&#039;48561&#039;,&#039;48562&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:21:09.294'
        , request_start_time = '0.494'
        , parsing_start_time = '0.289'
        , mapping_complete_time = '0.083'
        , mongo_start_time = '0.084'
        , search_end_time = '0.033'
        , total_duration = '0.978'
        , error_description = ''
        , memory_used = '13087832'
        WHERE id = '187276682';
[09/23/2024 02:21:10], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=localsystem&sessionid=24062320240914204612500422642&xml_user_id=2406&request_no=2&local_hotel_code=19659&#039;,&#039;19660&#039;,&#039;19661&#039;,&#039;19662&#039;,&#039;19663&#039;,&#039;19664&#039;,&#039;19665&#039;,&#039;19666&#039;,&#039;19667&#039;,&#039;19668&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:21:09.239'
        , request_start_time = '0.592'
        , parsing_start_time = '0.310'
        , mapping_complete_time = '0.016'
        , mongo_start_time = '0.016'
        , search_end_time = '0.000'
        , total_duration = '1.048'
        , error_description = ''
        , memory_used = '13130064'
        WHERE id = '187276679';
[09/23/2024 02:21:10], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=localsystem&sessionid=24062320240914204612500422642&xml_user_id=2406&request_no=4&local_hotel_code=19679&#039;,&#039;19680&#039;,&#039;19681&#039;,&#039;19682&#039;,&#039;19683&#039;,&#039;19684&#039;,&#039;19685&#039;,&#039;19686&#039;,&#039;19687&#039;,&#039;47435&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:21:09.246'
        , request_start_time = '0.850'
        , parsing_start_time = '0.087'
        , mapping_complete_time = '0.023'
        , mongo_start_time = '0.023'
        , search_end_time = '0.000'
        , total_duration = '1.062'
        , error_description = ''
        , memory_used = '13124040'
        WHERE id = '187276688';
[09/23/2024 02:21:10], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '1'
        , request_url = '/call.php?s=localsystem&sessionid=24062320240914204612500422642&xml_user_id=2406&request_no=3&local_hotel_code=19669&#039;,&#039;19670&#039;,&#039;19671&#039;,&#039;19672&#039;,&#039;19673&#039;,&#039;19674&#039;,&#039;19675&#039;,&#039;19676&#039;,&#039;19677&#039;,&#039;19678&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:21:09.235'
        , request_start_time = '0.671'
        , parsing_start_time = '0.263'
        , mapping_complete_time = '0.032'
        , mongo_start_time = '0.033'
        , search_end_time = '0.025'
        , total_duration = '1.118'
        , error_description = ''
        , memory_used = '13124040'
        WHERE id = '187276674';
[09/23/2024 02:21:10], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '1'
        , request_url = '/call.php?s=localsystem&sessionid=24062320240914204612500422642&xml_user_id=2406&request_no=11&local_hotel_code=48050&#039;,&#039;48053&#039;,&#039;48061&#039;,&#039;48072&#039;,&#039;48083&#039;,&#039;48084&#039;,&#039;48087&#039;,&#039;48090&#039;,&#039;48093&#039;,&#039;48096&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:21:09.281'
        , request_start_time = '0.734'
        , parsing_start_time = '0.207'
        , mapping_complete_time = '0.038'
        , mongo_start_time = '0.038'
        , search_end_time = '0.028'
        , total_duration = '1.096'
        , error_description = ''
        , memory_used = '13087832'
        WHERE id = '187276684';
[09/23/2024 02:21:10], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '1'
        , request_url = '/call.php?s=localsystem&sessionid=24062320240914204612500422642&xml_user_id=2406&request_no=16&local_hotel_code=48248&#039;,&#039;48250&#039;,&#039;48257&#039;,&#039;48258&#039;,&#039;48259&#039;,&#039;48260&#039;,&#039;48261&#039;,&#039;48262&#039;,&#039;48263&#039;,&#039;48270&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:21:09.291'
        , request_start_time = '0.560'
        , parsing_start_time = '0.398'
        , mapping_complete_time = '0.023'
        , mongo_start_time = '0.023'
        , search_end_time = '0.039'
        , total_duration = '1.098'
        , error_description = ''
        , memory_used = '13087832'
        WHERE id = '187276670';
[09/23/2024 02:21:10], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=localsystem&sessionid=24062320240914204612500422642&xml_user_id=2406&request_no=14&local_hotel_code=48173&#039;,&#039;48174&#039;,&#039;48190&#039;,&#039;48192&#039;,&#039;48196&#039;,&#039;48197&#039;,&#039;48200&#039;,&#039;48209&#039;,&#039;48212&#039;,&#039;48219&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:21:09.276'
        , request_start_time = '0.906'
        , parsing_start_time = '0.079'
        , mapping_complete_time = '0.064'
        , mongo_start_time = '0.065'
        , search_end_time = '0.000'
        , total_duration = '1.148'
        , error_description = ''
        , memory_used = '13087832'
        WHERE id = '187276678';
[09/23/2024 02:21:10], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '1'
        , request_url = '/call.php?s=localsystem&sessionid=24062320240914204612500422642&xml_user_id=2406&request_no=10&local_hotel_code=48000&#039;,&#039;48002&#039;,&#039;48003&#039;,&#039;48007&#039;,&#039;48031&#039;,&#039;48037&#039;,&#039;48038&#039;,&#039;48039&#039;,&#039;48040&#039;,&#039;48041&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:21:09.278'
        , request_start_time = '0.763'
        , parsing_start_time = '0.214'
        , mapping_complete_time = '0.062'
        , mongo_start_time = '0.062'
        , search_end_time = '0.032'
        , total_duration = '1.160'
        , error_description = ''
        , memory_used = '13087832'
        WHERE id = '187276690';
[09/23/2024 02:21:10], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '1'
        , request_url = '/call.php?s=localsystem&sessionid=24062320240914204612500422642&xml_user_id=2406&request_no=9&local_hotel_code=47686&#039;,&#039;47836&#039;,&#039;47931&#039;,&#039;47975&#039;,&#039;47986&#039;,&#039;47990&#039;,&#039;47992&#039;,&#039;47996&#039;,&#039;47997&#039;,&#039;47998&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:21:09.285'
        , request_start_time = '0.564'
        , parsing_start_time = '0.309'
        , mapping_complete_time = '0.139'
        , mongo_start_time = '0.140'
        , search_end_time = '0.047'
        , total_duration = '1.173'
        , error_description = ''
        , memory_used = '13087720'
        WHERE id = '187276694';
[09/23/2024 02:21:10], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=localsystem&sessionid=24062320240914204612500422642&xml_user_id=2406&request_no=5&local_hotel_code=47436&#039;,&#039;47440&#039;,&#039;47451&#039;,&#039;47452&#039;,&#039;47454&#039;,&#039;47465&#039;,&#039;47468&#039;,&#039;47470&#039;,&#039;47471&#039;,&#039;47472&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:21:09.259'
        , request_start_time = '0.912'
        , parsing_start_time = '0.167'
        , mapping_complete_time = '0.013'
        , mongo_start_time = '0.013'
        , search_end_time = '0.000'
        , total_duration = '1.206'
        , error_description = ''
        , memory_used = '13124040'
        WHERE id = '187276689';
[09/23/2024 02:21:10], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=localsystem&sessionid=24062320240914204612500422642&xml_user_id=2406&request_no=19&local_hotel_code=48404&#039;,&#039;48406&#039;,&#039;48410&#039;,&#039;48413&#039;,&#039;48416&#039;,&#039;48417&#039;,&#039;48419&#039;,&#039;48422&#039;,&#039;48426&#039;,&#039;48427&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:21:09.284'
        , request_start_time = '0.963'
        , parsing_start_time = '0.119'
        , mapping_complete_time = '0.005'
        , mongo_start_time = '0.006'
        , search_end_time = '0.000'
        , total_duration = '1.185'
        , error_description = ''
        , memory_used = '13087832'
        WHERE id = '187276691';
[09/23/2024 02:21:10], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '2'
        , request_url = '/call.php?s=localsystem&sessionid=24062320240914204612500422642&xml_user_id=2406&request_no=17&local_hotel_code=48272&#039;,&#039;48276&#039;,&#039;48277&#039;,&#039;48279&#039;,&#039;48280&#039;,&#039;48283&#039;,&#039;48287&#039;,&#039;48291&#039;,&#039;48292&#039;,&#039;48293&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:21:09.285'
        , request_start_time = '0.431'
        , parsing_start_time = '0.564'
        , mapping_complete_time = '0.076'
        , mongo_start_time = '0.077'
        , search_end_time = '0.053'
        , total_duration = '1.210'
        , error_description = ''
        , memory_used = '13087832'
        WHERE id = '187276686';
[09/23/2024 02:21:10], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=localsystem&sessionid=24062320240914204612500422642&xml_user_id=2406&request_no=1&local_hotel_code=19649&#039;,&#039;19650&#039;,&#039;19651&#039;,&#039;19652&#039;,&#039;19653&#039;,&#039;19654&#039;,&#039;19655&#039;,&#039;19656&#039;,&#039;19657&#039;,&#039;19658&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:21:09.232'
        , request_start_time = '1.069'
        , parsing_start_time = '0.083'
        , mapping_complete_time = '0.005'
        , mongo_start_time = '0.005'
        , search_end_time = '0.000'
        , total_duration = '1.271'
        , error_description = ''
        , memory_used = '13128112'
        WHERE id = '187276681';
[09/23/2024 02:21:10], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '1'
        , request_url = '/call.php?s=localsystem&sessionid=24062320240914204612500422642&xml_user_id=2406&request_no=20&local_hotel_code=48431&#039;,&#039;48435&#039;,&#039;48441&#039;,&#039;48442&#039;,&#039;48447&#039;,&#039;48448&#039;,&#039;48456&#039;,&#039;48473&#039;,&#039;48474&#039;,&#039;48486&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:21:09.293'
        , request_start_time = '0.620'
        , parsing_start_time = '0.502'
        , mapping_complete_time = '0.079'
        , mongo_start_time = '0.079'
        , search_end_time = '0.009'
        , total_duration = '1.287'
        , error_description = ''
        , memory_used = '13087832'
        WHERE id = '187276680';
[09/23/2024 02:21:10], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '1'
        , request_url = '/call.php?s=localsystem&sessionid=24062320240914204612500422642&xml_user_id=2406&request_no=15&local_hotel_code=48220&#039;,&#039;48222&#039;,&#039;48224&#039;,&#039;48234&#039;,&#039;48235&#039;,&#039;48238&#039;,&#039;48241&#039;,&#039;48245&#039;,&#039;48246&#039;,&#039;48247&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:21:09.278'
        , request_start_time = '0.902'
        , parsing_start_time = '0.245'
        , mapping_complete_time = '0.053'
        , mongo_start_time = '0.054'
        , search_end_time = '0.029'
        , total_duration = '1.323'
        , error_description = ''
        , memory_used = '13087832'
        WHERE id = '187276675';
[09/23/2024 02:21:10], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '1'
        , request_url = '/call.php?s=localsystem&sessionid=24062320240914204612500422642&xml_user_id=2406&request_no=6&local_hotel_code=47475&#039;,&#039;47476&#039;,&#039;47477&#039;,&#039;47482&#039;,&#039;47487&#039;,&#039;47489&#039;,&#039;47491&#039;,&#039;47496&#039;,&#039;47497&#039;,&#039;47498&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:21:09.284'
        , request_start_time = '0.963'
        , parsing_start_time = '0.238'
        , mapping_complete_time = '0.025'
        , mongo_start_time = '0.026'
        , search_end_time = '0.009'
        , total_duration = '1.335'
        , error_description = ''
        , memory_used = '11957600'
        WHERE id = '187276685';
[09/23/2024 02:21:10], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '1'
        , request_url = '/call.php?s=localsystem&sessionid=24062320240914204612500422642&xml_user_id=2406&request_no=21&local_hotel_code=48492&#039;,&#039;48499&#039;,&#039;48510&#039;,&#039;48511&#039;,&#039;48512&#039;,&#039;48514&#039;,&#039;48518&#039;,&#039;48527&#039;,&#039;48529&#039;,&#039;48532&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:21:09.291'
        , request_start_time = '0.909'
        , parsing_start_time = '0.328'
        , mapping_complete_time = '0.010'
        , mongo_start_time = '0.011'
        , search_end_time = '0.018'
        , total_duration = '1.339'
        , error_description = ''
        , memory_used = '13087720'
        WHERE id = '187276676';
[09/23/2024 02:21:10], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '1'
        , request_url = '/call.php?s=localsystem&sessionid=24062320240914204612500422642&xml_user_id=2406&request_no=7&local_hotel_code=47499&#039;,&#039;47501&#039;,&#039;47505&#039;,&#039;47510&#039;,&#039;47512&#039;,&#039;47513&#039;,&#039;47541&#039;,&#039;47575&#039;,&#039;47576&#039;,&#039;47579&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:21:09.274'
        , request_start_time = '1.003'
        , parsing_start_time = '0.301'
        , mapping_complete_time = '0.019'
        , mongo_start_time = '0.019'
        , search_end_time = '0.013'
        , total_duration = '1.443'
        , error_description = ''
        , memory_used = '13087720'
        WHERE id = '187276683';
[09/23/2024 02:21:10], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '4'
        , request_url = '/call.php?s=localsystem&sessionid=24062320240914204612500422642&xml_user_id=2406&request_no=18&local_hotel_code=48294&#039;,&#039;48298&#039;,&#039;48300&#039;,&#039;48303&#039;,&#039;48304&#039;,&#039;48312&#039;,&#039;48383&#039;,&#039;48384&#039;,&#039;48391&#039;,&#039;48403&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:21:09.295'
        , request_start_time = '0.511'
        , parsing_start_time = '0.883'
        , mapping_complete_time = '0.043'
        , mongo_start_time = '0.044'
        , search_end_time = '0.014'
        , total_duration = '1.566'
        , error_description = ''
        , memory_used = '13087832'
        WHERE id = '187276696';
[09/23/2024 02:21:11], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '4'
        , request_url = '/call.php?s=localsystem&sessionid=24062320240914204612500422642&xml_user_id=2406&request_no=24&local_hotel_code=48575&#039;,&#039;48576&#039;,&#039;48589&#039;,&#039;48590&#039;,&#039;48592&#039;,&#039;48593&#039;,&#039;48596&#039;,&#039;48597&#039;,&#039;48598&#039;,&#039;48599&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:21:09.296'
        , request_start_time = '0.890'
        , parsing_start_time = '0.669'
        , mapping_complete_time = '0.056'
        , mongo_start_time = '0.057'
        , search_end_time = '0.016'
        , total_duration = '1.719'
        , error_description = ''
        , memory_used = '13087720'
        WHERE id = '187276697';
[09/23/2024 02:21:11], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '7'
        , request_url = '/call.php?s=localsystem&sessionid=24062320240914204612500422642&xml_user_id=2406&request_no=23&local_hotel_code=48563&#039;,&#039;48564&#039;,&#039;48565&#039;,&#039;48566&#039;,&#039;48567&#039;,&#039;48568&#039;,&#039;48569&#039;,&#039;48572&#039;,&#039;48573&#039;,&#039;48574&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:21:09.295'
        , request_start_time = '0.913'
        , parsing_start_time = '0.671'
        , mapping_complete_time = '0.059'
        , mongo_start_time = '0.060'
        , search_end_time = '0.016'
        , total_duration = '1.737'
        , error_description = ''
        , memory_used = '13087832'
        WHERE id = '187276692';
[09/23/2024 02:21:14], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/23_09_2024/request_availability_Qtech_pranali_14_21_10_17271012705.json', 'rh/23_09_2024/response_availability_Qtech_pranali_14_21_10_17271012705.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_14_21_10_17271012705.json', 'ratehawk', '2024-09-23 02:21:14', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_14_21_10_17271012705.json');
[09/23/2024 02:21:15], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '23'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240914204612500422642&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=5&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:21:09.209'
        , request_start_time = '1.008'
        , parsing_start_time = '4.590'
        , mapping_complete_time = '0.067'
        , mongo_start_time = '0.112'
        , search_end_time = '0.055'
        , total_duration = '5.877'
        , error_description = ''
        , memory_used = '43578936'
        WHERE id = '187276722';
[09/23/2024 02:21:15], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/23_09_2024/request_availability_Qtech_pranali_14_21_09_17271012692.json', 'rh/23_09_2024/response_availability_Qtech_pranali_14_21_09_17271012692.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_14_21_09_17271012692.json', 'ratehawk', '2024-09-23 02:21:15', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_14_21_09_17271012692.json');
[09/23/2024 02:21:15], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/23_09_2024/request_availability_Qtech_pranali_14_21_09_17271012690.json', 'rh/23_09_2024/response_availability_Qtech_pranali_14_21_09_17271012690.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_14_21_09_17271012690.json', 'ratehawk', '2024-09-23 02:21:15', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_14_21_09_17271012690.json');
[09/23/2024 02:21:15], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/23_09_2024/request_availability_Qtech_pranali_14_21_10_17271012703.json', 'rh/23_09_2024/response_availability_Qtech_pranali_14_21_10_17271012703.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_14_21_10_17271012703.json', 'ratehawk', '2024-09-23 02:21:15', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_14_21_10_17271012703.json');
[09/23/2024 02:21:16], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '51'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240914204612500422642&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=3&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:21:09.209'
        , request_start_time = '1.263'
        , parsing_start_time = '5.212'
        , mapping_complete_time = '0.096'
        , mongo_start_time = '0.177'
        , search_end_time = '0.126'
        , total_duration = '6.908'
        , error_description = ''
        , memory_used = '75415968'
        WHERE id = '187276725';
[09/23/2024 02:21:16], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/23_09_2024/request_availability_Qtech_pranali_14_21_10_172710127010.json', 'rh/23_09_2024/response_availability_Qtech_pranali_14_21_10_172710127010.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_14_21_10_172710127010.json', 'ratehawk', '2024-09-23 02:21:16', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_14_21_10_172710127010.json');
[09/23/2024 02:21:16], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '69'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240914204612500422642&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=0&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:21:09.209'
        , request_start_time = '0.096'
        , parsing_start_time = '6.316'
        , mapping_complete_time = '0.153'
        , mongo_start_time = '0.299'
        , search_end_time = '0.163'
        , total_duration = '6.989'
        , error_description = ''
        , memory_used = '105748184'
        WHERE id = '187276724';
[09/23/2024 02:21:16], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '20'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240914204612500422642&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=10&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:21:09.224'
        , request_start_time = '1.199'
        , parsing_start_time = '5.667'
        , mapping_complete_time = '0.030'
        , mongo_start_time = '0.058'
        , search_end_time = '0.068'
        , total_duration = '7.080'
        , error_description = ''
        , memory_used = '17848064'
        WHERE id = '187276726';
[09/23/2024 02:21:16], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/23_09_2024/request_availability_Qtech_pranali_14_21_10_172710127012.json', 'rh/23_09_2024/response_availability_Qtech_pranali_14_21_10_172710127012.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_14_21_10_172710127012.json', 'ratehawk', '2024-09-23 02:21:16', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_14_21_10_172710127012.json');
[09/23/2024 02:21:16], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '31'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240914204612500422642&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=12&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:21:09.233'
        , request_start_time = '1.071'
        , parsing_start_time = '5.879'
        , mapping_complete_time = '0.063'
        , mongo_start_time = '0.112'
        , search_end_time = '0.071'
        , total_duration = '7.274'
        , error_description = ''
        , memory_used = '40454000'
        WHERE id = '187276727';
[09/23/2024 02:21:16], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '105'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240914204612500422642&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=2&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:21:09.209'
        , request_start_time = '0.682'
        , parsing_start_time = '5.596'
        , mapping_complete_time = '0.255'
        , mongo_start_time = '0.548'
        , search_end_time = '0.345'
        , total_duration = '7.308'
        , error_description = ''
        , memory_used = '183807080'
        WHERE id = '187276723';
[09/23/2024 02:21:16], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/23_09_2024/request_availability_Qtech_pranali_14_21_10_172710127011.json', 'rh/23_09_2024/response_availability_Qtech_pranali_14_21_10_172710127011.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_14_21_10_172710127011.json', 'ratehawk', '2024-09-23 02:21:16', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_14_21_10_172710127011.json');
[09/23/2024 02:21:16], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/23_09_2024/request_availability_Qtech_pranali_14_21_10_17271012706.json', 'rh/23_09_2024/response_availability_Qtech_pranali_14_21_10_17271012706.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_14_21_10_17271012706.json', 'ratehawk', '2024-09-23 02:21:16', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_14_21_10_17271012706.json');
[09/23/2024 02:21:16], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '20'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240914204612500422642&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=11&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:21:09.230'
        , request_start_time = '0.967'
        , parsing_start_time = '6.233'
        , mapping_complete_time = '0.041'
        , mongo_start_time = '0.073'
        , search_end_time = '0.045'
        , total_duration = '7.444'
        , error_description = ''
        , memory_used = '26569104'
        WHERE id = '187276728';
[09/23/2024 02:21:16], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '35'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240914204612500422642&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=6&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:21:09.211'
        , request_start_time = '1.109'
        , parsing_start_time = '6.238'
        , mapping_complete_time = '0.091'
        , mongo_start_time = '0.153'
        , search_end_time = '0.107'
        , total_duration = '7.720'
        , error_description = ''
        , memory_used = '59103776'
        WHERE id = '187276729';
[09/23/2024 02:21:17], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/23_09_2024/request_availability_Qtech_pranali_14_21_10_17271012707.json', 'rh/23_09_2024/response_availability_Qtech_pranali_14_21_10_17271012707.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_14_21_10_17271012707.json', 'ratehawk', '2024-09-23 02:21:17', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_14_21_10_17271012707.json');
[09/23/2024 02:21:17], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '37'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240914204612500422642&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=7&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:21:09.214'
        , request_start_time = '1.305'
        , parsing_start_time = '6.548'
        , mapping_complete_time = '0.098'
        , mongo_start_time = '0.162'
        , search_end_time = '0.089'
        , total_duration = '8.204'
        , error_description = ''
        , memory_used = '65830920'
        WHERE id = '187276730';
[09/23/2024 02:21:17], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/23_09_2024/request_availability_Qtech_pranali_14_21_10_17271012704.json', 'rh/23_09_2024/response_availability_Qtech_pranali_14_21_10_17271012704.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_14_21_10_17271012704.json', 'ratehawk', '2024-09-23 02:21:17', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_14_21_10_17271012704.json');
[09/23/2024 02:21:18], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '42'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240914204612500422642&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=4&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:21:09.208'
        , request_start_time = '1.183'
        , parsing_start_time = '7.237'
        , mapping_complete_time = '0.124'
        , mongo_start_time = '0.199'
        , search_end_time = '0.118'
        , total_duration = '8.853'
        , error_description = ''
        , memory_used = '85151168'
        WHERE id = '187276731';
[09/23/2024 02:21:26], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/23_09_2024/request_availability_Qtech_pranali_14_21_09_17271012699.json', 'rh/23_09_2024/response_availability_Qtech_pranali_14_21_09_17271012699.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_14_21_09_17271012699.json', 'ratehawk', '2024-09-23 02:21:26', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_14_21_09_17271012699.json');
[09/23/2024 02:21:26], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/23_09_2024/request_availability_Qtech_pranali_14_21_09_17271012691.json', 'rh/23_09_2024/response_availability_Qtech_pranali_14_21_09_17271012691.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_14_21_09_17271012691.json', 'ratehawk', '2024-09-23 02:21:26', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_14_21_09_17271012691.json');
[09/23/2024 02:21:26], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/23_09_2024/request_availability_Qtech_pranali_14_21_10_17271012708.json', 'rh/23_09_2024/response_availability_Qtech_pranali_14_21_10_17271012708.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_14_21_10_17271012708.json', 'ratehawk', '2024-09-23 02:21:26', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_14_21_10_17271012708.json');
[09/23/2024 02:21:26], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '37'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240914204612500422642&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=9&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:21:09.225'
        , request_start_time = '0.667'
        , parsing_start_time = '16.263'
        , mapping_complete_time = '0.090'
        , mongo_start_time = '0.151'
        , search_end_time = '0.087'
        , total_duration = '17.269'
        , error_description = ''
        , memory_used = '59560280'
        WHERE id = '187276884';
[09/23/2024 02:21:26], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '35'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240914204612500422642&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=8&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:21:09.221'
        , request_start_time = '1.292'
        , parsing_start_time = '15.852'
        , mapping_complete_time = '0.090'
        , mongo_start_time = '0.148'
        , search_end_time = '0.082'
        , total_duration = '17.468'
        , error_description = ''
        , memory_used = '59784232'
        WHERE id = '187276886';
[09/23/2024 02:21:27], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '137'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240914204612500422642&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=1&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:21:09.203'
        , request_start_time = '0.125'
        , parsing_start_time = '16.997'
        , mapping_complete_time = '0.319'
        , mongo_start_time = '0.685'
        , search_end_time = '0.366'
        , total_duration = '18.302'
        , error_description = ''
        , memory_used = '219713128'
        WHERE id = '187276885';
[09/23/2024 02:21:28], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '621',
        request_path = '/xml_all.php?userid=2406&sessionid=24062320240914204612500422642',
        duration = '20.463',
        merge_duration = '0.117',
        assigned_supplier_count = '3',
        searched_supplier_count = '3',
        system_load_1_min = '0.96',
        system_load_5_min = '2.70',
        system_load_15_min = '4.60',
        system_memory_usage = '33.86',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '16479389') + '7656984',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '16479389';
[09/23/2024 02:21:29], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_2406_24062320240914204612500422642', session_id='24062320240914204612500422642', Collection_create_time='2024-09-23 14:21:29';
[09/23/2024 02:21:48], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'a5/23_09_2024/request_availability_Qtech_pranali_14_21_48_1727101308_0.json', 'a5/23_09_2024/response_availability_Qtech_pranali_14_21_48_1727101308_0.json', 'a5/23_09_2024/response_header_availability_Qtech_pranali_14_21_48_1727101308_0.json', 'agoda', '2024-09-23 02:21:48', '', '24062320240914204612500422642', '16479389', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/23_09_2024/response_availability_Qtech_pranali_14_21_48_1727101308_0.json');
[09/23/2024 02:21:48], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062320240914204612500422642&xml_user_id=2406&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=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 14:21:48.114'
        , request_start_time = '0.015'
        , parsing_start_time = '0.089'
        , mapping_complete_time = '0.024'
        , mongo_start_time = '0.030'
        , search_end_time = '0.000'
        , total_duration = '0.162'
        , error_description = ''
        , memory_used = '3103888'
        WHERE id = '187276922';
