Created
February 29, 2016 23:19
-
-
Save jraddaoui/32abee1040f793464291 to your computer and use it in GitHub Desktop.
IO creation with fix. Forcing a timeout in the middle of the nested set update.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 131 Connect root@localhost on atom_2 | |
| 131 Query SET NAMES 'utf8' | |
| 131 Query SELECT COUNT(*) FROM `setting` WHERE setting.NAME='plugins' | |
| 131 Query SELECT setting.NAME, setting.SCOPE, setting.EDITABLE, setting.DELETEABLE, setting.SOURCE_CULTURE, setting.ID, setting.SERIAL_NUMBER FROM `setting` WHERE setting.NAME='plugins' | |
| 131 Query SELECT setting_i18n.VALUE, setting_i18n.ID, setting_i18n.CULTURE FROM `setting_i18n` WHERE setting_i18n.ID='1' | |
| 131 Query SELECT value | |
| FROM setting JOIN setting_i18n ON setting.id = setting_i18n.id | |
| WHERE scope = "default_template" AND name = 'informationobject' | |
| 131 Query SELECT COUNT(*) FROM `user`, `actor`, `object` WHERE user.ID='115215' AND actor.ID=object.ID AND user.ID=actor.ID | |
| 131 Query SELECT object.CLASS_NAME, object.CREATED_AT, object.UPDATED_AT, object.ID, object.SERIAL_NUMBER, actor.ID, actor.CORPORATE_BODY_IDENTIFIERS, actor.ENTITY_TYPE_ID, actor.DESCRIPTION_STATUS_ID, actor.DESCRIPTION_DETAIL_ID, actor.DESCRIPTION_IDENTIFIER, actor.SOURCE_STANDARD, actor.PARENT_ID, actor.LFT, actor.RGT, actor.SOURCE_CULTURE, user.ID, user.USERNAME, user.EMAIL, user.SHA1_PASSWORD, user.SALT, user.ACTIVE FROM `object`, `actor`, `user` WHERE user.ID='115215' AND actor.ID=object.ID AND user.ID=actor.ID | |
| 131 Query START TRANSACTION | |
| 131 Query SELECT COUNT(*) FROM `information_object`, `object` WHERE information_object.ID=1 AND information_object.ID=object.ID | |
| 131 Query SELECT object.CLASS_NAME, object.CREATED_AT, object.UPDATED_AT, object.ID, object.SERIAL_NUMBER, information_object.ID, information_object.IDENTIFIER, information_object.OAI_LOCAL_IDENTIFIER, information_object.LEVEL_OF_DESCRIPTION_ID, information_object.COLLECTION_TYPE_ID, information_object.REPOSITORY_ID, information_object.PARENT_ID, information_object.DESCRIPTION_STATUS_ID, information_object.DESCRIPTION_DETAIL_ID, information_object.DESCRIPTION_IDENTIFIER, information_object.SOURCE_STANDARD, information_object.DISPLAY_STANDARD_ID, information_object.LFT, information_object.RGT, information_object.SOURCE_CULTURE FROM `object`, `information_object` WHERE information_object.ID=1 AND information_object.ID=object.ID | |
| 131 Query SELECT information_object_i18n.TITLE, information_object_i18n.ALTERNATE_TITLE, information_object_i18n.EDITION, information_object_i18n.EXTENT_AND_MEDIUM, information_object_i18n.ARCHIVAL_HISTORY, information_object_i18n.ACQUISITION, information_object_i18n.SCOPE_AND_CONTENT, information_object_i18n.APPRAISAL, information_object_i18n.ACCRUALS, information_object_i18n.ARRANGEMENT, information_object_i18n.ACCESS_CONDITIONS, information_object_i18n.REPRODUCTION_CONDITIONS, information_object_i18n.PHYSICAL_CHARACTERISTICS, information_object_i18n.FINDING_AIDS, information_object_i18n.LOCATION_OF_ORIGINALS, information_object_i18n.LOCATION_OF_COPIES, information_object_i18n.RELATED_UNITS_OF_DESCRIPTION, information_object_i18n.INSTITUTION_RESPONSIBLE_IDENTIFIER, information_object_i18n.RULES, information_object_i18n.SOURCES, information_object_i18n.REVISION_HISTORY, information_object_i18n.ID, information_object_i18n.CULTURE FROM `information_object_i18n` WHERE information_object_i18n.ID='1' | |
| 131 Query SELECT slug.SLUG | |
| FROM slug | |
| WHERE '1' = slug.OBJECT_ID | |
| 131 Query SELECT COUNT(*) FROM `acl_group` WHERE acl_group.ID=99 | |
| 131 Query SELECT acl_group.ID, acl_group.PARENT_ID, acl_group.LFT, acl_group.RGT, acl_group.CREATED_AT, acl_group.UPDATED_AT, acl_group.SOURCE_CULTURE, acl_group.SERIAL_NUMBER FROM `acl_group` WHERE acl_group.ID=99 | |
| 131 Query SELECT actor_i18n.AUTHORIZED_FORM_OF_NAME, actor_i18n.DATES_OF_EXISTENCE, actor_i18n.HISTORY, actor_i18n.PLACES, actor_i18n.LEGAL_STATUS, actor_i18n.FUNCTIONS, actor_i18n.MANDATES, actor_i18n.INTERNAL_STRUCTURES, actor_i18n.GENERAL_CONTEXT, actor_i18n.INSTITUTION_RESPONSIBLE_IDENTIFIER, actor_i18n.RULES, actor_i18n.SOURCES, actor_i18n.REVISION_HISTORY, actor_i18n.ID, actor_i18n.CULTURE FROM `actor_i18n` WHERE actor_i18n.ID='115215' | |
| 131 Query SELECT COUNT(*) FROM `acl_user_group` WHERE acl_user_group.USER_ID='115215' | |
| 131 Query SELECT acl_user_group.ID, acl_user_group.USER_ID, acl_user_group.GROUP_ID, acl_user_group.SERIAL_NUMBER FROM `acl_user_group` WHERE acl_user_group.USER_ID='115215' | |
| 131 Query SELECT COUNT(*) FROM `acl_group` WHERE acl_group.ID='100' | |
| 131 Query SELECT acl_group.ID, acl_group.PARENT_ID, acl_group.LFT, acl_group.RGT, acl_group.CREATED_AT, acl_group.UPDATED_AT, acl_group.SOURCE_CULTURE, acl_group.SERIAL_NUMBER FROM `acl_group` WHERE acl_group.ID='100' | |
| 131 Query SELECT COUNT(*) FROM `acl_group` WHERE acl_group.ID='99' | |
| 131 Query SELECT acl_group.ID, acl_group.PARENT_ID, acl_group.LFT, acl_group.RGT, acl_group.CREATED_AT, acl_group.UPDATED_AT, acl_group.SOURCE_CULTURE, acl_group.SERIAL_NUMBER FROM `acl_group` WHERE acl_group.ID='99' | |
| 131 Query SELECT COUNT(*) FROM `information_object`, `object` WHERE information_object.LFT<'1' AND information_object.RGT>'962' AND information_object.ID=object.ID | |
| 131 Query SELECT object.CLASS_NAME, object.CREATED_AT, object.UPDATED_AT, object.ID, object.SERIAL_NUMBER, information_object.ID, information_object.IDENTIFIER, information_object.OAI_LOCAL_IDENTIFIER, information_object.LEVEL_OF_DESCRIPTION_ID, information_object.COLLECTION_TYPE_ID, information_object.REPOSITORY_ID, information_object.PARENT_ID, information_object.DESCRIPTION_STATUS_ID, information_object.DESCRIPTION_DETAIL_ID, information_object.DESCRIPTION_IDENTIFIER, information_object.SOURCE_STANDARD, information_object.DISPLAY_STANDARD_ID, information_object.LFT, information_object.RGT, information_object.SOURCE_CULTURE FROM `object`, `information_object` WHERE information_object.LFT<'1' AND information_object.RGT>'962' AND information_object.ID=object.ID ORDER BY information_object.LFT ASC,information_object.LFT ASC | |
| 131 Query SELECT COUNT(*) FROM `acl_permission` WHERE ((acl_permission.GROUP_ID IN (99,'100','115215') OR acl_permission.USER_ID='115215') AND (acl_permission.OBJECT_ID IN ('1') OR acl_permission.OBJECT_ID IS NULL )) | |
| 131 Query SELECT acl_permission.ID, acl_permission.USER_ID, acl_permission.GROUP_ID, acl_permission.OBJECT_ID, acl_permission.ACTION, acl_permission.GRANT_DENY, acl_permission.CONDITIONAL, acl_permission.CONSTANTS, acl_permission.CREATED_AT, acl_permission.UPDATED_AT, acl_permission.SERIAL_NUMBER FROM `acl_permission` WHERE ((acl_permission.GROUP_ID IN (99,'100','115215') OR acl_permission.USER_ID='115215') AND (acl_permission.OBJECT_ID IN ('1') OR acl_permission.OBJECT_ID IS NULL )) | |
| 131 Query SELECT COUNT(*) FROM `term`, `object` WHERE term.ID=111 AND term.ID=object.ID | |
| 131 Query SELECT object.CLASS_NAME, object.CREATED_AT, object.UPDATED_AT, object.ID, object.SERIAL_NUMBER, term.ID, term.TAXONOMY_ID, term.CODE, term.PARENT_ID, term.LFT, term.RGT, term.SOURCE_CULTURE FROM `object`, `term` WHERE term.ID=111 AND term.ID=object.ID | |
| 131 Query SELECT COUNT(*) FROM `term`, `object` WHERE term.ID=118 AND term.ID=object.ID | |
| 131 Query SELECT object.CLASS_NAME, object.CREATED_AT, object.UPDATED_AT, object.ID, object.SERIAL_NUMBER, term.ID, term.TAXONOMY_ID, term.CODE, term.PARENT_ID, term.LFT, term.RGT, term.SOURCE_CULTURE FROM `object`, `term` WHERE term.ID=118 AND term.ID=object.ID | |
| 131 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='111' | |
| 131 Query SELECT slug.SLUG | |
| FROM slug | |
| WHERE '111' = slug.OBJECT_ID | |
| 131 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='118' | |
| 131 Query SELECT slug.SLUG | |
| FROM slug | |
| WHERE '118' = slug.OBJECT_ID | |
| 131 Query SELECT note.OBJECT_ID, note.TYPE_ID, note.SCOPE, note.USER_ID, note.SOURCE_CULTURE, note.ID, note.SERIAL_NUMBER FROM `note`, `term` WHERE note.OBJECT_ID IS NULL AND note.TYPE_ID=120 AND note.TYPE_ID=term.ID | |
| 131 Query SELECT note.OBJECT_ID, note.TYPE_ID, note.SCOPE, note.USER_ID, note.SOURCE_CULTURE, note.ID, note.SERIAL_NUMBER FROM `note`, `term` WHERE note.OBJECT_ID IS NULL AND note.TYPE_ID=125 AND note.TYPE_ID=term.ID | |
| 131 Query SELECT note.OBJECT_ID, note.TYPE_ID, note.SCOPE, note.USER_ID, note.SOURCE_CULTURE, note.ID, note.SERIAL_NUMBER FROM `note`, `term` WHERE note.OBJECT_ID IS NULL AND note.TYPE_ID=124 AND note.TYPE_ID=term.ID | |
| 131 Query SELECT object.CLASS_NAME, object.CREATED_AT, object.UPDATED_AT, object.ID, object.SERIAL_NUMBER, event.ID, event.START_DATE, event.START_TIME, event.END_DATE, event.END_TIME, event.TYPE_ID, event.OBJECT_ID, event.ACTOR_ID, event.SOURCE_CULTURE FROM `object`, `event` WHERE event.OBJECT_ID IS NULL AND event.ACTOR_ID IS NOT NULL AND event.TYPE_ID=111 AND event.ID=object.ID | |
| 131 Query SELECT COUNT(*) FROM `term`, `object` WHERE term.ID IS NULL AND term.ID=object.ID | |
| 131 Query SELECT object.CLASS_NAME, object.CREATED_AT, object.UPDATED_AT, object.ID, object.SERIAL_NUMBER, term.ID, term.TAXONOMY_ID, term.CODE, term.PARENT_ID, term.LFT, term.RGT, term.SOURCE_CULTURE FROM `object`, `term` WHERE term.TAXONOMY_ID=31 AND term.ID=object.ID | |
| 131 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='189' | |
| 131 Query SELECT slug.SLUG | |
| FROM slug | |
| WHERE '189' = slug.OBJECT_ID | |
| 131 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='190' | |
| 131 Query SELECT slug.SLUG | |
| FROM slug | |
| WHERE '190' = slug.OBJECT_ID | |
| 131 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='191' | |
| 131 Query SELECT slug.SLUG | |
| FROM slug | |
| WHERE '191' = slug.OBJECT_ID | |
| 131 Query SELECT COUNT(*) FROM `property` WHERE property.OBJECT_ID IS NULL AND property.NAME='language' | |
| 131 Query SELECT note.OBJECT_ID, note.TYPE_ID, note.SCOPE, note.USER_ID, note.SOURCE_CULTURE, note.ID, note.SERIAL_NUMBER FROM `note`, `term` WHERE note.OBJECT_ID IS NULL AND note.TYPE_ID=174 AND note.TYPE_ID=term.ID | |
| 131 Query SELECT COUNT(*) FROM `property` WHERE property.OBJECT_ID IS NULL AND property.NAME='languageOfDescription' | |
| 131 Query SELECT COUNT(*) FROM `term`, `object` WHERE term.ID IS NULL AND term.ID=object.ID | |
| 131 Query SELECT object.CLASS_NAME, object.CREATED_AT, object.UPDATED_AT, object.ID, object.SERIAL_NUMBER, term.ID, term.TAXONOMY_ID, term.CODE, term.PARENT_ID, term.LFT, term.RGT, term.SOURCE_CULTURE, (CASE WHEN (current.NAME IS NOT NULL AND current.NAME <> '') THEN current.NAME ELSE source.NAME END) AS NAME, (CASE WHEN (current.ID IS NOT NULL AND current.ID <> '') THEN current.ID ELSE source.ID END) AS ID, (CASE WHEN (current.CULTURE IS NOT NULL AND current.CULTURE <> '') THEN current.CULTURE ELSE source.CULTURE END) AS CULTURE FROM `object` CROSS JOIN `term` LEFT JOIN term_i18n current ON (term.ID=current.id AND current.CULTURE='en') LEFT JOIN term_i18n source ON (term.ID=source.id AND source.CULTURE=term.SOURCE_CULTURE AND source.CULTURE <> 'en') WHERE term.TAXONOMY_ID=34 AND term.ID=object.ID ORDER BY name ASC | |
| 131 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='194' | |
| 131 Query SELECT slug.SLUG | |
| FROM slug | |
| WHERE '194' = slug.OBJECT_ID | |
| 131 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='197' | |
| 131 Query SELECT slug.SLUG | |
| FROM slug | |
| WHERE '197' = slug.OBJECT_ID | |
| 131 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='192' | |
| 131 Query SELECT slug.SLUG | |
| FROM slug | |
| WHERE '192' = slug.OBJECT_ID | |
| 131 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='198' | |
| 131 Query SELECT slug.SLUG | |
| FROM slug | |
| WHERE '198' = slug.OBJECT_ID | |
| 131 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='2000004' | |
| 131 Query SELECT slug.SLUG | |
| FROM slug | |
| WHERE '2000004' = slug.OBJECT_ID | |
| 131 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='69884' | |
| 131 Query SELECT slug.SLUG | |
| FROM slug | |
| WHERE '69884' = slug.OBJECT_ID | |
| 131 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='195' | |
| 131 Query SELECT slug.SLUG | |
| FROM slug | |
| WHERE '195' = slug.OBJECT_ID | |
| 131 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='193' | |
| 131 Query SELECT slug.SLUG | |
| FROM slug | |
| WHERE '193' = slug.OBJECT_ID | |
| 131 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='196' | |
| 131 Query SELECT slug.SLUG | |
| FROM slug | |
| WHERE '196' = slug.OBJECT_ID | |
| 131 Query SELECT object.CLASS_NAME, object.CREATED_AT, object.UPDATED_AT, object.ID, object.SERIAL_NUMBER, relation.ID, relation.SUBJECT_ID, relation.OBJECT_ID, relation.TYPE_ID, relation.START_DATE, relation.END_DATE, relation.SOURCE_CULTURE FROM `object`, `relation` WHERE relation.SUBJECT_ID IS NULL AND relation.TYPE_ID=161 AND relation.ID=object.ID | |
| 131 Query SELECT object.CLASS_NAME, object.CREATED_AT, object.UPDATED_AT, object.ID, object.SERIAL_NUMBER, object_term_relation.ID, object_term_relation.OBJECT_ID, object_term_relation.TERM_ID, object_term_relation.START_DATE, object_term_relation.END_DATE FROM `object`, `object_term_relation`, `term` WHERE object_term_relation.OBJECT_ID IS NULL AND term.TAXONOMY_ID=78 AND object_term_relation.TERM_ID=term.ID AND object_term_relation.ID=object.ID | |
| 131 Query SELECT object.CLASS_NAME, object.CREATED_AT, object.UPDATED_AT, object.ID, object.SERIAL_NUMBER, object_term_relation.ID, object_term_relation.OBJECT_ID, object_term_relation.TERM_ID, object_term_relation.START_DATE, object_term_relation.END_DATE FROM `object`, `object_term_relation`, `term` WHERE object_term_relation.OBJECT_ID IS NULL AND term.TAXONOMY_ID=42 AND object_term_relation.TERM_ID=term.ID AND object_term_relation.ID=object.ID | |
| 131 Query SELECT object.CLASS_NAME, object.CREATED_AT, object.UPDATED_AT, object.ID, object.SERIAL_NUMBER, relation.ID, relation.SUBJECT_ID, relation.OBJECT_ID, relation.TYPE_ID, relation.START_DATE, relation.END_DATE, relation.SOURCE_CULTURE FROM `object`, `relation` WHERE relation.SUBJECT_ID IS NULL AND relation.TYPE_ID=176 AND relation.ID=object.ID | |
| 131 Query SELECT object.CLASS_NAME, object.CREATED_AT, object.UPDATED_AT, object.ID, object.SERIAL_NUMBER, relation.ID, relation.SUBJECT_ID, relation.OBJECT_ID, relation.TYPE_ID, relation.START_DATE, relation.END_DATE, relation.SOURCE_CULTURE FROM `object`, `relation` WHERE relation.OBJECT_ID IS NULL AND relation.TYPE_ID=176 AND relation.ID=object.ID | |
| 131 Query SELECT COUNT(*) FROM `repository`, `actor`, `object` WHERE repository.ID IS NULL AND actor.ID=object.ID AND repository.ID=actor.ID | |
| 131 Query SELECT COUNT(*) FROM `property` WHERE property.OBJECT_ID IS NULL AND property.NAME='scriptOfDescription' | |
| 131 Query SELECT COUNT(*) FROM `property` WHERE property.OBJECT_ID IS NULL AND property.NAME='script' | |
| 131 Query SELECT object.CLASS_NAME, object.CREATED_AT, object.UPDATED_AT, object.ID, object.SERIAL_NUMBER, object_term_relation.ID, object_term_relation.OBJECT_ID, object_term_relation.TERM_ID, object_term_relation.START_DATE, object_term_relation.END_DATE FROM `object`, `object_term_relation`, `term` WHERE object_term_relation.OBJECT_ID IS NULL AND term.TAXONOMY_ID=35 AND object_term_relation.TERM_ID=term.ID AND object_term_relation.ID=object.ID | |
| 131 Query SELECT COUNT(*) FROM `term`, `object` WHERE term.ID IS NULL AND term.ID=object.ID | |
| 131 Query SELECT object.CLASS_NAME, object.CREATED_AT, object.UPDATED_AT, object.ID, object.SERIAL_NUMBER, term.ID, term.TAXONOMY_ID, term.CODE, term.PARENT_ID, term.LFT, term.RGT, term.SOURCE_CULTURE FROM `object`, `term` WHERE term.TAXONOMY_ID=33 AND term.ID=object.ID | |
| 131 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='186' | |
| 131 Query SELECT slug.SLUG | |
| FROM slug | |
| WHERE '186' = slug.OBJECT_ID | |
| 131 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='187' | |
| 131 Query SELECT slug.SLUG | |
| FROM slug | |
| WHERE '187' = slug.OBJECT_ID | |
| 131 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='188' | |
| 131 Query SELECT slug.SLUG | |
| FROM slug | |
| WHERE '188' = slug.OBJECT_ID | |
| 131 Query SELECT object.CLASS_NAME, object.CREATED_AT, object.UPDATED_AT, object.ID, object.SERIAL_NUMBER, term.ID, term.TAXONOMY_ID, term.CODE, term.PARENT_ID, term.LFT, term.RGT, term.SOURCE_CULTURE FROM `object`, `term` WHERE term.TAXONOMY_ID=70 AND term.ID=object.ID | |
| 131 Query SELECT property.OBJECT_ID, property.SCOPE, property.NAME, property.SOURCE_CULTURE, property.ID, property.SERIAL_NUMBER FROM `property` WHERE property.OBJECT_ID IS NULL AND property.SCOPE='alternativeIdentifiers' | |
| 131 Query SELECT object.CLASS_NAME, object.CREATED_AT, object.UPDATED_AT, object.ID, object.SERIAL_NUMBER, event.ID, event.START_DATE, event.START_TIME, event.END_DATE, event.END_TIME, event.TYPE_ID, event.OBJECT_ID, event.ACTOR_ID, event.SOURCE_CULTURE FROM `object` CROSS JOIN `event` LEFT JOIN event_i18n ON (event.ID=event_i18n.ID AND event.SOURCE_CULTURE=event_i18n.CULTURE) WHERE event.OBJECT_ID IS NULL AND ((event.END_DATE IS NOT NULL OR event.START_DATE IS NOT NULL ) OR event_i18n.DATE IS NOT NULL ) AND event.ID=object.ID ORDER BY event.START_DATE DESC | |
| 131 Query SELECT object.CLASS_NAME, object.CREATED_AT, object.UPDATED_AT, object.ID, object.SERIAL_NUMBER FROM `object`, `slug` WHERE slug.SLUG='v5gxo' AND slug.OBJECT_ID=object.ID | |
| 131 Query SELECT value | |
| FROM setting JOIN setting_i18n ON setting.id = setting_i18n.id | |
| WHERE scope = "default_template" AND name = 'informationobject' | |
| 131 Query SELECT code | |
| FROM information_object JOIN term ON information_object.display_standard_id = term.id | |
| WHERE information_object.id = '1' AND taxonomy_id = '70' | |
| 131 Query SELECT COUNT(*) FROM `property` WHERE property.OBJECT_ID IS NULL AND property.NAME='language' | |
| 131 Query SELECT COUNT(*) FROM `property` WHERE property.OBJECT_ID IS NULL AND property.NAME='languageOfDescription' | |
| 131 Query SELECT COUNT(*) FROM `property` WHERE property.OBJECT_ID IS NULL AND property.NAME='scriptOfDescription' | |
| 131 Query SELECT COUNT(*) FROM `property` WHERE property.OBJECT_ID IS NULL AND property.NAME='script' | |
| 131 Query SELECT status.OBJECT_ID, status.TYPE_ID, status.STATUS_ID, status.ID, status.SERIAL_NUMBER FROM `status` WHERE status.OBJECT_ID IS NULL AND status.TYPE_ID=158 LIMIT 1 | |
| 131 Query SELECT status.OBJECT_ID, status.TYPE_ID, status.STATUS_ID, status.ID, status.SERIAL_NUMBER FROM `status` WHERE status.OBJECT_ID IS NULL AND status.TYPE_ID=158 LIMIT 1 | |
| 131 Query SELECT slug.SLUG | |
| FROM slug | |
| WHERE NULL = slug.OBJECT_ID | |
| 131 Query SELECT setting.NAME, setting.SCOPE, setting.EDITABLE, setting.DELETEABLE, setting.SOURCE_CULTURE, setting.ID, setting.SERIAL_NUMBER FROM `setting` WHERE setting.NAME='slug_basis_informationobject' LIMIT 1 | |
| 131 Query SELECT setting_i18n.VALUE, setting_i18n.ID, setting_i18n.CULTURE FROM `setting_i18n` WHERE setting_i18n.ID='133' | |
| 131 Query SELECT COUNT(*) FROM `information_object`, `object` WHERE information_object.ID='1' AND information_object.ID=object.ID | |
| 131 Query SELECT object.CLASS_NAME, object.CREATED_AT, object.UPDATED_AT, object.ID, object.SERIAL_NUMBER, information_object.ID, information_object.IDENTIFIER, information_object.OAI_LOCAL_IDENTIFIER, information_object.LEVEL_OF_DESCRIPTION_ID, information_object.COLLECTION_TYPE_ID, information_object.REPOSITORY_ID, information_object.PARENT_ID, information_object.DESCRIPTION_STATUS_ID, information_object.DESCRIPTION_DETAIL_ID, information_object.DESCRIPTION_IDENTIFIER, information_object.SOURCE_STANDARD, information_object.DISPLAY_STANDARD_ID, information_object.LFT, information_object.RGT, information_object.SOURCE_CULTURE FROM `object`, `information_object` WHERE information_object.ID='1' AND information_object.ID=object.ID | |
| 131 Query SELECT object.CLASS_NAME, object.CREATED_AT, object.UPDATED_AT, object.ID, object.SERIAL_NUMBER, information_object.ID, information_object.IDENTIFIER, information_object.OAI_LOCAL_IDENTIFIER, information_object.LEVEL_OF_DESCRIPTION_ID, information_object.COLLECTION_TYPE_ID, information_object.REPOSITORY_ID, information_object.PARENT_ID, information_object.DESCRIPTION_STATUS_ID, information_object.DESCRIPTION_DETAIL_ID, information_object.DESCRIPTION_IDENTIFIER, information_object.SOURCE_STANDARD, information_object.DISPLAY_STANDARD_ID, information_object.LFT, information_object.RGT, information_object.SOURCE_CULTURE FROM `object`, `information_object` WHERE object.ID='1' AND information_object.ID=object.ID | |
| 131 Query UPDATE information_object | |
| SET information_object.LFT = information_object.LFT + '2' | |
| WHERE information_object.LFT >= '962' | |
| 131 Query rollback | |
| 131 Quit |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment