[08/26/2024 09:03:24], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-08-26 09:03:24',login_attempt=0 where id = '1284';
[08/26/2024 09:03:24], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'qtech_agent', user_type = 'A', branch_id = '26', login_datetime = '2024-08-26 09:03:24', ip = '43.239.53.130', action = 'Login' ;
[08/26/2024 09:03:49], [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 = 'erbil' , service_name = '' , country_of_residence = '129' , service_type = 'hotel' , arrival_date = '2024/09/06' , departure_date = '2024/09/07' , nights = '1' , nationality = '129' , room_types = '2.1, 1.1' , room_type='[{"numberOfAdults":2,"numberOfChild":1,"ChildAge":"4"},{"numberOfAdults":1,"numberOfChild":1,"ChildAge":"7"}]' , available='0' , create_date = '2024-08-26 09:03:49' , site_id = '' , country_code = '109' , city_code = '109_23475-EBL_5735' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'INR' , currency_code = 'INR' , web_service = '0' ;
[08/26/2024 09:03:50], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_1284_12842620240809034917429756008', session_id='12842620240809034917429756008', Collection_create_time='2024-08-26 09:03:50';
[08/26/2024 09:03:52], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=1284&sessionid=12842620240809034917429756008',
        duration = '2.069',
        merge_duration = '0.011',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '7.20',
        system_load_5_min = '10.19',
        system_load_15_min = '7.68',
        system_memory_usage = '27.22',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '15238521') + '2300744',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '15238521';
[08/26/2024 09:04:26], [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 = 'erbil' , service_name = '' , country_of_residence = '129' , service_type = 'hotel' , arrival_date = '2024/09/06' , departure_date = '2024/09/07' , nights = '1' , nationality = '129' , room_types = '2.1, 1.1' , room_type='[{"numberOfAdults":2,"numberOfChild":1,"ChildAge":"4"},{"numberOfAdults":1,"numberOfChild":1,"ChildAge":"7"}]' , available='0' , create_date = '2024-08-26 09:04:26' , site_id = '' , country_code = '109' , city_code = '109_23475-EBL_5735' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'INR' , currency_code = 'INR' , web_service = '0' ;
[08/26/2024 09:04:27], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_1284_12842620240809042694011189370', session_id='12842620240809042694011189370', Collection_create_time='2024-08-26 09:04:27';
[08/26/2024 09:04:31], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=1284&sessionid=12842620240809042694011189370',
        duration = '4.092',
        merge_duration = '0.018',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '19.22',
        system_load_5_min = '12.53',
        system_load_15_min = '8.54',
        system_memory_usage = '27.79',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '15238558') + '2300608',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '15238558';
[08/26/2024 09:05:34], [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 = 'erbil' , service_name = '' , country_of_residence = '129' , service_type = 'hotel' , arrival_date = '2024/09/06' , departure_date = '2024/09/07' , nights = '1' , nationality = '129' , room_types = '2.1, 1.1' , room_type='[{"numberOfAdults":2,"numberOfChild":1,"ChildAge":"4"},{"numberOfAdults":1,"numberOfChild":1,"ChildAge":"7"}]' , available='0' , create_date = '2024-08-26 09:05:34' , site_id = '' , country_code = '109' , city_code = '109_23475-EBL_5735' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'INR' , currency_code = 'INR' , web_service = '0' ;
[08/26/2024 09:05:35], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_1284_1284262024080905347915783636', session_id='1284262024080905347915783636', Collection_create_time='2024-08-26 09:05:35';
[08/26/2024 09:05:37], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=1284&sessionid=1284262024080905347915783636',
        duration = '2.080',
        merge_duration = '0.021',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '10.61',
        system_load_5_min = '11.07',
        system_load_15_min = '8.31',
        system_memory_usage = '27.45',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '15238624') + '2301008',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '15238624';
[08/26/2024 09:06:58], [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 = 'erbil' , service_name = '' , country_of_residence = '129' , service_type = 'hotel' , arrival_date = '2024/09/06' , departure_date = '2024/09/07' , nights = '1' , nationality = '129' , room_types = '2.1, 1.1' , room_type='[{"numberOfAdults":2,"numberOfChild":1,"ChildAge":"4"},{"numberOfAdults":1,"numberOfChild":1,"ChildAge":"7"}]' , available='0' , create_date = '2024-08-26 09:06:58' , site_id = '' , country_code = '109' , city_code = '109_23475-EBL_5735' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'INR' , currency_code = 'INR' , web_service = '0' ;
[08/26/2024 09:06:59], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_1284_12842620240809065893201357359', session_id='12842620240809065893201357359', Collection_create_time='2024-08-26 09:06:59';
[08/26/2024 09:07:01], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '26',
        request_path = '/xml_all.php?userid=1284&sessionid=12842620240809065893201357359',
        duration = '2.068',
        merge_duration = '0.014',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '7.31',
        system_load_5_min = '10.01',
        system_load_15_min = '8.17',
        system_memory_usage = '27.37',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '15238684') + '2300528',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '15238684';
[08/26/2024 09:07:28], [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 = 'erbil' , service_name = '' , country_of_residence = '129' , service_type = 'hotel' , arrival_date = '2024/09/06' , departure_date = '2024/09/07' , nights = '1' , nationality = '129' , room_types = '1.1, 1.1' , room_type='[{"numberOfAdults":1,"numberOfChild":1,"ChildAge":"4"},{"numberOfAdults":1,"numberOfChild":1,"ChildAge":"7"}]' , available='0' , create_date = '2024-08-26 09:07:28' , site_id = '' , country_code = '109' , city_code = '109_23475-EBL_5735' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'INR' , currency_code = 'INR' , web_service = '0' ;
[08/26/2024 09:07:29], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_1284_1284262024080907285678218938', session_id='1284262024080907285678218938', Collection_create_time='2024-08-26 09:07:29';
[08/26/2024 09:07:32], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=1284&sessionid=1284262024080907285678218938',
        duration = '3.075',
        merge_duration = '0.016',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '5.60',
        system_load_5_min = '9.31',
        system_load_15_min = '7.99',
        system_memory_usage = '27.49',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '15238723') + '2298528',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '15238723';
[08/26/2024 09:07:45], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_1284_1284262024080907285678218938', session_id='1284262024080907285678218938', Collection_create_time='2024-08-26 09:07:45';
[08/26/2024 09:10: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 = 'erbil' , service_name = '' , country_of_residence = '129' , service_type = 'hotel' , arrival_date = '2024/09/06' , departure_date = '2024/09/07' , nights = '1' , nationality = '129' , room_types = '1.1, 2.1' , room_type='[{"numberOfAdults":2,"numberOfChild":1,"ChildAge":"7"},{"numberOfAdults":1,"numberOfChild":1,"ChildAge":"4"}]' , available='0' , create_date = '2024-08-26 09:10:59' , site_id = '' , country_code = '109' , city_code = '109_23475-EBL_5735' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'INR' , currency_code = 'INR' , web_service = '0' ;
[08/26/2024 09:11:00], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_1284_12842620240809105933549241495', session_id='12842620240809105933549241495', Collection_create_time='2024-08-26 09:11:00';
[08/26/2024 09:11:02], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=1284&sessionid=12842620240809105933549241495',
        duration = '2.073',
        merge_duration = '0.014',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '3.48',
        system_load_5_min = '6.74',
        system_load_15_min = '7.26',
        system_memory_usage = '27.50',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '15238909') + '2300176',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '15238909';
[08/26/2024 09:11:09], [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 = 'erbil' , service_name = '' , country_of_residence = '129' , service_type = 'hotel' , arrival_date = '2024/09/06' , departure_date = '2024/09/07' , nights = '1' , nationality = '129' , room_types = '2.1, 1.1' , room_type='[{"numberOfAdults":2,"numberOfChild":1,"ChildAge":"7"},{"numberOfAdults":1,"numberOfChild":1,"ChildAge":"4"}]' , available='0' , create_date = '2024-08-26 09:11:09' , site_id = '' , country_code = '109' , city_code = '109_23475-EBL_5735' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'INR' , currency_code = 'INR' , web_service = '0' ;
[08/26/2024 09:11:10], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_1284_12842620240809110972108785810', session_id='12842620240809110972108785810', Collection_create_time='2024-08-26 09:11:10';
[08/26/2024 09:11:13], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '27',
        request_path = '/xml_all.php?userid=1284&sessionid=12842620240809110972108785810',
        duration = '3.066',
        merge_duration = '0.013',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '3.10',
        system_load_5_min = '6.55',
        system_load_15_min = '7.20',
        system_memory_usage = '27.47',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '15238911') + '2300608',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '15238911';
[08/26/2024 09:12:30], [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 = 'erbil' , service_name = '' , country_of_residence = '129' , service_type = 'hotel' , arrival_date = '2024/09/06' , departure_date = '2024/09/07' , nights = '1' , nationality = '129' , room_types = '2.1, 2.1' , room_type='[{"numberOfAdults":2,"numberOfChild":1,"ChildAge":"7"},{"numberOfAdults":2,"numberOfChild":1,"ChildAge":"4"}]' , available='0' , create_date = '2024-08-26 09:12:30' , site_id = '' , country_code = '109' , city_code = '109_23475-EBL_5735' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'INR' , currency_code = 'INR' , web_service = '0' ;
[08/26/2024 09:12:31], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_1284_12842620240809123016228718644', session_id='12842620240809123016228718644', Collection_create_time='2024-08-26 09:12:31';
[08/26/2024 09:12:38], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=1284&sessionid=12842620240809123016228718644',
        duration = '7.090',
        merge_duration = '0.014',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '3.72',
        system_load_5_min = '6.01',
        system_load_15_min = '6.96',
        system_memory_usage = '27.15',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '15239063') + '2297040',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '15239063';
[08/26/2024 09:15:02], [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 = 'erbil' , service_name = '' , country_of_residence = '129' , service_type = 'hotel' , arrival_date = '2024/09/06' , departure_date = '2024/09/07' , nights = '1' , nationality = '129' , room_types = '2.1, 2.1' , room_type='[{"numberOfAdults":2,"numberOfChild":1,"ChildAge":"7"},{"numberOfAdults":2,"numberOfChild":1,"ChildAge":"4"}]' , available='0' , create_date = '2024-08-26 09:15:02' , site_id = '' , country_code = '109' , city_code = '109_23475-EBL_5735' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'INR' , currency_code = 'INR' , web_service = '0' ;
[08/26/2024 09:15:03], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_1284_12842620240809150292526442698', session_id='12842620240809150292526442698', Collection_create_time='2024-08-26 09:15:03';
[08/26/2024 09:15:05], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=1284&sessionid=12842620240809150292526442698',
        duration = '2.070',
        merge_duration = '0.013',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '15.27',
        system_load_5_min = '8.92',
        system_load_15_min = '7.84',
        system_memory_usage = '27.32',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '15239224') + '2297088',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '15239224';
[08/26/2024 09:30:20], [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 = 'erbil' , service_name = '' , country_of_residence = '129' , service_type = 'hotel' , arrival_date = '2024/09/06' , departure_date = '2024/09/07' , nights = '1' , nationality = '129' , room_types = '2.1, 2.1' , room_type='[{"numberOfAdults":2,"numberOfChild":1,"ChildAge":"7"},{"numberOfAdults":2,"numberOfChild":1,"ChildAge":"4"}]' , available='0' , create_date = '2024-08-26 09:30:20' , site_id = '' , country_code = '109' , city_code = '109_23475-EBL_5735' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'INR' , currency_code = 'INR' , web_service = '0' ;
[08/26/2024 09:30:21], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_1284_12842620240809302039595228113', session_id='12842620240809302039595228113', Collection_create_time='2024-08-26 09:30:21';
[08/26/2024 09:30:23], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=1284&sessionid=12842620240809302039595228113',
        duration = '2.065',
        merge_duration = '0.011',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '3.57',
        system_load_5_min = '5.66',
        system_load_15_min = '6.87',
        system_memory_usage = '27.31',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '15240607') + '2297040',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '15240607';
[08/26/2024 09:31:30], [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 = 'erbil' , service_name = '' , country_of_residence = '129' , service_type = 'hotel' , arrival_date = '2024/09/06' , departure_date = '2024/09/07' , nights = '1' , nationality = '129' , room_types = '2.1, 2.1' , room_type='[{"numberOfAdults":2,"numberOfChild":1,"ChildAge":"7"},{"numberOfAdults":2,"numberOfChild":1,"ChildAge":"4"}]' , available='0' , create_date = '2024-08-26 09:31:30' , site_id = '' , country_code = '109' , city_code = '109_23475-EBL_5735' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'INR' , currency_code = 'INR' , web_service = '0' ;
[08/26/2024 09:31:30], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_1284_12842620240809313041295292420', session_id='12842620240809313041295292420', Collection_create_time='2024-08-26 09:31:30';
[08/26/2024 09:31:33], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '30',
        request_path = '/xml_all.php?userid=1284&sessionid=12842620240809313041295292420',
        duration = '3.065',
        merge_duration = '0.012',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '1.93',
        system_load_5_min = '4.73',
        system_load_15_min = '6.46',
        system_memory_usage = '27.23',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '15240683') + '2297040',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '15240683';
[08/26/2024 09:32:43], [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 = 'erbil' , service_name = '' , country_of_residence = '129' , service_type = 'hotel' , arrival_date = '2024/09/06' , departure_date = '2024/09/07' , nights = '1' , nationality = '129' , room_types = '2.1, 2.1' , room_type='[{"numberOfAdults":2,"numberOfChild":1,"ChildAge":"7"},{"numberOfAdults":2,"numberOfChild":1,"ChildAge":"4"}]' , available='0' , create_date = '2024-08-26 09:32:43' , site_id = '' , country_code = '109' , city_code = '109_23475-EBL_5735' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'INR' , currency_code = 'INR' , web_service = '0' ;
[08/26/2024 09:32:43], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_1284_1284262024080932432379897246', session_id='1284262024080932432379897246', Collection_create_time='2024-08-26 09:32:43';
[08/26/2024 09:32:50], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '30',
        request_path = '/xml_all.php?userid=1284&sessionid=1284262024080932432379897246',
        duration = '6.105',
        merge_duration = '0.016',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '9.93',
        system_load_5_min = '6.32',
        system_load_15_min = '6.87',
        system_memory_usage = '27.36',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '15240773') + '2297520',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '15240773';
[08/26/2024 09:34:06], [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 = 'erbil' , service_name = '' , country_of_residence = '129' , service_type = 'hotel' , arrival_date = '2024/09/06' , departure_date = '2024/09/07' , nights = '1' , nationality = '129' , room_types = '2.1, 2.1' , room_type='[{"numberOfAdults":2,"numberOfChild":1,"ChildAge":"7"},{"numberOfAdults":2,"numberOfChild":1,"ChildAge":"4"}]' , available='0' , create_date = '2024-08-26 09:34:06' , site_id = '' , country_code = '109' , city_code = '109_23475-EBL_5735' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'INR' , currency_code = 'INR' , web_service = '0' ;
[08/26/2024 09:34:07], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_1284_12842620240809340679059760041', session_id='12842620240809340679059760041', Collection_create_time='2024-08-26 09:34:07';
[08/26/2024 09:34:09], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '30',
        request_path = '/xml_all.php?userid=1284&sessionid=12842620240809340679059760041',
        duration = '2.065',
        merge_duration = '0.014',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '4.40',
        system_load_5_min = '5.60',
        system_load_15_min = '6.58',
        system_memory_usage = '27.34',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '15240905') + '2298192',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '15240905';
[08/26/2024 09:34:15], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_1284_12842620240809340679059760041', session_id='12842620240809340679059760041', Collection_create_time='2024-08-26 09:34:15';
[08/26/2024 09:37:20], [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 = 'erbil' , service_name = '' , country_of_residence = '129' , service_type = 'hotel' , arrival_date = '2024/09/06' , departure_date = '2024/09/07' , nights = '1' , nationality = '129' , room_types = '2.1, 1.1' , room_type='[{"numberOfAdults":2,"numberOfChild":1,"ChildAge":"7"},{"numberOfAdults":1,"numberOfChild":1,"ChildAge":"4"}]' , available='0' , create_date = '2024-08-26 09:37:20' , site_id = '' , country_code = '109' , city_code = '109_23475-EBL_5735' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'INR' , currency_code = 'INR' , web_service = '0' ;
[08/26/2024 09:37:22], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_1284_12842620240809372011763678034', session_id='12842620240809372011763678034', Collection_create_time='2024-08-26 09:37:22';
[08/26/2024 09:37:25], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '27',
        request_path = '/xml_all.php?userid=1284&sessionid=12842620240809372011763678034',
        duration = '3.070',
        merge_duration = '0.015',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '3.00',
        system_load_5_min = '5.41',
        system_load_15_min = '6.40',
        system_memory_usage = '27.23',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '15241153') + '2300864',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '15241153';
[08/26/2024 09:44:52], [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 = 'erbil' , service_name = '' , country_of_residence = '129' , service_type = 'hotel' , arrival_date = '2024/09/06' , departure_date = '2024/09/07' , nights = '1' , nationality = '129' , room_types = '2.1, 1.1' , room_type='[{"numberOfAdults":2,"numberOfChild":1,"ChildAge":"7"},{"numberOfAdults":1,"numberOfChild":1,"ChildAge":"4"}]' , available='0' , create_date = '2024-08-26 09:44:52' , site_id = '' , country_code = '109' , city_code = '109_23475-EBL_5735' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'INR' , currency_code = 'INR' , web_service = '0' ;
[08/26/2024 09:44:53], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_1284_12842620240809445225582500647', session_id='12842620240809445225582500647', Collection_create_time='2024-08-26 09:44:53';
[08/26/2024 09:44:55], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '27',
        request_path = '/xml_all.php?userid=1284&sessionid=12842620240809445225582500647',
        duration = '2.079',
        merge_duration = '0.018',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '8.63',
        system_load_5_min = '5.11',
        system_load_15_min = '5.74',
        system_memory_usage = '27.42',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '15242199') + '2301768',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '15242199';
[08/26/2024 09:46: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 = 'erbil' , service_name = '' , country_of_residence = '129' , service_type = 'hotel' , arrival_date = '2024/09/06' , departure_date = '2024/09/07' , nights = '1' , nationality = '129' , room_types = '2.1, 1.1' , room_type='[{"numberOfAdults":2,"numberOfChild":1,"ChildAge":"7"},{"numberOfAdults":1,"numberOfChild":1,"ChildAge":"4"}]' , available='0' , create_date = '2024-08-26 09:46:10' , site_id = '' , country_code = '109' , city_code = '109_23475-EBL_5735' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'INR' , currency_code = 'INR' , web_service = '0' ;
[08/26/2024 09:46:11], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_1284_12842620240809461053308010245', session_id='12842620240809461053308010245', Collection_create_time='2024-08-26 09:46:11';
[08/26/2024 09:46:13], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '27',
        request_path = '/xml_all.php?userid=1284&sessionid=12842620240809461053308010245',
        duration = '2.079',
        merge_duration = '0.016',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '17.51',
        system_load_5_min = '8.10',
        system_load_15_min = '6.70',
        system_memory_usage = '27.71',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '15242279') + '2301768',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '15242279';
[08/26/2024 09:46:28], [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 = 'erbil' , service_name = '' , country_of_residence = '129' , service_type = 'hotel' , arrival_date = '2024/09/06' , departure_date = '2024/09/07' , nights = '1' , nationality = '129' , room_types = '2.1, 2.1' , room_type='[{"numberOfAdults":2,"numberOfChild":1,"ChildAge":"7"},{"numberOfAdults":2,"numberOfChild":1,"ChildAge":"4"}]' , available='0' , create_date = '2024-08-26 09:46:28' , site_id = '' , country_code = '109' , city_code = '109_23475-EBL_5735' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'INR' , currency_code = 'INR' , web_service = '0' ;
[08/26/2024 09:46:30], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_1284_12842620240809462873644358062', session_id='12842620240809462873644358062', Collection_create_time='2024-08-26 09:46:30';
[08/26/2024 09:46:32], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '30',
        request_path = '/xml_all.php?userid=1284&sessionid=12842620240809462873644358062',
        duration = '2.071',
        merge_duration = '0.014',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '12.90',
        system_load_5_min = '7.66',
        system_load_15_min = '6.58',
        system_memory_usage = '27.58',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '15242332') + '2298176',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '15242332';
