[07/15/2024 10:18:58], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-07-15 10:18:58.400'
            , total_duration = '0.347'
            , hotel_count = 0
            , source_type = 'ebookingcenter'
            , create_date = '2024-07-15 10:18:58'
            , session_id = '12391520240709145670603090807'
            , agent_logs_id = ''
            , error_description = 'ebookingcenter: nationality missing.'
            , memory_used = '3314352';
[07/15/2024 10:19:08], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-07-15 10:19:08',login_attempt=0 where id = '1239';
[07/15/2024 10:19:08], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'agent_qtech', user_type = 'A', branch_id = '26', login_datetime = '2024-07-15 10:19:08', ip = '43.239.53.130', action = 'Login' ;
[07/15/2024 10:19:45], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '1239' , 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 = '112' , service_type = 'hotel' , arrival_date = '2024/07/16' , departure_date = '2024/07/17' , nights = '1' , nationality = '112' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-07-15 10:19:45' , 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' ;
[07/15/2024 10:19:51], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'ebookingcenter/15_07_2024/request_availability_agent_qtech_10_19_46_1721038786_45_9.json', 'ebookingcenter/15_07_2024/response_availability_agent_qtech_10_19_46_1721038786_45_9.json', 'ebookingcenter/15_07_2024/response_header_availability_agent_qtech_10_19_46_1721038786_45_9.json', 'ebookingcenter', '2024-07-15 10:19:51', '', '12391520240710194460946435857', '13287025', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/15_07_2024/response_availability_agent_qtech_10_19_46_1721038786_45_9.json');
[07/15/2024 10:19:51], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=12391520240710194460946435857&xml_user_id=1239&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-07-15 10:19:46.44'
        , request_start_time = '0.247'
        , parsing_start_time = '4.757'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '5.247'
        , error_description = ''
        , memory_used = '21072080'
        WHERE id = '160480146';
[07/15/2024 10:19:51], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'ebookingcenter/15_07_2024/request_availability_agent_qtech_10_19_46_1721038786_33_2.json', 'ebookingcenter/15_07_2024/response_availability_agent_qtech_10_19_46_1721038786_33_2.json', 'ebookingcenter/15_07_2024/response_header_availability_agent_qtech_10_19_46_1721038786_33_2.json', 'ebookingcenter', '2024-07-15 10:19:51', '', '12391520240710194460946435857', '13287025', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/15_07_2024/response_availability_agent_qtech_10_19_46_1721038786_33_2.json');
[07/15/2024 10:19:51], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'ebookingcenter/15_07_2024/request_availability_agent_qtech_10_19_46_1721038786_31_6.json', 'ebookingcenter/15_07_2024/response_availability_agent_qtech_10_19_46_1721038786_31_6.json', 'ebookingcenter/15_07_2024/response_header_availability_agent_qtech_10_19_46_1721038786_31_6.json', 'ebookingcenter', '2024-07-15 10:19:51', '', '12391520240710194460946435857', '13287025', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/15_07_2024/response_availability_agent_qtech_10_19_46_1721038786_31_6.json');
[07/15/2024 10:19:52], [file name :-/efsdata/otrams/public_html/beta/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/15_07_2024/request_availability_agent_qtech_10_19_46_1721038786_94_3.json', 'ebookingcenter/15_07_2024/response_availability_agent_qtech_10_19_46_1721038786_94_3.json', 'ebookingcenter/15_07_2024/response_header_availability_agent_qtech_10_19_46_1721038786_94_3.json', 'ebookingcenter', '2024-07-15 10:19:52', '', '12391520240710194460946435857', '13287025', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/15_07_2024/response_availability_agent_qtech_10_19_46_1721038786_94_3.json');
[07/15/2024 10:19:52], [file name :-/efsdata/otrams/public_html/beta/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/15_07_2024/request_availability_agent_qtech_10_19_46_1721038786_13_5.json', 'ebookingcenter/15_07_2024/response_availability_agent_qtech_10_19_46_1721038786_13_5.json', 'ebookingcenter/15_07_2024/response_header_availability_agent_qtech_10_19_46_1721038786_13_5.json', 'ebookingcenter', '2024-07-15 10:19:52', '', '12391520240710194460946435857', '13287025', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/15_07_2024/response_availability_agent_qtech_10_19_46_1721038786_13_5.json');
[07/15/2024 10:19:52], [file name :-/efsdata/otrams/public_html/beta/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/15_07_2024/request_availability_agent_qtech_10_19_46_1721038786_73_7.json', 'ebookingcenter/15_07_2024/response_availability_agent_qtech_10_19_46_1721038786_73_7.json', 'ebookingcenter/15_07_2024/response_header_availability_agent_qtech_10_19_46_1721038786_73_7.json', 'ebookingcenter', '2024-07-15 10:19:52', '', '12391520240710194460946435857', '13287025', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/15_07_2024/response_availability_agent_qtech_10_19_46_1721038786_73_7.json');
[07/15/2024 10:19:52], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=12391520240710194460946435857&xml_user_id=1239&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-07-15 10:19:46.44'
        , request_start_time = '0.209'
        , parsing_start_time = '5.345'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '6.253'
        , error_description = ''
        , memory_used = '40213416'
        WHERE id = '160480155';
[07/15/2024 10:19:52], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=12391520240710194460946435857&xml_user_id=1239&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-07-15 10:19:46.44'
        , request_start_time = '0.219'
        , parsing_start_time = '5.539'
        , mapping_complete_time = '0.023'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '6.460'
        , error_description = ''
        , memory_used = '50862032'
        WHERE id = '160480160';
[07/15/2024 10:19:52], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=12391520240710194460946435857&xml_user_id=1239&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-07-15 10:19:46.45'
        , request_start_time = '0.212'
        , parsing_start_time = '5.839'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '6.653'
        , error_description = ''
        , memory_used = '43012392'
        WHERE id = '160480167';
[07/15/2024 10:19:52], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=12391520240710194460946435857&xml_user_id=1239&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-07-15 10:19:46.44'
        , request_start_time = '0.237'
        , parsing_start_time = '5.823'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '6.885'
        , error_description = ''
        , memory_used = '62844040'
        WHERE id = '160480168';
[07/15/2024 10:19:52], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=12391520240710194460946435857&xml_user_id=1239&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-07-15 10:19:46.45'
        , request_start_time = '0.212'
        , parsing_start_time = '5.777'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '6.951'
        , error_description = ''
        , memory_used = '58115688'
        WHERE id = '160480165';
[07/15/2024 10:19:53], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'ebookingcenter/15_07_2024/request_availability_agent_qtech_10_19_46_1721038786_52_4.json', 'ebookingcenter/15_07_2024/response_availability_agent_qtech_10_19_46_1721038786_52_4.json', 'ebookingcenter/15_07_2024/response_header_availability_agent_qtech_10_19_46_1721038786_52_4.json', 'ebookingcenter', '2024-07-15 10:19:53', '', '12391520240710194460946435857', '13287025', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/15_07_2024/response_availability_agent_qtech_10_19_46_1721038786_52_4.json');
[07/15/2024 10:19:53], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'ebookingcenter/15_07_2024/request_availability_agent_qtech_10_19_46_1721038786_96_8.json', 'ebookingcenter/15_07_2024/response_availability_agent_qtech_10_19_46_1721038786_96_8.json', 'ebookingcenter/15_07_2024/response_header_availability_agent_qtech_10_19_46_1721038786_96_8.json', 'ebookingcenter', '2024-07-15 10:19:53', '', '12391520240710194460946435857', '13287025', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/15_07_2024/response_availability_agent_qtech_10_19_46_1721038786_96_8.json');
[07/15/2024 10:19:53], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'ebookingcenter/15_07_2024/request_availability_agent_qtech_10_19_46_1721038786_48_0.json', 'ebookingcenter/15_07_2024/response_availability_agent_qtech_10_19_46_1721038786_48_0.json', 'ebookingcenter/15_07_2024/response_header_availability_agent_qtech_10_19_46_1721038786_48_0.json', 'ebookingcenter', '2024-07-15 10:19:53', '', '12391520240710194460946435857', '13287025', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/15_07_2024/response_availability_agent_qtech_10_19_46_1721038786_48_0.json');
[07/15/2024 10:19:53], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=12391520240710194460946435857&xml_user_id=1239&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-07-15 10:19:46.45'
        , request_start_time = '0.205'
        , parsing_start_time = '6.772'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '7.855'
        , error_description = ''
        , memory_used = '74422192'
        WHERE id = '160480181';
[07/15/2024 10:19:53], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'ebookingcenter/15_07_2024/request_availability_agent_qtech_10_19_46_1721038786_14_1.json', 'ebookingcenter/15_07_2024/response_availability_agent_qtech_10_19_46_1721038786_14_1.json', 'ebookingcenter/15_07_2024/response_header_availability_agent_qtech_10_19_46_1721038786_14_1.json', 'ebookingcenter', '2024-07-15 10:19:53', '', '12391520240710194460946435857', '13287025', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/15_07_2024/response_availability_agent_qtech_10_19_46_1721038786_14_1.json');
[07/15/2024 10:19:54], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=12391520240710194460946435857&xml_user_id=1239&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-07-15 10:19:46.45'
        , request_start_time = '0.200'
        , parsing_start_time = '6.721'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '8.206'
        , error_description = ''
        , memory_used = '80030976'
        WHERE id = '160480180';
[07/15/2024 10:19:54], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=12391520240710194460946435857&xml_user_id=1239&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-07-15 10:19:46.44'
        , request_start_time = '0.191'
        , parsing_start_time = '7.486'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '8.439'
        , error_description = ''
        , memory_used = '67045800'
        WHERE id = '160480184';
[07/15/2024 10:19:54], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=12391520240710194460946435857&xml_user_id=1239&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-07-15 10:19:46.44'
        , request_start_time = '0.214'
        , parsing_start_time = '7.670'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '8.616'
        , error_description = ''
        , memory_used = '56139096'
        WHERE id = '160480186';
[07/15/2024 10:19:54], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=1239&sessionid=12391520240710194460946435857',
        duration = '8.862',
        merge_duration = '0.003',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '10.70',
        system_load_5_min = '9.78',
        system_load_15_min = '11.92',
        system_memory_usage = '86.28',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '13287025') + '119676472',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '13287025';
[07/15/2024 10:20: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/15_07_2024/request_availability_agent_qtech_10_20_24_1721038824_58_0.json', 'ebookingcenter/15_07_2024/response_availability_agent_qtech_10_20_24_1721038824_58_0.json', 'ebookingcenter/15_07_2024/response_header_availability_agent_qtech_10_20_24_1721038824_58_0.json', 'ebookingcenter', '2024-07-15 10:20:28', '', '12391520240710194460946435857', '13287025', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/15_07_2024/response_availability_agent_qtech_10_20_24_1721038824_58_0.json');
[07/15/2024 10:20:29], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=12391520240710194460946435857&xml_user_id=1239&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-07-15 10:20:23.765'
        , request_start_time = '0.082'
        , parsing_start_time = '3.579'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '5.434'
        , error_description = ''
        , memory_used = '67134552'
        WHERE id = '160481058';
[07/15/2024 10:21:20], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '1239' , 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 = '112' , service_type = 'hotel' , arrival_date = '2024/07/16' , departure_date = '2024/07/17' , nights = '1' , nationality = '112' , room_types = '2.2, 1.2' , room_type='[{"numberOfAdults":2,"numberOfChild":2},{"numberOfAdults":1,"numberOfChild":2}]' , available='0' , create_date = '2024-07-15 10:21:20' , 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' ;
[07/15/2024 10:21:36], [file name :-/efsdata/otrams/public_html/beta/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/15_07_2024/request_availability_agent_qtech_10_21_32_1721038892_86_9.json', 'ebookingcenter/15_07_2024/response_availability_agent_qtech_10_21_32_1721038892_86_9.json', 'ebookingcenter/15_07_2024/response_header_availability_agent_qtech_10_21_32_1721038892_86_9.json', 'ebookingcenter', '2024-07-15 10:21:36', '', '123915202407102120684401635', '13287206', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/15_07_2024/response_availability_agent_qtech_10_21_32_1721038892_86_9.json');
[07/15/2024 10:21:37], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=123915202407102120684401635&xml_user_id=1239&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-07-15 10:21:32.508'
        , request_start_time = '0.265'
        , parsing_start_time = '3.879'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '4.895'
        , error_description = ''
        , memory_used = '35505392'
        WHERE id = '160482006';
[07/15/2024 10:21:38], [file name :-/efsdata/otrams/public_html/beta/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/15_07_2024/request_availability_agent_qtech_10_21_32_1721038892_72_3.json', 'ebookingcenter/15_07_2024/response_availability_agent_qtech_10_21_32_1721038892_72_3.json', 'ebookingcenter/15_07_2024/response_header_availability_agent_qtech_10_21_32_1721038892_72_3.json', 'ebookingcenter', '2024-07-15 10:21:38', '', '123915202407102120684401635', '13287206', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/15_07_2024/response_availability_agent_qtech_10_21_32_1721038892_72_3.json');
[07/15/2024 10:21:38], [file name :-/efsdata/otrams/public_html/beta/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/15_07_2024/request_availability_agent_qtech_10_21_33_1721038893_57_2.json', 'ebookingcenter/15_07_2024/response_availability_agent_qtech_10_21_33_1721038893_57_2.json', 'ebookingcenter/15_07_2024/response_header_availability_agent_qtech_10_21_33_1721038893_57_2.json', 'ebookingcenter', '2024-07-15 10:21:38', '', '123915202407102120684401635', '13287206', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/15_07_2024/response_availability_agent_qtech_10_21_33_1721038893_57_2.json');
[07/15/2024 10:21:38], [file name :-/efsdata/otrams/public_html/beta/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/15_07_2024/request_availability_agent_qtech_10_21_33_1721038893_37_5.json', 'ebookingcenter/15_07_2024/response_availability_agent_qtech_10_21_33_1721038893_37_5.json', 'ebookingcenter/15_07_2024/response_header_availability_agent_qtech_10_21_33_1721038893_37_5.json', 'ebookingcenter', '2024-07-15 10:21:38', '', '123915202407102120684401635', '13287206', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/15_07_2024/response_availability_agent_qtech_10_21_33_1721038893_37_5.json');
[07/15/2024 10:21:38], [file name :-/efsdata/otrams/public_html/beta/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/15_07_2024/request_availability_agent_qtech_10_21_33_1721038893_78_7.json', 'ebookingcenter/15_07_2024/response_availability_agent_qtech_10_21_33_1721038893_78_7.json', 'ebookingcenter/15_07_2024/response_header_availability_agent_qtech_10_21_33_1721038893_78_7.json', 'ebookingcenter', '2024-07-15 10:21:38', '', '123915202407102120684401635', '13287206', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/15_07_2024/response_availability_agent_qtech_10_21_33_1721038893_78_7.json');
[07/15/2024 10:21:39], [file name :-/efsdata/otrams/public_html/beta/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/15_07_2024/request_availability_agent_qtech_10_21_33_1721038893_69_6.json', 'ebookingcenter/15_07_2024/response_availability_agent_qtech_10_21_33_1721038893_69_6.json', 'ebookingcenter/15_07_2024/response_header_availability_agent_qtech_10_21_33_1721038893_69_6.json', 'ebookingcenter', '2024-07-15 10:21:39', '', '123915202407102120684401635', '13287206', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/15_07_2024/response_availability_agent_qtech_10_21_33_1721038893_69_6.json');
[07/15/2024 10:21:39], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=123915202407102120684401635&xml_user_id=1239&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-07-15 10:21:32.511'
        , request_start_time = '0.261'
        , parsing_start_time = '5.275'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '6.814'
        , error_description = ''
        , memory_used = '98230000'
        WHERE id = '160482025';
[07/15/2024 10:21:39], [file name :-/efsdata/otrams/public_html/beta/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/15_07_2024/request_availability_agent_qtech_10_21_33_1721038893_55_1.json', 'ebookingcenter/15_07_2024/response_availability_agent_qtech_10_21_33_1721038893_55_1.json', 'ebookingcenter/15_07_2024/response_header_availability_agent_qtech_10_21_33_1721038893_55_1.json', 'ebookingcenter', '2024-07-15 10:21:39', '', '123915202407102120684401635', '13287206', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/15_07_2024/response_availability_agent_qtech_10_21_33_1721038893_55_1.json');
[07/15/2024 10:21:39], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=123915202407102120684401635&xml_user_id=1239&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-07-15 10:21:32.511'
        , request_start_time = '0.217'
        , parsing_start_time = '5.142'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '7.137'
        , error_description = ''
        , memory_used = '76759968'
        WHERE id = '160482031';
[07/15/2024 10:21:40], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=123915202407102120684401635&xml_user_id=1239&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-07-15 10:21:32.522'
        , request_start_time = '0.461'
        , parsing_start_time = '5.580'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '7.547'
        , error_description = ''
        , memory_used = '97670912'
        WHERE id = '160482033';
[07/15/2024 10:21:40], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=123915202407102120684401635&xml_user_id=1239&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-07-15 10:21:32.509'
        , request_start_time = '0.317'
        , parsing_start_time = '5.604'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '7.566'
        , error_description = ''
        , memory_used = '61949256'
        WHERE id = '160482032';
[07/15/2024 10:21:40], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=123915202407102120684401635&xml_user_id=1239&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-07-15 10:21:32.510'
        , request_start_time = '0.433'
        , parsing_start_time = '5.921'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '7.904'
        , error_description = ''
        , memory_used = '91492680'
        WHERE id = '160482038';
[07/15/2024 10:21:40], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=123915202407102120684401635&xml_user_id=1239&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-07-15 10:21:32.505'
        , request_start_time = '0.411'
        , parsing_start_time = '6.263'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '8.164'
        , error_description = ''
        , memory_used = '87725488'
        WHERE id = '160482043';
[07/15/2024 10:21:40], [file name :-/efsdata/otrams/public_html/beta/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/15_07_2024/request_availability_agent_qtech_10_21_33_1721038893_1_8.json', 'ebookingcenter/15_07_2024/response_availability_agent_qtech_10_21_33_1721038893_1_8.json', 'ebookingcenter/15_07_2024/response_header_availability_agent_qtech_10_21_33_1721038893_1_8.json', 'ebookingcenter', '2024-07-15 10:21:40', '', '123915202407102120684401635', '13287206', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/15_07_2024/response_availability_agent_qtech_10_21_33_1721038893_1_8.json');
[07/15/2024 10:21:42], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=123915202407102120684401635&xml_user_id=1239&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-07-15 10:21:32.510'
        , request_start_time = '0.678'
        , parsing_start_time = '7.372'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '9.535'
        , error_description = ''
        , memory_used = '127644016'
        WHERE id = '160482050';
[07/15/2024 10:21:42], [file name :-/efsdata/otrams/public_html/beta/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/15_07_2024/request_availability_agent_qtech_10_21_33_1721038893_94_0.json', 'ebookingcenter/15_07_2024/response_availability_agent_qtech_10_21_33_1721038893_94_0.json', 'ebookingcenter/15_07_2024/response_header_availability_agent_qtech_10_21_33_1721038893_94_0.json', 'ebookingcenter', '2024-07-15 10:21:42', '', '123915202407102120684401635', '13287206', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/15_07_2024/response_availability_agent_qtech_10_21_33_1721038893_94_0.json');
[07/15/2024 10:21:43], [file name :-/efsdata/otrams/public_html/beta/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/15_07_2024/request_availability_agent_qtech_10_21_33_1721038893_43_4.json', 'ebookingcenter/15_07_2024/response_availability_agent_qtech_10_21_33_1721038893_43_4.json', 'ebookingcenter/15_07_2024/response_header_availability_agent_qtech_10_21_33_1721038893_43_4.json', 'ebookingcenter', '2024-07-15 10:21:43', '', '123915202407102120684401635', '13287206', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/15_07_2024/response_availability_agent_qtech_10_21_33_1721038893_43_4.json');
[07/15/2024 10:21:43], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=123915202407102120684401635&xml_user_id=1239&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-07-15 10:21:32.536'
        , request_start_time = '0.043'
        , parsing_start_time = '9.094'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '10.884'
        , error_description = ''
        , memory_used = '129591184'
        WHERE id = '160482052';
[07/15/2024 10:21:44], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=123915202407102120684401635&xml_user_id=1239&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-07-15 10:21:32.510'
        , request_start_time = '0.407'
        , parsing_start_time = '10.103'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '12.459'
        , error_description = ''
        , memory_used = '143851856'
        WHERE id = '160482054';
[07/15/2024 10:21:45], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=1239&sessionid=123915202407102120684401635',
        duration = '17.233',
        merge_duration = '0.002',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '36.60',
        system_load_5_min = '17.53',
        system_load_15_min = '14.36',
        system_memory_usage = '90.78',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '13287206') + '178317104',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '13287206';
[07/15/2024 10:22:12], [file name :-/efsdata/otrams/public_html/beta/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/15_07_2024/request_availability_agent_qtech_10_21_58_1721038918_50_0.json', 'ebookingcenter/15_07_2024/response_availability_agent_qtech_10_21_58_1721038918_50_0.json', 'ebookingcenter/15_07_2024/response_header_availability_agent_qtech_10_21_58_1721038918_50_0.json', 'ebookingcenter', '2024-07-15 10:22:12', '', '123915202407102120684401635', '13287206', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/15_07_2024/response_availability_agent_qtech_10_21_58_1721038918_50_0.json');
[07/15/2024 10:22:13], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=123915202407102120684401635&xml_user_id=1239&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-07-15 10:21:58.267'
        , request_start_time = '0.015'
        , parsing_start_time = '13.774'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '15.207'
        , error_description = ''
        , memory_used = '129619008'
        WHERE id = '160483422';
[07/15/2024 10:25:16], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[07/15/2024 10:25:16], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '77' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/15/2024 10:25:16], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '89' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/15/2024 10:25:16], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '102' ,status = '' ,priority = '25' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '25';
[07/15/2024 10:25:16], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '76' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/15/2024 10:25:16], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '98' ,status = '' ,priority = '5' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[07/15/2024 10:25:16], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '58' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/15/2024 10:25:16], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '99' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/15/2024 10:25:16], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '86' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/15/2024 10:25:16], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '74' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/15/2024 10:25:16], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '75' ,status = '' ,priority = '14' ,lead_time = '48',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[07/15/2024 10:25:16], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '96' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/15/2024 10:25:16], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '56' ,status = '' ,priority = '27' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '27';
[07/15/2024 10:25:16], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '60' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/15/2024 10:25:16], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '84' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/15/2024 10:25:16], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '67' ,status = '' ,priority = '25' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '25';
[07/15/2024 10:25:16], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '1' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/15/2024 10:25:16], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '101' ,status = '' ,priority = '25' ,lead_time = '72',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '25';
[07/15/2024 10:25:16], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '73' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/15/2024 10:25:16], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '85' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/15/2024 10:25:16], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '103' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[07/15/2024 10:25:16], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '100' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/15/2024 10:25:16], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '93' ,status = '' ,priority = '' ,lead_time = '1200',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/15/2024 10:25:16], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '57' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/15/2024 10:25:16], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '97' ,status = '' ,priority = '' ,lead_time = '1440',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/15/2024 10:25:16], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '81' ,status = '' ,priority = '27' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '27';
[07/15/2024 10:25:16], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '78' ,status = '' ,priority = '27' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '27';
[07/15/2024 10:25:16], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '83' ,status = '' ,priority = '27' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '27';
[07/15/2024 10:25:16], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '68' ,status = '' ,priority = '27' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '27';
[07/15/2024 10:25:16], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '90' ,status = '' ,priority = '27' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '27';
[07/15/2024 10:25:17], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '66' ,status = '' ,priority = '27' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '27';
[07/15/2024 10:25:17], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '64' ,status = '' ,priority = '27' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '27';
[07/15/2024 10:25:17], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '65' ,status = '' ,priority = '27' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '27';
[07/15/2024 10:25:17], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '69' ,status = '' ,priority = '27' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '27';
[07/15/2024 10:25:17], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'Qtech_pranali',`create_date`= '2024-07-15 10:25:17',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 77 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 89 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 102 ,status = \&#039;\&#039; ,priority = \&#039;25\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;25\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 76 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 98 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 58 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 99 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 86 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 74 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 75 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;48\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 96 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 56 ,status = \&#039;\&#039; ,priority = \&#039;27\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;27\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 60 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 84 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 67 ,status = \&#039;\&#039; ,priority = \&#039;25\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;25\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 1 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 101 ,status = \&#039;\&#039; ,priority = \&#039;25\&#039; ,lead_time = \&#039;72\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;25\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 73 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 85 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 103 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 100 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 93 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;1200\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 57 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 97 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;1440\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 81 ,status = \&#039;\&#039; ,priority = \&#039;27\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;27\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 78 ,status = \&#039;\&#039; ,priority = \&#039;27\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;27\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 83 ,status = \&#039;\&#039; ,priority = \&#039;27\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;27\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 68 ,status = \&#039;\&#039; ,priority = \&#039;27\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;27\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 90 ,status = \&#039;\&#039; ,priority = \&#039;27\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;27\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 66 ,status = \&#039;\&#039; ,priority = \&#039;27\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;27\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 64 ,status = \&#039;\&#039; ,priority = \&#039;27\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;27\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 65 ,status = \&#039;\&#039; ,priority = \&#039;27\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;27\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 69 ,status = \&#039;\&#039; ,priority = \&#039;27\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;27\&#039;',`log_description`= 'Supplier setting updated  Previous data-- agent_id-1239 ## supplier_id- 99 ## company_name - EBooking Center ## supplier_code-ebookingcenter  ## percentage - 0.00 ## lead_time - 0 ',`ip`= '43.239.53.130';
[07/15/2024 10:25:22], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-07-15 10:25:22',login_attempt=0 where id = '1239';
[07/15/2024 10:25:22], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'agent_qtech', user_type = 'A', branch_id = '26', login_datetime = '2024-07-15 10:25:22', ip = '43.239.53.130', action = 'Login' ;
[07/15/2024 10:26:28], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-07-15 10:26:28',login_attempt=0 where id = '1239';
[07/15/2024 10:26:28], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'agent_qtech', user_type = 'A', branch_id = '26', login_datetime = '2024-07-15 10:26:28', ip = '43.239.53.130', action = 'Login' ;
[07/15/2024 10:27:00], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[07/15/2024 10:27:00], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '77' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/15/2024 10:27:00], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '89' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/15/2024 10:27:00], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '102' ,status = '' ,priority = '25' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '25';
[07/15/2024 10:27:00], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '76' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/15/2024 10:27:00], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '98' ,status = '' ,priority = '5' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[07/15/2024 10:27:00], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '58' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/15/2024 10:27:00], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '99' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/15/2024 10:27:00], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '86' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/15/2024 10:27:00], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '74' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/15/2024 10:27:00], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '75' ,status = '' ,priority = '14' ,lead_time = '48',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[07/15/2024 10:27:00], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '96' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/15/2024 10:27:00], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '56' ,status = '' ,priority = '27' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '27';
[07/15/2024 10:27:00], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '60' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/15/2024 10:27:00], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '84' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/15/2024 10:27:00], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '67' ,status = '' ,priority = '25' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '25';
[07/15/2024 10:27:00], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '1' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/15/2024 10:27:00], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '101' ,status = '' ,priority = '25' ,lead_time = '72',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '25';
[07/15/2024 10:27:00], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '73' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/15/2024 10:27:00], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '85' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/15/2024 10:27:00], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '103' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[07/15/2024 10:27:00], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '100' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/15/2024 10:27:00], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '93' ,status = '' ,priority = '' ,lead_time = '1200',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/15/2024 10:27:00], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '57' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/15/2024 10:27:00], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '97' ,status = '' ,priority = '' ,lead_time = '1440',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/15/2024 10:27:00], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '81' ,status = '' ,priority = '27' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '27';
[07/15/2024 10:27:00], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '78' ,status = '' ,priority = '27' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '27';
[07/15/2024 10:27:00], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '83' ,status = '' ,priority = '27' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '27';
[07/15/2024 10:27:00], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '68' ,status = '' ,priority = '27' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '27';
[07/15/2024 10:27:00], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '90' ,status = '' ,priority = '27' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '27';
[07/15/2024 10:27:00], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '66' ,status = '' ,priority = '27' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '27';
[07/15/2024 10:27:00], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '64' ,status = '' ,priority = '27' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '27';
[07/15/2024 10:27:00], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '65' ,status = '' ,priority = '27' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '27';
[07/15/2024 10:27:00], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '69' ,status = '' ,priority = '27' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '27';
[07/15/2024 10:27:00], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'Qtech_pranali',`create_date`= '2024-07-15 10:27:00',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 77 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 89 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 102 ,status = \&#039;\&#039; ,priority = \&#039;25\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;25\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 76 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 98 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 58 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 99 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 86 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 74 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 75 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;48\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 96 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 56 ,status = \&#039;\&#039; ,priority = \&#039;27\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;27\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 60 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 84 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 67 ,status = \&#039;\&#039; ,priority = \&#039;25\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;25\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 1 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 101 ,status = \&#039;\&#039; ,priority = \&#039;25\&#039; ,lead_time = \&#039;72\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;25\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 73 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 85 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 103 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 100 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 93 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;1200\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 57 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 97 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;1440\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 81 ,status = \&#039;\&#039; ,priority = \&#039;27\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;27\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 78 ,status = \&#039;\&#039; ,priority = \&#039;27\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;27\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 83 ,status = \&#039;\&#039; ,priority = \&#039;27\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;27\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 68 ,status = \&#039;\&#039; ,priority = \&#039;27\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;27\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 90 ,status = \&#039;\&#039; ,priority = \&#039;27\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;27\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 66 ,status = \&#039;\&#039; ,priority = \&#039;27\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;27\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 64 ,status = \&#039;\&#039; ,priority = \&#039;27\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;27\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 65 ,status = \&#039;\&#039; ,priority = \&#039;27\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;27\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 69 ,status = \&#039;\&#039; ,priority = \&#039;27\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;27\&#039;',`log_description`= 'Supplier setting updated  Previous data-- agent_id-1239 ## supplier_id- 99 ## company_name - EBooking Center ## supplier_code-ebookingcenter  ## percentage - 0.00 ## lead_time - 0 ',`ip`= '43.239.53.130';
[07/15/2024 10:27:05], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-07-15 10:27:05',login_attempt=0 where id = '1239';
[07/15/2024 10:27:05], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'agent_qtech', user_type = 'A', branch_id = '26', login_datetime = '2024-07-15 10:27:05', ip = '43.239.53.130', action = 'Login' ;
[07/15/2024 10:29:06], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '1239' , 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 = '112' , service_type = 'hotel' , arrival_date = '2024/07/16' , departure_date = '2024/07/17' , nights = '1' , nationality = '112' , room_types = '2.1' , room_type='[{"numberOfAdults":2,"numberOfChild":1}]' , available='0' , create_date = '2024-07-15 10:29:06' , 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' ;
[07/15/2024 10:29:10], [file name :-/efsdata/otrams/public_html/beta/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/15_07_2024/request_availability_agent_qtech_10_29_07_1721039347_24_9.json', 'ebookingcenter/15_07_2024/response_availability_agent_qtech_10_29_07_1721039347_24_9.json', 'ebookingcenter/15_07_2024/response_header_availability_agent_qtech_10_29_07_1721039347_24_9.json', 'ebookingcenter', '2024-07-15 10:29:10', '', '12391520240710290656791721707', '13289388', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/15_07_2024/response_availability_agent_qtech_10_29_07_1721039347_24_9.json');
[07/15/2024 10:29:11], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=12391520240710290656791721707&xml_user_id=1239&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-07-15 10:29:07.581'
        , request_start_time = '0.187'
        , parsing_start_time = '3.105'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '3.587'
        , error_description = ''
        , memory_used = '21090464'
        WHERE id = '160491575';
[07/15/2024 10:29:11], [file name :-/efsdata/otrams/public_html/beta/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/15_07_2024/request_availability_agent_qtech_10_29_07_1721039347_25_2.json', 'ebookingcenter/15_07_2024/response_availability_agent_qtech_10_29_07_1721039347_25_2.json', 'ebookingcenter/15_07_2024/response_header_availability_agent_qtech_10_29_07_1721039347_25_2.json', 'ebookingcenter', '2024-07-15 10:29:11', '', '12391520240710290656791721707', '13289388', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/15_07_2024/response_availability_agent_qtech_10_29_07_1721039347_25_2.json');
[07/15/2024 10:29:11], [file name :-/efsdata/otrams/public_html/beta/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/15_07_2024/request_availability_agent_qtech_10_29_07_1721039347_29_6.json', 'ebookingcenter/15_07_2024/response_availability_agent_qtech_10_29_07_1721039347_29_6.json', 'ebookingcenter/15_07_2024/response_header_availability_agent_qtech_10_29_07_1721039347_29_6.json', 'ebookingcenter', '2024-07-15 10:29:11', '', '12391520240710290656791721707', '13289388', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/15_07_2024/response_availability_agent_qtech_10_29_07_1721039347_29_6.json');
[07/15/2024 10:29:11], [file name :-/efsdata/otrams/public_html/beta/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/15_07_2024/request_availability_agent_qtech_10_29_07_1721039347_82_5.json', 'ebookingcenter/15_07_2024/response_availability_agent_qtech_10_29_07_1721039347_82_5.json', 'ebookingcenter/15_07_2024/response_header_availability_agent_qtech_10_29_07_1721039347_82_5.json', 'ebookingcenter', '2024-07-15 10:29:11', '', '12391520240710290656791721707', '13289388', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/15_07_2024/response_availability_agent_qtech_10_29_07_1721039347_82_5.json');
[07/15/2024 10:29:11], [file name :-/efsdata/otrams/public_html/beta/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/15_07_2024/request_availability_agent_qtech_10_29_07_1721039347_46_3.json', 'ebookingcenter/15_07_2024/response_availability_agent_qtech_10_29_07_1721039347_46_3.json', 'ebookingcenter/15_07_2024/response_header_availability_agent_qtech_10_29_07_1721039347_46_3.json', 'ebookingcenter', '2024-07-15 10:29:11', '', '12391520240710290656791721707', '13289388', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/15_07_2024/response_availability_agent_qtech_10_29_07_1721039347_46_3.json');
[07/15/2024 10:29:11], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=12391520240710290656791721707&xml_user_id=1239&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-07-15 10:29:07.579'
        , request_start_time = '0.168'
        , parsing_start_time = '3.657'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '4.345'
        , error_description = ''
        , memory_used = '40224440'
        WHERE id = '160491591';
[07/15/2024 10:29:12], [file name :-/efsdata/otrams/public_html/beta/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/15_07_2024/request_availability_agent_qtech_10_29_07_1721039347_75_1.json', 'ebookingcenter/15_07_2024/response_availability_agent_qtech_10_29_07_1721039347_75_1.json', 'ebookingcenter/15_07_2024/response_header_availability_agent_qtech_10_29_07_1721039347_75_1.json', 'ebookingcenter', '2024-07-15 10:29:12', '', '12391520240710290656791721707', '13289388', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/15_07_2024/response_availability_agent_qtech_10_29_07_1721039347_75_1.json');
[07/15/2024 10:29:12], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=12391520240710290656791721707&xml_user_id=1239&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-07-15 10:29:07.579'
        , request_start_time = '0.181'
        , parsing_start_time = '3.816'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '4.731'
        , error_description = ''
        , memory_used = '50855144'
        WHERE id = '160491593';
[07/15/2024 10:29:12], [file name :-/efsdata/otrams/public_html/beta/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/15_07_2024/request_availability_agent_qtech_10_29_07_1721039347_49_8.json', 'ebookingcenter/15_07_2024/response_availability_agent_qtech_10_29_07_1721039347_49_8.json', 'ebookingcenter/15_07_2024/response_header_availability_agent_qtech_10_29_07_1721039347_49_8.json', 'ebookingcenter', '2024-07-15 10:29:12', '', '12391520240710290656791721707', '13289388', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/15_07_2024/response_availability_agent_qtech_10_29_07_1721039347_49_8.json');
[07/15/2024 10:29:12], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=12391520240710290656791721707&xml_user_id=1239&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-07-15 10:29:07.579'
        , request_start_time = '0.179'
        , parsing_start_time = '3.977'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '4.805'
        , error_description = ''
        , memory_used = '42994744'
        WHERE id = '160491594';
[07/15/2024 10:29:12], [file name :-/efsdata/otrams/public_html/beta/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/15_07_2024/request_availability_agent_qtech_10_29_07_1721039347_78_0.json', 'ebookingcenter/15_07_2024/response_availability_agent_qtech_10_29_07_1721039347_78_0.json', 'ebookingcenter/15_07_2024/response_header_availability_agent_qtech_10_29_07_1721039347_78_0.json', 'ebookingcenter', '2024-07-15 10:29:12', '', '12391520240710290656791721707', '13289388', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/15_07_2024/response_availability_agent_qtech_10_29_07_1721039347_78_0.json');
[07/15/2024 10:29:12], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=12391520240710290656791721707&xml_user_id=1239&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-07-15 10:29:07.580'
        , request_start_time = '0.172'
        , parsing_start_time = '4.005'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '5.053'
        , error_description = ''
        , memory_used = '58049184'
        WHERE id = '160491595';
[07/15/2024 10:29:12], [file name :-/efsdata/otrams/public_html/beta/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/15_07_2024/request_availability_agent_qtech_10_29_07_1721039347_19_7.json', 'ebookingcenter/15_07_2024/response_availability_agent_qtech_10_29_07_1721039347_19_7.json', 'ebookingcenter/15_07_2024/response_header_availability_agent_qtech_10_29_07_1721039347_19_7.json', 'ebookingcenter', '2024-07-15 10:29:12', '', '12391520240710290656791721707', '13289388', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/15_07_2024/response_availability_agent_qtech_10_29_07_1721039347_19_7.json');
[07/15/2024 10:29:12], [file name :-/efsdata/otrams/public_html/beta/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/15_07_2024/request_availability_agent_qtech_10_29_07_1721039347_27_4.json', 'ebookingcenter/15_07_2024/response_availability_agent_qtech_10_29_07_1721039347_27_4.json', 'ebookingcenter/15_07_2024/response_header_availability_agent_qtech_10_29_07_1721039347_27_4.json', 'ebookingcenter', '2024-07-15 10:29:12', '', '12391520240710290656791721707', '13289388', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/15_07_2024/response_availability_agent_qtech_10_29_07_1721039347_27_4.json');
[07/15/2024 10:29:13], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=12391520240710290656791721707&xml_user_id=1239&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-07-15 10:29:07.580'
        , request_start_time = '0.171'
        , parsing_start_time = '4.511'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '5.662'
        , error_description = ''
        , memory_used = '56959872'
        WHERE id = '160491596';
[07/15/2024 10:29:13], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=12391520240710290656791721707&xml_user_id=1239&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-07-15 10:29:07.580'
        , request_start_time = '0.181'
        , parsing_start_time = '4.535'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '5.752'
        , error_description = ''
        , memory_used = '73922576'
        WHERE id = '160491597';
[07/15/2024 10:29:13], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=12391520240710290656791721707&xml_user_id=1239&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-07-15 10:29:07.580'
        , request_start_time = '0.167'
        , parsing_start_time = '4.692'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '5.887'
        , error_description = ''
        , memory_used = '67158496'
        WHERE id = '160491598';
[07/15/2024 10:29:13], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=12391520240710290656791721707&xml_user_id=1239&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-07-15 10:29:07.580'
        , request_start_time = '0.181'
        , parsing_start_time = '4.857'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '5.946'
        , error_description = ''
        , memory_used = '62785472'
        WHERE id = '160491599';
[07/15/2024 10:29:13], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=12391520240710290656791721707&xml_user_id=1239&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-07-15 10:29:07.580'
        , request_start_time = '0.180'
        , parsing_start_time = '5.204'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '6.297'
        , error_description = ''
        , memory_used = '80390080'
        WHERE id = '160491600';
[07/15/2024 10:29:13], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=1239&sessionid=12391520240710290656791721707',
        duration = '6.534',
        merge_duration = '0.003',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '5.62',
        system_load_5_min = '15.57',
        system_load_15_min = '14.85',
        system_memory_usage = '87.30',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '13289388') + '130727104',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '13289388';
[07/15/2024 10:29: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', 'ebookingcenter/15_07_2024/request_availability_agent_qtech_10_29_41_1721039381_46_0.json', 'ebookingcenter/15_07_2024/response_availability_agent_qtech_10_29_41_1721039381_46_0.json', 'ebookingcenter/15_07_2024/response_header_availability_agent_qtech_10_29_41_1721039381_46_0.json', 'ebookingcenter', '2024-07-15 10:29:56', '', '12391520240710290656791721707', '13289388', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/15_07_2024/response_availability_agent_qtech_10_29_41_1721039381_46_0.json');
[07/15/2024 10:29:57], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=12391520240710290656791721707&xml_user_id=1239&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-07-15 10:29:41.729'
        , request_start_time = '0.011'
        , parsing_start_time = '14.435'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '15.296'
        , error_description = ''
        , memory_used = '67233344'
        WHERE id = '160491759';
[07/15/2024 10:30:26], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '1239' , 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 = '112' , service_type = 'hotel' , arrival_date = '2024/07/16' , departure_date = '2024/07/17' , nights = '1' , nationality = '112' , room_types = '2.1, 1' , room_type='[{"numberOfAdults":2,"numberOfChild":1,"ChildAge":"7"},{"numberOfAdults":1}]' , available='0' , create_date = '2024-07-15 10:30:26' , 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' ;
[07/15/2024 10:30:38], [file name :-/efsdata/otrams/public_html/beta/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/15_07_2024/request_availability_agent_qtech_10_30_29_1721039429_34_9.json', 'ebookingcenter/15_07_2024/response_availability_agent_qtech_10_30_29_1721039429_34_9.json', 'ebookingcenter/15_07_2024/response_header_availability_agent_qtech_10_30_29_1721039429_34_9.json', 'ebookingcenter', '2024-07-15 10:30:38', '', '12391520240710302685049209326', '13289502', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/15_07_2024/response_availability_agent_qtech_10_30_29_1721039429_34_9.json');
[07/15/2024 10:30:39], [file name :-/efsdata/otrams/public_html/beta/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/15_07_2024/request_availability_agent_qtech_10_30_28_1721039428_80_5.json', 'ebookingcenter/15_07_2024/response_availability_agent_qtech_10_30_28_1721039428_80_5.json', 'ebookingcenter/15_07_2024/response_header_availability_agent_qtech_10_30_28_1721039428_80_5.json', 'ebookingcenter', '2024-07-15 10:30:39', '', '12391520240710302685049209326', '13289502', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/15_07_2024/response_availability_agent_qtech_10_30_28_1721039428_80_5.json');
[07/15/2024 10:30:39], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=12391520240710302685049209326&xml_user_id=1239&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-07-15 10:30:27.88'
        , request_start_time = '2.383'
        , parsing_start_time = '9.212'
        , mapping_complete_time = '0.032'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '12.808'
        , error_description = ''
        , memory_used = '27612216'
        WHERE id = '160493108';
[07/15/2024 10:30:41], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=12391520240710302685049209326&xml_user_id=1239&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-07-15 10:30:27.87'
        , request_start_time = '1.487'
        , parsing_start_time = '11.226'
        , mapping_complete_time = '0.021'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '14.229'
        , error_description = ''
        , memory_used = '53431944'
        WHERE id = '160493148';
[07/15/2024 10:30:41], [file name :-/efsdata/otrams/public_html/beta/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/15_07_2024/request_availability_agent_qtech_10_30_28_1721039428_91_2.json', 'ebookingcenter/15_07_2024/response_availability_agent_qtech_10_30_28_1721039428_91_2.json', 'ebookingcenter/15_07_2024/response_header_availability_agent_qtech_10_30_28_1721039428_91_2.json', 'ebookingcenter', '2024-07-15 10:30:41', '', '12391520240710302685049209326', '13289502', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/15_07_2024/response_availability_agent_qtech_10_30_28_1721039428_91_2.json');
[07/15/2024 10:30:42], [file name :-/efsdata/otrams/public_html/beta/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/15_07_2024/request_availability_agent_qtech_10_30_29_1721039429_19_7.json', 'ebookingcenter/15_07_2024/response_availability_agent_qtech_10_30_29_1721039429_19_7.json', 'ebookingcenter/15_07_2024/response_header_availability_agent_qtech_10_30_29_1721039429_19_7.json', 'ebookingcenter', '2024-07-15 10:30:42', '', '12391520240710302685049209326', '13289502', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/15_07_2024/response_availability_agent_qtech_10_30_29_1721039429_19_7.json');
[07/15/2024 10:30:42], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=12391520240710302685049209326&xml_user_id=1239&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-07-15 10:30:27.87'
        , request_start_time = '1.566'
        , parsing_start_time = '13.231'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '15.669'
        , error_description = ''
        , memory_used = '55289744'
        WHERE id = '160493185';
[07/15/2024 10:30:43], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=12391520240710302685049209326&xml_user_id=1239&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-07-15 10:30:27.86'
        , request_start_time = '1.880'
        , parsing_start_time = '13.506'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '16.708'
        , error_description = ''
        , memory_used = '78996968'
        WHERE id = '160493196';
[07/15/2024 10:30:43], [file name :-/efsdata/otrams/public_html/beta/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/15_07_2024/request_availability_agent_qtech_10_30_28_1721039428_61_1.json', 'ebookingcenter/15_07_2024/response_availability_agent_qtech_10_30_28_1721039428_61_1.json', 'ebookingcenter/15_07_2024/response_header_availability_agent_qtech_10_30_28_1721039428_61_1.json', 'ebookingcenter', '2024-07-15 10:30:43', '', '12391520240710302685049209326', '13289502', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/15_07_2024/response_availability_agent_qtech_10_30_28_1721039428_61_1.json');
[07/15/2024 10:30:44], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'ebookingcenter/15_07_2024/request_availability_agent_qtech_10_30_29_1721039429_13_3.json', 'ebookingcenter/15_07_2024/response_availability_agent_qtech_10_30_29_1721039429_13_3.json', 'ebookingcenter/15_07_2024/response_header_availability_agent_qtech_10_30_29_1721039429_13_3.json', 'ebookingcenter', '2024-07-15 10:30:44', '', '12391520240710302685049209326', '13289502', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/15_07_2024/response_availability_agent_qtech_10_30_29_1721039429_13_3.json');
[07/15/2024 10:30:44], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=12391520240710302685049209326&xml_user_id=1239&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-07-15 10:30:27.87'
        , request_start_time = '1.417'
        , parsing_start_time = '15.292'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '17.435'
        , error_description = ''
        , memory_used = '64998152'
        WHERE id = '160493325';
[07/15/2024 10:30:45], [file name :-/efsdata/otrams/public_html/beta/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/15_07_2024/request_availability_agent_qtech_10_30_28_1721039428_15_6.json', 'ebookingcenter/15_07_2024/response_availability_agent_qtech_10_30_28_1721039428_15_6.json', 'ebookingcenter/15_07_2024/response_header_availability_agent_qtech_10_30_28_1721039428_15_6.json', 'ebookingcenter', '2024-07-15 10:30:45', '', '12391520240710302685049209326', '13289502', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/15_07_2024/response_availability_agent_qtech_10_30_28_1721039428_15_6.json');
[07/15/2024 10:30:45], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=12391520240710302685049209326&xml_user_id=1239&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-07-15 10:30:27.87'
        , request_start_time = '2.103'
        , parsing_start_time = '15.109'
        , mapping_complete_time = '0.005'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '18.116'
        , error_description = ''
        , memory_used = '74111328'
        WHERE id = '160493349';
[07/15/2024 10:30:45], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=12391520240710302685049209326&xml_user_id=1239&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-07-15 10:30:27.88'
        , request_start_time = '1.750'
        , parsing_start_time = '16.155'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '18.603'
        , error_description = ''
        , memory_used = '66446432'
        WHERE id = '160493419';
[07/15/2024 10:30:46], [file name :-/efsdata/otrams/public_html/beta/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/15_07_2024/request_availability_agent_qtech_10_30_28_1721039428_7_8.json', 'ebookingcenter/15_07_2024/response_availability_agent_qtech_10_30_28_1721039428_7_8.json', 'ebookingcenter/15_07_2024/response_header_availability_agent_qtech_10_30_28_1721039428_7_8.json', 'ebookingcenter', '2024-07-15 10:30:46', '', '12391520240710302685049209326', '13289502', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/15_07_2024/response_availability_agent_qtech_10_30_28_1721039428_7_8.json');
[07/15/2024 10:30:47], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=12391520240710302685049209326&xml_user_id=1239&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-07-15 10:30:27.87'
        , request_start_time = '1.467'
        , parsing_start_time = '17.734'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '20.124'
        , error_description = ''
        , memory_used = '90099536'
        WHERE id = '160493511';
[07/15/2024 10:30: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', 'ebookingcenter/15_07_2024/request_availability_agent_qtech_10_30_28_1721039428_70_0.json', 'ebookingcenter/15_07_2024/response_availability_agent_qtech_10_30_28_1721039428_70_0.json', 'ebookingcenter/15_07_2024/response_header_availability_agent_qtech_10_30_28_1721039428_70_0.json', 'ebookingcenter', '2024-07-15 10:30:48', '', '12391520240710302685049209326', '13289502', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/15_07_2024/response_availability_agent_qtech_10_30_28_1721039428_70_0.json');
[07/15/2024 10:30:48], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=12391520240710302685049209326&xml_user_id=1239&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-07-15 10:30:27.87'
        , request_start_time = '1.648'
        , parsing_start_time = '20.030'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '21.717'
        , error_description = ''
        , memory_used = '3319344'
        WHERE id = '160493662';
[07/15/2024 10:30:49], [file name :-/efsdata/otrams/public_html/beta/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/15_07_2024/request_availability_agent_qtech_10_30_29_1721039429_78_4.json', 'ebookingcenter/15_07_2024/response_availability_agent_qtech_10_30_29_1721039429_78_4.json', 'ebookingcenter/15_07_2024/response_header_availability_agent_qtech_10_30_29_1721039429_78_4.json', 'ebookingcenter', '2024-07-15 10:30:49', '', '12391520240710302685049209326', '13289502', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/15_07_2024/response_availability_agent_qtech_10_30_29_1721039429_78_4.json');
[07/15/2024 10:30:49], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=12391520240710302685049209326&xml_user_id=1239&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-07-15 10:30:27.86'
        , request_start_time = '1.966'
        , parsing_start_time = '20.029'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '22.036'
        , error_description = ''
        , memory_used = '3319344'
        WHERE id = '160493663';
[07/15/2024 10:30:49], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=1239&sessionid=12391520240710302685049209326',
        duration = '22.182',
        merge_duration = '0.002',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '3.66',
        system_load_5_min = '12.62',
        system_load_15_min = '13.87',
        system_memory_usage = '87.78',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '13289502') + '105320712',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '13289502';
