150 Query SELECT isys_obj.*, isys_obj_type.*, isys_cmdb_status__color, isys_cmdb_status__title FROM isys_obj INNER JOIN isys_obj_type ON isys_obj__isys_obj_type__id = isys_obj_type__id INNER JOIN isys_cmdb_status ON isys_obj__isys_cmdb_status__id = isys_cmdb_status__id WHERE isys_obj__id = 23 LIMIT 1 150 Query SELECT * FROM isys_obj INNER JOIN isys_obj_type ON isys_obj_type__id = isys_obj__isys_obj_type__id WHERE isys_obj__id = 23 150 Query SELECT isysgui_catg_custom__list_multi_value FROM isysgui_catg_custom WHERE isysgui_catg_custom__id = 9 150 Query SELECT isysgui_catg_custom__const FROM isysgui_catg_custom WHERE isysgui_catg_custom__id = 9 150 Query SELECT * FROM isys_catg_custom_fields_list INNER JOIN isysgui_catg_custom ON isys_catg_custom_fields_list__isysgui_catg_custom__id = isysgui_catg_custom__id INNER JOIN isys_obj ON isys_catg_custom_fields_list__isys_obj__id = isys_obj__id LEFT JOIN isys_dialog_plus_custom ON isys_dialog_plus_custom__id = isys_catg_custom_fields_list__field_content WHERE TRUE AND (isys_obj.isys_obj__id = 23) AND (isys_catg_custom_fields_list__isysgui_catg_custom__id = '9') 150 Query SELECT * FROM isysgui_catg_custom WHERE TRUE AND isysgui_catg_custom__id = 9 150 Query SELECT MAX(DISTINCT(isys_catg_custom_fields_list__data__id)) AS last_id FROM isys_catg_custom_fields_list WHERE isys_catg_custom_fields_list__isysgui_catg_custom__id = 9 150 Query SELECT isys_catg_custom_fields_list__id FROM isys_catg_custom_fields_list WHERE isys_catg_custom_fields_list__isys_obj__id = 23 AND isys_catg_custom_fields_list__field_key = 'C__CMDB__CAT__COMMENTARY_49' AND isys_catg_custom_fields_list__data__id = 20766 150 Query INSERT INTO isys_catg_custom_fields_list SET isys_catg_custom_fields_list__isys_obj__id = 23, isys_catg_custom_fields_list__isysgui_catg_custom__id = 9, isys_catg_custom_fields_list__field_key = 'C__CMDB__CAT__COMMENTARY_49', isys_catg_custom_fields_list__field_content = '', isys_catg_custom_fields_list__field_type = 'commentary', isys_catg_custom_fields_list__status = 2, isys_catg_custom_fields_list__description = '', isys_catg_custom_fields_list__data__id = 20766 150 Query SET AUTOCOMMIT=0 150 Query COMMIT 150 Query SELECT LAST_INSERT_ID() as id 150 Query SELECT isys_catg_custom_fields_list__id FROM isys_catg_custom_fields_list WHERE isys_catg_custom_fields_list__isys_obj__id = 23 AND isys_catg_custom_fields_list__field_key = 'c_1501692823543' AND isys_catg_custom_fields_list__data__id = 20766 150 Query INSERT INTO isys_catg_custom_fields_list SET isys_catg_custom_fields_list__isys_obj__id = 23, isys_catg_custom_fields_list__isysgui_catg_custom__id = 9, isys_catg_custom_fields_list__field_key = 'c_1501692823543', isys_catg_custom_fields_list__field_content = '163589', isys_catg_custom_fields_list__field_type = 'f_popup', isys_catg_custom_fields_list__status = 2, isys_catg_custom_fields_list__description = '', isys_catg_custom_fields_list__data__id = 20766 150 Query SET AUTOCOMMIT=0 150 Query COMMIT 150 Query SELECT LAST_INSERT_ID() as id 150 Query UPDATE isys_catg_custom_fields_list SET isys_catg_custom_fields_list__isysgui_catg_custom__id = 9, isys_catg_custom_fields_list__field_key = 'c_1501692823543', isys_catg_custom_fields_list__field_content = '163589', isys_catg_custom_fields_list__field_type = 'f_popup', isys_catg_custom_fields_list__status = 2, isys_catg_custom_fields_list__description = '', isys_catg_custom_fields_list__data__id = 20766 WHERE isys_catg_custom_fields_list__isysgui_catg_custom__id = 9 AND isys_catg_custom_fields_list__field_key = 'c_1501692823543' AND isys_catg_custom_fields_list__data__id = 20766 150 Query SET AUTOCOMMIT=0 150 Query COMMIT 150 Query SELECT isys_catg_custom_fields_list__id FROM isys_catg_custom_fields_list WHERE isys_catg_custom_fields_list__isys_obj__id = 23 AND isys_catg_custom_fields_list__field_key = 'c_1501683324836' AND isys_catg_custom_fields_list__data__id = 20766 150 Query INSERT INTO isys_catg_custom_fields_list SET isys_catg_custom_fields_list__isys_obj__id = 23, isys_catg_custom_fields_list__isysgui_catg_custom__id = 9, isys_catg_custom_fields_list__field_key = 'c_1501683324836', isys_catg_custom_fields_list__field_content = 'CVS ACS', isys_catg_custom_fields_list__field_type = 'f_text', isys_catg_custom_fields_list__status = 2, isys_catg_custom_fields_list__description = '', isys_catg_custom_fields_list__data__id = 20766 150 Query SET AUTOCOMMIT=0 150 Query COMMIT 150 Query SELECT LAST_INSERT_ID() as id 150 Query UPDATE isys_catg_custom_fields_list SET isys_catg_custom_fields_list__isysgui_catg_custom__id = 9, isys_catg_custom_fields_list__field_key = 'c_1501683324836', isys_catg_custom_fields_list__field_content = 'CVS ACS', isys_catg_custom_fields_list__field_type = 'f_text', isys_catg_custom_fields_list__status = 2, isys_catg_custom_fields_list__description = '', isys_catg_custom_fields_list__data__id = 20766 WHERE isys_catg_custom_fields_list__isysgui_catg_custom__id = 9 AND isys_catg_custom_fields_list__field_key = 'c_1501683324836' AND isys_catg_custom_fields_list__data__id = 20766 150 Query SET AUTOCOMMIT=0 150 Query COMMIT 150 Query SELECT isys_catg_custom_fields_list__id FROM isys_catg_custom_fields_list WHERE isys_catg_custom_fields_list__isys_obj__id = 23 AND isys_catg_custom_fields_list__field_key = 'c_1501683371760' AND isys_catg_custom_fields_list__data__id = 20766 150 Query INSERT INTO isys_catg_custom_fields_list SET isys_catg_custom_fields_list__isys_obj__id = 23, isys_catg_custom_fields_list__isysgui_catg_custom__id = 9, isys_catg_custom_fields_list__field_key = 'c_1501683371760', isys_catg_custom_fields_list__field_content = 'RW', isys_catg_custom_fields_list__field_type = 'f_text', isys_catg_custom_fields_list__status = 2, isys_catg_custom_fields_list__description = '', isys_catg_custom_fields_list__data__id = 20766 150 Query SET AUTOCOMMIT=0 150 Query COMMIT 150 Query SELECT LAST_INSERT_ID() as id 150 Query UPDATE isys_catg_custom_fields_list SET isys_catg_custom_fields_list__isysgui_catg_custom__id = 9, isys_catg_custom_fields_list__field_key = 'c_1501683371760', isys_catg_custom_fields_list__field_content = 'RW', isys_catg_custom_fields_list__field_type = 'f_text', isys_catg_custom_fields_list__status = 2, isys_catg_custom_fields_list__description = '', isys_catg_custom_fields_list__data__id = 20766 WHERE isys_catg_custom_fields_list__isysgui_catg_custom__id = 9 AND isys_catg_custom_fields_list__field_key = 'c_1501683371760' AND isys_catg_custom_fields_list__data__id = 20766 150 Query SET AUTOCOMMIT=0 150 Query COMMIT 150 Query SELECT isys_catg_custom_fields_list__id FROM isys_catg_custom_fields_list WHERE isys_catg_custom_fields_list__isys_obj__id = 23 AND isys_catg_custom_fields_list__field_key = 'c_1501683444012' AND isys_catg_custom_fields_list__data__id = 20766 150 Query INSERT INTO isys_catg_custom_fields_list SET isys_catg_custom_fields_list__isys_obj__id = 23, isys_catg_custom_fields_list__isysgui_catg_custom__id = 9, isys_catg_custom_fields_list__field_key = 'c_1501683444012', isys_catg_custom_fields_list__field_content = '/here', isys_catg_custom_fields_list__field_type = 'f_text', isys_catg_custom_fields_list__status = 2, isys_catg_custom_fields_list__description = '', isys_catg_custom_fields_list__data__id = 20766 150 Query SET AUTOCOMMIT=0 150 Query COMMIT 150 Query SELECT LAST_INSERT_ID() as id 150 Query UPDATE isys_catg_custom_fields_list SET isys_catg_custom_fields_list__isysgui_catg_custom__id = 9, isys_catg_custom_fields_list__field_key = 'c_1501683444012', isys_catg_custom_fields_list__field_content = '/here', isys_catg_custom_fields_list__field_type = 'f_text', isys_catg_custom_fields_list__status = 2, isys_catg_custom_fields_list__description = '', isys_catg_custom_fields_list__data__id = 20766 WHERE isys_catg_custom_fields_list__isysgui_catg_custom__id = 9 AND isys_catg_custom_fields_list__field_key = 'c_1501683444012' AND isys_catg_custom_fields_list__data__id = 20766 150 Query SET AUTOCOMMIT=0 150 Query COMMIT 150 Query SELECT isys_catg_custom_fields_list__id FROM isys_catg_custom_fields_list WHERE isys_catg_custom_fields_list__isys_obj__id = 23 AND isys_catg_custom_fields_list__field_key = 'c_1501683480114' AND isys_catg_custom_fields_list__data__id = 20766 150 Query INSERT INTO isys_catg_custom_fields_list SET isys_catg_custom_fields_list__isys_obj__id = 23, isys_catg_custom_fields_list__isysgui_catg_custom__id = 9, isys_catg_custom_fields_list__field_key = 'c_1501683480114', isys_catg_custom_fields_list__field_content = '172.22.11.10', isys_catg_custom_fields_list__field_type = 'f_text', isys_catg_custom_fields_list__status = 2, isys_catg_custom_fields_list__description = '', isys_catg_custom_fields_list__data__id = 20766 150 Query SET AUTOCOMMIT=0 150 Query COMMIT 150 Query SELECT LAST_INSERT_ID() as id 150 Query UPDATE isys_catg_custom_fields_list SET isys_catg_custom_fields_list__isysgui_catg_custom__id = 9, isys_catg_custom_fields_list__field_key = 'c_1501683480114', isys_catg_custom_fields_list__field_content = '172.22.11.10', isys_catg_custom_fields_list__field_type = 'f_text', isys_catg_custom_fields_list__status = 2, isys_catg_custom_fields_list__description = '', isys_catg_custom_fields_list__data__id = 20766 WHERE isys_catg_custom_fields_list__isysgui_catg_custom__id = 9 AND isys_catg_custom_fields_list__field_key = 'c_1501683480114' AND isys_catg_custom_fields_list__data__id = 20766 150 Query SET AUTOCOMMIT=0 150 Query COMMIT 150 Query SELECT isys_catg_custom_fields_list__id FROM isys_catg_custom_fields_list WHERE isys_catg_custom_fields_list__isys_obj__id = 23 AND isys_catg_custom_fields_list__field_key = 'c_1501683447293' AND isys_catg_custom_fields_list__data__id = 20766 150 Query INSERT INTO isys_catg_custom_fields_list SET isys_catg_custom_fields_list__isys_obj__id = 23, isys_catg_custom_fields_list__isysgui_catg_custom__id = 9, isys_catg_custom_fields_list__field_key = 'c_1501683447293', isys_catg_custom_fields_list__field_content = 'comment', isys_catg_custom_fields_list__field_type = 'f_text', isys_catg_custom_fields_list__status = 2, isys_catg_custom_fields_list__description = '', isys_catg_custom_fields_list__data__id = 20766 150 Query SET AUTOCOMMIT=0 150 Query COMMIT 150 Query SELECT LAST_INSERT_ID() as id 150 Query UPDATE isys_catg_custom_fields_list SET isys_catg_custom_fields_list__isysgui_catg_custom__id = 9, isys_catg_custom_fields_list__field_key = 'c_1501683447293', isys_catg_custom_fields_list__field_content = 'comment', isys_catg_custom_fields_list__field_type = 'f_text', isys_catg_custom_fields_list__status = 2, isys_catg_custom_fields_list__description = '', isys_catg_custom_fields_list__data__id = 20766 WHERE isys_catg_custom_fields_list__isysgui_catg_custom__id = 9 AND isys_catg_custom_fields_list__field_key = 'c_1501683447293' AND isys_catg_custom_fields_list__data__id = 20766 150 Query SET AUTOCOMMIT=0 150 Query COMMIT 150 Query SELECT isys_obj.*, isys_obj_type.*, isys_cmdb_status__color, isys_cmdb_status__title FROM isys_obj INNER JOIN isys_obj_type ON isys_obj__isys_obj_type__id = isys_obj_type__id INNER JOIN isys_cmdb_status ON isys_obj__isys_cmdb_status__id = isys_cmdb_status__id WHERE isys_obj__id = 163590 LIMIT 1 150 Query SELECT * FROM isys_obj INNER JOIN isys_obj_type ON isys_obj_type__id = isys_obj__isys_obj_type__id WHERE isys_obj__id = 163590 150 Query SELECT * FROM isys_obj_type WHERE TRUE AND isys_obj_type__id = 123 150 Query SELECT isys_obj.*, isys_obj_type.*, isys_cmdb_status__color, isys_cmdb_status__title FROM isys_obj INNER JOIN isys_obj_type ON isys_obj__isys_obj_type__id = isys_obj_type__id INNER JOIN isys_cmdb_status ON isys_obj__isys_cmdb_status__id = isys_cmdb_status__id WHERE isys_obj__id = 163589 LIMIT 1 150 Query SELECT * FROM isys_obj INNER JOIN isys_obj_type ON isys_obj_type__id = isys_obj__isys_obj_type__id WHERE isys_obj__id = 163589 150 Query SELECT * FROM isys_obj INNER JOIN isys_obj_type ON isys_obj_type__id = isys_obj__isys_obj_type__id WHERE isys_obj__id = 23 150 Query SELECT isys_obj__title FROM isys_obj WHERE isys_obj__id = 23 150 Query SELECT * FROM isys_obj_type 150 Query SELECT * FROM isys_logbook_configuration 150 Query SELECT *, isys_catg_mail_addresses_list__title AS isys_cats_person_list__mail_address FROM isys_cats_person_list LEFT JOIN isys_catg_mail_addresses_list ON isys_catg_mail_addresses_list__isys_obj__id = isys_cats_person_list__isys_obj__id AND isys_catg_mail_addresses_list__primary = 1 WHERE TRUE AND isys_cats_person_list__isys_obj__id = 9 150 Query SET AUTOCOMMIT=0 150 Query BEGIN 150 Query INSERT INTO isys_logbook SET isys_logbook__user_name_static = 'admin admin', isys_logbook__isys_obj__id = 9, isys_logbook__isys_logbook_level__id = 1, isys_logbook__status = 2, isys_logbook__isys_logbook_reason__id = NULL, isys_logbook__entry_identifier_static = '', isys_logbook__changecount = 0, isys_logbook__property = NULL, isys_logbook__description = NULL, isys_logbook__isys_logbook_source__id = 1, isys_logbook__date = '2017-08-05 11:40:16', isys_logbook__event_static = 'C__LOGBOOK_EVENT__CATEGORY_CHANGED', isys_logbook__obj_name_static = 'Armin', isys_logbook__category_static = 'Repository Access List', isys_logbook__comment = '', isys_logbook__changes = 'a:6:{s:63:\"isys_cmdb_dao_category_g_custom_fields::f_popup_c_1501692823543\";a:2:{s:4:\"from\";s:18:\"Repos 00001-keeper\";s:2:\"to\";s:19:\"Repos 00000-holding\";}s:62:\"isys_cmdb_dao_category_g_custom_fields::f_text_c_1501683324836\";a:2:{s:4:\"from\";s:14:\"Projectarchive\";s:2:\"to\";s:7:\"CVS ACS\";}s:62:\"isys_cmdb_dao_category_g_custom_fields::f_text_c_1501683371760\";a:2:{s:4:\"from\";s:10:\"read-write\";s:2:\"to\";s:2:\"RW\";}s:62:\"isys_cmdb_dao_category_g_custom_fields::f_text_c_1501683444012\";a:2:{s:4:\"from\";s:0:\"\";s:2:\"to\";s:5:\"/here\";}s:62:\"isys_cmdb_dao_category_g_custom_fields::f_text_c_1501683480114\";a:2:{s:4:\"from\";s:0:\"\";s:2:\"to\";s:12:\"172.22.11.10\";}s:62:\"isys_cmdb_dao_category_g_custom_fields::f_text_c_1501683447293\";a:2:{s:4:\"from\";s:0:\"\";s:2:\"to\";s:7:\"comment\";}}', isys_logbook__obj_type_static = 'LC__CONTACT__TREE__PERSON' 150 Query SELECT LAST_INSERT_ID() as id 150 Query INSERT INTO isys_catg_logb_list SET isys_catg_logb_list__isys_obj__id = 23, isys_catg_logb_list__isys_logbook__id = (SELECT LAST_INSERT_ID()), isys_catg_logb_list__status = 2 150 Query SET AUTOCOMMIT=0 150 Query COMMIT 150 Query REPLACE INTO isys_search_idx (isys_search_idx__version, isys_search_idx__type, isys_search_idx__key, isys_search_idx__value, isys_search_idx__reference) SELECT 1, 'cmdb', CONCAT(isys_obj__isys_obj_type__id, '.custom_fields.', isys_catg_custom_fields_list__data__id, '.', REPLACE(isysgui_catg_custom__title, '.', '_'), '.', isysgui_catg_custom__id, '.', isys_catg_custom_fields_list__field_key), isys_catg_custom_fields_list__field_content, isys_obj__id FROM isys_catg_custom_fields_list INNER JOIN isys_obj ON isys_catg_custom_fields_list__isys_obj__id = isys_obj__id INNER JOIN isysgui_catg_custom ON isys_catg_custom_fields_list__isysgui_catg_custom__id = isysgui_catg_custom__id WHERE isys_catg_custom_fields_list__field_type IN ('f_text', 'f_textarea', 'f_link') AND isys_catg_custom_fields_list__isysgui_catg_custom__id = 9 170805 11:40:18 150 Query SELECT 1, 'cmdb', CONCAT(isys_obj__isys_obj_type__id, '.custom_fields.', isys_catg_custom_fields_list__data__id, '.', REPLACE(isysgui_catg_custom__title, '.', '_'), '.', isysgui_catg_custom__id, '.', isys_catg_custom_fields_list__field_key), isys_catg_custom_fields_list__field_content, isys_obj__id FROM isys_catg_custom_fields_list INNER JOIN isys_obj ON isys_catg_custom_fields_list__isys_obj__id = isys_obj__id INNER JOIN isysgui_catg_custom ON isys_catg_custom_fields_list__isysgui_catg_custom__id = isysgui_catg_custom__id WHERE isys_catg_custom_fields_list__field_type IN ('f_wysiwyg') AND isys_catg_custom_fields_list__isysgui_catg_custom__id = 9 150 Query REPLACE INTO isys_search_idx (isys_search_idx__version, isys_search_idx__type, isys_search_idx__key, isys_search_idx__value, isys_search_idx__reference) SELECT 1, 'cmdb', CONCAT(isys_obj__isys_obj_type__id, '.custom_fields.', isys_catg_custom_fields_list__data__id, '.', REPLACE(isysgui_catg_custom__title, '.', '_'), '.', isysgui_catg_custom__id, '.', isys_catg_custom_fields_list__field_key), isys_dialog_plus_custom__title, isys_obj__id FROM isys_catg_custom_fields_list INNER JOIN isys_obj ON isys_catg_custom_fields_list__isys_obj__id = isys_obj__id INNER JOIN isysgui_catg_custom ON isys_catg_custom_fields_list__isysgui_catg_custom__id = isysgui_catg_custom__id INNER JOIN isys_dialog_plus_custom ON isys_dialog_plus_custom__id = isys_catg_custom_fields_list__field_content WHERE isys_catg_custom_fields_list__field_type = 'f_popup' AND isys_catg_custom_fields_list__isysgui_catg_custom__id = 9 150 Query SELECT isysgui_catg__id, isysgui_catg__title, isysgui_catg__const, isysgui_catg__source_table, isysgui_catg__class_name, isysgui_catg__list_multi_value, isysgui_catg__parent FROM isysgui_catg WHERE TRUE AND isysgui_catg__id='9' AND isysgui_catg__status = 2 150 Query SELECT isys_obj.*, isys_obj_type.*, isys_cmdb_status__color, isys_cmdb_status__title FROM isys_obj INNER JOIN isys_obj_type ON isys_obj__isys_obj_type__id = isys_obj_type__id INNER JOIN isys_cmdb_status ON isys_obj__isys_cmdb_status__id = isys_cmdb_status__id WHERE isys_obj__id = 23 LIMIT 1 150 Query SELECT *, output.isys_catg_connector_list__isys_obj__id AS output_obj_id, output.isys_catg_connector_list__title AS connector_name, output.isys_catg_connector_list__id AS con_connector FROM isys_catg_pc_list LEFT JOIN isys_obj ON isys_obj__id = isys_catg_pc_list__isys_obj__id LEFT JOIN isys_catg_connector_list AS input ON isys_catg_connector_list__id = isys_catg_pc_list__isys_catg_connector_list__id LEFT JOIN isys_catg_connector_list AS output ON output.isys_catg_connector_list__isys_cable_connection__id = input.isys_catg_connector_list__isys_cable_connection__id AND output.isys_catg_connector_list__id != input.isys_catg_connector_list__id LEFT JOIN isys_pc_model ON isys_pc_model__id = isys_catg_pc_list__isys_pc_model__id LEFT JOIN isys_pc_manufacturer ON isys_pc_manufacturer__id = isys_catg_pc_list__isys_pc_manufacturer__id WHERE TRUE AND (isys_catg_pc_list__isys_obj__id = 23) AND isys_catg_pc_list__id = NULL 150 Query SELECT COUNT(isys_catg_pc_list__id) as count FROM isys_catg_pc_list WHERE (isys_catg_pc_list__status = 2 OR isys_catg_pc_list__status = 6) AND isys_catg_pc_list__isys_obj__id = 23 150 Query INSERT INTO isys_summary (isys_summary__namespace, isys_summary__key, isys_summary__count) VALUES ("cmdb.category.g", "23.9.2", "0") ON DUPLICATE KEY UPDATE isys_summary__count = "0" 150 Query DELETE FROM isys_cache_qinfo WHERE isys_cache_qinfo__isys_obj__id = 23 150 Query UPDATE isys_obj SET isys_obj__updated = NOW(), isys_obj__updated_by = 'admin' WHERE isys_obj__id = 23 150 Query SET AUTOCOMMIT=0 150 Query COMMIT 150 Query DELETE FROM isys_user_session WHERE (isys_user_session__php_sid = "l0l314hbjuep6ttphj7koi19k1") 150 Query SET AUTOCOMMIT=0 150 Query BEGIN 150 Query DELETE FROM isys_user_session WHERE isys_user_session__php_sid = 'l0l314hbjuep6ttphj7koi19k1' 150 Query DROP TABLE IF EXISTS tempObjList_226aa35a93e6b80baf7cd8cb50d3068d 150 Query SET AUTOCOMMIT=0 150 Query COMMIT 149 Quit 150 Quit