[08/26/2024 09:46:53], [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 = 'erbil' , service_name = '' , country_of_residence = '129' , service_type = 'hotel' , arrival_date = '2024/09/06' , departure_date = '2024/09/07' , nights = '1' , nationality = '129' , room_types = '2.2, 2.1' , room_type='[{"numberOfAdults":2,"numberOfChild":2,"ChildAge":"5,7"},{"numberOfAdults":2,"numberOfChild":1,"ChildAge":"4"}]' , available='0' , create_date = '2024-08-26 09:46:53' , site_id = '' , country_code = '109' , city_code = '109_23475-EBL_5735' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'INR' , currency_code = 'INR' , web_service = '0' ;
[08/26/2024 09:46:54], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_1284_12842620240809465343782325699', session_id='12842620240809465343782325699', Collection_create_time='2024-08-26 09:46:54';
[08/26/2024 09:46:57], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '15',
        request_path = '/xml_all.php?userid=1284&sessionid=12842620240809465343782325699',
        duration = '3.068',
        merge_duration = '0.013',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '10.26',
        system_load_5_min = '7.40',
        system_load_15_min = '6.52',
        system_memory_usage = '27.56',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '15242376') + '2302672',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '15242376';
[08/26/2024 09:49:19], [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 = 'erbil' , service_name = '' , country_of_residence = '129' , service_type = 'hotel' , arrival_date = '2024/09/06' , departure_date = '2024/09/07' , nights = '1' , nationality = '129' , room_types = '2.2, 2.1' , room_type='[{"numberOfAdults":2,"numberOfChild":2,"ChildAge":"5,7"},{"numberOfAdults":2,"numberOfChild":1,"ChildAge":"4"}]' , available='0' , create_date = '2024-08-26 09:49:19' , site_id = '' , country_code = '109' , city_code = '109_23475-EBL_5735' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'INR' , currency_code = 'INR' , web_service = '0' ;
[08/26/2024 09:49:20], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_1284_12842620240809491988984514261', session_id='12842620240809491988984514261', Collection_create_time='2024-08-26 09:49:20';
[08/26/2024 09:49:22], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '15',
        request_path = '/xml_all.php?userid=1284&sessionid=12842620240809491988984514261',
        duration = '2.067',
        merge_duration = '0.013',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '6.82',
        system_load_5_min = '6.89',
        system_load_15_min = '6.44',
        system_memory_usage = '27.48',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '15242909') + '2302424',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '15242909';
[08/26/2024 09:53:06], [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 = 'erbil' , service_name = '' , country_of_residence = '129' , service_type = 'hotel' , arrival_date = '2024/09/06' , departure_date = '2024/09/07' , nights = '1' , nationality = '129' , room_types = '2.2, 2.1' , room_type='[{"numberOfAdults":2,"numberOfChild":2,"ChildAge":"5,7"},{"numberOfAdults":2,"numberOfChild":1,"ChildAge":"4"}]' , available='0' , create_date = '2024-08-26 09:53:06' , site_id = '' , country_code = '109' , city_code = '109_23475-EBL_5735' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'INR' , currency_code = 'INR' , web_service = '0' ;
[08/26/2024 09:53:09], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_1284_12842620240809530611884670992', session_id='12842620240809530611884670992', Collection_create_time='2024-08-26 09:53:09';
[08/26/2024 09:53:11], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '15',
        request_path = '/xml_all.php?userid=1284&sessionid=12842620240809530611884670992',
        duration = '2.614',
        merge_duration = '0.016',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '3.93',
        system_load_5_min = '7.09',
        system_load_15_min = '6.76',
        system_memory_usage = '25.99',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '15243528') + '2302424',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '15243528';
[08/26/2024 09:58:53], [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 = 'erbil' , service_name = '' , country_of_residence = '129' , service_type = 'hotel' , arrival_date = '2024/09/06' , departure_date = '2024/09/07' , nights = '1' , nationality = '129' , room_types = '2.2, 2.1' , room_type='[{"numberOfAdults":2,"numberOfChild":2,"ChildAge":"5,7"},{"numberOfAdults":2,"numberOfChild":1,"ChildAge":"4"}]' , available='0' , create_date = '2024-08-26 09:58:53' , site_id = '' , country_code = '109' , city_code = '109_23475-EBL_5735' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'INR' , currency_code = 'INR' , web_service = '0' ;
[08/26/2024 09:58:55], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_1284_12842620240809585369914320952', session_id='12842620240809585369914320952', Collection_create_time='2024-08-26 09:58:55';
[08/26/2024 09:58:57], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '15',
        request_path = '/xml_all.php?userid=1284&sessionid=12842620240809585369914320952',
        duration = '2.072',
        merge_duration = '0.013',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '2.93',
        system_load_5_min = '5.36',
        system_load_15_min = '6.22',
        system_memory_usage = '26.26',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '15243966') + '2302424',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '15243966';