[07/15/2024 10:31: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', 'ebookingcenter/15_07_2024/request_availability_agent_qtech_10_31_08_1721039468_79_0.json', 'ebookingcenter/15_07_2024/response_availability_agent_qtech_10_31_08_1721039468_79_0.json', 'ebookingcenter/15_07_2024/response_header_availability_agent_qtech_10_31_08_1721039468_79_0.json', 'ebookingcenter', '2024-07-15 10:31:14', '', '12391520240710302685049209326', '13289502', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/15_07_2024/response_availability_agent_qtech_10_31_08_1721039468_79_0.json');
[07/15/2024 10:31:16], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=12391520240710302685049209326&xml_user_id=1239&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-07-15 10:31:08.305'
        , request_start_time = '0.012'
        , parsing_start_time = '6.380'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '7.721'
        , error_description = ''
        , memory_used = '94476088'
        WHERE id = '160494294';
[07/15/2024 10:31: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/15_07_2024/request_availability_agent_qtech_10_31_23_1721039483_33_0.json', 'ebookingcenter/15_07_2024/response_availability_agent_qtech_10_31_23_1721039483_33_0.json', 'ebookingcenter/15_07_2024/response_header_availability_agent_qtech_10_31_23_1721039483_33_0.json', 'ebookingcenter', '2024-07-15 10:31:28', '', '12391520240710302685049209326', '13289502', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/15_07_2024/response_availability_agent_qtech_10_31_23_1721039483_33_0.json');
[07/15/2024 10:31:29], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=12391520240710302685049209326&xml_user_id=1239&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-07-15 10:31:23.47'
        , request_start_time = '0.010'
        , parsing_start_time = '5.828'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '6.814'
        , error_description = ''
        , memory_used = '94476408'
        WHERE id = '160494382';
[07/15/2024 10:35:24], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[07/15/2024 10:35:24], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '77' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/15/2024 10:35:24], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '89' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/15/2024 10:35:24], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '102' ,status = '' ,priority = '25' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '25';
[07/15/2024 10:35:24], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '76' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/15/2024 10:35:24], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '98' ,status = '' ,priority = '5' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[07/15/2024 10:35:24], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '58' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/15/2024 10:35:24], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '99' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/15/2024 10:35:24], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '86' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/15/2024 10:35:24], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '74' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/15/2024 10:35:24], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '75' ,status = '' ,priority = '14' ,lead_time = '48',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[07/15/2024 10:35:24], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '96' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/15/2024 10:35:24], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '56' ,status = '' ,priority = '27' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '27';
[07/15/2024 10:35:24], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '60' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/15/2024 10:35:24], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '84' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/15/2024 10:35:24], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '67' ,status = '' ,priority = '25' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '25';
[07/15/2024 10:35:24], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '1' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/15/2024 10:35:24], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '101' ,status = '' ,priority = '25' ,lead_time = '72',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '25';
[07/15/2024 10:35:24], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '73' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/15/2024 10:35:24], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '85' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/15/2024 10:35:24], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '103' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[07/15/2024 10:35:24], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '100' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/15/2024 10:35:24], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '93' ,status = '' ,priority = '' ,lead_time = '1200',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/15/2024 10:35:24], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '57' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/15/2024 10:35:24], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '97' ,status = '' ,priority = '' ,lead_time = '1440',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/15/2024 10:35:24], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '81' ,status = '' ,priority = '27' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '27';
[07/15/2024 10:35:24], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '78' ,status = '' ,priority = '27' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '27';
[07/15/2024 10:35:24], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '83' ,status = '' ,priority = '27' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '27';
[07/15/2024 10:35:24], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '68' ,status = '' ,priority = '27' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '27';
[07/15/2024 10:35:24], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '90' ,status = '' ,priority = '27' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '27';
[07/15/2024 10:35:24], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '66' ,status = '' ,priority = '27' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '27';
[07/15/2024 10:35:24], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '64' ,status = '' ,priority = '27' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '27';
[07/15/2024 10:35:24], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '65' ,status = '' ,priority = '27' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '27';
[07/15/2024 10:35:24], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '69' ,status = '' ,priority = '27' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '27';
[07/15/2024 10:35:24], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'Qtech_pranali',`create_date`= '2024-07-15 10:35:24',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 77 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 89 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 102 ,status = \&#039;\&#039; ,priority = \&#039;25\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;25\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 76 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 98 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 58 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 99 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 86 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 74 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 75 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;48\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 96 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 56 ,status = \&#039;\&#039; ,priority = \&#039;27\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;27\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 60 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 84 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 67 ,status = \&#039;\&#039; ,priority = \&#039;25\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;25\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 1 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 101 ,status = \&#039;\&#039; ,priority = \&#039;25\&#039; ,lead_time = \&#039;72\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;25\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 73 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 85 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 103 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 100 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 93 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;1200\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 57 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 97 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;1440\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 81 ,status = \&#039;\&#039; ,priority = \&#039;27\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;27\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 78 ,status = \&#039;\&#039; ,priority = \&#039;27\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;27\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 83 ,status = \&#039;\&#039; ,priority = \&#039;27\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;27\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 68 ,status = \&#039;\&#039; ,priority = \&#039;27\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;27\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 90 ,status = \&#039;\&#039; ,priority = \&#039;27\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;27\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 66 ,status = \&#039;\&#039; ,priority = \&#039;27\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;27\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 64 ,status = \&#039;\&#039; ,priority = \&#039;27\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;27\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 65 ,status = \&#039;\&#039; ,priority = \&#039;27\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;27\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 69 ,status = \&#039;\&#039; ,priority = \&#039;27\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;27\&#039;',`log_description`= 'Supplier setting updated  Previous data-- agent_id-1239 ## supplier_id- 99 ## company_name - EBooking Center ## supplier_code-ebookingcenter  ## percentage - 0.00 ## lead_time - 0 ',`ip`= '43.239.53.130';
[07/15/2024 10:35:29], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-07-15 10:35:29',login_attempt=0 where id = '1239';
[07/15/2024 10:35:29], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'agent_qtech', user_type = 'A', branch_id = '26', login_datetime = '2024-07-15 10:35:29', ip = '43.239.53.130', action = 'Login' ;
[07/15/2024 10:35:44], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '1239' , 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 = '112' , service_type = 'hotel' , arrival_date = '2024/07/16' , departure_date = '2024/07/17' , nights = '1' , nationality = '112' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-07-15 10:35:44' , 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' ;
[07/15/2024 10:36: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', 'ebookingcenter/15_07_2024/request_availability_agent_qtech_10_35_46_1721039746_80_9.json', 'ebookingcenter/15_07_2024/response_availability_agent_qtech_10_35_46_1721039746_80_9.json', 'ebookingcenter/15_07_2024/response_header_availability_agent_qtech_10_35_46_1721039746_80_9.json', 'ebookingcenter', '2024-07-15 10:36:05', '', '12391520240710354422933250254', '13291564', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/15_07_2024/response_availability_agent_qtech_10_35_46_1721039746_80_9.json');
[07/15/2024 10:36:06], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=12391520240710354422933250254&xml_user_id=1239&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-07-15 10:35:45.669'
        , request_start_time = '1.111'
        , parsing_start_time = '18.708'
        , mapping_complete_time = '0.031'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '20.750'
        , error_description = ''
        , memory_used = '21070624'
        WHERE id = '160500071';
[07/15/2024 10:36:06], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'ebookingcenter/15_07_2024/request_availability_agent_qtech_10_35_46_1721039746_57_3.json', 'ebookingcenter/15_07_2024/response_availability_agent_qtech_10_35_46_1721039746_57_3.json', 'ebookingcenter/15_07_2024/response_header_availability_agent_qtech_10_35_46_1721039746_57_3.json', 'ebookingcenter', '2024-07-15 10:36:06', '', '12391520240710354422933250254', '13291564', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/15_07_2024/response_availability_agent_qtech_10_35_46_1721039746_57_3.json');
[07/15/2024 10:36:06], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'ebookingcenter/15_07_2024/request_availability_agent_qtech_10_35_46_1721039746_17_6.json', 'ebookingcenter/15_07_2024/response_availability_agent_qtech_10_35_46_1721039746_17_6.json', 'ebookingcenter/15_07_2024/response_header_availability_agent_qtech_10_35_46_1721039746_17_6.json', 'ebookingcenter', '2024-07-15 10:36:06', '', '12391520240710354422933250254', '13291564', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/15_07_2024/response_availability_agent_qtech_10_35_46_1721039746_17_6.json');
[07/15/2024 10:36:06], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'ebookingcenter/15_07_2024/request_availability_agent_qtech_10_35_46_1721039746_31_1.json', 'ebookingcenter/15_07_2024/response_availability_agent_qtech_10_35_46_1721039746_31_1.json', 'ebookingcenter/15_07_2024/response_header_availability_agent_qtech_10_35_46_1721039746_31_1.json', 'ebookingcenter', '2024-07-15 10:36:06', '', '12391520240710354422933250254', '13291564', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/15_07_2024/response_availability_agent_qtech_10_35_46_1721039746_31_1.json');
[07/15/2024 10:36:06], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'ebookingcenter/15_07_2024/request_availability_agent_qtech_10_35_46_1721039746_2_5.json', 'ebookingcenter/15_07_2024/response_availability_agent_qtech_10_35_46_1721039746_2_5.json', 'ebookingcenter/15_07_2024/response_header_availability_agent_qtech_10_35_46_1721039746_2_5.json', 'ebookingcenter', '2024-07-15 10:36:06', '', '12391520240710354422933250254', '13291564', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/15_07_2024/response_availability_agent_qtech_10_35_46_1721039746_2_5.json');
[07/15/2024 10:36:06], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=12391520240710354422933250254&xml_user_id=1239&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-07-15 10:35:45.669'
        , request_start_time = '0.914'
        , parsing_start_time = '20.099'
        , mapping_complete_time = '0.003'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '21.058'
        , error_description = ''
        , memory_used = '3312784'
        WHERE id = '160500073';
[07/15/2024 10:36:06], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=12391520240710354422933250254&xml_user_id=1239&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-07-15 10:35:45.669'
        , request_start_time = '0.884'
        , parsing_start_time = '20.127'
        , mapping_complete_time = '0.013'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '21.062'
        , error_description = ''
        , memory_used = '3312160'
        WHERE id = '160500072';
[07/15/2024 10:36:06], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'ebookingcenter/15_07_2024/request_availability_agent_qtech_10_35_46_1721039746_8_2.json', 'ebookingcenter/15_07_2024/response_availability_agent_qtech_10_35_46_1721039746_8_2.json', 'ebookingcenter/15_07_2024/response_header_availability_agent_qtech_10_35_46_1721039746_8_2.json', 'ebookingcenter', '2024-07-15 10:36:06', '', '12391520240710354422933250254', '13291564', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/15_07_2024/response_availability_agent_qtech_10_35_46_1721039746_8_2.json');
[07/15/2024 10:36:06], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=12391520240710354422933250254&xml_user_id=1239&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-07-15 10:35:45.669'
        , request_start_time = '0.958'
        , parsing_start_time = '20.070'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '21.070'
        , error_description = ''
        , memory_used = '3312792'
        WHERE id = '160500075';
[07/15/2024 10:36:06], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=12391520240710354422933250254&xml_user_id=1239&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-07-15 10:35:45.669'
        , request_start_time = '0.930'
        , parsing_start_time = '20.089'
        , mapping_complete_time = '0.003'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '21.080'
        , error_description = ''
        , memory_used = '3312872'
        WHERE id = '160500074';
[07/15/2024 10:36:06], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=12391520240710354422933250254&xml_user_id=1239&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-07-15 10:35:45.669'
        , request_start_time = '1.016'
        , parsing_start_time = '20.039'
        , mapping_complete_time = '0.002'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '21.097'
        , error_description = ''
        , memory_used = '3312896'
        WHERE id = '160500076';
[07/15/2024 10:36:06], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'ebookingcenter/15_07_2024/request_availability_agent_qtech_10_35_46_1721039746_96_4.json', 'ebookingcenter/15_07_2024/response_availability_agent_qtech_10_35_46_1721039746_96_4.json', 'ebookingcenter/15_07_2024/response_header_availability_agent_qtech_10_35_46_1721039746_96_4.json', 'ebookingcenter', '2024-07-15 10:36:06', '', '12391520240710354422933250254', '13291564', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/15_07_2024/response_availability_agent_qtech_10_35_46_1721039746_96_4.json');
[07/15/2024 10:36:06], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=12391520240710354422933250254&xml_user_id=1239&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-07-15 10:35:45.669'
        , request_start_time = '1.048'
        , parsing_start_time = '20.037'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '21.125'
        , error_description = ''
        , memory_used = '3312784'
        WHERE id = '160500078';
[07/15/2024 10:36:06], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'ebookingcenter/15_07_2024/request_availability_agent_qtech_10_35_46_1721039746_34_0.json', 'ebookingcenter/15_07_2024/response_availability_agent_qtech_10_35_46_1721039746_34_0.json', 'ebookingcenter/15_07_2024/response_header_availability_agent_qtech_10_35_46_1721039746_34_0.json', 'ebookingcenter', '2024-07-15 10:36:06', '', '12391520240710354422933250254', '13291564', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/15_07_2024/response_availability_agent_qtech_10_35_46_1721039746_34_0.json');
[07/15/2024 10:36:06], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=12391520240710354422933250254&xml_user_id=1239&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-07-15 10:35:45.669'
        , request_start_time = '1.075'
        , parsing_start_time = '20.036'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '21.148'
        , error_description = ''
        , memory_used = '3312904'
        WHERE id = '160500079';
[07/15/2024 10:36:06], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'ebookingcenter/15_07_2024/request_availability_agent_qtech_10_35_46_1721039746_57_8.json', 'ebookingcenter/15_07_2024/response_availability_agent_qtech_10_35_46_1721039746_57_8.json', 'ebookingcenter/15_07_2024/response_header_availability_agent_qtech_10_35_46_1721039746_57_8.json', 'ebookingcenter', '2024-07-15 10:36:06', '', '12391520240710354422933250254', '13291564', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/15_07_2024/response_availability_agent_qtech_10_35_46_1721039746_57_8.json');
[07/15/2024 10:36:06], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=12391520240710354422933250254&xml_user_id=1239&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-07-15 10:35:45.666'
        , request_start_time = '1.102'
        , parsing_start_time = '20.035'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '21.175'
        , error_description = ''
        , memory_used = '3313192'
        WHERE id = '160500080';
[07/15/2024 10:36:06], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'ebookingcenter/15_07_2024/request_availability_agent_qtech_10_35_46_1721039746_23_7.json', 'ebookingcenter/15_07_2024/response_availability_agent_qtech_10_35_46_1721039746_23_7.json', 'ebookingcenter/15_07_2024/response_header_availability_agent_qtech_10_35_46_1721039746_23_7.json', 'ebookingcenter', '2024-07-15 10:36:06', '', '12391520240710354422933250254', '13291564', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/15_07_2024/response_availability_agent_qtech_10_35_46_1721039746_23_7.json');
[07/15/2024 10:36:06], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=12391520240710354422933250254&xml_user_id=1239&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-07-15 10:35:45.669'
        , request_start_time = '1.128'
        , parsing_start_time = '20.031'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '21.200'
        , error_description = ''
        , memory_used = '3312880'
        WHERE id = '160500081';
[07/15/2024 10:36:06], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=1239&sessionid=12391520240710354422933250254',
        duration = '21.977',
        merge_duration = '0.002',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '5.50',
        system_load_5_min = '7.15',
        system_load_15_min = '11.10',
        system_memory_usage = '89.09',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '13291564') + '18430488',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '13291564';
[07/15/2024 10:36:07], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-07-15 10:36:07',login_attempt=0 where id = '1239';
[07/15/2024 10:36:07], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'agent_qtech', user_type = 'A', branch_id = '26', login_datetime = '2024-07-15 10:36:07', ip = '43.239.53.130', action = 'Login' ;
[07/15/2024 10:36:41], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '1239' , 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 = '112' , service_type = 'hotel' , arrival_date = '2024/07/16' , departure_date = '2024/07/17' , nights = '1' , nationality = '112' , room_types = '2.1' , room_type='[{"numberOfAdults":2,"numberOfChild":1}]' , available='0' , create_date = '2024-07-15 10:36:41' , 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' ;
[07/15/2024 10:36: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', 'ebookingcenter/15_07_2024/request_availability_agent_qtech_10_36_42_1721039802_81_9.json', 'ebookingcenter/15_07_2024/response_availability_agent_qtech_10_36_42_1721039802_81_9.json', 'ebookingcenter/15_07_2024/response_header_availability_agent_qtech_10_36_42_1721039802_81_9.json', 'ebookingcenter', '2024-07-15 10:36:48', '', '1239152024071036414699728274', '13292370', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/15_07_2024/response_availability_agent_qtech_10_36_42_1721039802_81_9.json');
[07/15/2024 10:36:48], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=1239152024071036414699728274&xml_user_id=1239&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-07-15 10:36:42.681'
        , request_start_time = '0.194'
        , parsing_start_time = '5.534'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '6.059'
        , error_description = ''
        , memory_used = '21076400'
        WHERE id = '160501992';
[07/15/2024 10:36:49], [file name :-/efsdata/otrams/public_html/beta/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/15_07_2024/request_availability_agent_qtech_10_36_42_1721039802_31_2.json', 'ebookingcenter/15_07_2024/response_availability_agent_qtech_10_36_42_1721039802_31_2.json', 'ebookingcenter/15_07_2024/response_header_availability_agent_qtech_10_36_42_1721039802_31_2.json', 'ebookingcenter', '2024-07-15 10:36:49', '', '1239152024071036414699728274', '13292370', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/15_07_2024/response_availability_agent_qtech_10_36_42_1721039802_31_2.json');
[07/15/2024 10:36:49], [file name :-/efsdata/otrams/public_html/beta/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/15_07_2024/request_availability_agent_qtech_10_36_42_1721039802_21_5.json', 'ebookingcenter/15_07_2024/response_availability_agent_qtech_10_36_42_1721039802_21_5.json', 'ebookingcenter/15_07_2024/response_header_availability_agent_qtech_10_36_42_1721039802_21_5.json', 'ebookingcenter', '2024-07-15 10:36:49', '', '1239152024071036414699728274', '13292370', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/15_07_2024/response_availability_agent_qtech_10_36_42_1721039802_21_5.json');
[07/15/2024 10:36:49], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=1239152024071036414699728274&xml_user_id=1239&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-07-15 10:36:42.682'
        , request_start_time = '0.187'
        , parsing_start_time = '6.109'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '6.824'
        , error_description = ''
        , memory_used = '40341136'
        WHERE id = '160501994';
[07/15/2024 10:36:49], [file name :-/efsdata/otrams/public_html/beta/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/15_07_2024/request_availability_agent_qtech_10_36_42_1721039802_78_1.json', 'ebookingcenter/15_07_2024/response_availability_agent_qtech_10_36_42_1721039802_78_1.json', 'ebookingcenter/15_07_2024/response_header_availability_agent_qtech_10_36_42_1721039802_78_1.json', 'ebookingcenter', '2024-07-15 10:36:49', '', '1239152024071036414699728274', '13292370', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/15_07_2024/response_availability_agent_qtech_10_36_42_1721039802_78_1.json');
[07/15/2024 10:36:49], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=1239152024071036414699728274&xml_user_id=1239&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-07-15 10:36:42.682'
        , request_start_time = '0.185'
        , parsing_start_time = '6.216'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '7.050'
        , error_description = ''
        , memory_used = '42646120'
        WHERE id = '160501995';
[07/15/2024 10:36:49], [file name :-/efsdata/otrams/public_html/beta/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/15_07_2024/request_availability_agent_qtech_10_36_42_1721039802_10_6.json', 'ebookingcenter/15_07_2024/response_availability_agent_qtech_10_36_42_1721039802_10_6.json', 'ebookingcenter/15_07_2024/response_header_availability_agent_qtech_10_36_42_1721039802_10_6.json', 'ebookingcenter', '2024-07-15 10:36:49', '', '1239152024071036414699728274', '13292370', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/15_07_2024/response_availability_agent_qtech_10_36_42_1721039802_10_6.json');
[07/15/2024 10:36:49], [file name :-/efsdata/otrams/public_html/beta/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/15_07_2024/request_availability_agent_qtech_10_36_42_1721039802_3_7.json', 'ebookingcenter/15_07_2024/response_availability_agent_qtech_10_36_42_1721039802_3_7.json', 'ebookingcenter/15_07_2024/response_header_availability_agent_qtech_10_36_42_1721039802_3_7.json', 'ebookingcenter', '2024-07-15 10:36:49', '', '1239152024071036414699728274', '13292370', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/15_07_2024/response_availability_agent_qtech_10_36_42_1721039802_3_7.json');
[07/15/2024 10:36:50], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=1239152024071036414699728274&xml_user_id=1239&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-07-15 10:36:42.683'
        , request_start_time = '0.183'
        , parsing_start_time = '6.617'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '7.508'
        , error_description = ''
        , memory_used = '57107016'
        WHERE id = '160501996';
