[12/17/2024 01:07:29], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-12-17 01:07:29',login_attempt=0 where id = '1284';
[12/17/2024 01:07:29], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'qtech_agent', user_type = 'A', branch_id = '26', login_datetime = '2024-12-17 13:07:29', ip = '43.239.53.130', action = 'Login' ;
[12/17/2024 01:08:21], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '1284' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '129' , service_type = 'hotel' , arrival_date = '2024/12/26' , departure_date = '2024/12/27' , nights = '1' , nationality = '129' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-12-17 13:08:21' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'INR' , currency_code = 'INR' , web_service = '0' ;
[12/17/2024 01:08:22], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_1284_12841720241213082193815834634', session_id='12841720241213082193815834634', Collection_create_time='2024-12-17 13:08:22';
[12/17/2024 01:08:23], [file name :-/efsdata/otrams/public_html/beta/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', 'h1/17_12_2024/request_availability_qtech_agent_13_08_22_1734440902_74_6.json', 'h1/17_12_2024/response_availability_qtech_agent_13_08_22_1734440902_74_6.json', 'h1/17_12_2024/response_header_availability_qtech_agent_13_08_22_1734440902_74_6.json', 'hotelbeds', '2024-12-17 01:08:23', '\n', '12841720241213082193815834634', '18474725', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/h1/17_12_2024/response_availability_qtech_agent_13_08_22_1734440902_74_6.json');
[12/17/2024 01:08:23], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '38'
        , request_url = '/call.php?s=hotelbeds&sessionid=12841720241213082193815834634&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=6&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-12-17 13:08:22.574'
        , request_start_time = '0.024'
        , parsing_start_time = '0.775'
        , mapping_complete_time = '0.031'
        , mongo_start_time = '0.113'
        , search_end_time = '0.256'
        , total_duration = '1.237'
        , error_description = ''
        , memory_used = '20750160'
        WHERE id = '207763435';
[12/17/2024 01:08:23], [file name :-/efsdata/otrams/public_html/beta/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', 'h1/17_12_2024/request_availability_qtech_agent_13_08_22_1734440902_78_5.json', 'h1/17_12_2024/response_availability_qtech_agent_13_08_22_1734440902_78_5.json', 'h1/17_12_2024/response_header_availability_qtech_agent_13_08_22_1734440902_78_5.json', 'hotelbeds', '2024-12-17 01:08:23', '\n', '12841720241213082193815834634', '18474725', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/h1/17_12_2024/response_availability_qtech_agent_13_08_22_1734440902_78_5.json');
[12/17/2024 01:08:24], [file name :-/efsdata/otrams/public_html/beta/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', 'h1/17_12_2024/request_availability_qtech_agent_13_08_22_1734440902_88_1.json', 'h1/17_12_2024/response_availability_qtech_agent_13_08_22_1734440902_88_1.json', 'h1/17_12_2024/response_header_availability_qtech_agent_13_08_22_1734440902_88_1.json', 'hotelbeds', '2024-12-17 01:08:24', '\n', '12841720241213082193815834634', '18474725', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/h1/17_12_2024/response_availability_qtech_agent_13_08_22_1734440902_88_1.json');
[12/17/2024 01:08:24], [file name :-/efsdata/otrams/public_html/beta/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', 'h1/17_12_2024/request_availability_qtech_agent_13_08_22_1734440902_65_4.json', 'h1/17_12_2024/response_availability_qtech_agent_13_08_22_1734440902_65_4.json', 'h1/17_12_2024/response_header_availability_qtech_agent_13_08_22_1734440902_65_4.json', 'hotelbeds', '2024-12-17 01:08:24', '\n', '12841720241213082193815834634', '18474725', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/h1/17_12_2024/response_availability_qtech_agent_13_08_22_1734440902_65_4.json');
[12/17/2024 01:08:24], [file name :-/efsdata/otrams/public_html/beta/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', 'h1/17_12_2024/request_availability_qtech_agent_13_08_22_1734440902_97_3.json', 'h1/17_12_2024/response_availability_qtech_agent_13_08_22_1734440902_97_3.json', 'h1/17_12_2024/response_header_availability_qtech_agent_13_08_22_1734440902_97_3.json', 'hotelbeds', '2024-12-17 01:08:24', '\n', '12841720241213082193815834634', '18474725', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/h1/17_12_2024/response_availability_qtech_agent_13_08_22_1734440902_97_3.json');
[12/17/2024 01:08:24], [file name :-/efsdata/otrams/public_html/beta/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', 'h1/17_12_2024/request_availability_qtech_agent_13_08_22_1734440902_37_2.json', 'h1/17_12_2024/response_availability_qtech_agent_13_08_22_1734440902_37_2.json', 'h1/17_12_2024/response_header_availability_qtech_agent_13_08_22_1734440902_37_2.json', 'hotelbeds', '2024-12-17 01:08:24', '\n', '12841720241213082193815834634', '18474725', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/h1/17_12_2024/response_availability_qtech_agent_13_08_22_1734440902_37_2.json');
[12/17/2024 01:08:24], [file name :-/efsdata/otrams/public_html/beta/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', 'h1/17_12_2024/request_availability_qtech_agent_13_08_22_1734440902_47_0.json', 'h1/17_12_2024/response_availability_qtech_agent_13_08_22_1734440902_47_0.json', 'h1/17_12_2024/response_header_availability_qtech_agent_13_08_22_1734440902_47_0.json', 'hotelbeds', '2024-12-17 01:08:24', '\n', '12841720241213082193815834634', '18474725', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/h1/17_12_2024/response_availability_qtech_agent_13_08_22_1734440902_47_0.json');
[12/17/2024 01:08:24], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '74'
        , request_url = '/call.php?s=hotelbeds&sessionid=12841720241213082193815834634&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=1&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-12-17 13:08:22.564'
        , request_start_time = '0.020'
        , parsing_start_time = '1.312'
        , mapping_complete_time = '0.061'
        , mongo_start_time = '0.309'
        , search_end_time = '0.512'
        , total_duration = '2.235'
        , error_description = ''
        , memory_used = '35002048'
        WHERE id = '207763446';
[12/17/2024 01:08:24], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '81'
        , request_url = '/call.php?s=hotelbeds&sessionid=12841720241213082193815834634&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=5&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-12-17 13:08:22.566'
        , request_start_time = '0.035'
        , parsing_start_time = '1.188'
        , mapping_complete_time = '0.063'
        , mongo_start_time = '0.375'
        , search_end_time = '0.623'
        , total_duration = '2.290'
        , error_description = ''
        , memory_used = '43542016'
        WHERE id = '207763445';
[12/17/2024 01:08:24], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '80'
        , request_url = '/call.php?s=hotelbeds&sessionid=12841720241213082193815834634&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=4&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-12-17 13:08:22.572'
        , request_start_time = '0.028'
        , parsing_start_time = '1.445'
        , mapping_complete_time = '0.059'
        , mongo_start_time = '0.284'
        , search_end_time = '0.494'
        , total_duration = '2.333'
        , error_description = ''
        , memory_used = '37171072'
        WHERE id = '207763455';
[12/17/2024 01:08:24], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '77'
        , request_url = '/call.php?s=hotelbeds&sessionid=12841720241213082193815834634&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=3&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-12-17 13:08:22.565'
        , request_start_time = '0.018'
        , parsing_start_time = '1.491'
        , mapping_complete_time = '0.058'
        , mongo_start_time = '0.215'
        , search_end_time = '0.554'
        , total_duration = '2.385'
        , error_description = ''
        , memory_used = '33881544'
        WHERE id = '207763461';
[12/17/2024 01:08:25], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '77'
        , request_url = '/call.php?s=hotelbeds&sessionid=12841720241213082193815834634&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=0&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-12-17 13:08:22.572'
        , request_start_time = '0.021'
        , parsing_start_time = '1.919'
        , mapping_complete_time = '0.034'
        , mongo_start_time = '0.186'
        , search_end_time = '0.418'
        , total_duration = '2.636'
        , error_description = ''
        , memory_used = '32834248'
        WHERE id = '207763500';
[12/17/2024 01:08:25], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '83'
        , request_url = '/call.php?s=hotelbeds&sessionid=12841720241213082193815834634&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=2&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-12-17 13:08:22.564'
        , request_start_time = '0.040'
        , parsing_start_time = '1.799'
        , mapping_complete_time = '0.038'
        , mongo_start_time = '0.241'
        , search_end_time = '0.589'
        , total_duration = '2.747'
        , error_description = ''
        , memory_used = '40832600'
        WHERE id = '207763494';
[12/17/2024 01:08: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', 'ebookingcenter/17_12_2024/request_availability_qtech_agent_13_08_22_1734440902_42_9.json', 'ebookingcenter/17_12_2024/response_availability_qtech_agent_13_08_22_1734440902_42_9.json', 'ebookingcenter/17_12_2024/response_header_availability_qtech_agent_13_08_22_1734440902_42_9.json', 'ebookingcenter', '2024-12-17 01:08:26', '', '12841720241213082193815834634', '18474725', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/17_12_2024/response_availability_qtech_agent_13_08_22_1734440902_42_9.json');
[12/17/2024 01:08:26], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '18'
        , request_url = '/call.php?s=ebookingcenter&sessionid=12841720241213082193815834634&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=9&total_request=10&city_code=2555&city_name=DUBAI&country_code=350&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-12-17 13:08:22.565'
        , request_start_time = '0.169'
        , parsing_start_time = '3.299'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.114'
        , search_end_time = '0.135'
        , total_duration = '3.805'
        , error_description = ''
        , memory_used = '27406624'
        WHERE id = '207763558';
[12/17/2024 01:08: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', 'ebookingcenter/17_12_2024/request_availability_qtech_agent_13_08_22_1734440902_74_2.json', 'ebookingcenter/17_12_2024/response_availability_qtech_agent_13_08_22_1734440902_74_2.json', 'ebookingcenter/17_12_2024/response_header_availability_qtech_agent_13_08_22_1734440902_74_2.json', 'ebookingcenter', '2024-12-17 01:08:26', '', '12841720241213082193815834634', '18474725', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/17_12_2024/response_availability_qtech_agent_13_08_22_1734440902_74_2.json');
[12/17/2024 01:08: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', 'ebookingcenter/17_12_2024/request_availability_qtech_agent_13_08_22_1734440902_61_5.json', 'ebookingcenter/17_12_2024/response_availability_qtech_agent_13_08_22_1734440902_61_5.json', 'ebookingcenter/17_12_2024/response_header_availability_qtech_agent_13_08_22_1734440902_61_5.json', 'ebookingcenter', '2024-12-17 01:08:26', '', '12841720241213082193815834634', '18474725', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/17_12_2024/response_availability_qtech_agent_13_08_22_1734440902_61_5.json');
[12/17/2024 01:08: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', 'ebookingcenter/17_12_2024/request_availability_qtech_agent_13_08_22_1734440902_81_1.json', 'ebookingcenter/17_12_2024/response_availability_qtech_agent_13_08_22_1734440902_81_1.json', 'ebookingcenter/17_12_2024/response_header_availability_qtech_agent_13_08_22_1734440902_81_1.json', 'ebookingcenter', '2024-12-17 01:08:26', '', '12841720241213082193815834634', '18474725', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/17_12_2024/response_availability_qtech_agent_13_08_22_1734440902_81_1.json');
[12/17/2024 01:08: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', 'ebookingcenter/17_12_2024/request_availability_qtech_agent_13_08_22_1734440902_48_7.json', 'ebookingcenter/17_12_2024/response_availability_qtech_agent_13_08_22_1734440902_48_7.json', 'ebookingcenter/17_12_2024/response_header_availability_qtech_agent_13_08_22_1734440902_48_7.json', 'ebookingcenter', '2024-12-17 01:08:26', '', '12841720241213082193815834634', '18474725', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/17_12_2024/response_availability_qtech_agent_13_08_22_1734440902_48_7.json');
[12/17/2024 01:08: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', 'ebookingcenter/17_12_2024/request_availability_qtech_agent_13_08_22_1734440902_36_3.json', 'ebookingcenter/17_12_2024/response_availability_qtech_agent_13_08_22_1734440902_36_3.json', 'ebookingcenter/17_12_2024/response_header_availability_qtech_agent_13_08_22_1734440902_36_3.json', 'ebookingcenter', '2024-12-17 01:08:26', '', '12841720241213082193815834634', '18474725', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/17_12_2024/response_availability_qtech_agent_13_08_22_1734440902_36_3.json');
[12/17/2024 01:08:27], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '41'
        , request_url = '/call.php?s=ebookingcenter&sessionid=12841720241213082193815834634&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=2&total_request=10&city_code=2555&city_name=DUBAI&country_code=350&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-12-17 13:08:22.551'
        , request_start_time = '0.178'
        , parsing_start_time = '3.749'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.175'
        , search_end_time = '0.371'
        , total_duration = '4.542'
        , error_description = ''
        , memory_used = '52788304'
        WHERE id = '207763571';
