[05/21/2024 01:00:23], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],update room_rates set  availability='2', consumed_inventory='0' where supplier_id='S000000001' AND hotel_id='7' AND inventory_class_id='2'  AND date_from >='2024-05-21' AND date_from <='2024-06-20' AND FIND_IN_SET(LEFT(DAYNAME(date_from),2),'Sa,Su')='0';
[05/21/2024 01:00:23], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],update room_rates set  availability='3', consumed_inventory='0' where supplier_id='S000000001' AND hotel_id='7' AND inventory_class_id='2'  AND date_from >='2024-05-21' AND date_from <='2024-06-20' AND FIND_IN_SET(LEFT(DAYNAME(date_from),2),'Sa,Su')>'0';
[05/21/2024 01:00:23], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into `user_logs` set  `create_date`= '2024-05-21 13:00:23',`log_type`= 'Inventory Allocation',`sql_query`= 'update room_rates set  availability=\&#039;2\&#039;, consumed_inventory=\&#039;0\&#039; where supplier_id=\&#039;S000000001\&#039; AND hotel_id=\&#039;7\&#039; AND inventory_class_id=\&#039;2\&#039;  AND date_from &gt;=\&#039;2024-05-21\&#039; AND date_from &lt;=\&#039;2024-06-20\&#039; AND FIND_IN_SET(LEFT(DAYNAME(date_from),2),\&#039;Sa,Su\&#039;)=\&#039;0\&#039;&lt;br&gt;update room_rates set  availability=\&#039;3\&#039;, consumed_inventory=\&#039;0\&#039; where supplier_id=\&#039;S000000001\&#039; AND hotel_id=\&#039;7\&#039; AND inventory_class_id=\&#039;2\&#039;  AND date_from &gt;=\&#039;2024-05-21\&#039; AND date_from &lt;=\&#039;2024-06-20\&#039; AND FIND_IN_SET(LEFT(DAYNAME(date_from),2),\&#039;Sa,Su\&#039;)&gt;\&#039;0\&#039;',`log_description`= 'Upadated Inventory Allocation For hotel qtech_test- Inventory:-Standard From:-21-05-2024 To:-20-06-2024 Weekday Inventory Allocation:-2 Weekend Inventory Allocation:-3',`ip`= '43.239.53.130',`username`= 'v3alpha',`user_id`= 'S000000001';
[05/21/2024 01:00:23], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3395', `entity`='Hotels', `value`='7' ;
[05/21/2024 01:00:23], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3395', `entity`='Suppliers', `value`='S000000001' ;
[05/21/2024 01:00:23], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3395', `entity`='Inventory', `value`='2' ;
[05/21/2024 01:00:29], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '23' , ip = '43.239.53.130' , city = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/24' , departure_date = '2024/05/25' , nights = '1' , nationality = '106' , room_types = '2.1' , room_type='[{"numberOfAdults":2,"numberOfChild":1,"ChildAge":"3"}]' , available='0' , create_date = '2024-05-21 13:00:29' , site_id = '' , country_code = '106' , city_code = '64440' , ratings = '1.0,2.0,3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[05/21/2024 01:00:30], [file name :-/efsdata/otrams/public_html/beta/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', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-05-21 01:00:30', '', '681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487', '1843');
[05/21/2024 01:00:30], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=localsystem&sessionid=681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487&xml_user_id=7857&request_no=0&local_hotel_code=4&#039;,&#039;7&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 13:00:30.604'
        , request_start_time = '0.036'
        , parsing_start_time = '0.015'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.200'
        , error_description = ' Unsupported operand types | 1 | /efsdata/otrams/public_html/beta/common/functions/site.func.php:984'
        , memory_used = '5497656'
        WHERE id = '554798';
[05/21/2024 01:00:30], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7857&sessionid=681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487',
        duration = '0.467',
        merge_duration = '0.003',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '16.68',
        system_load_5_min = '13.53',
        system_load_15_min = '13.01',
        system_memory_usage = '95.23',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1843') + '6449264',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1843';
[05/21/2024 01:00:41], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '23' , ip = '43.239.53.130' , city = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/24' , departure_date = '2024/05/25' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-05-21 13:00:41' , site_id = '' , country_code = '106' , city_code = '64440' , ratings = '1.0,2.0,3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[05/21/2024 01:00:42], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-05-21 01:00:42', '', '681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487', '1844');
[05/21/2024 01:00:42], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=localsystem&sessionid=681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487&xml_user_id=7857&request_no=0&local_hotel_code=4&#039;,&#039;7&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 13:00:42.87'
        , request_start_time = '0.028'
        , parsing_start_time = '0.026'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.163'
        , error_description = ' Unsupported operand types | 1 | /efsdata/otrams/public_html/beta/common/functions/site.func.php:984'
        , memory_used = '5520688'
        WHERE id = '554799';
[05/21/2024 01:00:42], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7857&sessionid=681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487',
        duration = '0.269',
        merge_duration = '0.003',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '21.16',
        system_load_5_min = '14.55',
        system_load_15_min = '13.35',
        system_memory_usage = '95.93',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1844') + '6448424',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1844';
[05/21/2024 01:01:28], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],update room_rates set  availability='2', consumed_inventory='0', time_limit='24' where supplier_id='S000000001' AND hotel_id='7' AND inventory_class_id='2'  AND date_from >='2024-05-21' AND date_from <='2024-06-20' AND FIND_IN_SET(LEFT(DAYNAME(date_from),2),'Sa,Su')='0';
[05/21/2024 01:01:28], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],update room_rates set  availability='2', consumed_inventory='0', time_limit='24' where supplier_id='S000000001' AND hotel_id='7' AND inventory_class_id='2'  AND date_from >='2024-05-21' AND date_from <='2024-06-20' AND FIND_IN_SET(LEFT(DAYNAME(date_from),2),'Sa,Su')>'0';
[05/21/2024 01:01:28], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into `user_logs` set  `create_date`= '2024-05-21 13:01:28',`log_type`= 'Inventory Allocation and Release Period',`sql_query`= 'update room_rates set  availability=\&#039;2\&#039;, consumed_inventory=\&#039;0\&#039;, time_limit=\&#039;24\&#039; where supplier_id=\&#039;S000000001\&#039; AND hotel_id=\&#039;7\&#039; AND inventory_class_id=\&#039;2\&#039;  AND date_from &gt;=\&#039;2024-05-21\&#039; AND date_from &lt;=\&#039;2024-06-20\&#039; AND FIND_IN_SET(LEFT(DAYNAME(date_from),2),\&#039;Sa,Su\&#039;)=\&#039;0\&#039;&lt;br&gt;update room_rates set  availability=\&#039;2\&#039;, consumed_inventory=\&#039;0\&#039;, time_limit=\&#039;24\&#039; where supplier_id=\&#039;S000000001\&#039; AND hotel_id=\&#039;7\&#039; AND inventory_class_id=\&#039;2\&#039;  AND date_from &gt;=\&#039;2024-05-21\&#039; AND date_from &lt;=\&#039;2024-06-20\&#039; AND FIND_IN_SET(LEFT(DAYNAME(date_from),2),\&#039;Sa,Su\&#039;)&gt;\&#039;0\&#039;',`log_description`= 'Upadated Inventory Allocation and Release Period For hotel qtech_test- Inventory:-Standard From:-21-05-2024 To:-20-06-2024 Weekday Inventory Allocation:-2 Weekend Inventory Allocation:-2 Weekday Release Period:-24 Weekend Release Period:-24',`ip`= '43.239.53.130',`username`= 'v3alpha',`user_id`= 'S000000001';
[05/21/2024 01:01:28], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3396', `entity`='Hotels', `value`='7' ;
[05/21/2024 01:01:28], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3396', `entity`='Suppliers', `value`='S000000001' ;
[05/21/2024 01:01:28], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3396', `entity`='Inventory', `value`='2' ;
[05/21/2024 01:01:56], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '23' , ip = '43.239.53.130' , city = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/24' , departure_date = '2024/05/25' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-05-21 13:01:56' , site_id = '' , country_code = '106' , city_code = '64440' , ratings = '1.0,2.0,3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[05/21/2024 01:01:57], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-05-21 01:01:57', '', '681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487', '1845');
[05/21/2024 01:01:57], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=localsystem&sessionid=681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487&xml_user_id=7857&request_no=0&local_hotel_code=4&#039;,&#039;7&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 13:01:57.641'
        , request_start_time = '0.027'
        , parsing_start_time = '0.021'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.140'
        , error_description = ' Unsupported operand types | 1 | /efsdata/otrams/public_html/beta/common/functions/site.func.php:984'
        , memory_used = '5520688'
        WHERE id = '554800';
[05/21/2024 01:01:57], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7857&sessionid=681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487',
        duration = '0.296',
        merge_duration = '0.002',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '6.70',
        system_load_5_min = '11.59',
        system_load_15_min = '12.41',
        system_memory_usage = '95.57',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1845') + '6448424',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1845';
[05/21/2024 01:02:13], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[05/21/2024 01:02:13], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '67' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/21/2024 01:02:13], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '52' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/21/2024 01:02:13], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '80' ,status = '' ,priority = '7' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/21/2024 01:02:13], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '76' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/21/2024 01:02:13], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '24' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/21/2024 01:02:13], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '77' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/21/2024 01:02:13], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '64' ,status = '' ,priority = '12' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/21/2024 01:02:13], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '65' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/21/2024 01:02:13], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '34' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/21/2024 01:02:13], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '20' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/21/2024 01:02:13], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '55' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/21/2024 01:02:13], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '62' ,status = '1' ,priority = '8' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '8';
[05/21/2024 01:02:13], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '53' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/21/2024 01:02:13], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '16' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/21/2024 01:02:13], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '81' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/21/2024 01:02:13], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '78' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/21/2024 01:02:13], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '75' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/21/2024 01:02:13], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '60' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/21/2024 01:02:13], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '18' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/21/2024 01:02:13], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '19' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/21/2024 01:02:13], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '73' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/21/2024 01:02:13], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '71' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/21/2024 01:02:13], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '69' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/21/2024 01:02:13], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '68' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/21/2024 01:02:13], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '74' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/21/2024 01:02:13], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '35' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/21/2024 01:02:13], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '70' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/21/2024 01:02:13], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '59' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/21/2024 01:02:13], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '32' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/21/2024 01:02:13], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '58' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/21/2024 01:02:13], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '56' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/21/2024 01:02:13], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '57' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/21/2024 01:02:13], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '61' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/21/2024 01:02:13], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '63' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/21/2024 01:02:13], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '54' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/21/2024 01:02:13], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '45' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/21/2024 01:02:13], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'v3alpha',`create_date`= '2024-05-21 13:02:13',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 67 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 52 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 80 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 76 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 24 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 77 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 64 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 65 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 34 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 20 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 55 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 62 ,status = \&#039;1\&#039; ,priority = \&#039;8\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;8\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 53 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 16 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 81 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 78 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 75 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 60 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 18 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 19 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 73 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 71 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 69 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 68 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 74 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 35 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 70 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 59 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 32 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 58 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 56 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 57 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 61 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 63 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 54 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 45 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;',`log_description`= 'Supplier setting updated  Previous data-- agent_id-7857 ## supplier_id- 62 ## company_name - local_system ## supplier_code-localsystem  ## percentage - 0.00 ## lead_time - 0 ',`ip`= '43.239.53.130';
[05/21/2024 01:02:23], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '23' , ip = '43.239.53.130' , city = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/28' , departure_date = '2024/05/29' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-05-21 13:02:23' , site_id = '' , country_code = '106' , city_code = '64440' , ratings = '1.0,2.0,3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[05/21/2024 01:02:24], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-05-21 01:02:24', '', '681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487', '1846');
[05/21/2024 01:02:24], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=localsystem&sessionid=681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487&xml_user_id=7857&request_no=0&local_hotel_code=4&#039;,&#039;7&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 13:02:24.540'
        , request_start_time = '0.040'
        , parsing_start_time = '0.020'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.245'
        , error_description = ' Unsupported operand types | 1 | /efsdata/otrams/public_html/beta/common/functions/site.func.php:984'
        , memory_used = '5520688'
        WHERE id = '554801';
[05/21/2024 01:02:24], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7857&sessionid=681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487',
        duration = '0.421',
        merge_duration = '0.002',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '4.47',
        system_load_5_min = '10.67',
        system_load_15_min = '12.09',
        system_memory_usage = '95.80',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1846') + '6448424',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1846';
[05/21/2024 01:03:48], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '23' , ip = '43.239.53.130' , city = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/06/05' , departure_date = '2024/06/06' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-05-21 13:03:48' , site_id = '' , country_code = '106' , city_code = '64440' , ratings = '1.0,2.0,3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[05/21/2024 01:03:49], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-05-21 01:03:49', '', '681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487', '1847');
[05/21/2024 01:03:49], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=localsystem&sessionid=681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487&xml_user_id=7857&request_no=0&local_hotel_code=4&#039;,&#039;7&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 13:03:49.782'
        , request_start_time = '0.031'
        , parsing_start_time = '0.021'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.108'
        , error_description = ' Unsupported operand types | 1 | /efsdata/otrams/public_html/beta/common/functions/site.func.php:984'
        , memory_used = '5521064'
        WHERE id = '554802';
[05/21/2024 01:03:49], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7857&sessionid=681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487',
        duration = '0.281',
        merge_duration = '0.002',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '20.17',
        system_load_5_min = '13.64',
        system_load_15_min = '12.96',
        system_memory_usage = '95.61',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1847') + '6448312',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1847';
[05/21/2024 01:05:43], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],DELETE FROM localsystem_cancellation_policy WHERE hotel_id='7' AND supplier_id='S000000001' AND cancellation_policy_id IN (3);;
[05/21/2024 01:05:43], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into `user_logs` set  `create_date`= '2024-05-21 13:05:43',`log_type`= 'Cancellation Policy',`sql_query`= 'DELETE FROM localsystem_cancellation_policy WHERE \&#039;7\&#039;=\&#039;7\&#039; AND \&#039;S000000001\&#039;=\&#039;S000000001\&#039; AND cancellation_policy_id IN (3);',`log_description`= 'Cancellation Policy of qtech_test from 2024-05-31 to 2024-05-31 deleted by User : v3alpha',`ip`= '43.239.53.130',`username`= 'v3alpha',`user_id`= 'S000000001';
[05/21/2024 01:05:43], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3398', `entity`='Hotels', `value`='7' ;
[05/21/2024 01:05:43], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3398', `entity`='Suppliers', `value`='S000000001' ;
[05/21/2024 01:05:48], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '23' , ip = '43.239.53.130' , city = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/06/05' , departure_date = '2024/06/06' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-05-21 13:05:48' , site_id = '' , country_code = '106' , city_code = '64440' , ratings = '1.0,2.0,3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[05/21/2024 01:05:49], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-05-21 01:05:49', '', '681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487', '1848');
[05/21/2024 01:05:49], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=localsystem&sessionid=681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487&xml_user_id=7857&request_no=0&local_hotel_code=4&#039;,&#039;7&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 13:05:49.475'
        , request_start_time = '0.035'
        , parsing_start_time = '0.022'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.236'
        , error_description = ' Unsupported operand types | 1 | /efsdata/otrams/public_html/beta/common/functions/site.func.php:984'
        , memory_used = '5520568'
        WHERE id = '554803';
[05/21/2024 01:05:49], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7857&sessionid=681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487',
        duration = '0.406',
        merge_duration = '0.002',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '10.95',
        system_load_5_min = '13.50',
        system_load_15_min = '13.07',
        system_memory_usage = '93.86',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1848') + '6448312',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1848';