[07/15/2024 10:36:50], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'ebookingcenter/15_07_2024/request_availability_agent_qtech_10_36_42_1721039802_46_0.json', 'ebookingcenter/15_07_2024/response_availability_agent_qtech_10_36_42_1721039802_46_0.json', 'ebookingcenter/15_07_2024/response_header_availability_agent_qtech_10_36_42_1721039802_46_0.json', 'ebookingcenter', '2024-07-15 10:36:50', '', '1239152024071036414699728274', '13292370', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/15_07_2024/response_availability_agent_qtech_10_36_42_1721039802_46_0.json');
[07/15/2024 10:36:50], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'ebookingcenter/15_07_2024/request_availability_agent_qtech_10_36_42_1721039802_32_3.json', 'ebookingcenter/15_07_2024/response_availability_agent_qtech_10_36_42_1721039802_32_3.json', 'ebookingcenter/15_07_2024/response_header_availability_agent_qtech_10_36_42_1721039802_32_3.json', 'ebookingcenter', '2024-07-15 10:36:50', '', '1239152024071036414699728274', '13292370', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/15_07_2024/response_availability_agent_qtech_10_36_42_1721039802_32_3.json');
[07/15/2024 10:36:50], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'ebookingcenter/15_07_2024/request_availability_agent_qtech_10_36_42_1721039802_79_8.json', 'ebookingcenter/15_07_2024/response_availability_agent_qtech_10_36_42_1721039802_79_8.json', 'ebookingcenter/15_07_2024/response_header_availability_agent_qtech_10_36_42_1721039802_79_8.json', 'ebookingcenter', '2024-07-15 10:36:50', '', '1239152024071036414699728274', '13292370', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/15_07_2024/response_availability_agent_qtech_10_36_42_1721039802_79_8.json');
[07/15/2024 10:36:50], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=1239152024071036414699728274&xml_user_id=1239&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-07-15 10:36:42.681'
        , request_start_time = '0.180'
        , parsing_start_time = '6.858'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '7.877'
        , error_description = ''
        , memory_used = '50868776'
        WHERE id = '160501997';
[07/15/2024 10:36:50], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=1239152024071036414699728274&xml_user_id=1239&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-07-15 10:36:42.681'
        , request_start_time = '0.189'
        , parsing_start_time = '6.951'
        , mapping_complete_time = '0.031'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '8.100'
        , error_description = ''
        , memory_used = '62916792'
        WHERE id = '160501998';
[07/15/2024 10:36:50], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=1239152024071036414699728274&xml_user_id=1239&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-07-15 10:36:42.681'
        , request_start_time = '0.186'
        , parsing_start_time = '7.309'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '8.235'
        , error_description = ''
        , memory_used = '58185552'
        WHERE id = '160502000';
[07/15/2024 10:36:51], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'ebookingcenter/15_07_2024/request_availability_agent_qtech_10_36_42_1721039802_26_4.json', 'ebookingcenter/15_07_2024/response_availability_agent_qtech_10_36_42_1721039802_26_4.json', 'ebookingcenter/15_07_2024/response_header_availability_agent_qtech_10_36_42_1721039802_26_4.json', 'ebookingcenter', '2024-07-15 10:36:51', '', '1239152024071036414699728274', '13292370', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/15_07_2024/response_availability_agent_qtech_10_36_42_1721039802_26_4.json');
[07/15/2024 10:36:51], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=1239152024071036414699728274&xml_user_id=1239&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-07-15 10:36:42.683'
        , request_start_time = '0.171'
        , parsing_start_time = '7.322'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '8.383'
        , error_description = ''
        , memory_used = '66920264'
        WHERE id = '160501999';
[07/15/2024 10:36:51], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=1239152024071036414699728274&xml_user_id=1239&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-07-15 10:36:42.682'
        , request_start_time = '0.173'
        , parsing_start_time = '7.395'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '8.450'
        , error_description = ''
        , memory_used = '74424048'
        WHERE id = '160502001';
[07/15/2024 10:36:51], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=1239152024071036414699728274&xml_user_id=1239&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-07-15 10:36:42.680'
        , request_start_time = '0.185'
        , parsing_start_time = '8.170'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '9.178'
        , error_description = ''
        , memory_used = '80736912'
        WHERE id = '160502081';
[07/15/2024 10:36:51], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=1239&sessionid=1239152024071036414699728274',
        duration = '9.332',
        merge_duration = '0.002',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '10.06',
        system_load_5_min = '8.35',
        system_load_15_min = '11.27',
        system_memory_usage = '89.16',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '13292370') + '116935920',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '13292370';
[07/15/2024 10:37: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', 'ebookingcenter/15_07_2024/request_availability_agent_qtech_10_37_12_1721039832_7_0.json', 'ebookingcenter/15_07_2024/response_availability_agent_qtech_10_37_12_1721039832_7_0.json', 'ebookingcenter/15_07_2024/response_header_availability_agent_qtech_10_37_12_1721039832_7_0.json', 'ebookingcenter', '2024-07-15 10:37:15', '', '1239152024071036414699728274', '13292370', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/15_07_2024/response_availability_agent_qtech_10_37_12_1721039832_7_0.json');
[07/15/2024 10:37:16], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=1239152024071036414699728274&xml_user_id=1239&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-07-15 10:37:12.49'
        , request_start_time = '0.012'
        , parsing_start_time = '3.619'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '4.295'
        , error_description = ''
        , memory_used = '67010144'
        WHERE id = '160502281';
[07/15/2024 10:42:56], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[07/15/2024 10:42:56], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '77' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/15/2024 10:42:56], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '89' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/15/2024 10:42:56], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '102' ,status = '' ,priority = '25' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '25';
[07/15/2024 10:42:56], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '76' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/15/2024 10:42:56], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '98' ,status = '' ,priority = '5' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[07/15/2024 10:42:56], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '58' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/15/2024 10:42:56], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '99' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/15/2024 10:42:56], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '86' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/15/2024 10:42:56], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '74' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/15/2024 10:42:56], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '75' ,status = '' ,priority = '14' ,lead_time = '48',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[07/15/2024 10:42:56], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '96' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/15/2024 10:42:56], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '56' ,status = '' ,priority = '27' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '27';
[07/15/2024 10:42:56], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '60' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/15/2024 10:42:56], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '84' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/15/2024 10:42:56], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '67' ,status = '' ,priority = '25' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '25';
[07/15/2024 10:42:56], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '1' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/15/2024 10:42:56], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '101' ,status = '' ,priority = '25' ,lead_time = '72',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '25';
[07/15/2024 10:42:56], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '73' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/15/2024 10:42:56], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '85' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/15/2024 10:42:56], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '103' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[07/15/2024 10:42:56], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '100' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/15/2024 10:42:56], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '93' ,status = '' ,priority = '' ,lead_time = '1200',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/15/2024 10:42:56], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '57' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/15/2024 10:42:56], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '97' ,status = '' ,priority = '' ,lead_time = '1440',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/15/2024 10:42:56], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '81' ,status = '' ,priority = '27' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '27';
[07/15/2024 10:42:56], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '78' ,status = '' ,priority = '27' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '27';
[07/15/2024 10:42:56], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '83' ,status = '' ,priority = '27' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '27';
[07/15/2024 10:42:56], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '68' ,status = '' ,priority = '27' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '27';
[07/15/2024 10:42:56], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '90' ,status = '' ,priority = '27' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '27';
[07/15/2024 10:42:56], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '66' ,status = '' ,priority = '27' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '27';
[07/15/2024 10:42:56], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '64' ,status = '' ,priority = '27' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '27';
[07/15/2024 10:42:56], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '65' ,status = '' ,priority = '27' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '27';
[07/15/2024 10:42:56], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '69' ,status = '' ,priority = '27' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '27';
[07/15/2024 10:42:56], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'Qtech_pranali',`create_date`= '2024-07-15 10:42:56',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 77 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 89 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 102 ,status = \&#039;\&#039; ,priority = \&#039;25\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;25\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 76 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 98 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 58 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 99 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 86 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 74 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 75 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;48\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 96 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 56 ,status = \&#039;\&#039; ,priority = \&#039;27\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;27\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 60 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 84 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 67 ,status = \&#039;\&#039; ,priority = \&#039;25\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;25\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 1 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 101 ,status = \&#039;\&#039; ,priority = \&#039;25\&#039; ,lead_time = \&#039;72\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;25\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 73 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 85 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 103 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 100 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 93 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;1200\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 57 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 97 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;1440\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 81 ,status = \&#039;\&#039; ,priority = \&#039;27\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;27\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 78 ,status = \&#039;\&#039; ,priority = \&#039;27\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;27\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 83 ,status = \&#039;\&#039; ,priority = \&#039;27\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;27\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 68 ,status = \&#039;\&#039; ,priority = \&#039;27\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;27\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 90 ,status = \&#039;\&#039; ,priority = \&#039;27\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;27\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 66 ,status = \&#039;\&#039; ,priority = \&#039;27\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;27\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 64 ,status = \&#039;\&#039; ,priority = \&#039;27\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;27\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 65 ,status = \&#039;\&#039; ,priority = \&#039;27\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;27\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 69 ,status = \&#039;\&#039; ,priority = \&#039;27\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;27\&#039;',`log_description`= 'Supplier setting updated  Previous data-- agent_id-1239 ## supplier_id- 99 ## company_name - EBooking Center ## supplier_code-ebookingcenter  ## percentage - 0.00 ## lead_time - 0 ',`ip`= '43.239.53.130';
[07/15/2024 10:43:07], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-07-15 10:43:07',login_attempt=0 where id = '1239';
[07/15/2024 10:43:07], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'agent_qtech', user_type = 'A', branch_id = '26', login_datetime = '2024-07-15 10:43:07', ip = '43.239.53.130', action = 'Login' ;
[07/15/2024 10:54:25], [file name :-/efsdata/otrams/public_html/beta/index.php],INSERT INTO psa_login_log  SET username = '', user_type = 'A', branch_id = '7', login_datetime = '2024-07-15 10:54:25', ip = '109.202.99.46', action = 'Login' ;
