Navigation Menu

Skip to content

Instantly share code, notes, and snippets.

@jraddaoui

jraddaoui/gist:d6189f7424112e055365

Last active February 29, 2016 22:22
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jraddaoui/d6189f7424112e055365 to your computer and use it in GitHub Desktop.
Save jraddaoui/d6189f7424112e055365 to your computer and use it in GitHub Desktop.
Download ZIP
IO creation with fix.
Raw
gistfile1.txt
100 Connect root@localhost on atom_2
100 Query SET NAMES 'utf8'
100 Query SELECT COUNT(*) FROM `setting` WHERE setting.NAME='plugins'
100 Query SELECT setting.NAME, setting.SCOPE, setting.EDITABLE, setting.DELETEABLE, setting.SOURCE_CULTURE, setting.ID, setting.SERIAL_NUMBER FROM `setting` WHERE setting.NAME='plugins'
100 Query SELECT setting_i18n.VALUE, setting_i18n.ID, setting_i18n.CULTURE FROM `setting_i18n` WHERE setting_i18n.ID='1'
100 Query SELECT value
FROM setting JOIN setting_i18n ON setting.id = setting_i18n.id
WHERE scope = "default_template" AND name = 'informationobject'
100 Query SELECT COUNT(*) FROM `user`, `actor`, `object` WHERE user.ID='115215' AND actor.ID=object.ID AND user.ID=actor.ID
100 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
100 Query START TRANSACTION
100 Query SELECT COUNT(*) FROM `information_object`, `object` WHERE information_object.ID=1 AND information_object.ID=object.ID
100 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
100 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'
100 Query SELECT slug.SLUG
FROM slug
WHERE '1' = slug.OBJECT_ID
100 Query SELECT COUNT(*) FROM `acl_group` WHERE acl_group.ID=99
100 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
100 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'
100 Query SELECT COUNT(*) FROM `acl_user_group` WHERE acl_user_group.USER_ID='115215'
100 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'
100 Query SELECT COUNT(*) FROM `acl_group` WHERE acl_group.ID='100'
100 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'
100 Query SELECT COUNT(*) FROM `acl_group` WHERE acl_group.ID='99'
100 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'
100 Query SELECT COUNT(*) FROM `information_object`, `object` WHERE information_object.LFT<'1' AND information_object.RGT>'956' AND information_object.ID=object.ID
100 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>'956' AND information_object.ID=object.ID ORDER BY information_object.LFT ASC,information_object.LFT ASC
100 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 ))
100 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 ))
100 Query SELECT COUNT(*) FROM `term`, `object` WHERE term.ID=111 AND term.ID=object.ID
100 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
100 Query SELECT COUNT(*) FROM `term`, `object` WHERE term.ID=118 AND term.ID=object.ID
100 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
100 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='111'
100 Query SELECT slug.SLUG
FROM slug
WHERE '111' = slug.OBJECT_ID
100 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='118'
100 Query SELECT slug.SLUG
FROM slug
WHERE '118' = slug.OBJECT_ID
100 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
100 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
100 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
100 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
100 Query SELECT COUNT(*) FROM `term`, `object` WHERE term.ID IS NULL AND term.ID=object.ID
100 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
100 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='189'
100 Query SELECT slug.SLUG
FROM slug
WHERE '189' = slug.OBJECT_ID
100 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='190'
100 Query SELECT slug.SLUG
FROM slug
WHERE '190' = slug.OBJECT_ID
100 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='191'
100 Query SELECT slug.SLUG
FROM slug
WHERE '191' = slug.OBJECT_ID
100 Query SELECT COUNT(*) FROM `property` WHERE property.OBJECT_ID IS NULL AND property.NAME='language'
100 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
100 Query SELECT COUNT(*) FROM `property` WHERE property.OBJECT_ID IS NULL AND property.NAME='languageOfDescription'
100 Query SELECT COUNT(*) FROM `term`, `object` WHERE term.ID IS NULL AND term.ID=object.ID
100 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
100 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='194'
100 Query SELECT slug.SLUG
FROM slug
WHERE '194' = slug.OBJECT_ID
100 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='197'
100 Query SELECT slug.SLUG
FROM slug
WHERE '197' = slug.OBJECT_ID
100 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='192'
100 Query SELECT slug.SLUG
FROM slug
WHERE '192' = slug.OBJECT_ID
100 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='198'
100 Query SELECT slug.SLUG
FROM slug
WHERE '198' = slug.OBJECT_ID
100 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='2000004'
100 Query SELECT slug.SLUG
FROM slug
WHERE '2000004' = slug.OBJECT_ID
100 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='69884'
100 Query SELECT slug.SLUG
FROM slug
WHERE '69884' = slug.OBJECT_ID
100 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='195'
100 Query SELECT slug.SLUG
FROM slug
WHERE '195' = slug.OBJECT_ID
100 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='193'
100 Query SELECT slug.SLUG
FROM slug
WHERE '193' = slug.OBJECT_ID
100 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='196'
100 Query SELECT slug.SLUG
FROM slug
WHERE '196' = slug.OBJECT_ID
100 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
100 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
100 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
100 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
100 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
100 Query SELECT COUNT(*) FROM `repository`, `actor`, `object` WHERE repository.ID IS NULL AND actor.ID=object.ID AND repository.ID=actor.ID
100 Query SELECT COUNT(*) FROM `property` WHERE property.OBJECT_ID IS NULL AND property.NAME='scriptOfDescription'
100 Query SELECT COUNT(*) FROM `property` WHERE property.OBJECT_ID IS NULL AND property.NAME='script'
100 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
100 Query SELECT COUNT(*) FROM `term`, `object` WHERE term.ID IS NULL AND term.ID=object.ID
100 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
100 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='186'
100 Query SELECT slug.SLUG
FROM slug
WHERE '186' = slug.OBJECT_ID
100 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='187'
100 Query SELECT slug.SLUG
FROM slug
WHERE '187' = slug.OBJECT_ID
100 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='188'
100 Query SELECT slug.SLUG
FROM slug
WHERE '188' = slug.OBJECT_ID
100 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
100 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'
100 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
100 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
100 Query SELECT value
FROM setting JOIN setting_i18n ON setting.id = setting_i18n.id
WHERE scope = "default_template" AND name = 'informationobject'
100 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'
100 Query SELECT COUNT(*) FROM `property` WHERE property.OBJECT_ID IS NULL AND property.NAME='language'
100 Query SELECT COUNT(*) FROM `property` WHERE property.OBJECT_ID IS NULL AND property.NAME='languageOfDescription'
100 Query SELECT object.CLASS_NAME, object.CREATED_AT, object.UPDATED_AT, object.ID, object.SERIAL_NUMBER FROM `object`, `slug` WHERE slug.SLUG='fonds' AND slug.OBJECT_ID=object.ID
100 Query SELECT COUNT(*) FROM `property` WHERE property.OBJECT_ID IS NULL AND property.NAME='scriptOfDescription'
100 Query SELECT COUNT(*) FROM `property` WHERE property.OBJECT_ID IS NULL AND property.NAME='script'
100 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
100 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
100 Query SELECT slug.SLUG
FROM slug
WHERE NULL = slug.OBJECT_ID
100 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
100 Query SELECT setting_i18n.VALUE, setting_i18n.ID, setting_i18n.CULTURE FROM `setting_i18n` WHERE setting_i18n.ID='133'
100 Query SELECT COUNT(*) FROM `information_object`, `object` WHERE information_object.ID='1' AND information_object.ID=object.ID
100 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
100 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
100 Query UPDATE information_object
SET information_object.LFT = information_object.LFT + '2'
WHERE information_object.LFT >= '956'
100 Query UPDATE information_object
SET information_object.RGT = information_object.RGT + '2'
WHERE information_object.RGT >= '956'
100 Query INSERT INTO object (`CLASS_NAME`,`CREATED_AT`,`UPDATED_AT`) VALUES ('QubitInformationObject','2016-02-29 13:53:47','2016-02-29 13:53:47')
100 Query INSERT INTO information_object (`ID`,`IDENTIFIER`,`LEVEL_OF_DESCRIPTION_ID`,`PARENT_ID`,`SOURCE_STANDARD`,`LFT`,`RGT`,`SOURCE_CULTURE`) VALUES ('2001247','456','192','1','ISAD(G) 2nd edition','956',957,'en')
100 Query INSERT INTO slug (slug.OBJECT_ID, slug.SLUG)
VALUES ('2001247', 'test-two')
100 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` WHERE object_term_relation.OBJECT_ID='2001247' AND object_term_relation.ID=object.ID
100 Query SELECT note.OBJECT_ID, note.TYPE_ID, note.SCOPE, note.USER_ID, note.SOURCE_CULTURE, note.ID, note.SERIAL_NUMBER FROM `note` WHERE note.OBJECT_ID='2001247'
100 Query INSERT INTO property (`OBJECT_ID`,`NAME`,`SOURCE_CULTURE`) VALUES ('2001247','language','en')
100 Query INSERT INTO property_i18n (`VALUE`,`ID`,`CULTURE`) VALUES ('N;','251101','en')
100 Query INSERT INTO property (`OBJECT_ID`,`NAME`,`SOURCE_CULTURE`) VALUES ('2001247','languageOfDescription','en')
100 Query INSERT INTO property_i18n (`VALUE`,`ID`,`CULTURE`) VALUES ('N;','251102','en')
100 Query INSERT INTO property (`OBJECT_ID`,`NAME`,`SOURCE_CULTURE`) VALUES ('2001247','scriptOfDescription','en')
100 Query INSERT INTO property_i18n (`VALUE`,`ID`,`CULTURE`) VALUES ('N;','251103','en')
100 Query INSERT INTO property (`OBJECT_ID`,`NAME`,`SOURCE_CULTURE`) VALUES ('2001247','script','en')
100 Query INSERT INTO property_i18n (`VALUE`,`ID`,`CULTURE`) VALUES ('N;','251104','en')
100 Query SELECT other_name.OBJECT_ID, other_name.TYPE_ID, other_name.START_DATE, other_name.END_DATE, other_name.SOURCE_CULTURE, other_name.ID, other_name.SERIAL_NUMBER FROM `other_name` WHERE other_name.OBJECT_ID='2001247'
100 Query INSERT INTO information_object_i18n (`TITLE`,`ID`,`CULTURE`) VALUES ('test two','2001247','en')
100 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='2001247' AND event.ID=object.ID
100 Query SELECT object.CLASS_NAME, object.CREATED_AT, object.UPDATED_AT, object.ID, object.SERIAL_NUMBER, digital_object.ID, digital_object.INFORMATION_OBJECT_ID, digital_object.USAGE_ID, digital_object.MIME_TYPE, digital_object.MEDIA_TYPE_ID, digital_object.NAME, digital_object.PATH, digital_object.SEQUENCE, digital_object.BYTE_SIZE, digital_object.CHECKSUM, digital_object.CHECKSUM_TYPE, digital_object.PARENT_ID FROM `object`, `digital_object` WHERE digital_object.INFORMATION_OBJECT_ID='2001247' AND digital_object.ID=object.ID
100 Query INSERT INTO status (`OBJECT_ID`,`TYPE_ID`,`STATUS_ID`) VALUES ('2001247',158,'159')
100 Query SELECT
io.*,
obj.created_at,
obj.updated_at,
slug.slug,
pubstat.status_id as publication_status_id,
do.id as digital_object_id,
do.media_type_id as media_type_id,
do.name as filename
FROM information_object io
JOIN object obj
ON io.id = obj.id
JOIN slug slug
ON io.id = slug.object_id
JOIN status pubstat
ON io.id = pubstat.object_id
LEFT JOIN digital_object do
ON io.id = do.information_object_id
WHERE io.id = '2001247'
100 Query SELECT
event.id,
event.start_date,
event.end_date,
event.actor_id,
event.type_id,
event.source_culture,
i18n.date,
i18n.culture FROM event event JOIN event_i18n i18n
ON event.id = i18n.id WHERE event.object_id = '2001247'
100 Query SELECT
node.id,
identifier,
repository_id,
slug FROM information_object node JOIN slug slug
ON node.id = slug.object_id WHERE node.lft < '956' AND node.rgt > '957' ORDER BY lft
100 Query SELECT
node.name,
i18n.value FROM property node JOIN property_i18n i18n
ON node.id = i18n.id WHERE node.source_culture = i18n.culture
AND node.object_id = '2001247'
AND node.scope = 'alternativeIdentifiers'
100 Query SELECT
node.id FROM information_object node WHERE node.parent_id = '2001247' ORDER BY lft
100 Query SELECT
rights.*, rightsi18n.* FROM rights rights JOIN rights_i18n rightsi18n
ON rights.id = rightsi18n.id JOIN relation rel
ON rights.id = rel.object_id WHERE rel.subject_id = '2001247' AND rel.type_id = 168
100 Query SELECT term.id FROM object_term_relation otr JOIN term term
ON otr.term_id = term.id WHERE object_id = '2001247' AND term.taxonomy_id = 50
100 Query SELECT
DISTINCT term.id,
term.taxonomy_id,
term.source_culture,
slug.slug,
i18n.name FROM object_term_relation otr JOIN term current
ON otr.term_id = current.id JOIN term term
ON term.lft <= current.lft AND term.rgt >= current.rgt JOIN term_i18n i18n
ON term.id = i18n.id JOIN slug slug
ON term.id = slug.object_id WHERE otr.object_id = '2001247'
AND term.taxonomy_id = '42'
100 Query SELECT
DISTINCT current.id FROM object_term_relation otr JOIN term current
ON otr.term_id = current.id WHERE otr.object_id = '2001247'
AND current.taxonomy_id = '42'
100 Query SELECT
DISTINCT term.id,
term.taxonomy_id,
term.source_culture,
slug.slug,
i18n.name FROM object_term_relation otr JOIN term current
ON otr.term_id = current.id JOIN term term
ON term.lft <= current.lft AND term.rgt >= current.rgt JOIN term_i18n i18n
ON term.id = i18n.id JOIN slug slug
ON term.id = slug.object_id WHERE otr.object_id = '2001247'
AND term.taxonomy_id = '35'
100 Query SELECT
DISTINCT current.id FROM object_term_relation otr JOIN term current
ON otr.term_id = current.id WHERE otr.object_id = '2001247'
AND current.taxonomy_id = '35'
100 Query SELECT actor.id FROM actor actor JOIN relation relation
ON actor.id = relation.object_id WHERE relation.subject_id = '2001247'
AND relation.type_id = '161'
100 Query SELECT
DISTINCT term.id,
term.taxonomy_id,
term.source_culture,
slug.slug,
i18n.name FROM object_term_relation otr JOIN term current
ON otr.term_id = current.id JOIN term term
ON term.lft <= current.lft AND term.rgt >= current.rgt JOIN term_i18n i18n
ON term.id = i18n.id JOIN slug slug
ON term.id = slug.object_id WHERE otr.object_id = '2001247'
AND term.taxonomy_id = '78'
100 Query SELECT
phys.id,
phys.source_culture FROM physical_object phys JOIN relation relation
ON phys.id = relation.subject_id WHERE relation.object_id = '2001247'
AND relation.type_id = '147'
100 Query SELECT
id, source_culture
FROM note WHERE object_id = '2001247' AND type_id = '125'
100 Query SELECT t.id
FROM term t
LEFT JOIN term_i18n ti
ON t.id=ti.id
WHERE t.taxonomy_id='51' AND ti.name='Alpha-numeric designations' AND ti.culture='en'
100 Query SELECT
id, source_culture
FROM note WHERE object_id = '2001247' AND type_id = '247'
100 Query SELECT t.id
FROM term t
LEFT JOIN term_i18n ti
ON t.id=ti.id
WHERE t.taxonomy_id='51' AND ti.name='Conservation' AND ti.culture='en'
100 Query SELECT
id, source_culture
FROM note WHERE object_id = '2001247' AND type_id = '244'
100 Query SELECT t.id
FROM term t
LEFT JOIN term_i18n ti
ON t.id=ti.id
WHERE t.taxonomy_id='51' AND ti.name='Physical description' AND ti.culture='en'
100 Query SELECT
id, source_culture
FROM note WHERE object_id = '2001247' AND type_id = '243'
100 Query SELECT t.id
FROM term t
LEFT JOIN term_i18n ti
ON t.id=ti.id
WHERE t.taxonomy_id='52' AND ti.name='Continuation of title' AND ti.culture='en'
100 Query SELECT
id, source_culture
FROM note WHERE object_id = '2001247' AND type_id = '253'
100 Query SELECT
prop.id, prop.source_culture FROM property prop WHERE prop.object_id = '2001247'
AND prop.name = 'titleStatementOfResponsibility'
100 Query SELECT
aip.id FROM aip aip JOIN relation relation
ON aip.id = relation.subject_id WHERE relation.object_id = '2001247'
AND relation.type_id = '178'
100 Query SELECT
i18n.value FROM property node JOIN property_i18n i18n
ON node.id = i18n.id WHERE node.source_culture = i18n.culture
AND node.object_id = '2001247'
AND node.name = 'aipUUID'
100 Query SELECT
i18n.value FROM property node JOIN property_i18n i18n
ON node.id = i18n.id WHERE node.source_culture = i18n.culture
AND node.object_id = '2001247'
AND node.name = 'objectUUID'
100 Query SELECT
gr.* FROM granted_right gr JOIN relation rel
ON gr.rights_id = rel.object_id WHERE rel.subject_id = '2001247' AND rel.type_id = 168
100 Query SELECT
rights.*, rightsi18n.* FROM rights rights JOIN rights_i18n rightsi18n
ON rights.id = rightsi18n.id JOIN relation rel
ON rights.id = rel.object_id WHERE rel.subject_id = '2001247' AND rel.type_id = 168
100 Query SELECT setting.NAME, setting.SCOPE, setting.EDITABLE, setting.DELETEABLE, setting.SOURCE_CULTURE, setting.ID, setting.SERIAL_NUMBER FROM `setting` WHERE setting.SCOPE='i18n_languages'
100 Query SELECT setting_i18n.VALUE, setting_i18n.ID, setting_i18n.CULTURE FROM `setting_i18n` WHERE setting_i18n.ID='27'
100 Query SELECT setting_i18n.VALUE, setting_i18n.ID, setting_i18n.CULTURE FROM `setting_i18n` WHERE setting_i18n.ID='28'
100 Query SELECT setting_i18n.VALUE, setting_i18n.ID, setting_i18n.CULTURE FROM `setting_i18n` WHERE setting_i18n.ID='29'
100 Query SELECT setting_i18n.VALUE, setting_i18n.ID, setting_i18n.CULTURE FROM `setting_i18n` WHERE setting_i18n.ID='30'
100 Query SELECT setting_i18n.VALUE, setting_i18n.ID, setting_i18n.CULTURE FROM `setting_i18n` WHERE setting_i18n.ID='31'
100 Query SELECT * FROM information_object_i18n WHERE id = '2001247' ORDER BY culture ASC
100 Query SELECT id FROM information_object
WHERE parent_id = '1' AND lft < '956' AND rgt > '957'
100 Query SELECT slug.SLUG
FROM slug
WHERE '2001247' = slug.OBJECT_ID
100 Query commit
100 Quit
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment