[05/16/2024 10:46:12], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '1284' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '129' , service_type = 'hotel' , arrival_date = '2024/05/23' , departure_date = '2024/05/24' , nights = '1' , nationality = '129' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-05-16 10:46:12' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'INR' , currency_code = 'INR' , web_service = '0' ;
[05/16/2024 10:46: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)
                VALUE ('', 'availability', 'h2/16_05_2024/request_availability_qtech_agent_10_46_14_1715856374_23_.json', 'h2/16_05_2024/response_availability_qtech_agent_10_46_14_1715856374_23_.json', 'h2/16_05_2024/response_header_availability_qtech_agent_10_46_14_1715856374_23_.json', 'hotelspro', '2024-05-16 10:46:14', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9553726');
[05/16/2024 10:46:14], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=hotelspro&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&&erequest=23&total_request=24&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 10:46:13.913'
        , request_start_time = '0.045'
        , parsing_start_time = '0.215'
        , mapping_complete_time = '0.021'
        , mongo_start_time = '0.024'
        , search_end_time = '0.000'
        , total_duration = '0.354'
        , error_description = ''
        , memory_used = '3182048'
        WHERE id = '139552202';
[05/16/2024 10:46: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)
                VALUE ('', 'availability', 'h2/16_05_2024/request_availability_qtech_agent_10_46_14_1715856374_4_.json', 'h2/16_05_2024/response_availability_qtech_agent_10_46_14_1715856374_4_.json', 'h2/16_05_2024/response_header_availability_qtech_agent_10_46_14_1715856374_4_.json', 'hotelspro', '2024-05-16 10:46:15', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9553726');
[05/16/2024 10:46:15], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '10'
        , request_url = '/call.php?s=hotelspro&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&&erequest=4&total_request=24&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 10:46:13.913'
        , request_start_time = '0.016'
        , parsing_start_time = '1.551'
        , mapping_complete_time = '0.022'
        , mongo_start_time = '0.046'
        , search_end_time = '0.075'
        , total_duration = '1.770'
        , error_description = ''
        , memory_used = '7400600'
        WHERE id = '139552203';
[05/16/2024 10:46: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)
                VALUE ('', 'availability', 'h2/16_05_2024/request_availability_qtech_agent_10_46_14_1715856374_11_.json', 'h2/16_05_2024/response_availability_qtech_agent_10_46_14_1715856374_11_.json', 'h2/16_05_2024/response_header_availability_qtech_agent_10_46_14_1715856374_11_.json', 'hotelspro', '2024-05-16 10:46:15', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9553726');
[05/16/2024 10:46:15], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '4'
        , request_url = '/call.php?s=hotelspro&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&&erequest=11&total_request=24&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 10:46:13.911'
        , request_start_time = '0.044'
        , parsing_start_time = '1.790'
        , mapping_complete_time = '0.021'
        , mongo_start_time = '0.048'
        , search_end_time = '0.080'
        , total_duration = '2.024'
        , error_description = ''
        , memory_used = '9078832'
        WHERE id = '139552204';
[05/16/2024 10:46:16], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'h2/16_05_2024/request_availability_qtech_agent_10_46_14_1715856374_20_.json', 'h2/16_05_2024/response_availability_qtech_agent_10_46_14_1715856374_20_.json', 'h2/16_05_2024/response_header_availability_qtech_agent_10_46_14_1715856374_20_.json', 'hotelspro', '2024-05-16 10:46:16', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9553726');
[05/16/2024 10:46:16], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'h2/16_05_2024/request_availability_qtech_agent_10_46_14_1715856374_21_.json', 'h2/16_05_2024/response_availability_qtech_agent_10_46_14_1715856374_21_.json', 'h2/16_05_2024/response_header_availability_qtech_agent_10_46_14_1715856374_21_.json', 'hotelspro', '2024-05-16 10:46:16', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9553726');
[05/16/2024 10:46:16], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '14'
        , request_url = '/call.php?s=hotelspro&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&&erequest=21&total_request=24&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 10:46:13.913'
        , request_start_time = '0.043'
        , parsing_start_time = '2.291'
        , mapping_complete_time = '0.024'
        , mongo_start_time = '0.060'
        , search_end_time = '0.134'
        , total_duration = '2.618'
        , error_description = ''
        , memory_used = '11848016'
        WHERE id = '139552206';
[05/16/2024 10:46:16], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '16'
        , request_url = '/call.php?s=hotelspro&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&&erequest=20&total_request=24&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 10:46:13.915'
        , request_start_time = '0.033'
        , parsing_start_time = '2.237'
        , mapping_complete_time = '0.025'
        , mongo_start_time = '0.077'
        , search_end_time = '0.217'
        , total_duration = '2.628'
        , error_description = ''
        , memory_used = '17477136'
        WHERE id = '139552205';
[05/16/2024 10:46:17], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'h2/16_05_2024/request_availability_qtech_agent_10_46_14_1715856374_15_.json', 'h2/16_05_2024/response_availability_qtech_agent_10_46_14_1715856374_15_.json', 'h2/16_05_2024/response_header_availability_qtech_agent_10_46_14_1715856374_15_.json', 'hotelspro', '2024-05-16 10:46:17', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9553726');
[05/16/2024 10:46:17], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'h2/16_05_2024/request_availability_qtech_agent_10_46_14_1715856374_5_.json', 'h2/16_05_2024/response_availability_qtech_agent_10_46_14_1715856374_5_.json', 'h2/16_05_2024/response_header_availability_qtech_agent_10_46_14_1715856374_5_.json', 'hotelspro', '2024-05-16 10:46:17', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9553726');
[05/16/2024 10:46:17], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'h2/16_05_2024/request_availability_qtech_agent_10_46_14_1715856374_22_.json', 'h2/16_05_2024/response_availability_qtech_agent_10_46_14_1715856374_22_.json', 'h2/16_05_2024/response_header_availability_qtech_agent_10_46_14_1715856374_22_.json', 'hotelspro', '2024-05-16 10:46:17', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9553726');
[05/16/2024 10:46:17], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'h2/16_05_2024/request_availability_qtech_agent_10_46_14_1715856374_16_.json', 'h2/16_05_2024/response_availability_qtech_agent_10_46_14_1715856374_16_.json', 'h2/16_05_2024/response_header_availability_qtech_agent_10_46_14_1715856374_16_.json', 'hotelspro', '2024-05-16 10:46:17', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9553726');
[05/16/2024 10:46:17], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '14'
        , request_url = '/call.php?s=hotelspro&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&&erequest=15&total_request=24&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 10:46:13.915'
        , request_start_time = '0.029'
        , parsing_start_time = '3.107'
        , mapping_complete_time = '0.027'
        , mongo_start_time = '0.092'
        , search_end_time = '0.283'
        , total_duration = '3.599'
        , error_description = ''
        , memory_used = '22934400'
        WHERE id = '139552207';
[05/16/2024 10:46:17], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'h2/16_05_2024/request_availability_qtech_agent_10_46_14_1715856374_6_.json', 'h2/16_05_2024/response_availability_qtech_agent_10_46_14_1715856374_6_.json', 'h2/16_05_2024/response_header_availability_qtech_agent_10_46_14_1715856374_6_.json', 'hotelspro', '2024-05-16 10:46:17', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9553726');
[05/16/2024 10:46:17], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '22'
        , request_url = '/call.php?s=hotelspro&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&&erequest=5&total_request=24&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 10:46:13.911'
        , request_start_time = '0.026'
        , parsing_start_time = '3.230'
        , mapping_complete_time = '0.036'
        , mongo_start_time = '0.150'
        , search_end_time = '0.482'
        , total_duration = '3.979'
        , error_description = ''
        , memory_used = '36462080'
        WHERE id = '139552208';
[05/16/2024 10:46:17], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'h2/16_05_2024/request_availability_qtech_agent_10_46_14_1715856374_0_.json', 'h2/16_05_2024/response_availability_qtech_agent_10_46_14_1715856374_0_.json', 'h2/16_05_2024/response_header_availability_qtech_agent_10_46_14_1715856374_0_.json', 'hotelspro', '2024-05-16 10:46:17', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9553726');
[05/16/2024 10:46:17], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '18'
        , request_url = '/call.php?s=hotelspro&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&&erequest=22&total_request=24&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 10:46:13.914'
        , request_start_time = '0.039'
        , parsing_start_time = '3.327'
        , mapping_complete_time = '0.031'
        , mongo_start_time = '0.137'
        , search_end_time = '0.462'
        , total_duration = '4.033'
        , error_description = ''
        , memory_used = '35212656'
        WHERE id = '139552209';
[05/16/2024 10:46:18], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '20'
        , request_url = '/call.php?s=hotelspro&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&&erequest=16&total_request=24&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 10:46:13.915'
        , request_start_time = '0.032'
        , parsing_start_time = '3.426'
        , mapping_complete_time = '0.028'
        , mongo_start_time = '0.118'
        , search_end_time = '0.442'
        , total_duration = '4.118'
        , error_description = ''
        , memory_used = '32181120'
        WHERE id = '139552210';
[05/16/2024 10:46:18], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'h2/16_05_2024/request_availability_qtech_agent_10_46_13_1715856373_13_.json', 'h2/16_05_2024/response_availability_qtech_agent_10_46_13_1715856373_13_.json', 'h2/16_05_2024/response_header_availability_qtech_agent_10_46_13_1715856373_13_.json', 'hotelspro', '2024-05-16 10:46:18', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9553726');
[05/16/2024 10:46:18], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '20'
        , request_url = '/call.php?s=hotelspro&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&&erequest=6&total_request=24&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 10:46:13.915'
        , request_start_time = '0.023'
        , parsing_start_time = '3.705'
        , mapping_complete_time = '0.031'
        , mongo_start_time = '0.122'
        , search_end_time = '0.483'
        , total_duration = '4.429'
        , error_description = ''
        , memory_used = '33402504'
        WHERE id = '139552211';
[05/16/2024 10:46:18], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'h2/16_05_2024/request_availability_qtech_agent_10_46_13_1715856373_1_.json', 'h2/16_05_2024/response_availability_qtech_agent_10_46_13_1715856373_1_.json', 'h2/16_05_2024/response_header_availability_qtech_agent_10_46_13_1715856373_1_.json', 'hotelspro', '2024-05-16 10:46:18', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9553726');
[05/16/2024 10:46:18], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'h2/16_05_2024/request_availability_qtech_agent_10_46_14_1715856374_17_.json', 'h2/16_05_2024/response_availability_qtech_agent_10_46_14_1715856374_17_.json', 'h2/16_05_2024/response_header_availability_qtech_agent_10_46_14_1715856374_17_.json', 'hotelspro', '2024-05-16 10:46:18', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9553726');
[05/16/2024 10:46:18], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'h2/16_05_2024/request_availability_qtech_agent_10_46_13_1715856373_7_.json', 'h2/16_05_2024/response_availability_qtech_agent_10_46_13_1715856373_7_.json', 'h2/16_05_2024/response_header_availability_qtech_agent_10_46_13_1715856373_7_.json', 'hotelspro', '2024-05-16 10:46:18', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9553726');
[05/16/2024 10:46:18], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'h2/16_05_2024/request_availability_qtech_agent_10_46_13_1715856373_3_.json', 'h2/16_05_2024/response_availability_qtech_agent_10_46_13_1715856373_3_.json', 'h2/16_05_2024/response_header_availability_qtech_agent_10_46_13_1715856373_3_.json', 'hotelspro', '2024-05-16 10:46:18', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9553726');
[05/16/2024 10:46:19], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '31'
        , request_url = '/call.php?s=hotelspro&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&&erequest=0&total_request=24&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 10:46:13.913'
        , request_start_time = '0.027'
        , parsing_start_time = '3.876'
        , mapping_complete_time = '0.048'
        , mongo_start_time = '0.233'
        , search_end_time = '0.886'
        , total_duration = '5.113'
        , error_description = ''
        , memory_used = '58917840'
        WHERE id = '139552212';
[05/16/2024 10:46:19], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'h2/16_05_2024/request_availability_qtech_agent_10_46_14_1715856374_14_.json', 'h2/16_05_2024/response_availability_qtech_agent_10_46_14_1715856374_14_.json', 'h2/16_05_2024/response_header_availability_qtech_agent_10_46_14_1715856374_14_.json', 'hotelspro', '2024-05-16 10:46:19', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9553726');
[05/16/2024 10:46:19], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '19'
        , request_url = '/call.php?s=hotelspro&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&&erequest=13&total_request=24&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 10:46:13.911'
        , request_start_time = '0.024'
        , parsing_start_time = '4.306'
        , mapping_complete_time = '0.040'
        , mongo_start_time = '0.232'
        , search_end_time = '0.657'
        , total_duration = '5.284'
        , error_description = ''
        , memory_used = '48846848'
        WHERE id = '139552213';
[05/16/2024 10:46:19], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '36'
        , request_url = '/call.php?s=hotelspro&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&&erequest=1&total_request=24&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 10:46:13.913'
        , request_start_time = '0.016'
        , parsing_start_time = '4.350'
        , mapping_complete_time = '0.039'
        , mongo_start_time = '0.177'
        , search_end_time = '0.765'
        , total_duration = '5.376'
        , error_description = ''
        , memory_used = '50134736'
        WHERE id = '139552214';
[05/16/2024 10:46:19], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'h2/16_05_2024/request_availability_qtech_agent_10_46_14_1715856374_8_.json', 'h2/16_05_2024/response_availability_qtech_agent_10_46_14_1715856374_8_.json', 'h2/16_05_2024/response_header_availability_qtech_agent_10_46_14_1715856374_8_.json', 'hotelspro', '2024-05-16 10:46:19', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9553726');
[05/16/2024 10:46:19], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '17'
        , request_url = '/call.php?s=hotelspro&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&&erequest=17&total_request=24&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 10:46:13.911'
        , request_start_time = '0.048'
        , parsing_start_time = '4.623'
        , mapping_complete_time = '0.038'
        , mongo_start_time = '0.179'
        , search_end_time = '0.617'
        , total_duration = '5.548'
        , error_description = ''
        , memory_used = '43628224'
        WHERE id = '139552215';
[05/16/2024 10:46:19], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '20'
        , request_url = '/call.php?s=hotelspro&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&&erequest=7&total_request=24&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 10:46:13.911'
        , request_start_time = '0.017'
        , parsing_start_time = '4.827'
        , mapping_complete_time = '0.036'
        , mongo_start_time = '0.155'
        , search_end_time = '0.624'
        , total_duration = '5.689'
        , error_description = ''
        , memory_used = '39395608'
        WHERE id = '139552216';
[05/16/2024 10:46:19], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'h2/16_05_2024/request_availability_qtech_agent_10_46_14_1715856374_19_.json', 'h2/16_05_2024/response_availability_qtech_agent_10_46_14_1715856374_19_.json', 'h2/16_05_2024/response_header_availability_qtech_agent_10_46_14_1715856374_19_.json', 'hotelspro', '2024-05-16 10:46:19', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9553726');
[05/16/2024 10:46:19], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'h2/16_05_2024/request_availability_qtech_agent_10_46_13_1715856373_9_.json', 'h2/16_05_2024/response_availability_qtech_agent_10_46_13_1715856373_9_.json', 'h2/16_05_2024/response_header_availability_qtech_agent_10_46_13_1715856373_9_.json', 'hotelspro', '2024-05-16 10:46:19', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9553726');
[05/16/2024 10:46:19], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '25'
        , request_url = '/call.php?s=hotelspro&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&&erequest=14&total_request=24&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 10:46:13.911'
        , request_start_time = '0.031'
        , parsing_start_time = '5.027'
        , mapping_complete_time = '0.035'
        , mongo_start_time = '0.178'
        , search_end_time = '0.502'
        , total_duration = '5.829'
        , error_description = ''
        , memory_used = '36855344'
        WHERE id = '139552218';
[05/16/2024 10:46:19], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'h2/16_05_2024/request_availability_qtech_agent_10_46_14_1715856374_18_.json', 'h2/16_05_2024/response_availability_qtech_agent_10_46_14_1715856374_18_.json', 'h2/16_05_2024/response_header_availability_qtech_agent_10_46_14_1715856374_18_.json', 'hotelspro', '2024-05-16 10:46:19', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9553726');
[05/16/2024 10:46:20], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'h2/16_05_2024/request_availability_qtech_agent_10_46_14_1715856374_12_.json', 'h2/16_05_2024/response_availability_qtech_agent_10_46_14_1715856374_12_.json', 'h2/16_05_2024/response_header_availability_qtech_agent_10_46_14_1715856374_12_.json', 'hotelspro', '2024-05-16 10:46:20', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9553726');
[05/16/2024 10:46:20], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'h2/16_05_2024/request_availability_qtech_agent_10_46_13_1715856373_2_.json', 'h2/16_05_2024/response_availability_qtech_agent_10_46_13_1715856373_2_.json', 'h2/16_05_2024/response_header_availability_qtech_agent_10_46_13_1715856373_2_.json', 'hotelspro', '2024-05-16 10:46:20', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9553726');
[05/16/2024 10:46:20], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '31'
        , request_url = '/call.php?s=hotelspro&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&&erequest=19&total_request=24&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 10:46:13.913'
        , request_start_time = '0.041'
        , parsing_start_time = '5.542'
        , mapping_complete_time = '0.050'
        , mongo_start_time = '0.298'
        , search_end_time = '0.909'
        , total_duration = '6.877'
        , error_description = ''
        , memory_used = '63433808'
        WHERE id = '139552220';
[05/16/2024 10:46:20], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '28'
        , request_url = '/call.php?s=hotelspro&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&&erequest=3&total_request=24&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 10:46:13.913'
        , request_start_time = '0.014'
        , parsing_start_time = '4.876'
        , mapping_complete_time = '0.057'
        , mongo_start_time = '0.591'
        , search_end_time = '1.356'
        , total_duration = '6.910'
        , error_description = ''
        , memory_used = '86307392'
        WHERE id = '139552217';
[05/16/2024 10:46:20], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '27'
        , request_url = '/call.php?s=hotelspro&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&&erequest=8&total_request=24&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 10:46:13.911'
        , request_start_time = '0.045'
        , parsing_start_time = '5.298'
        , mapping_complete_time = '0.066'
        , mongo_start_time = '0.410'
        , search_end_time = '1.109'
        , total_duration = '6.941'
        , error_description = ''
        , memory_used = '73591576'
        WHERE id = '139552219';
[05/16/2024 10:46:20], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '30'
        , request_url = '/call.php?s=hotelspro&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&&erequest=18&total_request=24&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 10:46:13.912'
        , request_start_time = '0.031'
        , parsing_start_time = '5.723'
        , mapping_complete_time = '0.038'
        , mongo_start_time = '0.268'
        , search_end_time = '0.885'
        , total_duration = '7.000'
        , error_description = ''
        , memory_used = '61671624'
        WHERE id = '139552222';
[05/16/2024 10:46:20], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'h2/16_05_2024/request_availability_qtech_agent_10_46_14_1715856374_10_.json', 'h2/16_05_2024/response_availability_qtech_agent_10_46_14_1715856374_10_.json', 'h2/16_05_2024/response_header_availability_qtech_agent_10_46_14_1715856374_10_.json', 'hotelspro', '2024-05-16 10:46:20', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9553726');
[05/16/2024 10:46:21], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '35'
        , request_url = '/call.php?s=hotelspro&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&&erequest=9&total_request=24&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 10:46:13.915'
        , request_start_time = '0.019'
        , parsing_start_time = '5.628'
        , mapping_complete_time = '0.050'
        , mongo_start_time = '0.285'
        , search_end_time = '1.267'
        , total_duration = '7.266'
        , error_description = ''
        , memory_used = '76105088'
        WHERE id = '139552221';
[05/16/2024 10:46:21], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '29'
        , request_url = '/call.php?s=hotelspro&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&&erequest=10&total_request=24&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 10:46:13.911'
        , request_start_time = '0.023'
        , parsing_start_time = '6.950'
        , mapping_complete_time = '0.036'
        , mongo_start_time = '0.206'
        , search_end_time = '0.690'
        , total_duration = '7.956'
        , error_description = ''
        , memory_used = '50270608'
        WHERE id = '139552225';
[05/16/2024 10:46:21], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '22'
        , request_url = '/call.php?s=hotelspro&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&&erequest=12&total_request=24&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 10:46:13.911'
        , request_start_time = '0.025'
        , parsing_start_time = '6.463'
        , mapping_complete_time = '0.048'
        , mongo_start_time = '0.353'
        , search_end_time = '1.050'
        , total_duration = '7.970'
        , error_description = ''
        , memory_used = '71991744'
        WHERE id = '139552223';
[05/16/2024 10:46:22], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '31'
        , request_url = '/call.php?s=hotelspro&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&&erequest=2&total_request=24&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 10:46:13.913'
        , request_start_time = '0.018'
        , parsing_start_time = '6.681'
        , mapping_complete_time = '0.074'
        , mongo_start_time = '0.475'
        , search_end_time = '1.239'
        , total_duration = '8.493'
        , error_description = ''
        , memory_used = '88844648'
        WHERE id = '139552224';
[05/16/2024 10:46:22], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '499',
        request_path = '/xml_all.php?userid=1284&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02',
        duration = '9.029',
        merge_duration = '0.138',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '0.84',
        system_load_5_min = '1.10',
        system_load_15_min = '1.05',
        system_memory_usage = '93.58',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '9553726') + '20404768',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '9553726';
[05/16/2024 10:47:10], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '1284' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '129' , service_type = 'hotel' , arrival_date = '2024/05/23' , departure_date = '2024/05/24' , nights = '1' , nationality = '129' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-05-16 10:47:10' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'INR' , currency_code = 'INR' , web_service = '0' ;
[05/16/2024 10:47: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)
                VALUE ('', 'availability', 'h2/16_05_2024/request_availability_qtech_agent_10_47_11_1715856431_23_.json', 'h2/16_05_2024/response_availability_qtech_agent_10_47_11_1715856431_23_.json', 'h2/16_05_2024/response_header_availability_qtech_agent_10_47_11_1715856431_23_.json', 'hotelspro', '2024-05-16 10:47:11', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9553764');
[05/16/2024 10:47:11], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=hotelspro&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&&erequest=23&total_request=24&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 10:47:11.196'
        , request_start_time = '0.041'
        , parsing_start_time = '0.188'
        , mapping_complete_time = '0.021'
        , mongo_start_time = '0.024'
        , search_end_time = '0.000'
        , total_duration = '0.313'
        , error_description = ''
        , memory_used = '3182032'
        WHERE id = '139552298';
[05/16/2024 10:47:13], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'h2/16_05_2024/request_availability_qtech_agent_10_47_11_1715856431_11_.json', 'h2/16_05_2024/response_availability_qtech_agent_10_47_11_1715856431_11_.json', 'h2/16_05_2024/response_header_availability_qtech_agent_10_47_11_1715856431_11_.json', 'hotelspro', '2024-05-16 10:47:13', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9553764');
[05/16/2024 10:47:13], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '4'
        , request_url = '/call.php?s=hotelspro&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&&erequest=11&total_request=24&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 10:47:11.191'
        , request_start_time = '0.024'
        , parsing_start_time = '2.413'
        , mapping_complete_time = '0.021'
        , mongo_start_time = '0.049'
        , search_end_time = '0.095'
        , total_duration = '2.673'
        , error_description = ''
        , memory_used = '9078504'
        WHERE id = '139552341';
[05/16/2024 10:47:13], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'h2/16_05_2024/request_availability_qtech_agent_10_47_11_1715856431_22_.json', 'h2/16_05_2024/response_availability_qtech_agent_10_47_11_1715856431_22_.json', 'h2/16_05_2024/response_header_availability_qtech_agent_10_47_11_1715856431_22_.json', 'hotelspro', '2024-05-16 10:47:13', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9553764');
[05/16/2024 10:47: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)
                VALUE ('', 'availability', 'h2/16_05_2024/request_availability_qtech_agent_10_47_11_1715856431_15_.json', 'h2/16_05_2024/response_availability_qtech_agent_10_47_11_1715856431_15_.json', 'h2/16_05_2024/response_header_availability_qtech_agent_10_47_11_1715856431_15_.json', 'hotelspro', '2024-05-16 10:47:13', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9553764');
[05/16/2024 10:47: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)
                VALUE ('', 'availability', 'h2/16_05_2024/request_availability_qtech_agent_10_47_11_1715856431_6_.json', 'h2/16_05_2024/response_availability_qtech_agent_10_47_11_1715856431_6_.json', 'h2/16_05_2024/response_header_availability_qtech_agent_10_47_11_1715856431_6_.json', 'hotelspro', '2024-05-16 10:47:14', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9553764');
[05/16/2024 10:47: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)
                VALUE ('', 'availability', 'h2/16_05_2024/request_availability_qtech_agent_10_47_11_1715856431_7_.json', 'h2/16_05_2024/response_availability_qtech_agent_10_47_11_1715856431_7_.json', 'h2/16_05_2024/response_header_availability_qtech_agent_10_47_11_1715856431_7_.json', 'hotelspro', '2024-05-16 10:47:14', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9553764');
[05/16/2024 10:47:14], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '18'
        , request_url = '/call.php?s=hotelspro&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&&erequest=22&total_request=24&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 10:47:11.194'
        , request_start_time = '0.035'
        , parsing_start_time = '2.602'
        , mapping_complete_time = '0.030'
        , mongo_start_time = '0.133'
        , search_end_time = '0.485'
        , total_duration = '3.321'
        , error_description = ''
        , memory_used = '35346408'
        WHERE id = '139552347';
[05/16/2024 10:47: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)
                VALUE ('', 'availability', 'h2/16_05_2024/request_availability_qtech_agent_10_47_11_1715856431_12_.json', 'h2/16_05_2024/response_availability_qtech_agent_10_47_11_1715856431_12_.json', 'h2/16_05_2024/response_header_availability_qtech_agent_10_47_11_1715856431_12_.json', 'hotelspro', '2024-05-16 10:47:14', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9553764');
[05/16/2024 10:47:14], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '14'
        , request_url = '/call.php?s=hotelspro&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&&erequest=15&total_request=24&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 10:47:11.192'
        , request_start_time = '0.034'
        , parsing_start_time = '2.662'
        , mapping_complete_time = '0.028'
        , mongo_start_time = '0.097'
        , search_end_time = '0.497'
        , total_duration = '3.391'
        , error_description = ''
        , memory_used = '22622200'
        WHERE id = '139552350';
[05/16/2024 10:47:14], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '20'
        , request_url = '/call.php?s=hotelspro&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&&erequest=6&total_request=24&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 10:47:11.193'
        , request_start_time = '0.030'
        , parsing_start_time = '2.664'
        , mapping_complete_time = '0.043'
        , mongo_start_time = '0.140'
        , search_end_time = '0.520'
        , total_duration = '3.455'
        , error_description = ''
        , memory_used = '34261944'
        WHERE id = '139552351';
[05/16/2024 10:47: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)
                VALUE ('', 'availability', 'h2/16_05_2024/request_availability_qtech_agent_10_47_11_1715856431_4_.json', 'h2/16_05_2024/response_availability_qtech_agent_10_47_11_1715856431_4_.json', 'h2/16_05_2024/response_header_availability_qtech_agent_10_47_11_1715856431_4_.json', 'hotelspro', '2024-05-16 10:47:14', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9553764');
[05/16/2024 10:47: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)
                VALUE ('', 'availability', 'h2/16_05_2024/request_availability_qtech_agent_10_47_11_1715856431_19_.json', 'h2/16_05_2024/response_availability_qtech_agent_10_47_11_1715856431_19_.json', 'h2/16_05_2024/response_header_availability_qtech_agent_10_47_11_1715856431_19_.json', 'hotelspro', '2024-05-16 10:47:14', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9553764');
[05/16/2024 10:47:14], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '10'
        , request_url = '/call.php?s=hotelspro&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&&erequest=4&total_request=24&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 10:47:11.192'
        , request_start_time = '0.025'
        , parsing_start_time = '3.383'
        , mapping_complete_time = '0.021'
        , mongo_start_time = '0.048'
        , search_end_time = '0.111'
        , total_duration = '3.633'
        , error_description = ''
        , memory_used = '6939200'
        WHERE id = '139552361';
[05/16/2024 10:47:15], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '24'
        , request_url = '/call.php?s=hotelspro&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&&erequest=7&total_request=24&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 10:47:11.192'
        , request_start_time = '0.032'
        , parsing_start_time = '2.942'
        , mapping_complete_time = '0.032'
        , mongo_start_time = '0.197'
        , search_end_time = '0.773'
        , total_duration = '4.048'
        , error_description = ''
        , memory_used = '43687168'
        WHERE id = '139552353';
[05/16/2024 10:47: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)
                VALUE ('', 'availability', 'h2/16_05_2024/request_availability_qtech_agent_10_47_11_1715856431_10_.json', 'h2/16_05_2024/response_availability_qtech_agent_10_47_11_1715856431_10_.json', 'h2/16_05_2024/response_header_availability_qtech_agent_10_47_11_1715856431_10_.json', 'hotelspro', '2024-05-16 10:47:15', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9553764');
[05/16/2024 10:47: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)
                VALUE ('', 'availability', 'h2/16_05_2024/request_availability_qtech_agent_10_47_11_1715856431_21_.json', 'h2/16_05_2024/response_availability_qtech_agent_10_47_11_1715856431_21_.json', 'h2/16_05_2024/response_header_availability_qtech_agent_10_47_11_1715856431_21_.json', 'hotelspro', '2024-05-16 10:47:15', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9553764');
[05/16/2024 10:47:16], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'h2/16_05_2024/request_availability_qtech_agent_10_47_11_1715856431_17_.json', 'h2/16_05_2024/response_availability_qtech_agent_10_47_11_1715856431_17_.json', 'h2/16_05_2024/response_header_availability_qtech_agent_10_47_11_1715856431_17_.json', 'hotelspro', '2024-05-16 10:47:16', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9553764');
[05/16/2024 10:47:16], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'h2/16_05_2024/request_availability_qtech_agent_10_47_11_1715856431_14_.json', 'h2/16_05_2024/response_availability_qtech_agent_10_47_11_1715856431_14_.json', 'h2/16_05_2024/response_header_availability_qtech_agent_10_47_11_1715856431_14_.json', 'hotelspro', '2024-05-16 10:47:16', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9553764');
[05/16/2024 10:47:16], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '24'
        , request_url = '/call.php?s=hotelspro&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&&erequest=12&total_request=24&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 10:47:11.196'
        , request_start_time = '0.024'
        , parsing_start_time = '3.191'
        , mapping_complete_time = '0.078'
        , mongo_start_time = '0.448'
        , search_end_time = '1.234'
        , total_duration = '4.998'
        , error_description = ''
        , memory_used = '85391776'
        WHERE id = '139552359';
[05/16/2024 10:47:16], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '11'
        , request_url = '/call.php?s=hotelspro&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&&erequest=21&total_request=24&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 10:47:11.192'
        , request_start_time = '0.032'
        , parsing_start_time = '4.658'
        , mapping_complete_time = '0.023'
        , mongo_start_time = '0.057'
        , search_end_time = '0.188'
        , total_duration = '5.005'
        , error_description = ''
        , memory_used = '10063808'
        WHERE id = '139552370';
[05/16/2024 10:47:16], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'h2/16_05_2024/request_availability_qtech_agent_10_47_11_1715856431_16_.json', 'h2/16_05_2024/response_availability_qtech_agent_10_47_11_1715856431_16_.json', 'h2/16_05_2024/response_header_availability_qtech_agent_10_47_11_1715856431_16_.json', 'hotelspro', '2024-05-16 10:47:16', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9553764');
[05/16/2024 10:47:16], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '33'
        , request_url = '/call.php?s=hotelspro&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&&erequest=19&total_request=24&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 10:47:11.192'
        , request_start_time = '0.046'
        , parsing_start_time = '3.323'
        , mapping_complete_time = '0.046'
        , mongo_start_time = '0.451'
        , search_end_time = '1.125'
        , total_duration = '5.057'
        , error_description = ''
        , memory_used = '78701720'
        WHERE id = '139552362';
[05/16/2024 10:47:16], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'h2/16_05_2024/request_availability_qtech_agent_10_47_11_1715856431_18_.json', 'h2/16_05_2024/response_availability_qtech_agent_10_47_11_1715856431_18_.json', 'h2/16_05_2024/response_header_availability_qtech_agent_10_47_11_1715856431_18_.json', 'hotelspro', '2024-05-16 10:47:16', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9553764');
[05/16/2024 10:47:16], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'h2/16_05_2024/request_availability_qtech_agent_10_47_11_1715856431_5_.json', 'h2/16_05_2024/response_availability_qtech_agent_10_47_11_1715856431_5_.json', 'h2/16_05_2024/response_header_availability_qtech_agent_10_47_11_1715856431_5_.json', 'hotelspro', '2024-05-16 10:47:16', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9553764');
[05/16/2024 10:47:16], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'h2/16_05_2024/request_availability_qtech_agent_10_47_11_1715856431_9_.json', 'h2/16_05_2024/response_availability_qtech_agent_10_47_11_1715856431_9_.json', 'h2/16_05_2024/response_header_availability_qtech_agent_10_47_11_1715856431_9_.json', 'hotelspro', '2024-05-16 10:47:16', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9553764');
[05/16/2024 10:47:16], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '27'
        , request_url = '/call.php?s=hotelspro&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&&erequest=10&total_request=24&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 10:47:11.193'
        , request_start_time = '0.025'
        , parsing_start_time = '4.430'
        , mapping_complete_time = '0.039'
        , mongo_start_time = '0.179'
        , search_end_time = '0.609'
        , total_duration = '5.318'
        , error_description = ''
        , memory_used = '45507512'
        WHERE id = '139552368';
[05/16/2024 10:47:16], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'h2/16_05_2024/request_availability_qtech_agent_10_47_11_1715856431_20_.json', 'h2/16_05_2024/response_availability_qtech_agent_10_47_11_1715856431_20_.json', 'h2/16_05_2024/response_header_availability_qtech_agent_10_47_11_1715856431_20_.json', 'hotelspro', '2024-05-16 10:47:16', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9553764');
[05/16/2024 10:47:16], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'h2/16_05_2024/request_availability_qtech_agent_10_47_11_1715856431_2_.json', 'h2/16_05_2024/response_availability_qtech_agent_10_47_11_1715856431_2_.json', 'h2/16_05_2024/response_header_availability_qtech_agent_10_47_11_1715856431_2_.json', 'hotelspro', '2024-05-16 10:47:16', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9553764');
[05/16/2024 10:47:16], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'h2/16_05_2024/request_availability_qtech_agent_10_47_11_1715856431_3_.json', 'h2/16_05_2024/response_availability_qtech_agent_10_47_11_1715856431_3_.json', 'h2/16_05_2024/response_header_availability_qtech_agent_10_47_11_1715856431_3_.json', 'hotelspro', '2024-05-16 10:47:16', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9553764');
[05/16/2024 10:47:16], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '16'
        , request_url = '/call.php?s=hotelspro&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&&erequest=20&total_request=24&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 10:47:11.194'
        , request_start_time = '0.033'
        , parsing_start_time = '5.214'
        , mapping_complete_time = '0.025'
        , mongo_start_time = '0.079'
        , search_end_time = '0.242'
        , total_duration = '5.641'
        , error_description = ''
        , memory_used = '16290232'
        WHERE id = '139552378';
[05/16/2024 10:47:16], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '20'
        , request_url = '/call.php?s=hotelspro&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&&erequest=16&total_request=24&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 10:47:11.191'
        , request_start_time = '0.032'
        , parsing_start_time = '4.876'
        , mapping_complete_time = '0.033'
        , mongo_start_time = '0.130'
        , search_end_time = '0.535'
        , total_duration = '5.673'
        , error_description = ''
        , memory_used = '33250376'
        WHERE id = '139552374';
[05/16/2024 10:47:16], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '22'
        , request_url = '/call.php?s=hotelspro&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&&erequest=5&total_request=24&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 10:47:11.192'
        , request_start_time = '0.019'
        , parsing_start_time = '5.028'
        , mapping_complete_time = '0.037'
        , mongo_start_time = '0.149'
        , search_end_time = '0.508'
        , total_duration = '5.780'
        , error_description = ''
        , memory_used = '36479040'
        WHERE id = '139552376';
[05/16/2024 10:47:17], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '17'
        , request_url = '/call.php?s=hotelspro&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&&erequest=17&total_request=24&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 10:47:11.194'
        , request_start_time = '0.042'
        , parsing_start_time = '4.809'
        , mapping_complete_time = '0.035'
        , mongo_start_time = '0.267'
        , search_end_time = '0.649'
        , total_duration = '5.875'
        , error_description = ''
        , memory_used = '43008448'
        WHERE id = '139552372';
[05/16/2024 10:47:17], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '26'
        , request_url = '/call.php?s=hotelspro&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&&erequest=14&total_request=24&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 10:47:11.194'
        , request_start_time = '0.028'
        , parsing_start_time = '4.832'
        , mapping_complete_time = '0.044'
        , mongo_start_time = '0.245'
        , search_end_time = '0.792'
        , total_duration = '5.997'
        , error_description = ''
        , memory_used = '54443488'
        WHERE id = '139552373';
[05/16/2024 10:47:17], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'h2/16_05_2024/request_availability_qtech_agent_10_47_11_1715856431_1_.json', 'h2/16_05_2024/response_availability_qtech_agent_10_47_11_1715856431_1_.json', 'h2/16_05_2024/response_header_availability_qtech_agent_10_47_11_1715856431_1_.json', 'hotelspro', '2024-05-16 10:47:17', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9553764');
[05/16/2024 10:47:17], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '28'
        , request_url = '/call.php?s=hotelspro&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&&erequest=18&total_request=24&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 10:47:11.192'
        , request_start_time = '0.047'
        , parsing_start_time = '4.953'
        , mapping_complete_time = '0.059'
        , mongo_start_time = '0.288'
        , search_end_time = '0.727'
        , total_duration = '6.111'
        , error_description = ''
        , memory_used = '54959400'
        WHERE id = '139552375';
[05/16/2024 10:47:17], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '35'
        , request_url = '/call.php?s=hotelspro&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&&erequest=9&total_request=24&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 10:47:11.195'
        , request_start_time = '0.027'
        , parsing_start_time = '5.136'
        , mapping_complete_time = '0.043'
        , mongo_start_time = '0.487'
        , search_end_time = '0.986'
        , total_duration = '6.742'
        , error_description = ''
        , memory_used = '73221656'
        WHERE id = '139552377';
[05/16/2024 10:47:18], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '36'
        , request_url = '/call.php?s=hotelspro&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&&erequest=1&total_request=24&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 10:47:11.192'
        , request_start_time = '0.027'
        , parsing_start_time = '5.848'
        , mapping_complete_time = '0.063'
        , mongo_start_time = '0.218'
        , search_end_time = '0.697'
        , total_duration = '6.896'
        , error_description = ''
        , memory_used = '52892016'
        WHERE id = '139552381';
[05/16/2024 10:47:18], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '30'
        , request_url = '/call.php?s=hotelspro&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&&erequest=2&total_request=24&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 10:47:11.194'
        , request_start_time = '0.016'
        , parsing_start_time = '5.393'
        , mapping_complete_time = '0.045'
        , mongo_start_time = '0.361'
        , search_end_time = '1.318'
        , total_duration = '7.169'
        , error_description = ''
        , memory_used = '77055424'
        WHERE id = '139552379';
[05/16/2024 10:47:18], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '28'
        , request_url = '/call.php?s=hotelspro&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&&erequest=3&total_request=24&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 10:47:11.191'
        , request_start_time = '0.036'
        , parsing_start_time = '5.328'
        , mapping_complete_time = '0.075'
        , mongo_start_time = '0.492'
        , search_end_time = '1.334'
        , total_duration = '7.302'
        , error_description = ''
        , memory_used = '85845208'
        WHERE id = '139552380';
[05/16/2024 10:47:19], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'h2/16_05_2024/request_availability_qtech_agent_10_47_11_1715856431_13_.json', 'h2/16_05_2024/response_availability_qtech_agent_10_47_11_1715856431_13_.json', 'h2/16_05_2024/response_header_availability_qtech_agent_10_47_11_1715856431_13_.json', 'hotelspro', '2024-05-16 10:47:19', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9553764');
[05/16/2024 10:47:19], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'h2/16_05_2024/request_availability_qtech_agent_10_47_11_1715856431_8_.json', 'h2/16_05_2024/response_availability_qtech_agent_10_47_11_1715856431_8_.json', 'h2/16_05_2024/response_header_availability_qtech_agent_10_47_11_1715856431_8_.json', 'hotelspro', '2024-05-16 10:47:19', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9553764');
[05/16/2024 10:47:19], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '16'
        , request_url = '/call.php?s=hotelspro&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&&erequest=13&total_request=24&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 10:47:11.191'
        , request_start_time = '0.027'
        , parsing_start_time = '7.787'
        , mapping_complete_time = '0.030'
        , mongo_start_time = '0.209'
        , search_end_time = '0.494'
        , total_duration = '8.606'
        , error_description = ''
        , memory_used = '27238312'
        WHERE id = '139552387';
[05/16/2024 10:47:19], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'h2/16_05_2024/request_availability_qtech_agent_10_47_11_1715856431_0_.json', 'h2/16_05_2024/response_availability_qtech_agent_10_47_11_1715856431_0_.json', 'h2/16_05_2024/response_header_availability_qtech_agent_10_47_11_1715856431_0_.json', 'hotelspro', '2024-05-16 10:47:19', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9553764');
[05/16/2024 10:47:20], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '27'
        , request_url = '/call.php?s=hotelspro&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&&erequest=8&total_request=24&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 10:47:11.194'
        , request_start_time = '0.029'
        , parsing_start_time = '7.869'
        , mapping_complete_time = '0.048'
        , mongo_start_time = '0.405'
        , search_end_time = '1.031'
        , total_duration = '9.437'
        , error_description = ''
        , memory_used = '73795664'
        WHERE id = '139552388';
[05/16/2024 10:47:20], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '28'
        , request_url = '/call.php?s=hotelspro&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&&erequest=0&total_request=24&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 10:47:11.192'
        , request_start_time = '0.022'
        , parsing_start_time = '8.561'
        , mapping_complete_time = '0.039'
        , mongo_start_time = '0.211'
        , search_end_time = '0.746'
        , total_duration = '9.616'
        , error_description = ''
        , memory_used = '55245440'
        WHERE id = '139552390';
[05/16/2024 10:47:20], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '493',
        request_path = '/xml_all.php?userid=1284&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02',
        duration = '10.210',
        merge_duration = '0.140',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '0.56',
        system_load_5_min = '1.00',
        system_load_15_min = '1.02',
        system_memory_usage = '94.25',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '9553764') + '20102304',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '9553764';
[05/16/2024 10:50:13], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[05/16/2024 10:50:13], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '77' ,status = '' ,priority = '9' ,lead_time = '1470',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[05/16/2024 10:50:13], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '89' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[05/16/2024 10:50:13], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '76' ,status = '' ,priority = '9' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[05/16/2024 10:50:13], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '98' ,status = '' ,priority = '9' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[05/16/2024 10:50:13], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '58' ,status = '' ,priority = '9' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[05/16/2024 10:50:13], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '99' ,status = '' ,priority = '9' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[05/16/2024 10:50:13], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '86' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[05/16/2024 10:50:13], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '74' ,status = '' ,priority = '14' ,lead_time = '48',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[05/16/2024 10:50:13], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '75' ,status = '' ,priority = '14' ,lead_time = '48',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[05/16/2024 10:50:13], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '96' ,status = '' ,priority = '9' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[05/16/2024 10:50:13], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '56' ,status = '' ,priority = '9' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[05/16/2024 10:50:13], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '60' ,status = '' ,priority = '9' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[05/16/2024 10:50:13], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '84' ,status = '' ,priority = '9' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[05/16/2024 10:50:13], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '67' ,status = '' ,priority = '5' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[05/16/2024 10:50:13], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '1' ,status = '' ,priority = '9' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[05/16/2024 10:50:13], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '101' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[05/16/2024 10:50:13], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '73' ,status = '' ,priority = '9' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[05/16/2024 10:50:13], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '85' ,status = '' ,priority = '9' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[05/16/2024 10:50:13], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '100' ,status = '' ,priority = '9' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[05/16/2024 10:50:13], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '93' ,status = '' ,priority = '9' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[05/16/2024 10:50:13], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '57' ,status = '' ,priority = '9' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[05/16/2024 10:50:13], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '97' ,status = '1' ,priority = '9' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[05/16/2024 10:50:13], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '81' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[05/16/2024 10:50:13], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '78' ,status = '' ,priority = '9' ,lead_time = '72',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[05/16/2024 10:50:13], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '83' ,status = '' ,priority = '9' ,lead_time = '72',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[05/16/2024 10:50:13], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '68' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[05/16/2024 10:50:13], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '90' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[05/16/2024 10:50:13], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '66' ,status = '' ,priority = '9' ,lead_time = '48',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[05/16/2024 10:50:13], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '64' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[05/16/2024 10:50:13], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '65' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[05/16/2024 10:50:13], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '69' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[05/16/2024 10:50:13], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'sanketpdesai',`create_date`= '2024-05-16 10:50:13',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1284\&#039;,supplier_id = 77 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;1470\&#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;1284\&#039;,supplier_id = 89 ,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;1284\&#039;,supplier_id = 76 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;96\&#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;1284\&#039;,supplier_id = 98 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;96\&#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;1284\&#039;,supplier_id = 58 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;96\&#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;1284\&#039;,supplier_id = 99 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;96\&#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;1284\&#039;,supplier_id = 86 ,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;1284\&#039;,supplier_id = 74 ,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;1284\&#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;1284\&#039;,supplier_id = 96 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;96\&#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;1284\&#039;,supplier_id = 56 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;96\&#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;1284\&#039;,supplier_id = 60 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;96\&#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;1284\&#039;,supplier_id = 84 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;96\&#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;1284\&#039;,supplier_id = 67 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;96\&#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;1284\&#039;,supplier_id = 1 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;96\&#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;1284\&#039;,supplier_id = 101 ,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;1284\&#039;,supplier_id = 73 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;96\&#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;1284\&#039;,supplier_id = 85 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;96\&#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;1284\&#039;,supplier_id = 100 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;96\&#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;1284\&#039;,supplier_id = 93 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;96\&#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;1284\&#039;,supplier_id = 57 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;96\&#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;1284\&#039;,supplier_id = 97 ,status = \&#039;1\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;96\&#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;1284\&#039;,supplier_id = 81 ,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;1284\&#039;,supplier_id = 78 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;72\&#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;1284\&#039;,supplier_id = 83 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;72\&#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;1284\&#039;,supplier_id = 68 ,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;1284\&#039;,supplier_id = 90 ,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;1284\&#039;,supplier_id = 66 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;48\&#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;1284\&#039;,supplier_id = 64 ,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;1284\&#039;,supplier_id = 65 ,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;1284\&#039;,supplier_id = 69 ,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;',`log_description`= 'Supplier setting updated  Previous data-- agent_id-1284 ## supplier_id- 60 ## company_name - Hotelspro ## supplier_code-hotelspro  ## percentage - 0.00 ## lead_time - 96 ',`ip`= '43.239.53.130';
[05/16/2024 10:50:33], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '1284' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '129' , service_type = 'hotel' , arrival_date = '2024/05/23' , departure_date = '2024/05/24' , nights = '1' , nationality = '129' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-05-16 10:50:33' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'INR' , currency_code = 'INR' , web_service = '0' ;
[05/16/2024 10:50:34], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-05-16 10:50:34.886'
            , total_duration = '0.062'
            , hotel_count = 0
            , source_type = 'tripathonxml'
            , create_date = '2024-05-16 10:50:34'
            , session_id = '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02'
            , agent_logs_id = '9554100'
            , error_description = ''
            , memory_used = '2663752';
[05/16/2024 10:50:34], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-05-16 10:50:34.887'
            , total_duration = '0.082'
            , hotel_count = 0
            , source_type = 'tripathonxml'
            , create_date = '2024-05-16 10:50:34'
            , session_id = '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02'
            , agent_logs_id = '9554100'
            , error_description = ''
            , memory_used = '2663752';
[05/16/2024 10:50:34], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-05-16 10:50:34.887'
            , total_duration = '0.085'
            , hotel_count = 0
            , source_type = 'tripathonxml'
            , create_date = '2024-05-16 10:50:34'
            , session_id = '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02'
            , agent_logs_id = '9554100'
            , error_description = ''
            , memory_used = '2663752';
[05/16/2024 10:50:35], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'tr/16_05_2024/request_availability_qtech_agent__3_10_50_34_1715856634.json', 'tr/16_05_2024/response_availability_qtech_agent__3_10_50_34_1715856634.json', 'tr/16_05_2024/response_header_availability_qtech_agent__3_10_50_34_1715856634.json', 'tripathonxml', '2024-05-16 10:50:35', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9554100');
[05/16/2024 10:50:35], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '2'
        , request_url = '/call.php?s=tripathonxml&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&site_id=&save_log=yes&city_code=AE_135012_&city_name=Hatta+%28Dubai%29&country_code=AE&country_name=United+Arab+Emirates&multicityreq=3&ws=1&original_source='
        , http_hit_time = '2024-05-16 10:50:34.888'
        , request_start_time = '0.013'
        , parsing_start_time = '0.564'
        , mapping_complete_time = '0.021'
        , mongo_start_time = '0.033'
        , search_end_time = '0.034'
        , total_duration = '0.689'
        , error_description = ''
        , memory_used = '4550056'
        WHERE id = '139553272';
[05/16/2024 10:50: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)
                VALUE ('', 'availability', 'tr/16_05_2024/request_availability_qtech_agent__0_10_50_34_1715856634.json', 'tr/16_05_2024/response_availability_qtech_agent__0_10_50_34_1715856634.json', 'tr/16_05_2024/response_header_availability_qtech_agent__0_10_50_34_1715856634.json', 'tripathonxml', '2024-05-16 10:50:38', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9554100');
[05/16/2024 10:51:04], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '703'
        , request_url = '/call.php?s=tripathonxml&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&site_id=&save_log=yes&city_code=97001&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&multicityreq=0&ws=1&original_source='
        , http_hit_time = '2024-05-16 10:50:34.886'
        , request_start_time = '0.014'
        , parsing_start_time = '3.896'
        , mapping_complete_time = '0.542'
        , mongo_start_time = '3.475'
        , search_end_time = '21.789'
        , total_duration = '29.531'
        , error_description = ''
        , memory_used = '604027992'
        WHERE id = '139553273';
[05/16/2024 10:51:04], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '702',
        request_path = '/xml_all.php?userid=1284&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02',
        duration = '29.954',
        merge_duration = '0.262',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '0.42',
        system_load_5_min = '0.71',
        system_load_15_min = '0.90',
        system_memory_usage = '93.70',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '9554100') + '36873504',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '9554100';
[05/16/2024 10:51:59], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '1284' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '129' , service_type = 'hotel' , arrival_date = '2024/05/23' , departure_date = '2024/05/24' , nights = '1' , nationality = '129' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-05-16 10:51:59' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'INR' , currency_code = 'INR' , web_service = '0' ;
[05/16/2024 10:51:59], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-05-16 10:51:59.903'
            , total_duration = '0.061'
            , hotel_count = 0
            , source_type = 'tripathonxml'
            , create_date = '2024-05-16 10:51:59'
            , session_id = '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02'
            , agent_logs_id = '9554174'
            , error_description = ''
            , memory_used = '2663752';
[05/16/2024 10:51:59], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-05-16 10:51:59.905'
            , total_duration = '0.061'
            , hotel_count = 0
            , source_type = 'tripathonxml'
            , create_date = '2024-05-16 10:51:59'
            , session_id = '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02'
            , agent_logs_id = '9554174'
            , error_description = ''
            , memory_used = '2663752';
[05/16/2024 10:51:59], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-05-16 10:51:59.905'
            , total_duration = '0.071'
            , hotel_count = 0
            , source_type = 'tripathonxml'
            , create_date = '2024-05-16 10:51:59'
            , session_id = '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02'
            , agent_logs_id = '9554174'
            , error_description = ''
            , memory_used = '2663752';
[05/16/2024 10:52:00], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'tr/16_05_2024/request_availability_qtech_agent__3_10_51_59_1715856719.json', 'tr/16_05_2024/response_availability_qtech_agent__3_10_51_59_1715856719.json', 'tr/16_05_2024/response_header_availability_qtech_agent__3_10_51_59_1715856719.json', 'tripathonxml', '2024-05-16 10:52:00', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9554174');
[05/16/2024 10:52:00], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '2'
        , request_url = '/call.php?s=tripathonxml&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&site_id=&save_log=yes&city_code=AE_135012_&city_name=Hatta+%28Dubai%29&country_code=AE&country_name=United+Arab+Emirates&multicityreq=3&ws=1&original_source='
        , http_hit_time = '2024-05-16 10:51:59.905'
        , request_start_time = '0.012'
        , parsing_start_time = '0.767'
        , mapping_complete_time = '0.020'
        , mongo_start_time = '0.032'
        , search_end_time = '0.032'
        , total_duration = '0.896'
        , error_description = ''
        , memory_used = '4550056'
        WHERE id = '139554242';
[05/16/2024 10:52:04], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'tr/16_05_2024/request_availability_qtech_agent__0_10_51_59_1715856719.json', 'tr/16_05_2024/response_availability_qtech_agent__0_10_51_59_1715856719.json', 'tr/16_05_2024/response_header_availability_qtech_agent__0_10_51_59_1715856719.json', 'tripathonxml', '2024-05-16 10:52:04', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9554174');
[05/16/2024 10:52:29], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '703'
        , request_url = '/call.php?s=tripathonxml&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&site_id=&save_log=yes&city_code=97001&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&multicityreq=0&ws=1&original_source='
        , http_hit_time = '2024-05-16 10:51:59.905'
        , request_start_time = '0.013'
        , parsing_start_time = '4.002'
        , mapping_complete_time = '0.544'
        , mongo_start_time = '3.626'
        , search_end_time = '21.892'
        , total_duration = '29.899'
        , error_description = ''
        , memory_used = '603551528'
        WHERE id = '139554246';
[05/16/2024 10:52:30], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '702',
        request_path = '/xml_all.php?userid=1284&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02',
        duration = '30.307',
        merge_duration = '0.252',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '1.64',
        system_load_5_min = '1.03',
        system_load_15_min = '1.00',
        system_memory_usage = '94.06',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '9554174') + '36960600',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '9554174';
[05/16/2024 10:56:37], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'tr/16_05_2024/request_availability_qtech_agent__0_10_56_34_1715856994.json', 'tr/16_05_2024/response_availability_qtech_agent__0_10_56_34_1715856994.json', 'tr/16_05_2024/response_header_availability_qtech_agent__0_10_56_34_1715856994.json', 'tripathonxml', '2024-05-16 10:56:37', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9554174');
[05/16/2024 10:57:03], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '704'
        , request_url = '/call.php?s=tripathonxml&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&site_id=&save_log=yes&city_code=97001&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&multicityreq=0&ws=1&original_source='
        , http_hit_time = '2024-05-16 10:56:33.817'
        , request_start_time = '0.018'
        , parsing_start_time = '3.380'
        , mapping_complete_time = '0.553'
        , mongo_start_time = '3.749'
        , search_end_time = '21.592'
        , total_duration = '29.256'
        , error_description = ''
        , memory_used = '605320488'
        WHERE id = '139556203';
[05/16/2024 10:57: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)
                VALUE ('', 'availability', 'tr/16_05_2024/request_availability_qtech_agent__0_10_57_52_1715857072.json', 'tr/16_05_2024/response_availability_qtech_agent__0_10_57_52_1715857072.json', 'tr/16_05_2024/response_header_availability_qtech_agent__0_10_57_52_1715857072.json', 'tripathonxml', '2024-05-16 10:57:56', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9554174');
[05/16/2024 10:58:31], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '704'
        , request_url = '/call.php?s=tripathonxml&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&site_id=&save_log=yes&city_code=97001&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&multicityreq=0&ws=1&original_source=&debug=1'
        , http_hit_time = '2024-05-16 10:57:52.61'
        , request_start_time = '0.015'
        , parsing_start_time = '4.778'
        , mapping_complete_time = '0.546'
        , mongo_start_time = '13.198'
        , search_end_time = '21.214'
        , total_duration = '39.624'
        , error_description = ''
        , memory_used = '607201352'
        WHERE id = '139556903';