[12/17/2024 01:08:27], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '45'
        , request_url = '/call.php?s=ebookingcenter&sessionid=12841720241213082193815834634&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=5&total_request=10&city_code=2555&city_name=DUBAI&country_code=350&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-12-17 13:08:22.557'
        , request_start_time = '0.177'
        , parsing_start_time = '3.880'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.281'
        , search_end_time = '0.468'
        , total_duration = '4.894'
        , error_description = ''
        , memory_used = '71764256'
        WHERE id = '207763573';
[12/17/2024 01:08:27], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '62'
        , request_url = '/call.php?s=ebookingcenter&sessionid=12841720241213082193815834634&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=1&total_request=10&city_code=2555&city_name=DUBAI&country_code=350&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-12-17 13:08:22.528'
        , request_start_time = '0.189'
        , parsing_start_time = '3.911'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.276'
        , search_end_time = '0.572'
        , total_duration = '5.045'
        , error_description = ''
        , memory_used = '78121032'
        WHERE id = '207763575';
[12/17/2024 01:08:27], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'ebookingcenter/17_12_2024/request_availability_qtech_agent_13_08_22_1734440902_5_8.json', 'ebookingcenter/17_12_2024/response_availability_qtech_agent_13_08_22_1734440902_5_8.json', 'ebookingcenter/17_12_2024/response_header_availability_qtech_agent_13_08_22_1734440902_5_8.json', 'ebookingcenter', '2024-12-17 01:08:27', '', '12841720241213082193815834634', '18474725', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/17_12_2024/response_availability_qtech_agent_13_08_22_1734440902_5_8.json');
[12/17/2024 01:08:27], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '70'
        , request_url = '/call.php?s=ebookingcenter&sessionid=12841720241213082193815834634&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=7&total_request=10&city_code=2555&city_name=DUBAI&country_code=350&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-12-17 13:08:22.557'
        , request_start_time = '0.173'
        , parsing_start_time = '3.932'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.328'
        , search_end_time = '0.570'
        , total_duration = '5.102'
        , error_description = ''
        , memory_used = '88140648'
        WHERE id = '207763576';