[05/21/2024 01:06:25], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[05/21/2024 01:06:25], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '67' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/21/2024 01:06:25], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '52' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/21/2024 01:06:25], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '80' ,status = '' ,priority = '7' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/21/2024 01:06:25], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '76' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/21/2024 01:06:25], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '24' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/21/2024 01:06:25], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '77' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/21/2024 01:06:25], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '64' ,status = '' ,priority = '12' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/21/2024 01:06:25], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '65' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/21/2024 01:06:25], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '34' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/21/2024 01:06:25], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '20' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/21/2024 01:06:25], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '55' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/21/2024 01:06:25], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '62' ,status = '1' ,priority = '8' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '8';
[05/21/2024 01:06:25], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '53' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/21/2024 01:06:25], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '16' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/21/2024 01:06:25], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '81' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/21/2024 01:06:25], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '78' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/21/2024 01:06:26], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '75' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/21/2024 01:06:26], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '60' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/21/2024 01:06:26], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '18' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/21/2024 01:06:26], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '19' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/21/2024 01:06:26], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '73' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/21/2024 01:06:26], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '71' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/21/2024 01:06:26], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '69' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/21/2024 01:06:26], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '68' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/21/2024 01:06:26], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '74' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/21/2024 01:06:26], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '35' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/21/2024 01:06:26], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '70' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/21/2024 01:06:26], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '59' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/21/2024 01:06:26], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '32' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/21/2024 01:06:26], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '58' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/21/2024 01:06:26], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '56' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/21/2024 01:06:26], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '57' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/21/2024 01:06:26], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '61' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/21/2024 01:06:26], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '63' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/21/2024 01:06:26], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '54' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/21/2024 01:06:26], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '45' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/21/2024 01:06:26], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'v3alpha',`create_date`= '2024-05-21 13:06:26',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 67 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 52 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 80 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 76 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 24 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 77 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 64 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 65 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 34 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 20 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 55 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 62 ,status = \&#039;1\&#039; ,priority = \&#039;8\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;8\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 53 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 16 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 81 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 78 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 75 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 60 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 18 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 19 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 73 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 71 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 69 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 68 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 74 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 35 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 70 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 59 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 32 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 58 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 56 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 57 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 61 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 63 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 54 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 45 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;',`log_description`= 'Supplier setting updated  Previous data-- agent_id-7857 ## supplier_id- 62 ## company_name - local_system ## supplier_code-localsystem  ## percentage - 0.00 ## lead_time - 0 ',`ip`= '43.239.53.130';
[05/21/2024 01:06:32], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-05-21 01:06:32',login_attempt=0 where id = '7857';
[05/21/2024 01:06:32], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Deepak_T', user_type = 'A', branch_id = '23', login_datetime = '2024-05-21 13:06:32', ip = '43.239.53.130', action = 'Login' ;
[05/21/2024 01:06:59], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '23' , ip = '43.239.53.130' , city = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/30' , departure_date = '2024/05/31' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-05-21 13:06:59' , site_id = '' , country_code = '106' , city_code = '64440' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[05/21/2024 01:07: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', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-05-21 01:07:00', '', '681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487', '1849');
[05/21/2024 01:07:00], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=localsystem&sessionid=681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487&xml_user_id=7857&request_no=0&local_hotel_code=4&#039;,&#039;7&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 13:07:00.616'
        , request_start_time = '0.033'
        , parsing_start_time = '0.020'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.324'
        , error_description = ' Unsupported operand types | 1 | /efsdata/otrams/public_html/beta/common/functions/site.func.php:984'
        , memory_used = '5520096'
        WHERE id = '554804';
[05/21/2024 01:07:00], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7857&sessionid=681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487',
        duration = '0.485',
        merge_duration = '0.001',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '20.67',
        system_load_5_min = '15.42',
        system_load_15_min = '13.73',
        system_memory_usage = '94.23',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1849') + '6448520',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1849';
[05/21/2024 01:07:08], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '23' , ip = '43.239.53.130' , city = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/30' , departure_date = '2024/05/31' , nights = '1' , nationality = '106' , room_types = '3' , room_type='[{"numberOfAdults":3}]' , available='0' , create_date = '2024-05-21 13:07:08' , site_id = '' , country_code = '106' , city_code = '64440' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[05/21/2024 01:07:09], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-05-21 01:07:09', '', '681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487', '1850');
[05/21/2024 01:07:09], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=localsystem&sessionid=681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487&xml_user_id=7857&request_no=0&local_hotel_code=4&#039;,&#039;7&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 13:07:09.73'
        , request_start_time = '0.031'
        , parsing_start_time = '0.014'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.116'
        , error_description = ' Unsupported operand types | 1 | /efsdata/otrams/public_html/beta/common/functions/site.func.php:984'
        , memory_used = '5496544'
        WHERE id = '554805';
[05/21/2024 01:07:09], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7857&sessionid=681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487',
        duration = '0.268',
        merge_duration = '0.002',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '17.57',
        system_load_5_min = '14.92',
        system_load_15_min = '13.59',
        system_memory_usage = '94.43',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1850') + '6448280',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1850';