[12/17/2024 01:08:27], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '62'
        , request_url = '/call.php?s=ebookingcenter&sessionid=12841720241213082193815834634&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=3&total_request=10&city_code=2555&city_name=DUBAI&country_code=350&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-12-17 13:08:22.564'
        , request_start_time = '0.169'
        , parsing_start_time = '4.117'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.267'
        , search_end_time = '0.527'
        , total_duration = '5.233'
        , error_description = ''
        , memory_used = '79321096'
        WHERE id = '207763578';
[12/17/2024 01:08:27], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'ebookingcenter/17_12_2024/request_availability_qtech_agent_13_08_22_1734440902_58_6.json', 'ebookingcenter/17_12_2024/response_availability_qtech_agent_13_08_22_1734440902_58_6.json', 'ebookingcenter/17_12_2024/response_header_availability_qtech_agent_13_08_22_1734440902_58_6.json', 'ebookingcenter', '2024-12-17 01:08:27', '', '12841720241213082193815834634', '18474725', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/17_12_2024/response_availability_qtech_agent_13_08_22_1734440902_58_6.json');
[12/17/2024 01:08:28], [file name :-/efsdata/otrams/public_html/beta/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', 'ebookingcenter/17_12_2024/request_availability_qtech_agent_13_08_22_1734440902_4_0.json', 'ebookingcenter/17_12_2024/response_availability_qtech_agent_13_08_22_1734440902_4_0.json', 'ebookingcenter/17_12_2024/response_header_availability_qtech_agent_13_08_22_1734440902_4_0.json', 'ebookingcenter', '2024-12-17 01:08:28', '', '12841720241213082193815834634', '18474725', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/17_12_2024/response_availability_qtech_agent_13_08_22_1734440902_4_0.json');
[12/17/2024 01:08:28], [file name :-/efsdata/otrams/public_html/beta/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', 'ebookingcenter/17_12_2024/request_availability_qtech_agent_13_08_22_1734440902_24_4.json', 'ebookingcenter/17_12_2024/response_availability_qtech_agent_13_08_22_1734440902_24_4.json', 'ebookingcenter/17_12_2024/response_header_availability_qtech_agent_13_08_22_1734440902_24_4.json', 'ebookingcenter', '2024-12-17 01:08:28', '', '12841720241213082193815834634', '18474725', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/17_12_2024/response_availability_qtech_agent_13_08_22_1734440902_24_4.json');
[12/17/2024 01:08:28], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '54'
        , request_url = '/call.php?s=ebookingcenter&sessionid=12841720241213082193815834634&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=6&total_request=10&city_code=2555&city_name=DUBAI&country_code=350&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-12-17 13:08:22.566'
        , request_start_time = '0.176'
        , parsing_start_time = '5.129'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.246'
        , search_end_time = '0.449'
        , total_duration = '6.078'
        , error_description = ''
        , memory_used = '64729368'
        WHERE id = '207763595';
[12/17/2024 01:08:28], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '78'
        , request_url = '/call.php?s=ebookingcenter&sessionid=12841720241213082193815834634&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=8&total_request=10&city_code=2555&city_name=DUBAI&country_code=350&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-12-17 13:08:22.565'
        , request_start_time = '0.196'
        , parsing_start_time = '4.777'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.381'
        , search_end_time = '0.650'
        , total_duration = '6.105'
        , error_description = ''
        , memory_used = '100677824'
        WHERE id = '207763593';
[12/17/2024 01:08:28], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '69'
        , request_url = '/call.php?s=ebookingcenter&sessionid=12841720241213082193815834634&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=0&total_request=10&city_code=2555&city_name=DUBAI&country_code=350&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-12-17 13:08:22.530'
        , request_start_time = '0.171'
        , parsing_start_time = '5.302'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.296'
        , search_end_time = '0.550'
        , total_duration = '6.415'
        , error_description = ''
        , memory_used = '82396704'
        WHERE id = '207763601';
[12/17/2024 01:08:29], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '89'
        , request_url = '/call.php?s=ebookingcenter&sessionid=12841720241213082193815834634&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=4&total_request=10&city_code=2555&city_name=DUBAI&country_code=350&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-12-17 13:08:22.569'
        , request_start_time = '0.169'
        , parsing_start_time = '5.736'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.414'
        , search_end_time = '0.804'
        , total_duration = '7.227'
        , error_description = ''
        , memory_used = '116291560'
        WHERE id = '207763609';
[12/17/2024 01:08:59], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '1264',
        request_path = '/xml_all.php?userid=1284&sessionid=12841720241213082193815834634',
        duration = '37.572',
        merge_duration = '7.119',
        assigned_supplier_count = '19',
        searched_supplier_count = '3',
        system_load_1_min = '4.41',
        system_load_5_min = '2.97',
        system_load_15_min = '2.50',
        system_memory_usage = '45.88',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '18474725') + '37676208',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '18474725';
[12/17/2024 01:09:42], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1734440982','43.239.53.130');
[12/17/2024 01:09:45], [file name :-/efsdata/otrams/public_html/beta/book_now.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 ('', 'VALUATION', 'ebookingcenter/17_12_2024/request_valuation_qtech_agent_13_09_45_1734440985_95.json', 'ebookingcenter/17_12_2024/response_valuation_qtech_agent_13_09_45_1734440985_95.json', 'ebookingcenter/17_12_2024/response_header_valuation_qtech_agent_13_09_45_1734440985_95.json', 'ebookingcenter', '2024-12-17 01:09:45', '', '12841720241213082193815834634', '18474725', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/17_12_2024/response_valuation_qtech_agent_13_09_45_1734440985_95.json');
[12/17/2024 01:18:16], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1734441496','43.239.53.130');
[12/17/2024 01:18:16], [file name :-/efsdata/otrams/public_html/beta/book_now.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 ('', 'VALUATION', 'ebookingcenter/17_12_2024/request_valuation_qtech_agent_13_18_16_1734441496_75.json', 'ebookingcenter/17_12_2024/response_valuation_qtech_agent_13_18_16_1734441496_75.json', 'ebookingcenter/17_12_2024/response_header_valuation_qtech_agent_13_18_16_1734441496_75.json', 'ebookingcenter', '2024-12-17 01:18:16', '', '12841720241213082193815834634', '18474725', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/17_12_2024/response_valuation_qtech_agent_13_18_16_1734441496_75.json');
[12/17/2024 01:19:41], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1734441581','43.239.53.130');
[12/17/2024 01:19:41], [file name :-/efsdata/otrams/public_html/beta/book_now.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 ('', 'VALUATION', 'ebookingcenter/17_12_2024/request_valuation_qtech_agent_13_19_41_1734441581_34.json', 'ebookingcenter/17_12_2024/response_valuation_qtech_agent_13_19_41_1734441581_34.json', 'ebookingcenter/17_12_2024/response_header_valuation_qtech_agent_13_19_41_1734441581_34.json', 'ebookingcenter', '2024-12-17 01:19:41', '', '12841720241213082193815834634', '18474725', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/17_12_2024/response_valuation_qtech_agent_13_19_41_1734441581_34.json');
[12/17/2024 01:26:08], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1734441968','43.239.53.130');
[12/17/2024 01:26:08], [file name :-/efsdata/otrams/public_html/beta/book_now.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 ('', 'VALUATION', 'ebookingcenter/17_12_2024/request_valuation_qtech_agent_13_26_08_1734441968_60.json', 'ebookingcenter/17_12_2024/response_valuation_qtech_agent_13_26_08_1734441968_60.json', 'ebookingcenter/17_12_2024/response_header_valuation_qtech_agent_13_26_08_1734441968_60.json', 'ebookingcenter', '2024-12-17 01:26:08', '', '12841720241213082193815834634', '18474725', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/17_12_2024/response_valuation_qtech_agent_13_26_08_1734441968_60.json');