[05/21/2024 01:07:20], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '23' , ip = '43.239.53.130' , city = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/30' , departure_date = '2024/05/31' , nights = '1' , nationality = '106' , room_types = '3.1' , room_type='[{"numberOfAdults":3,"numberOfChild":1}]' , available='0' , create_date = '2024-05-21 13:07:20' , site_id = '' , country_code = '106' , city_code = '64440' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[05/21/2024 01:07:21], [file name :-/efsdata/otrams/public_html/beta/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', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-05-21 01:07:21', '', '681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487', '1851');
[05/21/2024 01:07:22], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=localsystem&sessionid=681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487&xml_user_id=7857&request_no=0&local_hotel_code=4&#039;,&#039;7&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 13:07:21.900'
        , request_start_time = '0.040'
        , parsing_start_time = '0.010'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.122'
        , error_description = ' Unsupported operand types | 1 | /efsdata/otrams/public_html/beta/common/functions/site.func.php:984'
        , memory_used = '5492904'
        WHERE id = '554806';
[05/21/2024 01:07:22], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7857&sessionid=681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487',
        duration = '0.248',
        merge_duration = '0.002',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '15.32',
        system_load_5_min = '14.53',
        system_load_15_min = '13.47',
        system_memory_usage = '94.40',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1851') + '6448416',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1851';
[05/21/2024 01:07:29], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '23' , ip = '43.239.53.130' , city = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/30' , departure_date = '2024/05/31' , nights = '1' , nationality = '106' , room_types = '3.1' , room_type='[{"numberOfAdults":3,"numberOfChild":1,"ChildAge":"3"}]' , available='0' , create_date = '2024-05-21 13:07:29' , site_id = '' , country_code = '106' , city_code = '64440' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[05/21/2024 01:07:30], [file name :-/efsdata/otrams/public_html/beta/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', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-05-21 01:07:30', '', '681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487', '1852');
[05/21/2024 01:07:30], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=localsystem&sessionid=681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487&xml_user_id=7857&request_no=0&local_hotel_code=4&#039;,&#039;7&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 13:07:30.436'
        , request_start_time = '0.030'
        , parsing_start_time = '0.011'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.108'
        , error_description = ' Unsupported operand types | 1 | /efsdata/otrams/public_html/beta/common/functions/site.func.php:984'
        , memory_used = '5516424'
        WHERE id = '554807';
[05/21/2024 01:07:30], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7857&sessionid=681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487',
        duration = '0.261',
        merge_duration = '0.001',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '13.28',
        system_load_5_min = '14.12',
        system_load_15_min = '13.35',
        system_memory_usage = '94.48',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1852') + '6448856',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1852';
[05/21/2024 01:11:57], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],DELETE FROM hotel_room_class_mapping WHERE hotel_id='7' AND supplier_id='S000000001';
[05/21/2024 01:11:57], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT into hotel_room_class_mapping SET hotel_id='7', supplier_id='S000000001', class_id='6';
[05/21/2024 01:11:57], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into `user_logs` set  `create_date`= '2024-05-21 13:11:57',`log_type`= 'Hotel Room Class Mapping',`sql_query`= 'INSERT into hotel_room_class_mapping SET hotel_id=\&#039;7\&#039;, supplier_id=\&#039;S000000001\&#039;, class_id=\&#039;6\&#039;',`log_description`= 'Hotel Room Class Mapping for hotel qtech_testRoom Category :-Double, Max Pax - 3, Extrabed - 1',`ip`= '43.239.53.130',`username`= 'v3alpha',`user_id`= 'S000000001';
[05/21/2024 01:11:57], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3400', `entity`='Suppliers', `value`='S000000001' ;
[05/21/2024 01:11:57], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3400', `entity`='Roomclass', `value`='6' ;
[05/21/2024 01:14:55], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '23' , ip = '43.239.53.130' , city = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/30' , departure_date = '2024/05/31' , nights = '1' , nationality = '106' , room_types = '3.1' , room_type='[{"numberOfAdults":3,"numberOfChild":1,"ChildAge":"3"}]' , available='0' , create_date = '2024-05-21 13:14:55' , site_id = '' , country_code = '106' , city_code = '64440' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[05/21/2024 01:14:57], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-05-21 01:14:57', '', '681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487', '1853');
[05/21/2024 01:14:57], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=localsystem&sessionid=681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487&xml_user_id=7857&request_no=0&local_hotel_code=4&#039;,&#039;7&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 13:14:56.938'
        , request_start_time = '0.038'
        , parsing_start_time = '0.049'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.210'
        , error_description = ' Unsupported operand types | 1 | /efsdata/otrams/public_html/beta/common/functions/site.func.php:984'
        , memory_used = '2856632'
        WHERE id = '554808';
[05/21/2024 01:14:57], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7857&sessionid=681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487',
        duration = '0.436',
        merge_duration = '0.002',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '5.86',
        system_load_5_min = '6.81',
        system_load_15_min = '9.95',
        system_memory_usage = '96.11',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1853') + '4136944',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1853';
[05/21/2024 01:21:37], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '23' , ip = '43.239.53.130' , city = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/30' , departure_date = '2024/05/31' , nights = '1' , nationality = '106' , room_types = '3.1' , room_type='[{"numberOfAdults":3,"numberOfChild":1,"ChildAge":"3"}]' , available='0' , create_date = '2024-05-21 13:21:37' , site_id = '' , country_code = '106' , city_code = '64440' , ratings = '1.0,2.0,3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[05/21/2024 01:21:39], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-05-21 01:21:39', '', '681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487', '1854');
[05/21/2024 01:21:39], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=localsystem&sessionid=681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487&xml_user_id=7857&request_no=0&local_hotel_code=4&#039;,&#039;7&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 13:21:38.879'
        , request_start_time = '0.021'
        , parsing_start_time = '0.012'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.151'
        , error_description = ' Unsupported operand types | 1 | /efsdata/otrams/public_html/beta/common/functions/site.func.php:984'
        , memory_used = '1912920'
        WHERE id = '554809';
[05/21/2024 01:21:39], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7857&sessionid=681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487',
        duration = '0.241',
        merge_duration = '0.002',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '5.04',
        system_load_5_min = '8.56',
        system_load_15_min = '9.65',
        system_memory_usage = '96.93',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1854') + '2030352',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1854';
[05/21/2024 01:30:26], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '23' , ip = '43.239.53.130' , city = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/30' , departure_date = '2024/05/31' , nights = '1' , nationality = '106' , room_types = '3.1' , room_type='[{"numberOfAdults":3,"numberOfChild":1,"ChildAge":"3"}]' , available='0' , create_date = '2024-05-21 13:30:26' , site_id = '' , country_code = '106' , city_code = '64440' , ratings = '1.0,2.0,3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[05/21/2024 01:30:27], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-05-21 01:30:27', '', '681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487', '1855');
[05/21/2024 01:30:27], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=localsystem&sessionid=681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487&xml_user_id=7857&request_no=0&local_hotel_code=4&#039;,&#039;7&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 13:30:27.469'
        , request_start_time = '0.026'
        , parsing_start_time = '0.014'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.103'
        , error_description = ' Unsupported operand types | 1 | /efsdata/otrams/public_html/beta/common/functions/site.func.php:984'
        , memory_used = '1913904'
        WHERE id = '554810';
[05/21/2024 01:30:27], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7857&sessionid=681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487',
        duration = '0.264',
        merge_duration = '0.003',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '7.30',
        system_load_5_min = '21.19',
        system_load_15_min = '16.51',
        system_memory_usage = '95.63',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1855') + '2030352',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1855';
[05/21/2024 01:30:39], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '23' , ip = '43.239.53.130' , city = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/29' , departure_date = '2024/05/30' , nights = '1' , nationality = '106' , room_types = '3' , room_type='[{"numberOfAdults":3}]' , available='0' , create_date = '2024-05-21 13:30:39' , site_id = '' , country_code = '106' , city_code = '64440' , ratings = '1.0,2.0,3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[05/21/2024 01:30:40], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-05-21 01:30:40', '', '681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487', '1856');
[05/21/2024 01:30:40], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=localsystem&sessionid=681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487&xml_user_id=7857&request_no=0&local_hotel_code=4&#039;,&#039;7&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 13:30:40.554'
        , request_start_time = '0.021'
        , parsing_start_time = '0.009'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.086'
        , error_description = ' Unsupported operand types | 1 | /efsdata/otrams/public_html/beta/common/functions/site.func.php:984'
        , memory_used = '1630864'
        WHERE id = '554811';
[05/21/2024 01:30:40], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7857&sessionid=681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487',
        duration = '0.224',
        merge_duration = '0.002',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '5.90',
        system_load_5_min = '20.20',
        system_load_15_min = '16.26',
        system_memory_usage = '95.51',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1856') + '2029360',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1856';
