Last active
April 25, 2018 19:38
-
-
Save jmchilton/d68565662f7f4b7ee2640f09fbb92962 to your computer and use it in GitHub Desktop.
This file contains 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
SELECT galaxy_session.id AS galaxy_session_id, galaxy_session.create_time AS galaxy_session_create_time, galaxy_session.update_time AS galaxy_session_update_time, galaxy_session.user_id AS galaxy_session_user_id, galaxy_session.remote_host AS galaxy_session_remote_host, galaxy_session.remote_addr AS galaxy_session_remote_addr, galaxy_session.referer AS galaxy_session_referer, galaxy_session.current_history_id AS galaxy_session_current_history_id, galaxy_session.session_key AS galaxy_session_session_key, galaxy_session.is_valid AS galaxy_session_is_valid, galaxy_session.prev_session_id AS galaxy_session_prev_session_id, galaxy_session.disk_usage AS galaxy_session_disk_usage, galaxy_session.last_action AS galaxy_session_last_action, galaxy_user_1.id AS galaxy_user_1_id, galaxy_user_1.create_time AS galaxy_user_1_create_time, galaxy_user_1.update_time AS galaxy_user_1_update_time, galaxy_user_1.email AS galaxy_user_1_email, galaxy_user_1.username AS galaxy_user_1_username, galaxy_user_1.password AS galaxy_user_1_password, galaxy_user_1.last_password_change AS galaxy_user_1_last_password_change, galaxy_user_1.external AS galaxy_user_1_external, galaxy_user_1.form_values_id AS galaxy_user_1_form_values_id, galaxy_user_1.deleted AS galaxy_user_1_deleted, galaxy_user_1.purged AS galaxy_user_1_purged, galaxy_user_1.disk_usage AS galaxy_user_1_disk_usage, galaxy_user_1.active AS galaxy_user_1_active, galaxy_user_1.activation_token AS galaxy_user_1_activation_token | |
FROM galaxy_session LEFT OUTER JOIN galaxy_user AS galaxy_user_1 ON galaxy_user_1.id = galaxy_session.user_id | |
WHERE galaxy_session.session_key = %(session_key_1)s AND galaxy_session.is_valid = true | |
LIMIT %(param_1)s | |
Parameters: {'session_key_1': u'6e4e7382e12b28401e895910bb305148', 'param_1': 1} | |
galaxy.model.orm.engine_factory DEBUG 2018-04-25 10:05:26,498 Request query: 0.002602(s) | |
SELECT history.id AS history_id, history.create_time AS history_create_time, history.update_time AS history_update_time, history.user_id AS history_user_id, history.name AS history_name, history.hid_counter AS history_hid_counter, history.deleted AS history_deleted, history.purged AS history_purged, history.importing AS history_importing, history.genome_build AS history_genome_build, history.importable AS history_importable, history.slug AS history_slug, history.published AS history_published | |
FROM history | |
WHERE history.id = %(param_1)s | |
Parameters: {'param_1': 600} | |
galaxy.model.orm.engine_factory DEBUG 2018-04-25 10:05:26,700 Request query: 0.014285(s) | |
SELECT history_dataset_association.id AS history_dataset_association_id, history_dataset_association.history_id AS history_dataset_association_history_id, history_dataset_association.dataset_id AS history_dataset_association_dataset_id, history_dataset_association.create_time AS history_dataset_association_create_time, history_dataset_association.update_time AS history_dataset_association_update_time, history_dataset_association.state AS history_dataset_association_state, history_dataset_association.copied_from_history_dataset_association_id AS history_dataset_association_copied_from_history_dataset_a_1, history_dataset_association.copied_from_library_dataset_dataset_association_id AS history_dataset_association_copied_from_library_dataset_d_2, history_dataset_association.name AS history_dataset_association_name, history_dataset_association.info AS history_dataset_association_info, history_dataset_association.blurb AS history_dataset_association_blurb, history_dataset_association.peek AS history_dataset_association_peek, history_dataset_association.tool_version AS history_dataset_association_tool_version, history_dataset_association.extension AS history_dataset_association_extension, history_dataset_association.parent_id AS history_dataset_association_parent_id, history_dataset_association.designation AS history_dataset_association_designation, history_dataset_association.deleted AS history_dataset_association_deleted, history_dataset_association.visible AS history_dataset_association_visible, history_dataset_association.extended_metadata_id AS history_dataset_association_extended_metadata_id, history_dataset_association.version AS history_dataset_association_version, history_dataset_association.hid AS history_dataset_association_hid, history_dataset_association.purged AS history_dataset_association_purged, history_dataset_association.hidden_beneath_collection_instance_id AS history_dataset_association_hidden_beneath_collection_ins_3, history_dataset_association_tag_association_1.id AS history_dataset_association_tag_association_1_id, history_dataset_association_tag_association_1.history_dataset_association_id AS history_dataset_association_tag_association_1_history_dat_4, history_dataset_association_tag_association_1.tag_id AS history_dataset_association_tag_association_1_tag_id, history_dataset_association_tag_association_1.user_id AS history_dataset_association_tag_association_1_user_id, history_dataset_association_tag_association_1.user_tname AS history_dataset_association_tag_association_1_user_tname, history_dataset_association_tag_association_1.value AS history_dataset_association_tag_association_1_value, history_dataset_association_tag_association_1.user_value AS history_dataset_association_tag_association_1_user_value, dataset_1.id AS dataset_1_id, dataset_1.create_time AS dataset_1_create_time, dataset_1.update_time AS dataset_1_update_time, dataset_1.state AS dataset_1_state, dataset_1.deleted AS dataset_1_deleted, dataset_1.purged AS dataset_1_purged, dataset_1.purgable AS dataset_1_purgable, dataset_1.object_store_id AS dataset_1_object_store_id, dataset_1.external_filename AS dataset_1_external_filename, dataset_1._extra_files_path AS dataset_1__extra_files_path, dataset_1.file_size AS dataset_1_file_size, dataset_1.total_size AS dataset_1_total_size, dataset_1.uuid AS dataset_1_uuid, role_1.id AS role_1_id, role_1.create_time AS role_1_create_time, role_1.update_time AS role_1_update_time, role_1.name AS role_1_name, role_1.description AS role_1_description, role_1.type AS role_1_type, role_1.deleted AS role_1_deleted, dataset_permissions_1.id AS dataset_permissions_1_id, dataset_permissions_1.create_time AS dataset_permissions_1_create_time, dataset_permissions_1.update_time AS dataset_permissions_1_update_time, dataset_permissions_1.action AS dataset_permissions_1_action, dataset_permissions_1.dataset_id AS dataset_permissions_1_dataset_id, dataset_permissions_1.role_id AS dataset_permissions_1_role_id | |
FROM history_dataset_association LEFT OUTER JOIN history_dataset_association_tag_association AS history_dataset_association_tag_association_1 ON history_dataset_association.id = history_dataset_association_tag_association_1.history_dataset_association_id LEFT OUTER JOIN dataset AS dataset_1 ON dataset_1.id = history_dataset_association.dataset_id LEFT OUTER JOIN dataset_permissions AS dataset_permissions_1 ON dataset_1.id = dataset_permissions_1.dataset_id LEFT OUTER JOIN role AS role_1 ON role_1.id = dataset_permissions_1.role_id | |
WHERE history_dataset_association.history_id = %(history_id_1)s AND NOT history_dataset_association.deleted AND history_dataset_association.visible ORDER BY history_dataset_association.hid ASC, history_dataset_association_tag_association_1.id | |
Parameters: {'history_id_1': 600} | |
galaxy.model.orm.engine_factory DEBUG 2018-04-25 10:05:26,714 Request query: 0.001649(s) | |
SELECT history_dataset_association.metadata AS history_dataset_association_metadata | |
FROM history_dataset_association | |
WHERE history_dataset_association.id = %(param_1)s | |
Parameters: {'param_1': 468} | |
galaxy.model.orm.engine_factory DEBUG 2018-04-25 10:05:26,742 Request query: 0.009374(s) | |
SELECT history_dataset_collection_association.id AS history_dataset_collection_association_id, history_dataset_collection_association.collection_id AS history_dataset_collection_association_collection_id, history_dataset_collection_association.history_id AS history_dataset_collection_association_history_id, history_dataset_collection_association.name AS history_dataset_collection_association_name, history_dataset_collection_association.hid AS history_dataset_collection_association_hid, history_dataset_collection_association.visible AS history_dataset_collection_association_visible, history_dataset_collection_association.deleted AS history_dataset_collection_association_deleted, history_dataset_collection_association.copied_from_history_dataset_collection_association_id AS history_dataset_collection_association_copied_from_histor_1, history_dataset_collection_association.implicit_output_name AS history_dataset_collection_association_implicit_output_na_2, history_dataset_collection_association.job_id AS history_dataset_collection_association_job_id, history_dataset_collection_association.implicit_collection_jobs_id AS history_dataset_collection_association_implicit_collectio_3, history_dataset_collection_tag_association_1.id AS history_dataset_collection_tag_association_1_id, history_dataset_collection_tag_association_1.history_dataset_collection_id AS history_dataset_collection_tag_association_1_history_data_4, history_dataset_collection_tag_association_1.tag_id AS history_dataset_collection_tag_association_1_tag_id, history_dataset_collection_tag_association_1.user_id AS history_dataset_collection_tag_association_1_user_id, history_dataset_collection_tag_association_1.user_tname AS history_dataset_collection_tag_association_1_user_tname, history_dataset_collection_tag_association_1.value AS history_dataset_collection_tag_association_1_value, history_dataset_collection_tag_association_1.user_value AS history_dataset_collection_tag_association_1_user_value, dataset_1.id AS dataset_1_id, dataset_1.create_time AS dataset_1_create_time, dataset_1.update_time AS dataset_1_update_time, dataset_1.state AS dataset_1_state, dataset_1.deleted AS dataset_1_deleted, dataset_1.purged AS dataset_1_purged, dataset_1.purgable AS dataset_1_purgable, dataset_1.object_store_id AS dataset_1_object_store_id, dataset_1.external_filename AS dataset_1_external_filename, dataset_1._extra_files_path AS dataset_1__extra_files_path, dataset_1.file_size AS dataset_1_file_size, dataset_1.total_size AS dataset_1_total_size, dataset_1.uuid AS dataset_1_uuid, history_dataset_association_1.id AS history_dataset_association_1_id, history_dataset_association_1.history_id AS history_dataset_association_1_history_id, history_dataset_association_1.dataset_id AS history_dataset_association_1_dataset_id, history_dataset_association_1.create_time AS history_dataset_association_1_create_time, history_dataset_association_1.update_time AS history_dataset_association_1_update_time, history_dataset_association_1.state AS history_dataset_association_1_state, history_dataset_association_1.copied_from_history_dataset_association_id AS history_dataset_association_1_copied_from_history_dataset_5, history_dataset_association_1.copied_from_library_dataset_dataset_association_id AS history_dataset_association_1_copied_from_library_dataset_6, history_dataset_association_1.name AS history_dataset_association_1_name, history_dataset_association_1.info AS history_dataset_association_1_info, history_dataset_association_1.blurb AS history_dataset_association_1_blurb, history_dataset_association_1.peek AS history_dataset_association_1_peek, history_dataset_association_1.tool_version AS history_dataset_association_1_tool_version, history_dataset_association_1.extension AS history_dataset_association_1_extension, history_dataset_association_1.parent_id AS history_dataset_association_1_parent_id, history_dataset_association_1.designation AS history_dataset_association_1_designation, history_dataset_association_1.deleted AS history_dataset_association_1_deleted, history_dataset_association_1.visible AS history_dataset_association_1_visible, history_dataset_association_1.extended_metadata_id AS history_dataset_association_1_extended_metadata_id, history_dataset_association_1.version AS history_dataset_association_1_version, history_dataset_association_1.hid AS history_dataset_association_1_hid, history_dataset_association_1.purged AS history_dataset_association_1_purged, history_dataset_association_1.hidden_beneath_collection_instance_id AS history_dataset_association_1_hidden_beneath_collection_i_7, dataset_collection_element_1.id AS dataset_collection_element_1_id, dataset_collection_element_1.dataset_collection_id AS dataset_collection_element_1_dataset_collection_id, dataset_collection_element_1.hda_id AS dataset_collection_element_1_hda_id, dataset_collection_element_1.ldda_id AS dataset_collection_element_1_ldda_id, dataset_collection_element_1.child_collection_id AS dataset_collection_element_1_child_collection_id, dataset_collection_element_1.element_index AS dataset_collection_element_1_element_index, dataset_collection_element_1.element_identifier AS dataset_collection_element_1_element_identifier, dataset_collection_1.id AS dataset_collection_1_id, dataset_collection_1.collection_type AS dataset_collection_1_collection_type, dataset_collection_1.populated_state AS dataset_collection_1_populated_state, dataset_collection_1.populated_state_message AS dataset_collection_1_populated_state_message, dataset_collection_1.element_count AS dataset_collection_1_element_count, dataset_collection_1.create_time AS dataset_collection_1_create_time, dataset_collection_1.update_time AS dataset_collection_1_update_time | |
FROM history_dataset_collection_association LEFT OUTER JOIN history_dataset_collection_tag_association AS history_dataset_collection_tag_association_1 ON history_dataset_collection_association.id = history_dataset_collection_tag_association_1.history_dataset_collection_id LEFT OUTER JOIN dataset_collection AS dataset_collection_1 ON dataset_collection_1.id = history_dataset_collection_association.collection_id LEFT OUTER JOIN dataset_collection_element AS dataset_collection_element_1 ON dataset_collection_1.id = dataset_collection_element_1.dataset_collection_id LEFT OUTER JOIN history_dataset_association AS history_dataset_association_1 ON dataset_collection_element_1.hda_id = history_dataset_association_1.id LEFT OUTER JOIN dataset AS dataset_1 ON dataset_1.id = history_dataset_association_1.dataset_id | |
WHERE history_dataset_collection_association.history_id = %(history_id_1)s AND NOT history_dataset_collection_association.deleted AND history_dataset_collection_association.visible ORDER BY history_dataset_collection_association.hid ASC, history_dataset_collection_tag_association_1.id, dataset_collection_element_1.element_index | |
Parameters: {'history_id_1': 600} | |
galaxy.model.orm.engine_factory DEBUG 2018-04-25 10:05:26,772 Request query: 0.010901(s) | |
SELECT galaxy_user.id AS galaxy_user_id, galaxy_user.create_time AS galaxy_user_create_time, galaxy_user.update_time AS galaxy_user_update_time, galaxy_user.email AS galaxy_user_email, galaxy_user.username AS galaxy_user_username, galaxy_user.password AS galaxy_user_password, galaxy_user.last_password_change AS galaxy_user_last_password_change, galaxy_user.external AS galaxy_user_external, galaxy_user.form_values_id AS galaxy_user_form_values_id, galaxy_user.deleted AS galaxy_user_deleted, galaxy_user.purged AS galaxy_user_purged, galaxy_user.disk_usage AS galaxy_user_disk_usage, galaxy_user.active AS galaxy_user_active, galaxy_user.activation_token AS galaxy_user_activation_token, galaxy_group_1.id AS galaxy_group_1_id, galaxy_group_1.create_time AS galaxy_group_1_create_time, galaxy_group_1.update_time AS galaxy_group_1_update_time, galaxy_group_1.name AS galaxy_group_1_name, galaxy_group_1.deleted AS galaxy_group_1_deleted, role_1.id AS role_1_id, role_1.create_time AS role_1_create_time, role_1.update_time AS role_1_update_time, role_1.name AS role_1_name, role_1.description AS role_1_description, role_1.type AS role_1_type, role_1.deleted AS role_1_deleted, group_role_association_1.id AS group_role_association_1_id, group_role_association_1.group_id AS group_role_association_1_group_id, group_role_association_1.role_id AS group_role_association_1_role_id, group_role_association_1.create_time AS group_role_association_1_create_time, group_role_association_1.update_time AS group_role_association_1_update_time, user_group_association_1.id AS user_group_association_1_id, user_group_association_1.user_id AS user_group_association_1_user_id, user_group_association_1.group_id AS user_group_association_1_group_id, user_group_association_1.create_time AS user_group_association_1_create_time, user_group_association_1.update_time AS user_group_association_1_update_time, role_2.id AS role_2_id, role_2.create_time AS role_2_create_time, role_2.update_time AS role_2_update_time, role_2.name AS role_2_name, role_2.description AS role_2_description, role_2.type AS role_2_type, role_2.deleted AS role_2_deleted, user_role_association_1.id AS user_role_association_1_id, user_role_association_1.user_id AS user_role_association_1_user_id, user_role_association_1.role_id AS user_role_association_1_role_id, user_role_association_1.create_time AS user_role_association_1_create_time, user_role_association_1.update_time AS user_role_association_1_update_time | |
FROM galaxy_user LEFT OUTER JOIN user_group_association AS user_group_association_1 ON galaxy_user.id = user_group_association_1.user_id LEFT OUTER JOIN galaxy_group AS galaxy_group_1 ON galaxy_group_1.id = user_group_association_1.group_id LEFT OUTER JOIN group_role_association AS group_role_association_1 ON galaxy_group_1.id = group_role_association_1.group_id LEFT OUTER JOIN role AS role_1 ON role_1.id = group_role_association_1.role_id LEFT OUTER JOIN user_role_association AS user_role_association_1 ON galaxy_user.id = user_role_association_1.user_id LEFT OUTER JOIN role AS role_2 ON role_2.id = user_role_association_1.role_id | |
WHERE galaxy_user.id = %(id_1)s | |
Parameters: {'id_1': 1} |
This file contains 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
galaxy.model.orm.engine_factory DEBUG 2018-04-25 15:36:35,861 Request query: 0.005144(s) | |
SELECT galaxy_session.id AS galaxy_session_id, galaxy_session.create_time AS galaxy_session_create_time, galaxy_session.update_time AS galaxy_session_update_time, galaxy_session.user_id AS galaxy_session_user_id, galaxy_session.remote_host AS galaxy_session_remote_host, galaxy_session.remote_addr AS galaxy_session_remote_addr, galaxy_session.referer AS galaxy_session_referer, galaxy_session.current_history_id AS galaxy_session_current_history_id, galaxy_session.session_key AS galaxy_session_session_key, galaxy_session.is_valid AS galaxy_session_is_valid, galaxy_session.prev_session_id AS galaxy_session_prev_session_id, galaxy_session.disk_usage AS galaxy_session_disk_usage, galaxy_session.last_action AS galaxy_session_last_action, galaxy_user_1.id AS galaxy_user_1_id, galaxy_user_1.create_time AS galaxy_user_1_create_time, galaxy_user_1.update_time AS galaxy_user_1_update_time, galaxy_user_1.email AS galaxy_user_1_email, galaxy_user_1.username AS galaxy_user_1_username, galaxy_user_1.password AS galaxy_user_1_password, galaxy_user_1.last_password_change AS galaxy_user_1_last_password_change, galaxy_user_1.external AS galaxy_user_1_external, galaxy_user_1.form_values_id AS galaxy_user_1_form_values_id, galaxy_user_1.deleted AS galaxy_user_1_deleted, galaxy_user_1.purged AS galaxy_user_1_purged, galaxy_user_1.disk_usage AS galaxy_user_1_disk_usage, galaxy_user_1.active AS galaxy_user_1_active, galaxy_user_1.activation_token AS galaxy_user_1_activation_token | |
FROM galaxy_session LEFT OUTER JOIN galaxy_user AS galaxy_user_1 ON galaxy_user_1.id = galaxy_session.user_id | |
WHERE galaxy_session.session_key = %(session_key_1)s AND galaxy_session.is_valid = true | |
LIMIT %(param_1)s | |
Parameters: {'session_key_1': u'6e4e7382e12b28401e895910bb305148', 'param_1': 1} | |
galaxy.model.orm.engine_factory DEBUG 2018-04-25 15:36:35,868 Request query: 0.002266(s) | |
SELECT history.id AS history_id, history.create_time AS history_create_time, history.update_time AS history_update_time, history.user_id AS history_user_id, history.name AS history_name, history.hid_counter AS history_hid_counter, history.deleted AS history_deleted, history.purged AS history_purged, history.importing AS history_importing, history.genome_build AS history_genome_build, history.importable AS history_importable, history.slug AS history_slug, history.published AS history_published | |
FROM history | |
WHERE history.id = %(param_1)s | |
Parameters: {'param_1': 600} | |
galaxy.model.orm.engine_factory DEBUG 2018-04-25 15:36:35,889 Request query: 0.009995(s) | |
SELECT history_dataset_association.id AS history_dataset_association_id, history_dataset_association.history_id AS history_dataset_association_history_id, history_dataset_association.dataset_id AS history_dataset_association_dataset_id, history_dataset_association.create_time AS history_dataset_association_create_time, history_dataset_association.update_time AS history_dataset_association_update_time, history_dataset_association.state AS history_dataset_association_state, history_dataset_association.copied_from_history_dataset_association_id AS history_dataset_association_copied_from_history_dataset_a_1, history_dataset_association.copied_from_library_dataset_dataset_association_id AS history_dataset_association_copied_from_library_dataset_d_2, history_dataset_association.name AS history_dataset_association_name, history_dataset_association.info AS history_dataset_association_info, history_dataset_association.blurb AS history_dataset_association_blurb, history_dataset_association.peek AS history_dataset_association_peek, history_dataset_association.tool_version AS history_dataset_association_tool_version, history_dataset_association.extension AS history_dataset_association_extension, history_dataset_association.parent_id AS history_dataset_association_parent_id, history_dataset_association.designation AS history_dataset_association_designation, history_dataset_association.deleted AS history_dataset_association_deleted, history_dataset_association.visible AS history_dataset_association_visible, history_dataset_association.extended_metadata_id AS history_dataset_association_extended_metadata_id, history_dataset_association.version AS history_dataset_association_version, history_dataset_association.hid AS history_dataset_association_hid, history_dataset_association.purged AS history_dataset_association_purged, history_dataset_association.hidden_beneath_collection_instance_id AS history_dataset_association_hidden_beneath_collection_ins_3, history_dataset_association_tag_association_1.id AS history_dataset_association_tag_association_1_id, history_dataset_association_tag_association_1.history_dataset_association_id AS history_dataset_association_tag_association_1_history_dat_4, history_dataset_association_tag_association_1.tag_id AS history_dataset_association_tag_association_1_tag_id, history_dataset_association_tag_association_1.user_id AS history_dataset_association_tag_association_1_user_id, history_dataset_association_tag_association_1.user_tname AS history_dataset_association_tag_association_1_user_tname, history_dataset_association_tag_association_1.value AS history_dataset_association_tag_association_1_value, history_dataset_association_tag_association_1.user_value AS history_dataset_association_tag_association_1_user_value, dataset_1.id AS dataset_1_id, dataset_1.create_time AS dataset_1_create_time, dataset_1.update_time AS dataset_1_update_time, dataset_1.state AS dataset_1_state, dataset_1.deleted AS dataset_1_deleted, dataset_1.purged AS dataset_1_purged, dataset_1.purgable AS dataset_1_purgable, dataset_1.object_store_id AS dataset_1_object_store_id, dataset_1.external_filename AS dataset_1_external_filename, dataset_1._extra_files_path AS dataset_1__extra_files_path, dataset_1.file_size AS dataset_1_file_size, dataset_1.total_size AS dataset_1_total_size, dataset_1.uuid AS dataset_1_uuid, role_1.id AS role_1_id, role_1.create_time AS role_1_create_time, role_1.update_time AS role_1_update_time, role_1.name AS role_1_name, role_1.description AS role_1_description, role_1.type AS role_1_type, role_1.deleted AS role_1_deleted, dataset_permissions_1.id AS dataset_permissions_1_id, dataset_permissions_1.create_time AS dataset_permissions_1_create_time, dataset_permissions_1.update_time AS dataset_permissions_1_update_time, dataset_permissions_1.action AS dataset_permissions_1_action, dataset_permissions_1.dataset_id AS dataset_permissions_1_dataset_id, dataset_permissions_1.role_id AS dataset_permissions_1_role_id | |
FROM history_dataset_association LEFT OUTER JOIN history_dataset_association_tag_association AS history_dataset_association_tag_association_1 ON history_dataset_association.id = history_dataset_association_tag_association_1.history_dataset_association_id LEFT OUTER JOIN dataset AS dataset_1 ON dataset_1.id = history_dataset_association.dataset_id LEFT OUTER JOIN dataset_permissions AS dataset_permissions_1 ON dataset_1.id = dataset_permissions_1.dataset_id LEFT OUTER JOIN role AS role_1 ON role_1.id = dataset_permissions_1.role_id | |
WHERE history_dataset_association.history_id = %(history_id_1)s AND NOT history_dataset_association.deleted AND history_dataset_association.visible ORDER BY history_dataset_association.hid ASC, history_dataset_association_tag_association_1.id | |
Parameters: {'history_id_1': 600} | |
galaxy.model.orm.engine_factory DEBUG 2018-04-25 15:36:35,899 Request query: 0.001450(s) | |
SELECT history_dataset_association.metadata AS history_dataset_association_metadata | |
FROM history_dataset_association | |
WHERE history_dataset_association.id = %(param_1)s | |
Parameters: {'param_1': 513} | |
galaxy.model.orm.engine_factory DEBUG 2018-04-25 15:36:35,918 Request query: 0.011972(s) | |
SELECT history_dataset_collection_association.id AS history_dataset_collection_association_id, history_dataset_collection_association.collection_id AS history_dataset_collection_association_collection_id, history_dataset_collection_association.history_id AS history_dataset_collection_association_history_id, history_dataset_collection_association.name AS history_dataset_collection_association_name, history_dataset_collection_association.hid AS history_dataset_collection_association_hid, history_dataset_collection_association.visible AS history_dataset_collection_association_visible, history_dataset_collection_association.deleted AS history_dataset_collection_association_deleted, history_dataset_collection_association.copied_from_history_dataset_collection_association_id AS history_dataset_collection_association_copied_from_histor_1, history_dataset_collection_association.implicit_output_name AS history_dataset_collection_association_implicit_output_na_2, history_dataset_collection_association.job_id AS history_dataset_collection_association_job_id, history_dataset_collection_association.implicit_collection_jobs_id AS history_dataset_collection_association_implicit_collectio_3, history_dataset_collection_tag_association_1.id AS history_dataset_collection_tag_association_1_id, history_dataset_collection_tag_association_1.history_dataset_collection_id AS history_dataset_collection_tag_association_1_history_data_4, history_dataset_collection_tag_association_1.tag_id AS history_dataset_collection_tag_association_1_tag_id, history_dataset_collection_tag_association_1.user_id AS history_dataset_collection_tag_association_1_user_id, history_dataset_collection_tag_association_1.user_tname AS history_dataset_collection_tag_association_1_user_tname, history_dataset_collection_tag_association_1.value AS history_dataset_collection_tag_association_1_value, history_dataset_collection_tag_association_1.user_value AS history_dataset_collection_tag_association_1_user_value, dataset_collection_1.id AS dataset_collection_1_id, dataset_collection_1.collection_type AS dataset_collection_1_collection_type, dataset_collection_1.populated_state AS dataset_collection_1_populated_state, dataset_collection_1.populated_state_message AS dataset_collection_1_populated_state_message, dataset_collection_1.element_count AS dataset_collection_1_element_count, dataset_collection_1.create_time AS dataset_collection_1_create_time, dataset_collection_1.update_time AS dataset_collection_1_update_time | |
FROM dataset_collection, history_dataset_collection_association LEFT OUTER JOIN history_dataset_collection_tag_association AS history_dataset_collection_tag_association_1 ON history_dataset_collection_association.id = history_dataset_collection_tag_association_1.history_dataset_collection_id LEFT OUTER JOIN dataset_collection AS dataset_collection_1 ON dataset_collection_1.id = history_dataset_collection_association.collection_id | |
WHERE history_dataset_collection_association.history_id = %(history_id_1)s AND NOT history_dataset_collection_association.deleted AND history_dataset_collection_association.visible AND dataset_collection.populated_state = %(populated_state_1)s ORDER BY history_dataset_collection_association.hid ASC, history_dataset_collection_tag_association_1.id | |
Parameters: {'history_id_1': 600, 'populated_state_1': 'ok'} | |
galaxy.model.orm.engine_factory DEBUG 2018-04-25 15:36:35,990 Request query: 0.007544(s) | |
SELECT dataset_collection.id AS dataset_collection_id, dataset_collection.collection_type AS dataset_collection_collection_type, dataset_collection.populated_state AS dataset_collection_populated_state, dataset_collection.populated_state_message AS dataset_collection_populated_state_message, dataset_collection.element_count AS dataset_collection_element_count, dataset_collection.create_time AS dataset_collection_create_time, dataset_collection.update_time AS dataset_collection_update_time, dataset_1.id AS dataset_1_id, dataset_1.create_time AS dataset_1_create_time, dataset_1.update_time AS dataset_1_update_time, dataset_1.state AS dataset_1_state, dataset_1.deleted AS dataset_1_deleted, dataset_1.purged AS dataset_1_purged, dataset_1.purgable AS dataset_1_purgable, dataset_1.object_store_id AS dataset_1_object_store_id, dataset_1.external_filename AS dataset_1_external_filename, dataset_1._extra_files_path AS dataset_1__extra_files_path, dataset_1.file_size AS dataset_1_file_size, dataset_1.total_size AS dataset_1_total_size, dataset_1.uuid AS dataset_1_uuid, role_1.id AS role_1_id, role_1.create_time AS role_1_create_time, role_1.update_time AS role_1_update_time, role_1.name AS role_1_name, role_1.description AS role_1_description, role_1.type AS role_1_type, role_1.deleted AS role_1_deleted, dataset_permissions_1.id AS dataset_permissions_1_id, dataset_permissions_1.create_time AS dataset_permissions_1_create_time, dataset_permissions_1.update_time AS dataset_permissions_1_update_time, dataset_permissions_1.action AS dataset_permissions_1_action, dataset_permissions_1.dataset_id AS dataset_permissions_1_dataset_id, dataset_permissions_1.role_id AS dataset_permissions_1_role_id, history_dataset_association_1.id AS history_dataset_association_1_id, history_dataset_association_1.history_id AS history_dataset_association_1_history_id, history_dataset_association_1.dataset_id AS history_dataset_association_1_dataset_id, history_dataset_association_1.create_time AS history_dataset_association_1_create_time, history_dataset_association_1.update_time AS history_dataset_association_1_update_time, history_dataset_association_1.state AS history_dataset_association_1_state, history_dataset_association_1.copied_from_history_dataset_association_id AS history_dataset_association_1_copied_from_history_dataset_1, history_dataset_association_1.copied_from_library_dataset_dataset_association_id AS history_dataset_association_1_copied_from_library_dataset_2, history_dataset_association_1.name AS history_dataset_association_1_name, history_dataset_association_1.info AS history_dataset_association_1_info, history_dataset_association_1.blurb AS history_dataset_association_1_blurb, history_dataset_association_1.peek AS history_dataset_association_1_peek, history_dataset_association_1.tool_version AS history_dataset_association_1_tool_version, history_dataset_association_1.extension AS history_dataset_association_1_extension, history_dataset_association_1.parent_id AS history_dataset_association_1_parent_id, history_dataset_association_1.designation AS history_dataset_association_1_designation, history_dataset_association_1.deleted AS history_dataset_association_1_deleted, history_dataset_association_1.visible AS history_dataset_association_1_visible, history_dataset_association_1.extended_metadata_id AS history_dataset_association_1_extended_metadata_id, history_dataset_association_1.version AS history_dataset_association_1_version, history_dataset_association_1.hid AS history_dataset_association_1_hid, history_dataset_association_1.purged AS history_dataset_association_1_purged, history_dataset_association_1.hidden_beneath_collection_instance_id AS history_dataset_association_1_hidden_beneath_collection_i_3, dataset_collection_element_1.id AS dataset_collection_element_1_id, dataset_collection_element_1.dataset_collection_id AS dataset_collection_element_1_dataset_collection_id, dataset_collection_element_1.hda_id AS dataset_collection_element_1_hda_id, dataset_collection_element_1.ldda_id AS dataset_collection_element_1_ldda_id, dataset_collection_element_1.child_collection_id AS dataset_collection_element_1_child_collection_id, dataset_collection_element_1.element_index AS dataset_collection_element_1_element_index, dataset_collection_element_1.element_identifier AS dataset_collection_element_1_element_identifier | |
FROM dataset_collection LEFT OUTER JOIN dataset_collection_element AS dataset_collection_element_1 ON dataset_collection.id = dataset_collection_element_1.dataset_collection_id LEFT OUTER JOIN history_dataset_association AS history_dataset_association_1 ON dataset_collection_element_1.hda_id = history_dataset_association_1.id LEFT OUTER JOIN dataset AS dataset_1 ON dataset_1.id = history_dataset_association_1.dataset_id LEFT OUTER JOIN dataset_permissions AS dataset_permissions_1 ON dataset_1.id = dataset_permissions_1.dataset_id LEFT OUTER JOIN role AS role_1 ON role_1.id = dataset_permissions_1.role_id | |
WHERE dataset_collection.id = %(id_1)s ORDER BY dataset_collection_element_1.element_index | |
Parameters: {'id_1': 88} | |
galaxy.model.orm.engine_factory DEBUG 2018-04-25 15:36:36,013 Request query: 0.010513(s) | |
SELECT galaxy_user.id AS galaxy_user_id, galaxy_user.create_time AS galaxy_user_create_time, galaxy_user.update_time AS galaxy_user_update_time, galaxy_user.email AS galaxy_user_email, galaxy_user.username AS galaxy_user_username, galaxy_user.password AS galaxy_user_password, galaxy_user.last_password_change AS galaxy_user_last_password_change, galaxy_user.external AS galaxy_user_external, galaxy_user.form_values_id AS galaxy_user_form_values_id, galaxy_user.deleted AS galaxy_user_deleted, galaxy_user.purged AS galaxy_user_purged, galaxy_user.disk_usage AS galaxy_user_disk_usage, galaxy_user.active AS galaxy_user_active, galaxy_user.activation_token AS galaxy_user_activation_token, galaxy_group_1.id AS galaxy_group_1_id, galaxy_group_1.create_time AS galaxy_group_1_create_time, galaxy_group_1.update_time AS galaxy_group_1_update_time, galaxy_group_1.name AS galaxy_group_1_name, galaxy_group_1.deleted AS galaxy_group_1_deleted, role_1.id AS role_1_id, role_1.create_time AS role_1_create_time, role_1.update_time AS role_1_update_time, role_1.name AS role_1_name, role_1.description AS role_1_description, role_1.type AS role_1_type, role_1.deleted AS role_1_deleted, group_role_association_1.id AS group_role_association_1_id, group_role_association_1.group_id AS group_role_association_1_group_id, group_role_association_1.role_id AS group_role_association_1_role_id, group_role_association_1.create_time AS group_role_association_1_create_time, group_role_association_1.update_time AS group_role_association_1_update_time, user_group_association_1.id AS user_group_association_1_id, user_group_association_1.user_id AS user_group_association_1_user_id, user_group_association_1.group_id AS user_group_association_1_group_id, user_group_association_1.create_time AS user_group_association_1_create_time, user_group_association_1.update_time AS user_group_association_1_update_time, role_2.id AS role_2_id, role_2.create_time AS role_2_create_time, role_2.update_time AS role_2_update_time, role_2.name AS role_2_name, role_2.description AS role_2_description, role_2.type AS role_2_type, role_2.deleted AS role_2_deleted, user_role_association_1.id AS user_role_association_1_id, user_role_association_1.user_id AS user_role_association_1_user_id, user_role_association_1.role_id AS user_role_association_1_role_id, user_role_association_1.create_time AS user_role_association_1_create_time, user_role_association_1.update_time AS user_role_association_1_update_time | |
FROM galaxy_user LEFT OUTER JOIN user_group_association AS user_group_association_1 ON galaxy_user.id = user_group_association_1.user_id LEFT OUTER JOIN galaxy_group AS galaxy_group_1 ON galaxy_group_1.id = user_group_association_1.group_id LEFT OUTER JOIN group_role_association AS group_role_association_1 ON galaxy_group_1.id = group_role_association_1.group_id LEFT OUTER JOIN role AS role_1 ON role_1.id = group_role_association_1.role_id LEFT OUTER JOIN user_role_association AS user_role_association_1 ON galaxy_user.id = user_role_association_1.user_id LEFT OUTER JOIN role AS role_2 ON role_2.id = user_role_association_1.role_id | |
WHERE galaxy_user.id = %(id_1)s | |
Parameters: {'id_1': 1} | |
galaxy.model.orm.engine_factory DEBUG 2018-04-25 15:36:36,028 Request query: 0.005425(s) | |
SELECT dataset_collection.id AS dataset_collection_id, dataset_collection.collection_type AS dataset_collection_collection_type, dataset_collection.populated_state AS dataset_collection_populated_state, dataset_collection.populated_state_message AS dataset_collection_populated_state_message, dataset_collection.element_count AS dataset_collection_element_count, dataset_collection.create_time AS dataset_collection_create_time, dataset_collection.update_time AS dataset_collection_update_time, dataset_1.id AS dataset_1_id, dataset_1.create_time AS dataset_1_create_time, dataset_1.update_time AS dataset_1_update_time, dataset_1.state AS dataset_1_state, dataset_1.deleted AS dataset_1_deleted, dataset_1.purged AS dataset_1_purged, dataset_1.purgable AS dataset_1_purgable, dataset_1.object_store_id AS dataset_1_object_store_id, dataset_1.external_filename AS dataset_1_external_filename, dataset_1._extra_files_path AS dataset_1__extra_files_path, dataset_1.file_size AS dataset_1_file_size, dataset_1.total_size AS dataset_1_total_size, dataset_1.uuid AS dataset_1_uuid, role_1.id AS role_1_id, role_1.create_time AS role_1_create_time, role_1.update_time AS role_1_update_time, role_1.name AS role_1_name, role_1.description AS role_1_description, role_1.type AS role_1_type, role_1.deleted AS role_1_deleted, dataset_permissions_1.id AS dataset_permissions_1_id, dataset_permissions_1.create_time AS dataset_permissions_1_create_time, dataset_permissions_1.update_time AS dataset_permissions_1_update_time, dataset_permissions_1.action AS dataset_permissions_1_action, dataset_permissions_1.dataset_id AS dataset_permissions_1_dataset_id, dataset_permissions_1.role_id AS dataset_permissions_1_role_id, history_dataset_association_1.id AS history_dataset_association_1_id, history_dataset_association_1.history_id AS history_dataset_association_1_history_id, history_dataset_association_1.dataset_id AS history_dataset_association_1_dataset_id, history_dataset_association_1.create_time AS history_dataset_association_1_create_time, history_dataset_association_1.update_time AS history_dataset_association_1_update_time, history_dataset_association_1.state AS history_dataset_association_1_state, history_dataset_association_1.copied_from_history_dataset_association_id AS history_dataset_association_1_copied_from_history_dataset_1, history_dataset_association_1.copied_from_library_dataset_dataset_association_id AS history_dataset_association_1_copied_from_library_dataset_2, history_dataset_association_1.name AS history_dataset_association_1_name, history_dataset_association_1.info AS history_dataset_association_1_info, history_dataset_association_1.blurb AS history_dataset_association_1_blurb, history_dataset_association_1.peek AS history_dataset_association_1_peek, history_dataset_association_1.tool_version AS history_dataset_association_1_tool_version, history_dataset_association_1.extension AS history_dataset_association_1_extension, history_dataset_association_1.parent_id AS history_dataset_association_1_parent_id, history_dataset_association_1.designation AS history_dataset_association_1_designation, history_dataset_association_1.deleted AS history_dataset_association_1_deleted, history_dataset_association_1.visible AS history_dataset_association_1_visible, history_dataset_association_1.extended_metadata_id AS history_dataset_association_1_extended_metadata_id, history_dataset_association_1.version AS history_dataset_association_1_version, history_dataset_association_1.hid AS history_dataset_association_1_hid, history_dataset_association_1.purged AS history_dataset_association_1_purged, history_dataset_association_1.hidden_beneath_collection_instance_id AS history_dataset_association_1_hidden_beneath_collection_i_3, dataset_collection_element_1.id AS dataset_collection_element_1_id, dataset_collection_element_1.dataset_collection_id AS dataset_collection_element_1_dataset_collection_id, dataset_collection_element_1.hda_id AS dataset_collection_element_1_hda_id, dataset_collection_element_1.ldda_id AS dataset_collection_element_1_ldda_id, dataset_collection_element_1.child_collection_id AS dataset_collection_element_1_child_collection_id, dataset_collection_element_1.element_index AS dataset_collection_element_1_element_index, dataset_collection_element_1.element_identifier AS dataset_collection_element_1_element_identifier | |
FROM dataset_collection LEFT OUTER JOIN dataset_collection_element AS dataset_collection_element_1 ON dataset_collection.id = dataset_collection_element_1.dataset_collection_id LEFT OUTER JOIN history_dataset_association AS history_dataset_association_1 ON dataset_collection_element_1.hda_id = history_dataset_association_1.id LEFT OUTER JOIN dataset AS dataset_1 ON dataset_1.id = history_dataset_association_1.dataset_id LEFT OUTER JOIN dataset_permissions AS dataset_permissions_1 ON dataset_1.id = dataset_permissions_1.dataset_id LEFT OUTER JOIN role AS role_1 ON role_1.id = dataset_permissions_1.role_id | |
WHERE dataset_collection.id = %(id_1)s ORDER BY dataset_collection_element_1.element_index | |
Parameters: {'id_1': 89} | |
galaxy.model.orm.engine_factory DEBUG 2018-04-25 15:36:36,045 Request query: 0.005474(s) | |
SELECT dataset_collection.id AS dataset_collection_id, dataset_collection.collection_type AS dataset_collection_collection_type, dataset_collection.populated_state AS dataset_collection_populated_state, dataset_collection.populated_state_message AS dataset_collection_populated_state_message, dataset_collection.element_count AS dataset_collection_element_count, dataset_collection.create_time AS dataset_collection_create_time, dataset_collection.update_time AS dataset_collection_update_time, dataset_1.id AS dataset_1_id, dataset_1.create_time AS dataset_1_create_time, dataset_1.update_time AS dataset_1_update_time, dataset_1.state AS dataset_1_state, dataset_1.deleted AS dataset_1_deleted, dataset_1.purged AS dataset_1_purged, dataset_1.purgable AS dataset_1_purgable, dataset_1.object_store_id AS dataset_1_object_store_id, dataset_1.external_filename AS dataset_1_external_filename, dataset_1._extra_files_path AS dataset_1__extra_files_path, dataset_1.file_size AS dataset_1_file_size, dataset_1.total_size AS dataset_1_total_size, dataset_1.uuid AS dataset_1_uuid, role_1.id AS role_1_id, role_1.create_time AS role_1_create_time, role_1.update_time AS role_1_update_time, role_1.name AS role_1_name, role_1.description AS role_1_description, role_1.type AS role_1_type, role_1.deleted AS role_1_deleted, dataset_permissions_1.id AS dataset_permissions_1_id, dataset_permissions_1.create_time AS dataset_permissions_1_create_time, dataset_permissions_1.update_time AS dataset_permissions_1_update_time, dataset_permissions_1.action AS dataset_permissions_1_action, dataset_permissions_1.dataset_id AS dataset_permissions_1_dataset_id, dataset_permissions_1.role_id AS dataset_permissions_1_role_id, history_dataset_association_1.id AS history_dataset_association_1_id, history_dataset_association_1.history_id AS history_dataset_association_1_history_id, history_dataset_association_1.dataset_id AS history_dataset_association_1_dataset_id, history_dataset_association_1.create_time AS history_dataset_association_1_create_time, history_dataset_association_1.update_time AS history_dataset_association_1_update_time, history_dataset_association_1.state AS history_dataset_association_1_state, history_dataset_association_1.copied_from_history_dataset_association_id AS history_dataset_association_1_copied_from_history_dataset_1, history_dataset_association_1.copied_from_library_dataset_dataset_association_id AS history_dataset_association_1_copied_from_library_dataset_2, history_dataset_association_1.name AS history_dataset_association_1_name, history_dataset_association_1.info AS history_dataset_association_1_info, history_dataset_association_1.blurb AS history_dataset_association_1_blurb, history_dataset_association_1.peek AS history_dataset_association_1_peek, history_dataset_association_1.tool_version AS history_dataset_association_1_tool_version, history_dataset_association_1.extension AS history_dataset_association_1_extension, history_dataset_association_1.parent_id AS history_dataset_association_1_parent_id, history_dataset_association_1.designation AS history_dataset_association_1_designation, history_dataset_association_1.deleted AS history_dataset_association_1_deleted, history_dataset_association_1.visible AS history_dataset_association_1_visible, history_dataset_association_1.extended_metadata_id AS history_dataset_association_1_extended_metadata_id, history_dataset_association_1.version AS history_dataset_association_1_version, history_dataset_association_1.hid AS history_dataset_association_1_hid, history_dataset_association_1.purged AS history_dataset_association_1_purged, history_dataset_association_1.hidden_beneath_collection_instance_id AS history_dataset_association_1_hidden_beneath_collection_i_3, dataset_collection_element_1.id AS dataset_collection_element_1_id, dataset_collection_element_1.dataset_collection_id AS dataset_collection_element_1_dataset_collection_id, dataset_collection_element_1.hda_id AS dataset_collection_element_1_hda_id, dataset_collection_element_1.ldda_id AS dataset_collection_element_1_ldda_id, dataset_collection_element_1.child_collection_id AS dataset_collection_element_1_child_collection_id, dataset_collection_element_1.element_index AS dataset_collection_element_1_element_index, dataset_collection_element_1.element_identifier AS dataset_collection_element_1_element_identifier | |
FROM dataset_collection LEFT OUTER JOIN dataset_collection_element AS dataset_collection_element_1 ON dataset_collection.id = dataset_collection_element_1.dataset_collection_id LEFT OUTER JOIN history_dataset_association AS history_dataset_association_1 ON dataset_collection_element_1.hda_id = history_dataset_association_1.id LEFT OUTER JOIN dataset AS dataset_1 ON dataset_1.id = history_dataset_association_1.dataset_id LEFT OUTER JOIN dataset_permissions AS dataset_permissions_1 ON dataset_1.id = dataset_permissions_1.dataset_id LEFT OUTER JOIN role AS role_1 ON role_1.id = dataset_permissions_1.role_id | |
WHERE dataset_collection.id = %(id_1)s ORDER BY dataset_collection_element_1.element_index | |
Parameters: {'id_1': 90} | |
galaxy.model.orm.engine_factory DEBUG 2018-04-25 15:36:36,061 Request query: 0.005010(s) | |
SELECT dataset_collection.id AS dataset_collection_id, dataset_collection.collection_type AS dataset_collection_collection_type, dataset_collection.populated_state AS dataset_collection_populated_state, dataset_collection.populated_state_message AS dataset_collection_populated_state_message, dataset_collection.element_count AS dataset_collection_element_count, dataset_collection.create_time AS dataset_collection_create_time, dataset_collection.update_time AS dataset_collection_update_time, dataset_1.id AS dataset_1_id, dataset_1.create_time AS dataset_1_create_time, dataset_1.update_time AS dataset_1_update_time, dataset_1.state AS dataset_1_state, dataset_1.deleted AS dataset_1_deleted, dataset_1.purged AS dataset_1_purged, dataset_1.purgable AS dataset_1_purgable, dataset_1.object_store_id AS dataset_1_object_store_id, dataset_1.external_filename AS dataset_1_external_filename, dataset_1._extra_files_path AS dataset_1__extra_files_path, dataset_1.file_size AS dataset_1_file_size, dataset_1.total_size AS dataset_1_total_size, dataset_1.uuid AS dataset_1_uuid, role_1.id AS role_1_id, role_1.create_time AS role_1_create_time, role_1.update_time AS role_1_update_time, role_1.name AS role_1_name, role_1.description AS role_1_description, role_1.type AS role_1_type, role_1.deleted AS role_1_deleted, dataset_permissions_1.id AS dataset_permissions_1_id, dataset_permissions_1.create_time AS dataset_permissions_1_create_time, dataset_permissions_1.update_time AS dataset_permissions_1_update_time, dataset_permissions_1.action AS dataset_permissions_1_action, dataset_permissions_1.dataset_id AS dataset_permissions_1_dataset_id, dataset_permissions_1.role_id AS dataset_permissions_1_role_id, history_dataset_association_1.id AS history_dataset_association_1_id, history_dataset_association_1.history_id AS history_dataset_association_1_history_id, history_dataset_association_1.dataset_id AS history_dataset_association_1_dataset_id, history_dataset_association_1.create_time AS history_dataset_association_1_create_time, history_dataset_association_1.update_time AS history_dataset_association_1_update_time, history_dataset_association_1.state AS history_dataset_association_1_state, history_dataset_association_1.copied_from_history_dataset_association_id AS history_dataset_association_1_copied_from_history_dataset_1, history_dataset_association_1.copied_from_library_dataset_dataset_association_id AS history_dataset_association_1_copied_from_library_dataset_2, history_dataset_association_1.name AS history_dataset_association_1_name, history_dataset_association_1.info AS history_dataset_association_1_info, history_dataset_association_1.blurb AS history_dataset_association_1_blurb, history_dataset_association_1.peek AS history_dataset_association_1_peek, history_dataset_association_1.tool_version AS history_dataset_association_1_tool_version, history_dataset_association_1.extension AS history_dataset_association_1_extension, history_dataset_association_1.parent_id AS history_dataset_association_1_parent_id, history_dataset_association_1.designation AS history_dataset_association_1_designation, history_dataset_association_1.deleted AS history_dataset_association_1_deleted, history_dataset_association_1.visible AS history_dataset_association_1_visible, history_dataset_association_1.extended_metadata_id AS history_dataset_association_1_extended_metadata_id, history_dataset_association_1.version AS history_dataset_association_1_version, history_dataset_association_1.hid AS history_dataset_association_1_hid, history_dataset_association_1.purged AS history_dataset_association_1_purged, history_dataset_association_1.hidden_beneath_collection_instance_id AS history_dataset_association_1_hidden_beneath_collection_i_3, dataset_collection_element_1.id AS dataset_collection_element_1_id, dataset_collection_element_1.dataset_collection_id AS dataset_collection_element_1_dataset_collection_id, dataset_collection_element_1.hda_id AS dataset_collection_element_1_hda_id, dataset_collection_element_1.ldda_id AS dataset_collection_element_1_ldda_id, dataset_collection_element_1.child_collection_id AS dataset_collection_element_1_child_collection_id, dataset_collection_element_1.element_index AS dataset_collection_element_1_element_index, dataset_collection_element_1.element_identifier AS dataset_collection_element_1_element_identifier | |
FROM dataset_collection LEFT OUTER JOIN dataset_collection_element AS dataset_collection_element_1 ON dataset_collection.id = dataset_collection_element_1.dataset_collection_id LEFT OUTER JOIN history_dataset_association AS history_dataset_association_1 ON dataset_collection_element_1.hda_id = history_dataset_association_1.id LEFT OUTER JOIN dataset AS dataset_1 ON dataset_1.id = history_dataset_association_1.dataset_id LEFT OUTER JOIN dataset_permissions AS dataset_permissions_1 ON dataset_1.id = dataset_permissions_1.dataset_id LEFT OUTER JOIN role AS role_1 ON role_1.id = dataset_permissions_1.role_id | |
WHERE dataset_collection.id = %(id_1)s ORDER BY dataset_collection_element_1.element_index | |
Parameters: {'id_1': 96} | |
galaxy.model.orm.engine_factory DEBUG 2018-04-25 15:36:36,080 Request query: 0.005183(s) | |
SELECT dataset_collection.id AS dataset_collection_id, dataset_collection.collection_type AS dataset_collection_collection_type, dataset_collection.populated_state AS dataset_collection_populated_state, dataset_collection.populated_state_message AS dataset_collection_populated_state_message, dataset_collection.element_count AS dataset_collection_element_count, dataset_collection.create_time AS dataset_collection_create_time, dataset_collection.update_time AS dataset_collection_update_time, dataset_1.id AS dataset_1_id, dataset_1.create_time AS dataset_1_create_time, dataset_1.update_time AS dataset_1_update_time, dataset_1.state AS dataset_1_state, dataset_1.deleted AS dataset_1_deleted, dataset_1.purged AS dataset_1_purged, dataset_1.purgable AS dataset_1_purgable, dataset_1.object_store_id AS dataset_1_object_store_id, dataset_1.external_filename AS dataset_1_external_filename, dataset_1._extra_files_path AS dataset_1__extra_files_path, dataset_1.file_size AS dataset_1_file_size, dataset_1.total_size AS dataset_1_total_size, dataset_1.uuid AS dataset_1_uuid, role_1.id AS role_1_id, role_1.create_time AS role_1_create_time, role_1.update_time AS role_1_update_time, role_1.name AS role_1_name, role_1.description AS role_1_description, role_1.type AS role_1_type, role_1.deleted AS role_1_deleted, dataset_permissions_1.id AS dataset_permissions_1_id, dataset_permissions_1.create_time AS dataset_permissions_1_create_time, dataset_permissions_1.update_time AS dataset_permissions_1_update_time, dataset_permissions_1.action AS dataset_permissions_1_action, dataset_permissions_1.dataset_id AS dataset_permissions_1_dataset_id, dataset_permissions_1.role_id AS dataset_permissions_1_role_id, history_dataset_association_1.id AS history_dataset_association_1_id, history_dataset_association_1.history_id AS history_dataset_association_1_history_id, history_dataset_association_1.dataset_id AS history_dataset_association_1_dataset_id, history_dataset_association_1.create_time AS history_dataset_association_1_create_time, history_dataset_association_1.update_time AS history_dataset_association_1_update_time, history_dataset_association_1.state AS history_dataset_association_1_state, history_dataset_association_1.copied_from_history_dataset_association_id AS history_dataset_association_1_copied_from_history_dataset_1, history_dataset_association_1.copied_from_library_dataset_dataset_association_id AS history_dataset_association_1_copied_from_library_dataset_2, history_dataset_association_1.name AS history_dataset_association_1_name, history_dataset_association_1.info AS history_dataset_association_1_info, history_dataset_association_1.blurb AS history_dataset_association_1_blurb, history_dataset_association_1.peek AS history_dataset_association_1_peek, history_dataset_association_1.tool_version AS history_dataset_association_1_tool_version, history_dataset_association_1.extension AS history_dataset_association_1_extension, history_dataset_association_1.parent_id AS history_dataset_association_1_parent_id, history_dataset_association_1.designation AS history_dataset_association_1_designation, history_dataset_association_1.deleted AS history_dataset_association_1_deleted, history_dataset_association_1.visible AS history_dataset_association_1_visible, history_dataset_association_1.extended_metadata_id AS history_dataset_association_1_extended_metadata_id, history_dataset_association_1.version AS history_dataset_association_1_version, history_dataset_association_1.hid AS history_dataset_association_1_hid, history_dataset_association_1.purged AS history_dataset_association_1_purged, history_dataset_association_1.hidden_beneath_collection_instance_id AS history_dataset_association_1_hidden_beneath_collection_i_3, dataset_collection_element_1.id AS dataset_collection_element_1_id, dataset_collection_element_1.dataset_collection_id AS dataset_collection_element_1_dataset_collection_id, dataset_collection_element_1.hda_id AS dataset_collection_element_1_hda_id, dataset_collection_element_1.ldda_id AS dataset_collection_element_1_ldda_id, dataset_collection_element_1.child_collection_id AS dataset_collection_element_1_child_collection_id, dataset_collection_element_1.element_index AS dataset_collection_element_1_element_index, dataset_collection_element_1.element_identifier AS dataset_collection_element_1_element_identifier | |
FROM dataset_collection LEFT OUTER JOIN dataset_collection_element AS dataset_collection_element_1 ON dataset_collection.id = dataset_collection_element_1.dataset_collection_id LEFT OUTER JOIN history_dataset_association AS history_dataset_association_1 ON dataset_collection_element_1.hda_id = history_dataset_association_1.id LEFT OUTER JOIN dataset AS dataset_1 ON dataset_1.id = history_dataset_association_1.dataset_id LEFT OUTER JOIN dataset_permissions AS dataset_permissions_1 ON dataset_1.id = dataset_permissions_1.dataset_id LEFT OUTER JOIN role AS role_1 ON role_1.id = dataset_permissions_1.role_id | |
WHERE dataset_collection.id = %(id_1)s ORDER BY dataset_collection_element_1.element_index | |
Parameters: {'id_1': 97} | |
galaxy.model.orm.engine_factory DEBUG 2018-04-25 15:36:36,097 Request query: 0.006640(s) | |
SELECT dataset_collection.id AS dataset_collection_id, dataset_collection.collection_type AS dataset_collection_collection_type, dataset_collection.populated_state AS dataset_collection_populated_state, dataset_collection.populated_state_message AS dataset_collection_populated_state_message, dataset_collection.element_count AS dataset_collection_element_count, dataset_collection.create_time AS dataset_collection_create_time, dataset_collection.update_time AS dataset_collection_update_time, dataset_1.id AS dataset_1_id, dataset_1.create_time AS dataset_1_create_time, dataset_1.update_time AS dataset_1_update_time, dataset_1.state AS dataset_1_state, dataset_1.deleted AS dataset_1_deleted, dataset_1.purged AS dataset_1_purged, dataset_1.purgable AS dataset_1_purgable, dataset_1.object_store_id AS dataset_1_object_store_id, dataset_1.external_filename AS dataset_1_external_filename, dataset_1._extra_files_path AS dataset_1__extra_files_path, dataset_1.file_size AS dataset_1_file_size, dataset_1.total_size AS dataset_1_total_size, dataset_1.uuid AS dataset_1_uuid, role_1.id AS role_1_id, role_1.create_time AS role_1_create_time, role_1.update_time AS role_1_update_time, role_1.name AS role_1_name, role_1.description AS role_1_description, role_1.type AS role_1_type, role_1.deleted AS role_1_deleted, dataset_permissions_1.id AS dataset_permissions_1_id, dataset_permissions_1.create_time AS dataset_permissions_1_create_time, dataset_permissions_1.update_time AS dataset_permissions_1_update_time, dataset_permissions_1.action AS dataset_permissions_1_action, dataset_permissions_1.dataset_id AS dataset_permissions_1_dataset_id, dataset_permissions_1.role_id AS dataset_permissions_1_role_id, history_dataset_association_1.id AS history_dataset_association_1_id, history_dataset_association_1.history_id AS history_dataset_association_1_history_id, history_dataset_association_1.dataset_id AS history_dataset_association_1_dataset_id, history_dataset_association_1.create_time AS history_dataset_association_1_create_time, history_dataset_association_1.update_time AS history_dataset_association_1_update_time, history_dataset_association_1.state AS history_dataset_association_1_state, history_dataset_association_1.copied_from_history_dataset_association_id AS history_dataset_association_1_copied_from_history_dataset_1, history_dataset_association_1.copied_from_library_dataset_dataset_association_id AS history_dataset_association_1_copied_from_library_dataset_2, history_dataset_association_1.name AS history_dataset_association_1_name, history_dataset_association_1.info AS history_dataset_association_1_info, history_dataset_association_1.blurb AS history_dataset_association_1_blurb, history_dataset_association_1.peek AS history_dataset_association_1_peek, history_dataset_association_1.tool_version AS history_dataset_association_1_tool_version, history_dataset_association_1.extension AS history_dataset_association_1_extension, history_dataset_association_1.parent_id AS history_dataset_association_1_parent_id, history_dataset_association_1.designation AS history_dataset_association_1_designation, history_dataset_association_1.deleted AS history_dataset_association_1_deleted, history_dataset_association_1.visible AS history_dataset_association_1_visible, history_dataset_association_1.extended_metadata_id AS history_dataset_association_1_extended_metadata_id, history_dataset_association_1.version AS history_dataset_association_1_version, history_dataset_association_1.hid AS history_dataset_association_1_hid, history_dataset_association_1.purged AS history_dataset_association_1_purged, history_dataset_association_1.hidden_beneath_collection_instance_id AS history_dataset_association_1_hidden_beneath_collection_i_3, dataset_collection_element_1.id AS dataset_collection_element_1_id, dataset_collection_element_1.dataset_collection_id AS dataset_collection_element_1_dataset_collection_id, dataset_collection_element_1.hda_id AS dataset_collection_element_1_hda_id, dataset_collection_element_1.ldda_id AS dataset_collection_element_1_ldda_id, dataset_collection_element_1.child_collection_id AS dataset_collection_element_1_child_collection_id, dataset_collection_element_1.element_index AS dataset_collection_element_1_element_index, dataset_collection_element_1.element_identifier AS dataset_collection_element_1_element_identifier | |
FROM dataset_collection LEFT OUTER JOIN dataset_collection_element AS dataset_collection_element_1 ON dataset_collection.id = dataset_collection_element_1.dataset_collection_id LEFT OUTER JOIN history_dataset_association AS history_dataset_association_1 ON dataset_collection_element_1.hda_id = history_dataset_association_1.id LEFT OUTER JOIN dataset AS dataset_1 ON dataset_1.id = history_dataset_association_1.dataset_id LEFT OUTER JOIN dataset_permissions AS dataset_permissions_1 ON dataset_1.id = dataset_permissions_1.dataset_id LEFT OUTER JOIN role AS role_1 ON role_1.id = dataset_permissions_1.role_id | |
WHERE dataset_collection.id = %(id_1)s ORDER BY dataset_collection_element_1.element_index | |
Parameters: {'id_1': 98} | |
galaxy.model.orm.engine_factory DEBUG 2018-04-25 15:36:36,118 Request query: 0.005249(s) | |
SELECT dataset_collection.id AS dataset_collection_id, dataset_collection.collection_type AS dataset_collection_collection_type, dataset_collection.populated_state AS dataset_collection_populated_state, dataset_collection.populated_state_message AS dataset_collection_populated_state_message, dataset_collection.element_count AS dataset_collection_element_count, dataset_collection.create_time AS dataset_collection_create_time, dataset_collection.update_time AS dataset_collection_update_time, dataset_1.id AS dataset_1_id, dataset_1.create_time AS dataset_1_create_time, dataset_1.update_time AS dataset_1_update_time, dataset_1.state AS dataset_1_state, dataset_1.deleted AS dataset_1_deleted, dataset_1.purged AS dataset_1_purged, dataset_1.purgable AS dataset_1_purgable, dataset_1.object_store_id AS dataset_1_object_store_id, dataset_1.external_filename AS dataset_1_external_filename, dataset_1._extra_files_path AS dataset_1__extra_files_path, dataset_1.file_size AS dataset_1_file_size, dataset_1.total_size AS dataset_1_total_size, dataset_1.uuid AS dataset_1_uuid, role_1.id AS role_1_id, role_1.create_time AS role_1_create_time, role_1.update_time AS role_1_update_time, role_1.name AS role_1_name, role_1.description AS role_1_description, role_1.type AS role_1_type, role_1.deleted AS role_1_deleted, dataset_permissions_1.id AS dataset_permissions_1_id, dataset_permissions_1.create_time AS dataset_permissions_1_create_time, dataset_permissions_1.update_time AS dataset_permissions_1_update_time, dataset_permissions_1.action AS dataset_permissions_1_action, dataset_permissions_1.dataset_id AS dataset_permissions_1_dataset_id, dataset_permissions_1.role_id AS dataset_permissions_1_role_id, history_dataset_association_1.id AS history_dataset_association_1_id, history_dataset_association_1.history_id AS history_dataset_association_1_history_id, history_dataset_association_1.dataset_id AS history_dataset_association_1_dataset_id, history_dataset_association_1.create_time AS history_dataset_association_1_create_time, history_dataset_association_1.update_time AS history_dataset_association_1_update_time, history_dataset_association_1.state AS history_dataset_association_1_state, history_dataset_association_1.copied_from_history_dataset_association_id AS history_dataset_association_1_copied_from_history_dataset_1, history_dataset_association_1.copied_from_library_dataset_dataset_association_id AS history_dataset_association_1_copied_from_library_dataset_2, history_dataset_association_1.name AS history_dataset_association_1_name, history_dataset_association_1.info AS history_dataset_association_1_info, history_dataset_association_1.blurb AS history_dataset_association_1_blurb, history_dataset_association_1.peek AS history_dataset_association_1_peek, history_dataset_association_1.tool_version AS history_dataset_association_1_tool_version, history_dataset_association_1.extension AS history_dataset_association_1_extension, history_dataset_association_1.parent_id AS history_dataset_association_1_parent_id, history_dataset_association_1.designation AS history_dataset_association_1_designation, history_dataset_association_1.deleted AS history_dataset_association_1_deleted, history_dataset_association_1.visible AS history_dataset_association_1_visible, history_dataset_association_1.extended_metadata_id AS history_dataset_association_1_extended_metadata_id, history_dataset_association_1.version AS history_dataset_association_1_version, history_dataset_association_1.hid AS history_dataset_association_1_hid, history_dataset_association_1.purged AS history_dataset_association_1_purged, history_dataset_association_1.hidden_beneath_collection_instance_id AS history_dataset_association_1_hidden_beneath_collection_i_3, dataset_collection_element_1.id AS dataset_collection_element_1_id, dataset_collection_element_1.dataset_collection_id AS dataset_collection_element_1_dataset_collection_id, dataset_collection_element_1.hda_id AS dataset_collection_element_1_hda_id, dataset_collection_element_1.ldda_id AS dataset_collection_element_1_ldda_id, dataset_collection_element_1.child_collection_id AS dataset_collection_element_1_child_collection_id, dataset_collection_element_1.element_index AS dataset_collection_element_1_element_index, dataset_collection_element_1.element_identifier AS dataset_collection_element_1_element_identifier | |
FROM dataset_collection LEFT OUTER JOIN dataset_collection_element AS dataset_collection_element_1 ON dataset_collection.id = dataset_collection_element_1.dataset_collection_id LEFT OUTER JOIN history_dataset_association AS history_dataset_association_1 ON dataset_collection_element_1.hda_id = history_dataset_association_1.id LEFT OUTER JOIN dataset AS dataset_1 ON dataset_1.id = history_dataset_association_1.dataset_id LEFT OUTER JOIN dataset_permissions AS dataset_permissions_1 ON dataset_1.id = dataset_permissions_1.dataset_id LEFT OUTER JOIN role AS role_1 ON role_1.id = dataset_permissions_1.role_id | |
WHERE dataset_collection.id = %(id_1)s ORDER BY dataset_collection_element_1.element_index | |
Parameters: {'id_1': 99} | |
galaxy.model.orm.engine_factory DEBUG 2018-04-25 15:36:36,138 Request query: 0.011604(s) | |
SELECT dataset_collection.id AS dataset_collection_id, dataset_collection.collection_type AS dataset_collection_collection_type, dataset_collection.populated_state AS dataset_collection_populated_state, dataset_collection.populated_state_message AS dataset_collection_populated_state_message, dataset_collection.element_count AS dataset_collection_element_count, dataset_collection.create_time AS dataset_collection_create_time, dataset_collection.update_time AS dataset_collection_update_time, dataset_1.id AS dataset_1_id, dataset_1.create_time AS dataset_1_create_time, dataset_1.update_time AS dataset_1_update_time, dataset_1.state AS dataset_1_state, dataset_1.deleted AS dataset_1_deleted, dataset_1.purged AS dataset_1_purged, dataset_1.purgable AS dataset_1_purgable, dataset_1.object_store_id AS dataset_1_object_store_id, dataset_1.external_filename AS dataset_1_external_filename, dataset_1._extra_files_path AS dataset_1__extra_files_path, dataset_1.file_size AS dataset_1_file_size, dataset_1.total_size AS dataset_1_total_size, dataset_1.uuid AS dataset_1_uuid, role_1.id AS role_1_id, role_1.create_time AS role_1_create_time, role_1.update_time AS role_1_update_time, role_1.name AS role_1_name, role_1.description AS role_1_description, role_1.type AS role_1_type, role_1.deleted AS role_1_deleted, dataset_permissions_1.id AS dataset_permissions_1_id, dataset_permissions_1.create_time AS dataset_permissions_1_create_time, dataset_permissions_1.update_time AS dataset_permissions_1_update_time, dataset_permissions_1.action AS dataset_permissions_1_action, dataset_permissions_1.dataset_id AS dataset_permissions_1_dataset_id, dataset_permissions_1.role_id AS dataset_permissions_1_role_id, history_dataset_association_1.id AS history_dataset_association_1_id, history_dataset_association_1.history_id AS history_dataset_association_1_history_id, history_dataset_association_1.dataset_id AS history_dataset_association_1_dataset_id, history_dataset_association_1.create_time AS history_dataset_association_1_create_time, history_dataset_association_1.update_time AS history_dataset_association_1_update_time, history_dataset_association_1.state AS history_dataset_association_1_state, history_dataset_association_1.copied_from_history_dataset_association_id AS history_dataset_association_1_copied_from_history_dataset_1, history_dataset_association_1.copied_from_library_dataset_dataset_association_id AS history_dataset_association_1_copied_from_library_dataset_2, history_dataset_association_1.name AS history_dataset_association_1_name, history_dataset_association_1.info AS history_dataset_association_1_info, history_dataset_association_1.blurb AS history_dataset_association_1_blurb, history_dataset_association_1.peek AS history_dataset_association_1_peek, history_dataset_association_1.tool_version AS history_dataset_association_1_tool_version, history_dataset_association_1.extension AS history_dataset_association_1_extension, history_dataset_association_1.parent_id AS history_dataset_association_1_parent_id, history_dataset_association_1.designation AS history_dataset_association_1_designation, history_dataset_association_1.deleted AS history_dataset_association_1_deleted, history_dataset_association_1.visible AS history_dataset_association_1_visible, history_dataset_association_1.extended_metadata_id AS history_dataset_association_1_extended_metadata_id, history_dataset_association_1.version AS history_dataset_association_1_version, history_dataset_association_1.hid AS history_dataset_association_1_hid, history_dataset_association_1.purged AS history_dataset_association_1_purged, history_dataset_association_1.hidden_beneath_collection_instance_id AS history_dataset_association_1_hidden_beneath_collection_i_3, dataset_collection_element_1.id AS dataset_collection_element_1_id, dataset_collection_element_1.dataset_collection_id AS dataset_collection_element_1_dataset_collection_id, dataset_collection_element_1.hda_id AS dataset_collection_element_1_hda_id, dataset_collection_element_1.ldda_id AS dataset_collection_element_1_ldda_id, dataset_collection_element_1.child_collection_id AS dataset_collection_element_1_child_collection_id, dataset_collection_element_1.element_index AS dataset_collection_element_1_element_index, dataset_collection_element_1.element_identifier AS dataset_collection_element_1_element_identifier | |
FROM dataset_collection LEFT OUTER JOIN dataset_collection_element AS dataset_collection_element_1 ON dataset_collection.id = dataset_collection_element_1.dataset_collection_id LEFT OUTER JOIN history_dataset_association AS history_dataset_association_1 ON dataset_collection_element_1.hda_id = history_dataset_association_1.id LEFT OUTER JOIN dataset AS dataset_1 ON dataset_1.id = history_dataset_association_1.dataset_id LEFT OUTER JOIN dataset_permissions AS dataset_permissions_1 ON dataset_1.id = dataset_permissions_1.dataset_id LEFT OUTER JOIN role AS role_1 ON role_1.id = dataset_permissions_1.role_id | |
WHERE dataset_collection.id = %(id_1)s ORDER BY dataset_collection_element_1.element_index | |
Parameters: {'id_1': 100} | |
galaxy.model.orm.engine_factory DEBUG 2018-04-25 15:36:36,154 Request query: 0.005782(s) | |
SELECT dataset_collection.id AS dataset_collection_id, dataset_collection.collection_type AS dataset_collection_collection_type, dataset_collection.populated_state AS dataset_collection_populated_state, dataset_collection.populated_state_message AS dataset_collection_populated_state_message, dataset_collection.element_count AS dataset_collection_element_count, dataset_collection.create_time AS dataset_collection_create_time, dataset_collection.update_time AS dataset_collection_update_time, dataset_1.id AS dataset_1_id, dataset_1.create_time AS dataset_1_create_time, dataset_1.update_time AS dataset_1_update_time, dataset_1.state AS dataset_1_state, dataset_1.deleted AS dataset_1_deleted, dataset_1.purged AS dataset_1_purged, dataset_1.purgable AS dataset_1_purgable, dataset_1.object_store_id AS dataset_1_object_store_id, dataset_1.external_filename AS dataset_1_external_filename, dataset_1._extra_files_path AS dataset_1__extra_files_path, dataset_1.file_size AS dataset_1_file_size, dataset_1.total_size AS dataset_1_total_size, dataset_1.uuid AS dataset_1_uuid, role_1.id AS role_1_id, role_1.create_time AS role_1_create_time, role_1.update_time AS role_1_update_time, role_1.name AS role_1_name, role_1.description AS role_1_description, role_1.type AS role_1_type, role_1.deleted AS role_1_deleted, dataset_permissions_1.id AS dataset_permissions_1_id, dataset_permissions_1.create_time AS dataset_permissions_1_create_time, dataset_permissions_1.update_time AS dataset_permissions_1_update_time, dataset_permissions_1.action AS dataset_permissions_1_action, dataset_permissions_1.dataset_id AS dataset_permissions_1_dataset_id, dataset_permissions_1.role_id AS dataset_permissions_1_role_id, history_dataset_association_1.id AS history_dataset_association_1_id, history_dataset_association_1.history_id AS history_dataset_association_1_history_id, history_dataset_association_1.dataset_id AS history_dataset_association_1_dataset_id, history_dataset_association_1.create_time AS history_dataset_association_1_create_time, history_dataset_association_1.update_time AS history_dataset_association_1_update_time, history_dataset_association_1.state AS history_dataset_association_1_state, history_dataset_association_1.copied_from_history_dataset_association_id AS history_dataset_association_1_copied_from_history_dataset_1, history_dataset_association_1.copied_from_library_dataset_dataset_association_id AS history_dataset_association_1_copied_from_library_dataset_2, history_dataset_association_1.name AS history_dataset_association_1_name, history_dataset_association_1.info AS history_dataset_association_1_info, history_dataset_association_1.blurb AS history_dataset_association_1_blurb, history_dataset_association_1.peek AS history_dataset_association_1_peek, history_dataset_association_1.tool_version AS history_dataset_association_1_tool_version, history_dataset_association_1.extension AS history_dataset_association_1_extension, history_dataset_association_1.parent_id AS history_dataset_association_1_parent_id, history_dataset_association_1.designation AS history_dataset_association_1_designation, history_dataset_association_1.deleted AS history_dataset_association_1_deleted, history_dataset_association_1.visible AS history_dataset_association_1_visible, history_dataset_association_1.extended_metadata_id AS history_dataset_association_1_extended_metadata_id, history_dataset_association_1.version AS history_dataset_association_1_version, history_dataset_association_1.hid AS history_dataset_association_1_hid, history_dataset_association_1.purged AS history_dataset_association_1_purged, history_dataset_association_1.hidden_beneath_collection_instance_id AS history_dataset_association_1_hidden_beneath_collection_i_3, dataset_collection_element_1.id AS dataset_collection_element_1_id, dataset_collection_element_1.dataset_collection_id AS dataset_collection_element_1_dataset_collection_id, dataset_collection_element_1.hda_id AS dataset_collection_element_1_hda_id, dataset_collection_element_1.ldda_id AS dataset_collection_element_1_ldda_id, dataset_collection_element_1.child_collection_id AS dataset_collection_element_1_child_collection_id, dataset_collection_element_1.element_index AS dataset_collection_element_1_element_index, dataset_collection_element_1.element_identifier AS dataset_collection_element_1_element_identifier | |
FROM dataset_collection LEFT OUTER JOIN dataset_collection_element AS dataset_collection_element_1 ON dataset_collection.id = dataset_collection_element_1.dataset_collection_id LEFT OUTER JOIN history_dataset_association AS history_dataset_association_1 ON dataset_collection_element_1.hda_id = history_dataset_association_1.id LEFT OUTER JOIN dataset AS dataset_1 ON dataset_1.id = history_dataset_association_1.dataset_id LEFT OUTER JOIN dataset_permissions AS dataset_permissions_1 ON dataset_1.id = dataset_permissions_1.dataset_id LEFT OUTER JOIN role AS role_1 ON role_1.id = dataset_permissions_1.role_id | |
WHERE dataset_collection.id = %(id_1)s ORDER BY dataset_collection_element_1.element_index | |
Parameters: {'id_1': 101} | |
galaxy.model.orm.engine_factory DEBUG 2018-04-25 15:36:36,169 Request query: 0.005542(s) | |
SELECT dataset_collection.id AS dataset_collection_id, dataset_collection.collection_type AS dataset_collection_collection_type, dataset_collection.populated_state AS dataset_collection_populated_state, dataset_collection.populated_state_message AS dataset_collection_populated_state_message, dataset_collection.element_count AS dataset_collection_element_count, dataset_collection.create_time AS dataset_collection_create_time, dataset_collection.update_time AS dataset_collection_update_time, dataset_1.id AS dataset_1_id, dataset_1.create_time AS dataset_1_create_time, dataset_1.update_time AS dataset_1_update_time, dataset_1.state AS dataset_1_state, dataset_1.deleted AS dataset_1_deleted, dataset_1.purged AS dataset_1_purged, dataset_1.purgable AS dataset_1_purgable, dataset_1.object_store_id AS dataset_1_object_store_id, dataset_1.external_filename AS dataset_1_external_filename, dataset_1._extra_files_path AS dataset_1__extra_files_path, dataset_1.file_size AS dataset_1_file_size, dataset_1.total_size AS dataset_1_total_size, dataset_1.uuid AS dataset_1_uuid, role_1.id AS role_1_id, role_1.create_time AS role_1_create_time, role_1.update_time AS role_1_update_time, role_1.name AS role_1_name, role_1.description AS role_1_description, role_1.type AS role_1_type, role_1.deleted AS role_1_deleted, dataset_permissions_1.id AS dataset_permissions_1_id, dataset_permissions_1.create_time AS dataset_permissions_1_create_time, dataset_permissions_1.update_time AS dataset_permissions_1_update_time, dataset_permissions_1.action AS dataset_permissions_1_action, dataset_permissions_1.dataset_id AS dataset_permissions_1_dataset_id, dataset_permissions_1.role_id AS dataset_permissions_1_role_id, history_dataset_association_1.id AS history_dataset_association_1_id, history_dataset_association_1.history_id AS history_dataset_association_1_history_id, history_dataset_association_1.dataset_id AS history_dataset_association_1_dataset_id, history_dataset_association_1.create_time AS history_dataset_association_1_create_time, history_dataset_association_1.update_time AS history_dataset_association_1_update_time, history_dataset_association_1.state AS history_dataset_association_1_state, history_dataset_association_1.copied_from_history_dataset_association_id AS history_dataset_association_1_copied_from_history_dataset_1, history_dataset_association_1.copied_from_library_dataset_dataset_association_id AS history_dataset_association_1_copied_from_library_dataset_2, history_dataset_association_1.name AS history_dataset_association_1_name, history_dataset_association_1.info AS history_dataset_association_1_info, history_dataset_association_1.blurb AS history_dataset_association_1_blurb, history_dataset_association_1.peek AS history_dataset_association_1_peek, history_dataset_association_1.tool_version AS history_dataset_association_1_tool_version, history_dataset_association_1.extension AS history_dataset_association_1_extension, history_dataset_association_1.parent_id AS history_dataset_association_1_parent_id, history_dataset_association_1.designation AS history_dataset_association_1_designation, history_dataset_association_1.deleted AS history_dataset_association_1_deleted, history_dataset_association_1.visible AS history_dataset_association_1_visible, history_dataset_association_1.extended_metadata_id AS history_dataset_association_1_extended_metadata_id, history_dataset_association_1.version AS history_dataset_association_1_version, history_dataset_association_1.hid AS history_dataset_association_1_hid, history_dataset_association_1.purged AS history_dataset_association_1_purged, history_dataset_association_1.hidden_beneath_collection_instance_id AS history_dataset_association_1_hidden_beneath_collection_i_3, dataset_collection_element_1.id AS dataset_collection_element_1_id, dataset_collection_element_1.dataset_collection_id AS dataset_collection_element_1_dataset_collection_id, dataset_collection_element_1.hda_id AS dataset_collection_element_1_hda_id, dataset_collection_element_1.ldda_id AS dataset_collection_element_1_ldda_id, dataset_collection_element_1.child_collection_id AS dataset_collection_element_1_child_collection_id, dataset_collection_element_1.element_index AS dataset_collection_element_1_element_index, dataset_collection_element_1.element_identifier AS dataset_collection_element_1_element_identifier | |
FROM dataset_collection LEFT OUTER JOIN dataset_collection_element AS dataset_collection_element_1 ON dataset_collection.id = dataset_collection_element_1.dataset_collection_id LEFT OUTER JOIN history_dataset_association AS history_dataset_association_1 ON dataset_collection_element_1.hda_id = history_dataset_association_1.id LEFT OUTER JOIN dataset AS dataset_1 ON dataset_1.id = history_dataset_association_1.dataset_id LEFT OUTER JOIN dataset_permissions AS dataset_permissions_1 ON dataset_1.id = dataset_permissions_1.dataset_id LEFT OUTER JOIN role AS role_1 ON role_1.id = dataset_permissions_1.role_id | |
WHERE dataset_collection.id = %(id_1)s ORDER BY dataset_collection_element_1.element_index | |
Parameters: {'id_1': 119} | |
galaxy.model.orm.engine_factory DEBUG 2018-04-25 15:36:36,187 Request query: 0.006055(s) | |
SELECT dataset_collection.id AS dataset_collection_id, dataset_collection.collection_type AS dataset_collection_collection_type, dataset_collection.populated_state AS dataset_collection_populated_state, dataset_collection.populated_state_message AS dataset_collection_populated_state_message, dataset_collection.element_count AS dataset_collection_element_count, dataset_collection.create_time AS dataset_collection_create_time, dataset_collection.update_time AS dataset_collection_update_time, dataset_1.id AS dataset_1_id, dataset_1.create_time AS dataset_1_create_time, dataset_1.update_time AS dataset_1_update_time, dataset_1.state AS dataset_1_state, dataset_1.deleted AS dataset_1_deleted, dataset_1.purged AS dataset_1_purged, dataset_1.purgable AS dataset_1_purgable, dataset_1.object_store_id AS dataset_1_object_store_id, dataset_1.external_filename AS dataset_1_external_filename, dataset_1._extra_files_path AS dataset_1__extra_files_path, dataset_1.file_size AS dataset_1_file_size, dataset_1.total_size AS dataset_1_total_size, dataset_1.uuid AS dataset_1_uuid, role_1.id AS role_1_id, role_1.create_time AS role_1_create_time, role_1.update_time AS role_1_update_time, role_1.name AS role_1_name, role_1.description AS role_1_description, role_1.type AS role_1_type, role_1.deleted AS role_1_deleted, dataset_permissions_1.id AS dataset_permissions_1_id, dataset_permissions_1.create_time AS dataset_permissions_1_create_time, dataset_permissions_1.update_time AS dataset_permissions_1_update_time, dataset_permissions_1.action AS dataset_permissions_1_action, dataset_permissions_1.dataset_id AS dataset_permissions_1_dataset_id, dataset_permissions_1.role_id AS dataset_permissions_1_role_id, history_dataset_association_1.id AS history_dataset_association_1_id, history_dataset_association_1.history_id AS history_dataset_association_1_history_id, history_dataset_association_1.dataset_id AS history_dataset_association_1_dataset_id, history_dataset_association_1.create_time AS history_dataset_association_1_create_time, history_dataset_association_1.update_time AS history_dataset_association_1_update_time, history_dataset_association_1.state AS history_dataset_association_1_state, history_dataset_association_1.copied_from_history_dataset_association_id AS history_dataset_association_1_copied_from_history_dataset_1, history_dataset_association_1.copied_from_library_dataset_dataset_association_id AS history_dataset_association_1_copied_from_library_dataset_2, history_dataset_association_1.name AS history_dataset_association_1_name, history_dataset_association_1.info AS history_dataset_association_1_info, history_dataset_association_1.blurb AS history_dataset_association_1_blurb, history_dataset_association_1.peek AS history_dataset_association_1_peek, history_dataset_association_1.tool_version AS history_dataset_association_1_tool_version, history_dataset_association_1.extension AS history_dataset_association_1_extension, history_dataset_association_1.parent_id AS history_dataset_association_1_parent_id, history_dataset_association_1.designation AS history_dataset_association_1_designation, history_dataset_association_1.deleted AS history_dataset_association_1_deleted, history_dataset_association_1.visible AS history_dataset_association_1_visible, history_dataset_association_1.extended_metadata_id AS history_dataset_association_1_extended_metadata_id, history_dataset_association_1.version AS history_dataset_association_1_version, history_dataset_association_1.hid AS history_dataset_association_1_hid, history_dataset_association_1.purged AS history_dataset_association_1_purged, history_dataset_association_1.hidden_beneath_collection_instance_id AS history_dataset_association_1_hidden_beneath_collection_i_3, dataset_collection_element_1.id AS dataset_collection_element_1_id, dataset_collection_element_1.dataset_collection_id AS dataset_collection_element_1_dataset_collection_id, dataset_collection_element_1.hda_id AS dataset_collection_element_1_hda_id, dataset_collection_element_1.ldda_id AS dataset_collection_element_1_ldda_id, dataset_collection_element_1.child_collection_id AS dataset_collection_element_1_child_collection_id, dataset_collection_element_1.element_index AS dataset_collection_element_1_element_index, dataset_collection_element_1.element_identifier AS dataset_collection_element_1_element_identifier | |
FROM dataset_collection LEFT OUTER JOIN dataset_collection_element AS dataset_collection_element_1 ON dataset_collection.id = dataset_collection_element_1.dataset_collection_id LEFT OUTER JOIN history_dataset_association AS history_dataset_association_1 ON dataset_collection_element_1.hda_id = history_dataset_association_1.id LEFT OUTER JOIN dataset AS dataset_1 ON dataset_1.id = history_dataset_association_1.dataset_id LEFT OUTER JOIN dataset_permissions AS dataset_permissions_1 ON dataset_1.id = dataset_permissions_1.dataset_id LEFT OUTER JOIN role AS role_1 ON role_1.id = dataset_permissions_1.role_id | |
WHERE dataset_collection.id = %(id_1)s ORDER BY dataset_collection_element_1.element_index | |
Parameters: {'id_1': 121} | |
galaxy.model.orm.engine_factory DEBUG 2018-04-25 15:36:36,216 Request query: 0.006827(s) | |
SELECT dataset_collection.id AS dataset_collection_id, dataset_collection.collection_type AS dataset_collection_collection_type, dataset_collection.populated_state AS dataset_collection_populated_state, dataset_collection.populated_state_message AS dataset_collection_populated_state_message, dataset_collection.element_count AS dataset_collection_element_count, dataset_collection.create_time AS dataset_collection_create_time, dataset_collection.update_time AS dataset_collection_update_time, dataset_1.id AS dataset_1_id, dataset_1.create_time AS dataset_1_create_time, dataset_1.update_time AS dataset_1_update_time, dataset_1.state AS dataset_1_state, dataset_1.deleted AS dataset_1_deleted, dataset_1.purged AS dataset_1_purged, dataset_1.purgable AS dataset_1_purgable, dataset_1.object_store_id AS dataset_1_object_store_id, dataset_1.external_filename AS dataset_1_external_filename, dataset_1._extra_files_path AS dataset_1__extra_files_path, dataset_1.file_size AS dataset_1_file_size, dataset_1.total_size AS dataset_1_total_size, dataset_1.uuid AS dataset_1_uuid, role_1.id AS role_1_id, role_1.create_time AS role_1_create_time, role_1.update_time AS role_1_update_time, role_1.name AS role_1_name, role_1.description AS role_1_description, role_1.type AS role_1_type, role_1.deleted AS role_1_deleted, dataset_permissions_1.id AS dataset_permissions_1_id, dataset_permissions_1.create_time AS dataset_permissions_1_create_time, dataset_permissions_1.update_time AS dataset_permissions_1_update_time, dataset_permissions_1.action AS dataset_permissions_1_action, dataset_permissions_1.dataset_id AS dataset_permissions_1_dataset_id, dataset_permissions_1.role_id AS dataset_permissions_1_role_id, history_dataset_association_1.id AS history_dataset_association_1_id, history_dataset_association_1.history_id AS history_dataset_association_1_history_id, history_dataset_association_1.dataset_id AS history_dataset_association_1_dataset_id, history_dataset_association_1.create_time AS history_dataset_association_1_create_time, history_dataset_association_1.update_time AS history_dataset_association_1_update_time, history_dataset_association_1.state AS history_dataset_association_1_state, history_dataset_association_1.copied_from_history_dataset_association_id AS history_dataset_association_1_copied_from_history_dataset_1, history_dataset_association_1.copied_from_library_dataset_dataset_association_id AS history_dataset_association_1_copied_from_library_dataset_2, history_dataset_association_1.name AS history_dataset_association_1_name, history_dataset_association_1.info AS history_dataset_association_1_info, history_dataset_association_1.blurb AS history_dataset_association_1_blurb, history_dataset_association_1.peek AS history_dataset_association_1_peek, history_dataset_association_1.tool_version AS history_dataset_association_1_tool_version, history_dataset_association_1.extension AS history_dataset_association_1_extension, history_dataset_association_1.parent_id AS history_dataset_association_1_parent_id, history_dataset_association_1.designation AS history_dataset_association_1_designation, history_dataset_association_1.deleted AS history_dataset_association_1_deleted, history_dataset_association_1.visible AS history_dataset_association_1_visible, history_dataset_association_1.extended_metadata_id AS history_dataset_association_1_extended_metadata_id, history_dataset_association_1.version AS history_dataset_association_1_version, history_dataset_association_1.hid AS history_dataset_association_1_hid, history_dataset_association_1.purged AS history_dataset_association_1_purged, history_dataset_association_1.hidden_beneath_collection_instance_id AS history_dataset_association_1_hidden_beneath_collection_i_3, dataset_collection_element_1.id AS dataset_collection_element_1_id, dataset_collection_element_1.dataset_collection_id AS dataset_collection_element_1_dataset_collection_id, dataset_collection_element_1.hda_id AS dataset_collection_element_1_hda_id, dataset_collection_element_1.ldda_id AS dataset_collection_element_1_ldda_id, dataset_collection_element_1.child_collection_id AS dataset_collection_element_1_child_collection_id, dataset_collection_element_1.element_index AS dataset_collection_element_1_element_index, dataset_collection_element_1.element_identifier AS dataset_collection_element_1_element_identifier, dataset_collection_1.id AS dataset_collection_1_id, dataset_collection_1.collection_type AS dataset_collection_1_collection_type, dataset_collection_1.populated_state AS dataset_collection_1_populated_state, dataset_collection_1.populated_state_message AS dataset_collection_1_populated_state_message, dataset_collection_1.element_count AS dataset_collection_1_element_count, dataset_collection_1.create_time AS dataset_collection_1_create_time, dataset_collection_1.update_time AS dataset_collection_1_update_time, dataset_collection_element_2.id AS dataset_collection_element_2_id, dataset_collection_element_2.dataset_collection_id AS dataset_collection_element_2_dataset_collection_id, dataset_collection_element_2.hda_id AS dataset_collection_element_2_hda_id, dataset_collection_element_2.ldda_id AS dataset_collection_element_2_ldda_id, dataset_collection_element_2.child_collection_id AS dataset_collection_element_2_child_collection_id, dataset_collection_element_2.element_index AS dataset_collection_element_2_element_index, dataset_collection_element_2.element_identifier AS dataset_collection_element_2_element_identifier | |
FROM dataset_collection LEFT OUTER JOIN dataset_collection_element AS dataset_collection_element_2 ON dataset_collection.id = dataset_collection_element_2.dataset_collection_id LEFT OUTER JOIN dataset_collection AS dataset_collection_1 ON dataset_collection_element_2.child_collection_id = dataset_collection_1.id LEFT OUTER JOIN dataset_collection_element AS dataset_collection_element_1 ON dataset_collection_1.id = dataset_collection_element_1.dataset_collection_id LEFT OUTER JOIN history_dataset_association AS history_dataset_association_1 ON dataset_collection_element_1.hda_id = history_dataset_association_1.id LEFT OUTER JOIN dataset AS dataset_1 ON dataset_1.id = history_dataset_association_1.dataset_id LEFT OUTER JOIN dataset_permissions AS dataset_permissions_1 ON dataset_1.id = dataset_permissions_1.dataset_id LEFT OUTER JOIN role AS role_1 ON role_1.id = dataset_permissions_1.role_id | |
WHERE dataset_collection.id = %(id_1)s ORDER BY dataset_collection_element_2.element_index, dataset_collection_element_1.element_index | |
Parameters: {'id_1': 122} | |
galaxy.model.orm.engine_factory DEBUG 2018-04-25 15:36:36,235 Request query: 0.005528(s) | |
SELECT dataset_collection.id AS dataset_collection_id, dataset_collection.collection_type AS dataset_collection_collection_type, dataset_collection.populated_state AS dataset_collection_populated_state, dataset_collection.populated_state_message AS dataset_collection_populated_state_message, dataset_collection.element_count AS dataset_collection_element_count, dataset_collection.create_time AS dataset_collection_create_time, dataset_collection.update_time AS dataset_collection_update_time, dataset_1.id AS dataset_1_id, dataset_1.create_time AS dataset_1_create_time, dataset_1.update_time AS dataset_1_update_time, dataset_1.state AS dataset_1_state, dataset_1.deleted AS dataset_1_deleted, dataset_1.purged AS dataset_1_purged, dataset_1.purgable AS dataset_1_purgable, dataset_1.object_store_id AS dataset_1_object_store_id, dataset_1.external_filename AS dataset_1_external_filename, dataset_1._extra_files_path AS dataset_1__extra_files_path, dataset_1.file_size AS dataset_1_file_size, dataset_1.total_size AS dataset_1_total_size, dataset_1.uuid AS dataset_1_uuid, role_1.id AS role_1_id, role_1.create_time AS role_1_create_time, role_1.update_time AS role_1_update_time, role_1.name AS role_1_name, role_1.description AS role_1_description, role_1.type AS role_1_type, role_1.deleted AS role_1_deleted, dataset_permissions_1.id AS dataset_permissions_1_id, dataset_permissions_1.create_time AS dataset_permissions_1_create_time, dataset_permissions_1.update_time AS dataset_permissions_1_update_time, dataset_permissions_1.action AS dataset_permissions_1_action, dataset_permissions_1.dataset_id AS dataset_permissions_1_dataset_id, dataset_permissions_1.role_id AS dataset_permissions_1_role_id, history_dataset_association_1.id AS history_dataset_association_1_id, history_dataset_association_1.history_id AS history_dataset_association_1_history_id, history_dataset_association_1.dataset_id AS history_dataset_association_1_dataset_id, history_dataset_association_1.create_time AS history_dataset_association_1_create_time, history_dataset_association_1.update_time AS history_dataset_association_1_update_time, history_dataset_association_1.state AS history_dataset_association_1_state, history_dataset_association_1.copied_from_history_dataset_association_id AS history_dataset_association_1_copied_from_history_dataset_1, history_dataset_association_1.copied_from_library_dataset_dataset_association_id AS history_dataset_association_1_copied_from_library_dataset_2, history_dataset_association_1.name AS history_dataset_association_1_name, history_dataset_association_1.info AS history_dataset_association_1_info, history_dataset_association_1.blurb AS history_dataset_association_1_blurb, history_dataset_association_1.peek AS history_dataset_association_1_peek, history_dataset_association_1.tool_version AS history_dataset_association_1_tool_version, history_dataset_association_1.extension AS history_dataset_association_1_extension, history_dataset_association_1.parent_id AS history_dataset_association_1_parent_id, history_dataset_association_1.designation AS history_dataset_association_1_designation, history_dataset_association_1.deleted AS history_dataset_association_1_deleted, history_dataset_association_1.visible AS history_dataset_association_1_visible, history_dataset_association_1.extended_metadata_id AS history_dataset_association_1_extended_metadata_id, history_dataset_association_1.version AS history_dataset_association_1_version, history_dataset_association_1.hid AS history_dataset_association_1_hid, history_dataset_association_1.purged AS history_dataset_association_1_purged, history_dataset_association_1.hidden_beneath_collection_instance_id AS history_dataset_association_1_hidden_beneath_collection_i_3, dataset_collection_element_1.id AS dataset_collection_element_1_id, dataset_collection_element_1.dataset_collection_id AS dataset_collection_element_1_dataset_collection_id, dataset_collection_element_1.hda_id AS dataset_collection_element_1_hda_id, dataset_collection_element_1.ldda_id AS dataset_collection_element_1_ldda_id, dataset_collection_element_1.child_collection_id AS dataset_collection_element_1_child_collection_id, dataset_collection_element_1.element_index AS dataset_collection_element_1_element_index, dataset_collection_element_1.element_identifier AS dataset_collection_element_1_element_identifier | |
FROM dataset_collection LEFT OUTER JOIN dataset_collection_element AS dataset_collection_element_1 ON dataset_collection.id = dataset_collection_element_1.dataset_collection_id LEFT OUTER JOIN history_dataset_association AS history_dataset_association_1 ON dataset_collection_element_1.hda_id = history_dataset_association_1.id LEFT OUTER JOIN dataset AS dataset_1 ON dataset_1.id = history_dataset_association_1.dataset_id LEFT OUTER JOIN dataset_permissions AS dataset_permissions_1 ON dataset_1.id = dataset_permissions_1.dataset_id LEFT OUTER JOIN role AS role_1 ON role_1.id = dataset_permissions_1.role_id | |
WHERE dataset_collection.id = %(id_1)s ORDER BY dataset_collection_element_1.element_index | |
Parameters: {'id_1': 126} | |
galaxy.model.orm.engine_factory DEBUG 2018-04-25 15:36:36,269 Request query: 0.022667(s) | |
SELECT dataset_collection.id AS dataset_collection_id, dataset_collection.collection_type AS dataset_collection_collection_type, dataset_collection.populated_state AS dataset_collection_populated_state, dataset_collection.populated_state_message AS dataset_collection_populated_state_message, dataset_collection.element_count AS dataset_collection_element_count, dataset_collection.create_time AS dataset_collection_create_time, dataset_collection.update_time AS dataset_collection_update_time, dataset_1.id AS dataset_1_id, dataset_1.create_time AS dataset_1_create_time, dataset_1.update_time AS dataset_1_update_time, dataset_1.state AS dataset_1_state, dataset_1.deleted AS dataset_1_deleted, dataset_1.purged AS dataset_1_purged, dataset_1.purgable AS dataset_1_purgable, dataset_1.object_store_id AS dataset_1_object_store_id, dataset_1.external_filename AS dataset_1_external_filename, dataset_1._extra_files_path AS dataset_1__extra_files_path, dataset_1.file_size AS dataset_1_file_size, dataset_1.total_size AS dataset_1_total_size, dataset_1.uuid AS dataset_1_uuid, role_1.id AS role_1_id, role_1.create_time AS role_1_create_time, role_1.update_time AS role_1_update_time, role_1.name AS role_1_name, role_1.description AS role_1_description, role_1.type AS role_1_type, role_1.deleted AS role_1_deleted, dataset_permissions_1.id AS dataset_permissions_1_id, dataset_permissions_1.create_time AS dataset_permissions_1_create_time, dataset_permissions_1.update_time AS dataset_permissions_1_update_time, dataset_permissions_1.action AS dataset_permissions_1_action, dataset_permissions_1.dataset_id AS dataset_permissions_1_dataset_id, dataset_permissions_1.role_id AS dataset_permissions_1_role_id, history_dataset_association_1.id AS history_dataset_association_1_id, history_dataset_association_1.history_id AS history_dataset_association_1_history_id, history_dataset_association_1.dataset_id AS history_dataset_association_1_dataset_id, history_dataset_association_1.create_time AS history_dataset_association_1_create_time, history_dataset_association_1.update_time AS history_dataset_association_1_update_time, history_dataset_association_1.state AS history_dataset_association_1_state, history_dataset_association_1.copied_from_history_dataset_association_id AS history_dataset_association_1_copied_from_history_dataset_1, history_dataset_association_1.copied_from_library_dataset_dataset_association_id AS history_dataset_association_1_copied_from_library_dataset_2, history_dataset_association_1.name AS history_dataset_association_1_name, history_dataset_association_1.info AS history_dataset_association_1_info, history_dataset_association_1.blurb AS history_dataset_association_1_blurb, history_dataset_association_1.peek AS history_dataset_association_1_peek, history_dataset_association_1.tool_version AS history_dataset_association_1_tool_version, history_dataset_association_1.extension AS history_dataset_association_1_extension, history_dataset_association_1.parent_id AS history_dataset_association_1_parent_id, history_dataset_association_1.designation AS history_dataset_association_1_designation, history_dataset_association_1.deleted AS history_dataset_association_1_deleted, history_dataset_association_1.visible AS history_dataset_association_1_visible, history_dataset_association_1.extended_metadata_id AS history_dataset_association_1_extended_metadata_id, history_dataset_association_1.version AS history_dataset_association_1_version, history_dataset_association_1.hid AS history_dataset_association_1_hid, history_dataset_association_1.purged AS history_dataset_association_1_purged, history_dataset_association_1.hidden_beneath_collection_instance_id AS history_dataset_association_1_hidden_beneath_collection_i_3, dataset_collection_element_1.id AS dataset_collection_element_1_id, dataset_collection_element_1.dataset_collection_id AS dataset_collection_element_1_dataset_collection_id, dataset_collection_element_1.hda_id AS dataset_collection_element_1_hda_id, dataset_collection_element_1.ldda_id AS dataset_collection_element_1_ldda_id, dataset_collection_element_1.child_collection_id AS dataset_collection_element_1_child_collection_id, dataset_collection_element_1.element_index AS dataset_collection_element_1_element_index, dataset_collection_element_1.element_identifier AS dataset_collection_element_1_element_identifier | |
FROM dataset_collection LEFT OUTER JOIN dataset_collection_element AS dataset_collection_element_1 ON dataset_collection.id = dataset_collection_element_1.dataset_collection_id LEFT OUTER JOIN history_dataset_association AS history_dataset_association_1 ON dataset_collection_element_1.hda_id = history_dataset_association_1.id LEFT OUTER JOIN dataset AS dataset_1 ON dataset_1.id = history_dataset_association_1.dataset_id LEFT OUTER JOIN dataset_permissions AS dataset_permissions_1 ON dataset_1.id = dataset_permissions_1.dataset_id LEFT OUTER JOIN role AS role_1 ON role_1.id = dataset_permissions_1.role_id | |
WHERE dataset_collection.id = %(id_1)s ORDER BY dataset_collection_element_1.element_index | |
Parameters: {'id_1': 127} | |
galaxy.model.orm.engine_factory DEBUG 2018-04-25 15:36:36,541 Request query: 0.024074(s) | |
SELECT dataset_collection.id AS dataset_collection_id, dataset_collection.collection_type AS dataset_collection_collection_type, dataset_collection.populated_state AS dataset_collection_populated_state, dataset_collection.populated_state_message AS dataset_collection_populated_state_message, dataset_collection.element_count AS dataset_collection_element_count, dataset_collection.create_time AS dataset_collection_create_time, dataset_collection.update_time AS dataset_collection_update_time, dataset_1.id AS dataset_1_id, dataset_1.create_time AS dataset_1_create_time, dataset_1.update_time AS dataset_1_update_time, dataset_1.state AS dataset_1_state, dataset_1.deleted AS dataset_1_deleted, dataset_1.purged AS dataset_1_purged, dataset_1.purgable AS dataset_1_purgable, dataset_1.object_store_id AS dataset_1_object_store_id, dataset_1.external_filename AS dataset_1_external_filename, dataset_1._extra_files_path AS dataset_1__extra_files_path, dataset_1.file_size AS dataset_1_file_size, dataset_1.total_size AS dataset_1_total_size, dataset_1.uuid AS dataset_1_uuid, role_1.id AS role_1_id, role_1.create_time AS role_1_create_time, role_1.update_time AS role_1_update_time, role_1.name AS role_1_name, role_1.description AS role_1_description, role_1.type AS role_1_type, role_1.deleted AS role_1_deleted, dataset_permissions_1.id AS dataset_permissions_1_id, dataset_permissions_1.create_time AS dataset_permissions_1_create_time, dataset_permissions_1.update_time AS dataset_permissions_1_update_time, dataset_permissions_1.action AS dataset_permissions_1_action, dataset_permissions_1.dataset_id AS dataset_permissions_1_dataset_id, dataset_permissions_1.role_id AS dataset_permissions_1_role_id, history_dataset_association_1.id AS history_dataset_association_1_id, history_dataset_association_1.history_id AS history_dataset_association_1_history_id, history_dataset_association_1.dataset_id AS history_dataset_association_1_dataset_id, history_dataset_association_1.create_time AS history_dataset_association_1_create_time, history_dataset_association_1.update_time AS history_dataset_association_1_update_time, history_dataset_association_1.state AS history_dataset_association_1_state, history_dataset_association_1.copied_from_history_dataset_association_id AS history_dataset_association_1_copied_from_history_dataset_1, history_dataset_association_1.copied_from_library_dataset_dataset_association_id AS history_dataset_association_1_copied_from_library_dataset_2, history_dataset_association_1.name AS history_dataset_association_1_name, history_dataset_association_1.info AS history_dataset_association_1_info, history_dataset_association_1.blurb AS history_dataset_association_1_blurb, history_dataset_association_1.peek AS history_dataset_association_1_peek, history_dataset_association_1.tool_version AS history_dataset_association_1_tool_version, history_dataset_association_1.extension AS history_dataset_association_1_extension, history_dataset_association_1.parent_id AS history_dataset_association_1_parent_id, history_dataset_association_1.designation AS history_dataset_association_1_designation, history_dataset_association_1.deleted AS history_dataset_association_1_deleted, history_dataset_association_1.visible AS history_dataset_association_1_visible, history_dataset_association_1.extended_metadata_id AS history_dataset_association_1_extended_metadata_id, history_dataset_association_1.version AS history_dataset_association_1_version, history_dataset_association_1.hid AS history_dataset_association_1_hid, history_dataset_association_1.purged AS history_dataset_association_1_purged, history_dataset_association_1.hidden_beneath_collection_instance_id AS history_dataset_association_1_hidden_beneath_collection_i_3, dataset_collection_element_1.id AS dataset_collection_element_1_id, dataset_collection_element_1.dataset_collection_id AS dataset_collection_element_1_dataset_collection_id, dataset_collection_element_1.hda_id AS dataset_collection_element_1_hda_id, dataset_collection_element_1.ldda_id AS dataset_collection_element_1_ldda_id, dataset_collection_element_1.child_collection_id AS dataset_collection_element_1_child_collection_id, dataset_collection_element_1.element_index AS dataset_collection_element_1_element_index, dataset_collection_element_1.element_identifier AS dataset_collection_element_1_element_identifier | |
FROM dataset_collection LEFT OUTER JOIN dataset_collection_element AS dataset_collection_element_1 ON dataset_collection.id = dataset_collection_element_1.dataset_collection_id LEFT OUTER JOIN history_dataset_association AS history_dataset_association_1 ON dataset_collection_element_1.hda_id = history_dataset_association_1.id LEFT OUTER JOIN dataset AS dataset_1 ON dataset_1.id = history_dataset_association_1.dataset_id LEFT OUTER JOIN dataset_permissions AS dataset_permissions_1 ON dataset_1.id = dataset_permissions_1.dataset_id LEFT OUTER JOIN role AS role_1 ON role_1.id = dataset_permissions_1.role_id | |
WHERE dataset_collection.id = %(id_1)s ORDER BY dataset_collection_element_1.element_index | |
Parameters: {'id_1': 128} | |
galaxy.model.orm.engine_factory DEBUG 2018-04-25 15:36:36,773 Request query: 0.014539(s) | |
SELECT dataset_collection.id AS dataset_collection_id, dataset_collection.collection_type AS dataset_collection_collection_type, dataset_collection.populated_state AS dataset_collection_populated_state, dataset_collection.populated_state_message AS dataset_collection_populated_state_message, dataset_collection.element_count AS dataset_collection_element_count, dataset_collection.create_time AS dataset_collection_create_time, dataset_collection.update_time AS dataset_collection_update_time, dataset_1.id AS dataset_1_id, dataset_1.create_time AS dataset_1_create_time, dataset_1.update_time AS dataset_1_update_time, dataset_1.state AS dataset_1_state, dataset_1.deleted AS dataset_1_deleted, dataset_1.purged AS dataset_1_purged, dataset_1.purgable AS dataset_1_purgable, dataset_1.object_store_id AS dataset_1_object_store_id, dataset_1.external_filename AS dataset_1_external_filename, dataset_1._extra_files_path AS dataset_1__extra_files_path, dataset_1.file_size AS dataset_1_file_size, dataset_1.total_size AS dataset_1_total_size, dataset_1.uuid AS dataset_1_uuid, role_1.id AS role_1_id, role_1.create_time AS role_1_create_time, role_1.update_time AS role_1_update_time, role_1.name AS role_1_name, role_1.description AS role_1_description, role_1.type AS role_1_type, role_1.deleted AS role_1_deleted, dataset_permissions_1.id AS dataset_permissions_1_id, dataset_permissions_1.create_time AS dataset_permissions_1_create_time, dataset_permissions_1.update_time AS dataset_permissions_1_update_time, dataset_permissions_1.action AS dataset_permissions_1_action, dataset_permissions_1.dataset_id AS dataset_permissions_1_dataset_id, dataset_permissions_1.role_id AS dataset_permissions_1_role_id, history_dataset_association_1.id AS history_dataset_association_1_id, history_dataset_association_1.history_id AS history_dataset_association_1_history_id, history_dataset_association_1.dataset_id AS history_dataset_association_1_dataset_id, history_dataset_association_1.create_time AS history_dataset_association_1_create_time, history_dataset_association_1.update_time AS history_dataset_association_1_update_time, history_dataset_association_1.state AS history_dataset_association_1_state, history_dataset_association_1.copied_from_history_dataset_association_id AS history_dataset_association_1_copied_from_history_dataset_1, history_dataset_association_1.copied_from_library_dataset_dataset_association_id AS history_dataset_association_1_copied_from_library_dataset_2, history_dataset_association_1.name AS history_dataset_association_1_name, history_dataset_association_1.info AS history_dataset_association_1_info, history_dataset_association_1.blurb AS history_dataset_association_1_blurb, history_dataset_association_1.peek AS history_dataset_association_1_peek, history_dataset_association_1.tool_version AS history_dataset_association_1_tool_version, history_dataset_association_1.extension AS history_dataset_association_1_extension, history_dataset_association_1.parent_id AS history_dataset_association_1_parent_id, history_dataset_association_1.designation AS history_dataset_association_1_designation, history_dataset_association_1.deleted AS history_dataset_association_1_deleted, history_dataset_association_1.visible AS history_dataset_association_1_visible, history_dataset_association_1.extended_metadata_id AS history_dataset_association_1_extended_metadata_id, history_dataset_association_1.version AS history_dataset_association_1_version, history_dataset_association_1.hid AS history_dataset_association_1_hid, history_dataset_association_1.purged AS history_dataset_association_1_purged, history_dataset_association_1.hidden_beneath_collection_instance_id AS history_dataset_association_1_hidden_beneath_collection_i_3, dataset_collection_element_1.id AS dataset_collection_element_1_id, dataset_collection_element_1.dataset_collection_id AS dataset_collection_element_1_dataset_collection_id, dataset_collection_element_1.hda_id AS dataset_collection_element_1_hda_id, dataset_collection_element_1.ldda_id AS dataset_collection_element_1_ldda_id, dataset_collection_element_1.child_collection_id AS dataset_collection_element_1_child_collection_id, dataset_collection_element_1.element_index AS dataset_collection_element_1_element_index, dataset_collection_element_1.element_identifier AS dataset_collection_element_1_element_identifier | |
FROM dataset_collection LEFT OUTER JOIN dataset_collection_element AS dataset_collection_element_1 ON dataset_collection.id = dataset_collection_element_1.dataset_collection_id LEFT OUTER JOIN history_dataset_association AS history_dataset_association_1 ON dataset_collection_element_1.hda_id = history_dataset_association_1.id LEFT OUTER JOIN dataset AS dataset_1 ON dataset_1.id = history_dataset_association_1.dataset_id LEFT OUTER JOIN dataset_permissions AS dataset_permissions_1 ON dataset_1.id = dataset_permissions_1.dataset_id LEFT OUTER JOIN role AS role_1 ON role_1.id = dataset_permissions_1.role_id | |
WHERE dataset_collection.id = %(id_1)s ORDER BY dataset_collection_element_1.element_index | |
Parameters: {'id_1': 129} | |
galaxy.model.orm.engine_factory DEBUG 2018-04-25 15:36:37,003 Request query: 0.014198(s) | |
SELECT dataset_collection.id AS dataset_collection_id, dataset_collection.collection_type AS dataset_collection_collection_type, dataset_collection.populated_state AS dataset_collection_populated_state, dataset_collection.populated_state_message AS dataset_collection_populated_state_message, dataset_collection.element_count AS dataset_collection_element_count, dataset_collection.create_time AS dataset_collection_create_time, dataset_collection.update_time AS dataset_collection_update_time, dataset_1.id AS dataset_1_id, dataset_1.create_time AS dataset_1_create_time, dataset_1.update_time AS dataset_1_update_time, dataset_1.state AS dataset_1_state, dataset_1.deleted AS dataset_1_deleted, dataset_1.purged AS dataset_1_purged, dataset_1.purgable AS dataset_1_purgable, dataset_1.object_store_id AS dataset_1_object_store_id, dataset_1.external_filename AS dataset_1_external_filename, dataset_1._extra_files_path AS dataset_1__extra_files_path, dataset_1.file_size AS dataset_1_file_size, dataset_1.total_size AS dataset_1_total_size, dataset_1.uuid AS dataset_1_uuid, role_1.id AS role_1_id, role_1.create_time AS role_1_create_time, role_1.update_time AS role_1_update_time, role_1.name AS role_1_name, role_1.description AS role_1_description, role_1.type AS role_1_type, role_1.deleted AS role_1_deleted, dataset_permissions_1.id AS dataset_permissions_1_id, dataset_permissions_1.create_time AS dataset_permissions_1_create_time, dataset_permissions_1.update_time AS dataset_permissions_1_update_time, dataset_permissions_1.action AS dataset_permissions_1_action, dataset_permissions_1.dataset_id AS dataset_permissions_1_dataset_id, dataset_permissions_1.role_id AS dataset_permissions_1_role_id, history_dataset_association_1.id AS history_dataset_association_1_id, history_dataset_association_1.history_id AS history_dataset_association_1_history_id, history_dataset_association_1.dataset_id AS history_dataset_association_1_dataset_id, history_dataset_association_1.create_time AS history_dataset_association_1_create_time, history_dataset_association_1.update_time AS history_dataset_association_1_update_time, history_dataset_association_1.state AS history_dataset_association_1_state, history_dataset_association_1.copied_from_history_dataset_association_id AS history_dataset_association_1_copied_from_history_dataset_1, history_dataset_association_1.copied_from_library_dataset_dataset_association_id AS history_dataset_association_1_copied_from_library_dataset_2, history_dataset_association_1.name AS history_dataset_association_1_name, history_dataset_association_1.info AS history_dataset_association_1_info, history_dataset_association_1.blurb AS history_dataset_association_1_blurb, history_dataset_association_1.peek AS history_dataset_association_1_peek, history_dataset_association_1.tool_version AS history_dataset_association_1_tool_version, history_dataset_association_1.extension AS history_dataset_association_1_extension, history_dataset_association_1.parent_id AS history_dataset_association_1_parent_id, history_dataset_association_1.designation AS history_dataset_association_1_designation, history_dataset_association_1.deleted AS history_dataset_association_1_deleted, history_dataset_association_1.visible AS history_dataset_association_1_visible, history_dataset_association_1.extended_metadata_id AS history_dataset_association_1_extended_metadata_id, history_dataset_association_1.version AS history_dataset_association_1_version, history_dataset_association_1.hid AS history_dataset_association_1_hid, history_dataset_association_1.purged AS history_dataset_association_1_purged, history_dataset_association_1.hidden_beneath_collection_instance_id AS history_dataset_association_1_hidden_beneath_collection_i_3, dataset_collection_element_1.id AS dataset_collection_element_1_id, dataset_collection_element_1.dataset_collection_id AS dataset_collection_element_1_dataset_collection_id, dataset_collection_element_1.hda_id AS dataset_collection_element_1_hda_id, dataset_collection_element_1.ldda_id AS dataset_collection_element_1_ldda_id, dataset_collection_element_1.child_collection_id AS dataset_collection_element_1_child_collection_id, dataset_collection_element_1.element_index AS dataset_collection_element_1_element_index, dataset_collection_element_1.element_identifier AS dataset_collection_element_1_element_identifier | |
FROM dataset_collection LEFT OUTER JOIN dataset_collection_element AS dataset_collection_element_1 ON dataset_collection.id = dataset_collection_element_1.dataset_collection_id LEFT OUTER JOIN history_dataset_association AS history_dataset_association_1 ON dataset_collection_element_1.hda_id = history_dataset_association_1.id LEFT OUTER JOIN dataset AS dataset_1 ON dataset_1.id = history_dataset_association_1.dataset_id LEFT OUTER JOIN dataset_permissions AS dataset_permissions_1 ON dataset_1.id = dataset_permissions_1.dataset_id LEFT OUTER JOIN role AS role_1 ON role_1.id = dataset_permissions_1.role_id | |
WHERE dataset_collection.id = %(id_1)s ORDER BY dataset_collection_element_1.element_index | |
Parameters: {'id_1': 130} |
This file contains 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
galaxy.model.orm.engine_factory DEBUG 2018-04-25 10:21:38,500 Request query: 0.003046(s) | |
SELECT galaxy_session.id AS galaxy_session_id, galaxy_session.create_time AS galaxy_session_create_time, galaxy_session.update_time AS galaxy_session_update_time, galaxy_session.user_id AS galaxy_session_user_id, galaxy_session.remote_host AS galaxy_session_remote_host, galaxy_session.remote_addr AS galaxy_session_remote_addr, galaxy_session.referer AS galaxy_session_referer, galaxy_session.current_history_id AS galaxy_session_current_history_id, galaxy_session.session_key AS galaxy_session_session_key, galaxy_session.is_valid AS galaxy_session_is_valid, galaxy_session.prev_session_id AS galaxy_session_prev_session_id, galaxy_session.disk_usage AS galaxy_session_disk_usage, galaxy_session.last_action AS galaxy_session_last_action, galaxy_user_1.id AS galaxy_user_1_id, galaxy_user_1.create_time AS galaxy_user_1_create_time, galaxy_user_1.update_time AS galaxy_user_1_update_time, galaxy_user_1.email AS galaxy_user_1_email, galaxy_user_1.username AS galaxy_user_1_username, galaxy_user_1.password AS galaxy_user_1_password, galaxy_user_1.last_password_change AS galaxy_user_1_last_password_change, galaxy_user_1.external AS galaxy_user_1_external, galaxy_user_1.form_values_id AS galaxy_user_1_form_values_id, galaxy_user_1.deleted AS galaxy_user_1_deleted, galaxy_user_1.purged AS galaxy_user_1_purged, galaxy_user_1.disk_usage AS galaxy_user_1_disk_usage, galaxy_user_1.active AS galaxy_user_1_active, galaxy_user_1.activation_token AS galaxy_user_1_activation_token | |
FROM galaxy_session LEFT OUTER JOIN galaxy_user AS galaxy_user_1 ON galaxy_user_1.id = galaxy_session.user_id | |
WHERE galaxy_session.session_key = %(session_key_1)s AND galaxy_session.is_valid = true | |
LIMIT %(param_1)s | |
Parameters: {'session_key_1': u'6e4e7382e12b28401e895910bb305148', 'param_1': 1} | |
galaxy.model.orm.engine_factory DEBUG 2018-04-25 10:21:38,508 Request query: 0.001332(s) | |
SELECT history.id AS history_id, history.create_time AS history_create_time, history.update_time AS history_update_time, history.user_id AS history_user_id, history.name AS history_name, history.hid_counter AS history_hid_counter, history.deleted AS history_deleted, history.purged AS history_purged, history.importing AS history_importing, history.genome_build AS history_genome_build, history.importable AS history_importable, history.slug AS history_slug, history.published AS history_published | |
FROM history | |
WHERE history.id = %(param_1)s | |
Parameters: {'param_1': 600} | |
galaxy.model.orm.engine_factory DEBUG 2018-04-25 10:21:38,521 Request query: 0.004741(s) | |
SELECT history_dataset_association.id AS history_dataset_association_id, history_dataset_association.history_id AS history_dataset_association_history_id, history_dataset_association.dataset_id AS history_dataset_association_dataset_id, history_dataset_association.create_time AS history_dataset_association_create_time, history_dataset_association.update_time AS history_dataset_association_update_time, history_dataset_association.state AS history_dataset_association_state, history_dataset_association.copied_from_history_dataset_association_id AS history_dataset_association_copied_from_history_dataset_a_1, history_dataset_association.copied_from_library_dataset_dataset_association_id AS history_dataset_association_copied_from_library_dataset_d_2, history_dataset_association.name AS history_dataset_association_name, history_dataset_association.info AS history_dataset_association_info, history_dataset_association.blurb AS history_dataset_association_blurb, history_dataset_association.peek AS history_dataset_association_peek, history_dataset_association.tool_version AS history_dataset_association_tool_version, history_dataset_association.extension AS history_dataset_association_extension, history_dataset_association.parent_id AS history_dataset_association_parent_id, history_dataset_association.designation AS history_dataset_association_designation, history_dataset_association.deleted AS history_dataset_association_deleted, history_dataset_association.visible AS history_dataset_association_visible, history_dataset_association.extended_metadata_id AS history_dataset_association_extended_metadata_id, history_dataset_association.version AS history_dataset_association_version, history_dataset_association.hid AS history_dataset_association_hid, history_dataset_association.purged AS history_dataset_association_purged, history_dataset_association.hidden_beneath_collection_instance_id AS history_dataset_association_hidden_beneath_collection_ins_3, history_dataset_association_tag_association_1.id AS history_dataset_association_tag_association_1_id, history_dataset_association_tag_association_1.history_dataset_association_id AS history_dataset_association_tag_association_1_history_dat_4, history_dataset_association_tag_association_1.tag_id AS history_dataset_association_tag_association_1_tag_id, history_dataset_association_tag_association_1.user_id AS history_dataset_association_tag_association_1_user_id, history_dataset_association_tag_association_1.user_tname AS history_dataset_association_tag_association_1_user_tname, history_dataset_association_tag_association_1.value AS history_dataset_association_tag_association_1_value, history_dataset_association_tag_association_1.user_value AS history_dataset_association_tag_association_1_user_value, dataset_1.id AS dataset_1_id, dataset_1.create_time AS dataset_1_create_time, dataset_1.update_time AS dataset_1_update_time, dataset_1.state AS dataset_1_state, dataset_1.deleted AS dataset_1_deleted, dataset_1.purged AS dataset_1_purged, dataset_1.purgable AS dataset_1_purgable, dataset_1.object_store_id AS dataset_1_object_store_id, dataset_1.external_filename AS dataset_1_external_filename, dataset_1._extra_files_path AS dataset_1__extra_files_path, dataset_1.file_size AS dataset_1_file_size, dataset_1.total_size AS dataset_1_total_size, dataset_1.uuid AS dataset_1_uuid, role_1.id AS role_1_id, role_1.create_time AS role_1_create_time, role_1.update_time AS role_1_update_time, role_1.name AS role_1_name, role_1.description AS role_1_description, role_1.type AS role_1_type, role_1.deleted AS role_1_deleted, dataset_permissions_1.id AS dataset_permissions_1_id, dataset_permissions_1.create_time AS dataset_permissions_1_create_time, dataset_permissions_1.update_time AS dataset_permissions_1_update_time, dataset_permissions_1.action AS dataset_permissions_1_action, dataset_permissions_1.dataset_id AS dataset_permissions_1_dataset_id, dataset_permissions_1.role_id AS dataset_permissions_1_role_id | |
FROM history_dataset_association LEFT OUTER JOIN history_dataset_association_tag_association AS history_dataset_association_tag_association_1 ON history_dataset_association.id = history_dataset_association_tag_association_1.history_dataset_association_id LEFT OUTER JOIN dataset AS dataset_1 ON dataset_1.id = history_dataset_association.dataset_id LEFT OUTER JOIN dataset_permissions AS dataset_permissions_1 ON dataset_1.id = dataset_permissions_1.dataset_id LEFT OUTER JOIN role AS role_1 ON role_1.id = dataset_permissions_1.role_id | |
WHERE history_dataset_association.history_id = %(history_id_1)s AND NOT history_dataset_association.deleted AND history_dataset_association.visible ORDER BY history_dataset_association.hid ASC, history_dataset_association_tag_association_1.id | |
Parameters: {'history_id_1': 600} | |
galaxy.model.orm.engine_factory DEBUG 2018-04-25 10:21:38,531 Request query: 0.001588(s) | |
SELECT history_dataset_association.metadata AS history_dataset_association_metadata | |
FROM history_dataset_association | |
WHERE history_dataset_association.id = %(param_1)s | |
Parameters: {'param_1': 468} | |
galaxy.model.orm.engine_factory DEBUG 2018-04-25 10:21:38,547 Request query: 0.006615(s) | |
SELECT history_dataset_collection_association.id AS history_dataset_collection_association_id, history_dataset_collection_association.collection_id AS history_dataset_collection_association_collection_id, history_dataset_collection_association.history_id AS history_dataset_collection_association_history_id, history_dataset_collection_association.name AS history_dataset_collection_association_name, history_dataset_collection_association.hid AS history_dataset_collection_association_hid, history_dataset_collection_association.visible AS history_dataset_collection_association_visible, history_dataset_collection_association.deleted AS history_dataset_collection_association_deleted, history_dataset_collection_association.copied_from_history_dataset_collection_association_id AS history_dataset_collection_association_copied_from_histor_1, history_dataset_collection_association.implicit_output_name AS history_dataset_collection_association_implicit_output_na_2, history_dataset_collection_association.job_id AS history_dataset_collection_association_job_id, history_dataset_collection_association.implicit_collection_jobs_id AS history_dataset_collection_association_implicit_collectio_3, history_dataset_collection_tag_association_1.id AS history_dataset_collection_tag_association_1_id, history_dataset_collection_tag_association_1.history_dataset_collection_id AS history_dataset_collection_tag_association_1_history_data_4, history_dataset_collection_tag_association_1.tag_id AS history_dataset_collection_tag_association_1_tag_id, history_dataset_collection_tag_association_1.user_id AS history_dataset_collection_tag_association_1_user_id, history_dataset_collection_tag_association_1.user_tname AS history_dataset_collection_tag_association_1_user_tname, history_dataset_collection_tag_association_1.value AS history_dataset_collection_tag_association_1_value, history_dataset_collection_tag_association_1.user_value AS history_dataset_collection_tag_association_1_user_value, dataset_1.id AS dataset_1_id, dataset_1.create_time AS dataset_1_create_time, dataset_1.update_time AS dataset_1_update_time, dataset_1.state AS dataset_1_state, dataset_1.deleted AS dataset_1_deleted, dataset_1.purged AS dataset_1_purged, dataset_1.purgable AS dataset_1_purgable, dataset_1.object_store_id AS dataset_1_object_store_id, dataset_1.external_filename AS dataset_1_external_filename, dataset_1._extra_files_path AS dataset_1__extra_files_path, dataset_1.file_size AS dataset_1_file_size, dataset_1.total_size AS dataset_1_total_size, dataset_1.uuid AS dataset_1_uuid, history_dataset_association_1.id AS history_dataset_association_1_id, history_dataset_association_1.history_id AS history_dataset_association_1_history_id, history_dataset_association_1.dataset_id AS history_dataset_association_1_dataset_id, history_dataset_association_1.create_time AS history_dataset_association_1_create_time, history_dataset_association_1.update_time AS history_dataset_association_1_update_time, history_dataset_association_1.state AS history_dataset_association_1_state, history_dataset_association_1.copied_from_history_dataset_association_id AS history_dataset_association_1_copied_from_history_dataset_5, history_dataset_association_1.copied_from_library_dataset_dataset_association_id AS history_dataset_association_1_copied_from_library_dataset_6, history_dataset_association_1.name AS history_dataset_association_1_name, history_dataset_association_1.info AS history_dataset_association_1_info, history_dataset_association_1.blurb AS history_dataset_association_1_blurb, history_dataset_association_1.peek AS history_dataset_association_1_peek, history_dataset_association_1.tool_version AS history_dataset_association_1_tool_version, history_dataset_association_1.extension AS history_dataset_association_1_extension, history_dataset_association_1.parent_id AS history_dataset_association_1_parent_id, history_dataset_association_1.designation AS history_dataset_association_1_designation, history_dataset_association_1.deleted AS history_dataset_association_1_deleted, history_dataset_association_1.visible AS history_dataset_association_1_visible, history_dataset_association_1.extended_metadata_id AS history_dataset_association_1_extended_metadata_id, history_dataset_association_1.version AS history_dataset_association_1_version, history_dataset_association_1.hid AS history_dataset_association_1_hid, history_dataset_association_1.purged AS history_dataset_association_1_purged, history_dataset_association_1.hidden_beneath_collection_instance_id AS history_dataset_association_1_hidden_beneath_collection_i_7, dataset_collection_element_1.id AS dataset_collection_element_1_id, dataset_collection_element_1.dataset_collection_id AS dataset_collection_element_1_dataset_collection_id, dataset_collection_element_1.hda_id AS dataset_collection_element_1_hda_id, dataset_collection_element_1.ldda_id AS dataset_collection_element_1_ldda_id, dataset_collection_element_1.child_collection_id AS dataset_collection_element_1_child_collection_id, dataset_collection_element_1.element_index AS dataset_collection_element_1_element_index, dataset_collection_element_1.element_identifier AS dataset_collection_element_1_element_identifier, dataset_collection_1.id AS dataset_collection_1_id, dataset_collection_1.collection_type AS dataset_collection_1_collection_type, dataset_collection_1.populated_state AS dataset_collection_1_populated_state, dataset_collection_1.populated_state_message AS dataset_collection_1_populated_state_message, dataset_collection_1.element_count AS dataset_collection_1_element_count, dataset_collection_1.create_time AS dataset_collection_1_create_time, dataset_collection_1.update_time AS dataset_collection_1_update_time | |
FROM history_dataset_collection_association LEFT OUTER JOIN history_dataset_collection_tag_association AS history_dataset_collection_tag_association_1 ON history_dataset_collection_association.id = history_dataset_collection_tag_association_1.history_dataset_collection_id LEFT OUTER JOIN dataset_collection AS dataset_collection_1 ON dataset_collection_1.id = history_dataset_collection_association.collection_id LEFT OUTER JOIN dataset_collection_element AS dataset_collection_element_1 ON dataset_collection_1.id = dataset_collection_element_1.dataset_collection_id LEFT OUTER JOIN history_dataset_association AS history_dataset_association_1 ON dataset_collection_element_1.hda_id = history_dataset_association_1.id LEFT OUTER JOIN dataset AS dataset_1 ON dataset_1.id = history_dataset_association_1.dataset_id | |
WHERE history_dataset_collection_association.history_id = %(history_id_1)s AND NOT history_dataset_collection_association.deleted AND history_dataset_collection_association.visible ORDER BY history_dataset_collection_association.hid ASC, history_dataset_collection_tag_association_1.id, dataset_collection_element_1.element_index | |
Parameters: {'history_id_1': 600} | |
galaxy.model.orm.engine_factory DEBUG 2018-04-25 10:21:38,566 Request query: 0.003983(s) | |
SELECT galaxy_user.id AS galaxy_user_id, galaxy_user.create_time AS galaxy_user_create_time, galaxy_user.update_time AS galaxy_user_update_time, galaxy_user.email AS galaxy_user_email, galaxy_user.username AS galaxy_user_username, galaxy_user.password AS galaxy_user_password, galaxy_user.last_password_change AS galaxy_user_last_password_change, galaxy_user.external AS galaxy_user_external, galaxy_user.form_values_id AS galaxy_user_form_values_id, galaxy_user.deleted AS galaxy_user_deleted, galaxy_user.purged AS galaxy_user_purged, galaxy_user.disk_usage AS galaxy_user_disk_usage, galaxy_user.active AS galaxy_user_active, galaxy_user.activation_token AS galaxy_user_activation_token, galaxy_group_1.id AS galaxy_group_1_id, galaxy_group_1.create_time AS galaxy_group_1_create_time, galaxy_group_1.update_time AS galaxy_group_1_update_time, galaxy_group_1.name AS galaxy_group_1_name, galaxy_group_1.deleted AS galaxy_group_1_deleted, role_1.id AS role_1_id, role_1.create_time AS role_1_create_time, role_1.update_time AS role_1_update_time, role_1.name AS role_1_name, role_1.description AS role_1_description, role_1.type AS role_1_type, role_1.deleted AS role_1_deleted, group_role_association_1.id AS group_role_association_1_id, group_role_association_1.group_id AS group_role_association_1_group_id, group_role_association_1.role_id AS group_role_association_1_role_id, group_role_association_1.create_time AS group_role_association_1_create_time, group_role_association_1.update_time AS group_role_association_1_update_time, user_group_association_1.id AS user_group_association_1_id, user_group_association_1.user_id AS user_group_association_1_user_id, user_group_association_1.group_id AS user_group_association_1_group_id, user_group_association_1.create_time AS user_group_association_1_create_time, user_group_association_1.update_time AS user_group_association_1_update_time, role_2.id AS role_2_id, role_2.create_time AS role_2_create_time, role_2.update_time AS role_2_update_time, role_2.name AS role_2_name, role_2.description AS role_2_description, role_2.type AS role_2_type, role_2.deleted AS role_2_deleted, user_role_association_1.id AS user_role_association_1_id, user_role_association_1.user_id AS user_role_association_1_user_id, user_role_association_1.role_id AS user_role_association_1_role_id, user_role_association_1.create_time AS user_role_association_1_create_time, user_role_association_1.update_time AS user_role_association_1_update_time | |
FROM galaxy_user LEFT OUTER JOIN user_group_association AS user_group_association_1 ON galaxy_user.id = user_group_association_1.user_id LEFT OUTER JOIN galaxy_group AS galaxy_group_1 ON galaxy_group_1.id = user_group_association_1.group_id LEFT OUTER JOIN group_role_association AS group_role_association_1 ON galaxy_group_1.id = group_role_association_1.group_id LEFT OUTER JOIN role AS role_1 ON role_1.id = group_role_association_1.role_id LEFT OUTER JOIN user_role_association AS user_role_association_1 ON galaxy_user.id = user_role_association_1.user_id LEFT OUTER JOIN role AS role_2 ON role_2.id = user_role_association_1.role_id | |
WHERE galaxy_user.id = %(id_1)s | |
Parameters: {'id_1': 1} | |
galaxy.model.orm.engine_factory DEBUG 2018-04-25 10:21:38,577 Request query: 0.005774(s) | |
SELECT dataset_permissions.id AS dataset_permissions_id, dataset_permissions.create_time AS dataset_permissions_create_time, dataset_permissions.update_time AS dataset_permissions_update_time, dataset_permissions.action AS dataset_permissions_action, dataset_permissions.dataset_id AS dataset_permissions_dataset_id, dataset_permissions.role_id AS dataset_permissions_role_id | |
FROM dataset_permissions | |
WHERE %(param_1)s = dataset_permissions.dataset_id | |
Parameters: {'param_1': 380} | |
galaxy.model.orm.engine_factory DEBUG 2018-04-25 10:21:38,581 Request query: 0.001533(s) | |
SELECT dataset_collection.id AS dataset_collection_id, dataset_collection.collection_type AS dataset_collection_collection_type, dataset_collection.populated_state AS dataset_collection_populated_state, dataset_collection.populated_state_message AS dataset_collection_populated_state_message, dataset_collection.element_count AS dataset_collection_element_count, dataset_collection.create_time AS dataset_collection_create_time, dataset_collection.update_time AS dataset_collection_update_time | |
FROM dataset_collection | |
WHERE dataset_collection.id = %(param_1)s | |
Parameters: {'param_1': 123} | |
galaxy.model.orm.engine_factory DEBUG 2018-04-25 10:21:38,584 Request query: 0.001238(s) | |
SELECT dataset_collection_element.id AS dataset_collection_element_id, dataset_collection_element.dataset_collection_id AS dataset_collection_element_dataset_collection_id, dataset_collection_element.hda_id AS dataset_collection_element_hda_id, dataset_collection_element.ldda_id AS dataset_collection_element_ldda_id, dataset_collection_element.child_collection_id AS dataset_collection_element_child_collection_id, dataset_collection_element.element_index AS dataset_collection_element_element_index, dataset_collection_element.element_identifier AS dataset_collection_element_element_identifier | |
FROM dataset_collection_element | |
WHERE %(param_1)s = dataset_collection_element.dataset_collection_id ORDER BY dataset_collection_element.element_index | |
Parameters: {'param_1': 123} | |
galaxy.model.orm.engine_factory DEBUG 2018-04-25 10:21:38,588 Request query: 0.001604(s) | |
SELECT history_dataset_association.id AS history_dataset_association_id, history_dataset_association.history_id AS history_dataset_association_history_id, history_dataset_association.dataset_id AS history_dataset_association_dataset_id, history_dataset_association.create_time AS history_dataset_association_create_time, history_dataset_association.update_time AS history_dataset_association_update_time, history_dataset_association.state AS history_dataset_association_state, history_dataset_association.copied_from_history_dataset_association_id AS history_dataset_association_copied_from_history_dataset_a_1, history_dataset_association.copied_from_library_dataset_dataset_association_id AS history_dataset_association_copied_from_library_dataset_d_2, history_dataset_association.name AS history_dataset_association_name, history_dataset_association.info AS history_dataset_association_info, history_dataset_association.blurb AS history_dataset_association_blurb, history_dataset_association.peek AS history_dataset_association_peek, history_dataset_association.tool_version AS history_dataset_association_tool_version, history_dataset_association.extension AS history_dataset_association_extension, history_dataset_association.parent_id AS history_dataset_association_parent_id, history_dataset_association.designation AS history_dataset_association_designation, history_dataset_association.deleted AS history_dataset_association_deleted, history_dataset_association.visible AS history_dataset_association_visible, history_dataset_association.extended_metadata_id AS history_dataset_association_extended_metadata_id, history_dataset_association.version AS history_dataset_association_version, history_dataset_association.hid AS history_dataset_association_hid, history_dataset_association.purged AS history_dataset_association_purged, history_dataset_association.hidden_beneath_collection_instance_id AS history_dataset_association_hidden_beneath_collection_ins_3, dataset_1.id AS dataset_1_id, dataset_1.create_time AS dataset_1_create_time, dataset_1.update_time AS dataset_1_update_time, dataset_1.state AS dataset_1_state, dataset_1.deleted AS dataset_1_deleted, dataset_1.purged AS dataset_1_purged, dataset_1.purgable AS dataset_1_purgable, dataset_1.object_store_id AS dataset_1_object_store_id, dataset_1.external_filename AS dataset_1_external_filename, dataset_1._extra_files_path AS dataset_1__extra_files_path, dataset_1.file_size AS dataset_1_file_size, dataset_1.total_size AS dataset_1_total_size, dataset_1.uuid AS dataset_1_uuid | |
FROM history_dataset_association LEFT OUTER JOIN dataset AS dataset_1 ON dataset_1.id = history_dataset_association.dataset_id | |
WHERE history_dataset_association.id = %(param_1)s | |
Parameters: {'param_1': 512} | |
galaxy.model.orm.engine_factory DEBUG 2018-04-25 10:21:38,596 Request query: 0.001856(s) | |
SELECT dataset_permissions.id AS dataset_permissions_id, dataset_permissions.create_time AS dataset_permissions_create_time, dataset_permissions.update_time AS dataset_permissions_update_time, dataset_permissions.action AS dataset_permissions_action, dataset_permissions.dataset_id AS dataset_permissions_dataset_id, dataset_permissions.role_id AS dataset_permissions_role_id | |
FROM dataset_permissions | |
WHERE %(param_1)s = dataset_permissions.dataset_id | |
Parameters: {'param_1': 381} |
This file contains 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
SELECT galaxy_session.id AS galaxy_session_id, galaxy_session.create_time AS galaxy_session_create_time, galaxy_session.update_time AS galaxy_session_update_time, galaxy_session.user_id AS galaxy_session_user_id, galaxy_session.remote_host AS galaxy_session_remote_host, galaxy_session.remote_addr AS galaxy_session_remote_addr, galaxy_session.referer AS galaxy_session_referer, galaxy_session.current_history_id AS galaxy_session_current_history_id, galaxy_session.session_key AS galaxy_session_session_key, galaxy_session.is_valid AS galaxy_session_is_valid, galaxy_session.prev_session_id AS galaxy_session_prev_session_id, galaxy_session.disk_usage AS galaxy_session_disk_usage, galaxy_session.last_action AS galaxy_session_last_action, galaxy_user_1.id AS galaxy_user_1_id, galaxy_user_1.create_time AS galaxy_user_1_create_time, galaxy_user_1.update_time AS galaxy_user_1_update_time, galaxy_user_1.email AS galaxy_user_1_email, galaxy_user_1.username AS galaxy_user_1_username, galaxy_user_1.password AS galaxy_user_1_password, galaxy_user_1.last_password_change AS galaxy_user_1_last_password_change, galaxy_user_1.external AS galaxy_user_1_external, galaxy_user_1.form_values_id AS galaxy_user_1_form_values_id, galaxy_user_1.deleted AS galaxy_user_1_deleted, galaxy_user_1.purged AS galaxy_user_1_purged, galaxy_user_1.disk_usage AS galaxy_user_1_disk_usage, galaxy_user_1.active AS galaxy_user_1_active, galaxy_user_1.activation_token AS galaxy_user_1_activation_token | |
FROM galaxy_session LEFT OUTER JOIN galaxy_user AS galaxy_user_1 ON galaxy_user_1.id = galaxy_session.user_id | |
WHERE galaxy_session.session_key = %(session_key_1)s AND galaxy_session.is_valid = true | |
LIMIT %(param_1)s | |
Parameters: {'session_key_1': u'6e4e7382e12b28401e895910bb305148', 'param_1': 1} | |
galaxy.model.orm.engine_factory DEBUG 2018-04-25 10:24:39,281 Request query: 0.002855(s) | |
SELECT history.id AS history_id, history.create_time AS history_create_time, history.update_time AS history_update_time, history.user_id AS history_user_id, history.name AS history_name, history.hid_counter AS history_hid_counter, history.deleted AS history_deleted, history.purged AS history_purged, history.importing AS history_importing, history.genome_build AS history_genome_build, history.importable AS history_importable, history.slug AS history_slug, history.published AS history_published | |
FROM history | |
WHERE history.id = %(param_1)s | |
Parameters: {'param_1': 600} | |
galaxy.model.orm.engine_factory DEBUG 2018-04-25 10:24:39,304 Request query: 0.008574(s) | |
SELECT history_dataset_association.id AS history_dataset_association_id, history_dataset_association.history_id AS history_dataset_association_history_id, history_dataset_association.dataset_id AS history_dataset_association_dataset_id, history_dataset_association.create_time AS history_dataset_association_create_time, history_dataset_association.update_time AS history_dataset_association_update_time, history_dataset_association.state AS history_dataset_association_state, history_dataset_association.copied_from_history_dataset_association_id AS history_dataset_association_copied_from_history_dataset_a_1, history_dataset_association.copied_from_library_dataset_dataset_association_id AS history_dataset_association_copied_from_library_dataset_d_2, history_dataset_association.name AS history_dataset_association_name, history_dataset_association.info AS history_dataset_association_info, history_dataset_association.blurb AS history_dataset_association_blurb, history_dataset_association.peek AS history_dataset_association_peek, history_dataset_association.tool_version AS history_dataset_association_tool_version, history_dataset_association.extension AS history_dataset_association_extension, history_dataset_association.parent_id AS history_dataset_association_parent_id, history_dataset_association.designation AS history_dataset_association_designation, history_dataset_association.deleted AS history_dataset_association_deleted, history_dataset_association.visible AS history_dataset_association_visible, history_dataset_association.extended_metadata_id AS history_dataset_association_extended_metadata_id, history_dataset_association.version AS history_dataset_association_version, history_dataset_association.hid AS history_dataset_association_hid, history_dataset_association.purged AS history_dataset_association_purged, history_dataset_association.hidden_beneath_collection_instance_id AS history_dataset_association_hidden_beneath_collection_ins_3, history_dataset_association_tag_association_1.id AS history_dataset_association_tag_association_1_id, history_dataset_association_tag_association_1.history_dataset_association_id AS history_dataset_association_tag_association_1_history_dat_4, history_dataset_association_tag_association_1.tag_id AS history_dataset_association_tag_association_1_tag_id, history_dataset_association_tag_association_1.user_id AS history_dataset_association_tag_association_1_user_id, history_dataset_association_tag_association_1.user_tname AS history_dataset_association_tag_association_1_user_tname, history_dataset_association_tag_association_1.value AS history_dataset_association_tag_association_1_value, history_dataset_association_tag_association_1.user_value AS history_dataset_association_tag_association_1_user_value, dataset_1.id AS dataset_1_id, dataset_1.create_time AS dataset_1_create_time, dataset_1.update_time AS dataset_1_update_time, dataset_1.state AS dataset_1_state, dataset_1.deleted AS dataset_1_deleted, dataset_1.purged AS dataset_1_purged, dataset_1.purgable AS dataset_1_purgable, dataset_1.object_store_id AS dataset_1_object_store_id, dataset_1.external_filename AS dataset_1_external_filename, dataset_1._extra_files_path AS dataset_1__extra_files_path, dataset_1.file_size AS dataset_1_file_size, dataset_1.total_size AS dataset_1_total_size, dataset_1.uuid AS dataset_1_uuid, role_1.id AS role_1_id, role_1.create_time AS role_1_create_time, role_1.update_time AS role_1_update_time, role_1.name AS role_1_name, role_1.description AS role_1_description, role_1.type AS role_1_type, role_1.deleted AS role_1_deleted, dataset_permissions_1.id AS dataset_permissions_1_id, dataset_permissions_1.create_time AS dataset_permissions_1_create_time, dataset_permissions_1.update_time AS dataset_permissions_1_update_time, dataset_permissions_1.action AS dataset_permissions_1_action, dataset_permissions_1.dataset_id AS dataset_permissions_1_dataset_id, dataset_permissions_1.role_id AS dataset_permissions_1_role_id | |
FROM history_dataset_association LEFT OUTER JOIN history_dataset_association_tag_association AS history_dataset_association_tag_association_1 ON history_dataset_association.id = history_dataset_association_tag_association_1.history_dataset_association_id LEFT OUTER JOIN dataset AS dataset_1 ON dataset_1.id = history_dataset_association.dataset_id LEFT OUTER JOIN dataset_permissions AS dataset_permissions_1 ON dataset_1.id = dataset_permissions_1.dataset_id LEFT OUTER JOIN role AS role_1 ON role_1.id = dataset_permissions_1.role_id | |
WHERE history_dataset_association.history_id = %(history_id_1)s AND NOT history_dataset_association.deleted AND history_dataset_association.visible ORDER BY history_dataset_association.hid ASC, history_dataset_association_tag_association_1.id | |
Parameters: {'history_id_1': 600} | |
galaxy.model.orm.engine_factory DEBUG 2018-04-25 10:24:39,316 Request query: 0.001481(s) | |
SELECT history_dataset_association.metadata AS history_dataset_association_metadata | |
FROM history_dataset_association | |
WHERE history_dataset_association.id = %(param_1)s | |
Parameters: {'param_1': 468} | |
galaxy.model.orm.engine_factory DEBUG 2018-04-25 10:24:39,351 Request query: 0.012161(s) | |
SELECT history_dataset_collection_association.id AS history_dataset_collection_association_id, history_dataset_collection_association.collection_id AS history_dataset_collection_association_collection_id, history_dataset_collection_association.history_id AS history_dataset_collection_association_history_id, history_dataset_collection_association.name AS history_dataset_collection_association_name, history_dataset_collection_association.hid AS history_dataset_collection_association_hid, history_dataset_collection_association.visible AS history_dataset_collection_association_visible, history_dataset_collection_association.deleted AS history_dataset_collection_association_deleted, history_dataset_collection_association.copied_from_history_dataset_collection_association_id AS history_dataset_collection_association_copied_from_histor_1, history_dataset_collection_association.implicit_output_name AS history_dataset_collection_association_implicit_output_na_2, history_dataset_collection_association.job_id AS history_dataset_collection_association_job_id, history_dataset_collection_association.implicit_collection_jobs_id AS history_dataset_collection_association_implicit_collectio_3, history_dataset_collection_tag_association_1.id AS history_dataset_collection_tag_association_1_id, history_dataset_collection_tag_association_1.history_dataset_collection_id AS history_dataset_collection_tag_association_1_history_data_4, history_dataset_collection_tag_association_1.tag_id AS history_dataset_collection_tag_association_1_tag_id, history_dataset_collection_tag_association_1.user_id AS history_dataset_collection_tag_association_1_user_id, history_dataset_collection_tag_association_1.user_tname AS history_dataset_collection_tag_association_1_user_tname, history_dataset_collection_tag_association_1.value AS history_dataset_collection_tag_association_1_value, history_dataset_collection_tag_association_1.user_value AS history_dataset_collection_tag_association_1_user_value, dataset_1.id AS dataset_1_id, dataset_1.create_time AS dataset_1_create_time, dataset_1.update_time AS dataset_1_update_time, dataset_1.state AS dataset_1_state, dataset_1.deleted AS dataset_1_deleted, dataset_1.purged AS dataset_1_purged, dataset_1.purgable AS dataset_1_purgable, dataset_1.object_store_id AS dataset_1_object_store_id, dataset_1.external_filename AS dataset_1_external_filename, dataset_1._extra_files_path AS dataset_1__extra_files_path, dataset_1.file_size AS dataset_1_file_size, dataset_1.total_size AS dataset_1_total_size, dataset_1.uuid AS dataset_1_uuid, history_dataset_association_1.id AS history_dataset_association_1_id, history_dataset_association_1.history_id AS history_dataset_association_1_history_id, history_dataset_association_1.dataset_id AS history_dataset_association_1_dataset_id, history_dataset_association_1.create_time AS history_dataset_association_1_create_time, history_dataset_association_1.update_time AS history_dataset_association_1_update_time, history_dataset_association_1.state AS history_dataset_association_1_state, history_dataset_association_1.copied_from_history_dataset_association_id AS history_dataset_association_1_copied_from_history_dataset_5, history_dataset_association_1.copied_from_library_dataset_dataset_association_id AS history_dataset_association_1_copied_from_library_dataset_6, history_dataset_association_1.name AS history_dataset_association_1_name, history_dataset_association_1.info AS history_dataset_association_1_info, history_dataset_association_1.blurb AS history_dataset_association_1_blurb, history_dataset_association_1.peek AS history_dataset_association_1_peek, history_dataset_association_1.tool_version AS history_dataset_association_1_tool_version, history_dataset_association_1.extension AS history_dataset_association_1_extension, history_dataset_association_1.parent_id AS history_dataset_association_1_parent_id, history_dataset_association_1.designation AS history_dataset_association_1_designation, history_dataset_association_1.deleted AS history_dataset_association_1_deleted, history_dataset_association_1.visible AS history_dataset_association_1_visible, history_dataset_association_1.extended_metadata_id AS history_dataset_association_1_extended_metadata_id, history_dataset_association_1.version AS history_dataset_association_1_version, history_dataset_association_1.hid AS history_dataset_association_1_hid, history_dataset_association_1.purged AS history_dataset_association_1_purged, history_dataset_association_1.hidden_beneath_collection_instance_id AS history_dataset_association_1_hidden_beneath_collection_i_7, dataset_collection_element_1.id AS dataset_collection_element_1_id, dataset_collection_element_1.dataset_collection_id AS dataset_collection_element_1_dataset_collection_id, dataset_collection_element_1.hda_id AS dataset_collection_element_1_hda_id, dataset_collection_element_1.ldda_id AS dataset_collection_element_1_ldda_id, dataset_collection_element_1.child_collection_id AS dataset_collection_element_1_child_collection_id, dataset_collection_element_1.element_index AS dataset_collection_element_1_element_index, dataset_collection_element_1.element_identifier AS dataset_collection_element_1_element_identifier, dataset_collection_1.id AS dataset_collection_1_id, dataset_collection_1.collection_type AS dataset_collection_1_collection_type, dataset_collection_1.populated_state AS dataset_collection_1_populated_state, dataset_collection_1.populated_state_message AS dataset_collection_1_populated_state_message, dataset_collection_1.element_count AS dataset_collection_1_element_count, dataset_collection_1.create_time AS dataset_collection_1_create_time, dataset_collection_1.update_time AS dataset_collection_1_update_time | |
FROM history_dataset_collection_association LEFT OUTER JOIN history_dataset_collection_tag_association AS history_dataset_collection_tag_association_1 ON history_dataset_collection_association.id = history_dataset_collection_tag_association_1.history_dataset_collection_id LEFT OUTER JOIN dataset_collection AS dataset_collection_1 ON dataset_collection_1.id = history_dataset_collection_association.collection_id LEFT OUTER JOIN dataset_collection_element AS dataset_collection_element_1 ON dataset_collection_1.id = dataset_collection_element_1.dataset_collection_id LEFT OUTER JOIN history_dataset_association AS history_dataset_association_1 ON dataset_collection_element_1.hda_id = history_dataset_association_1.id LEFT OUTER JOIN dataset AS dataset_1 ON dataset_1.id = history_dataset_association_1.dataset_id | |
WHERE history_dataset_collection_association.history_id = %(history_id_1)s AND NOT history_dataset_collection_association.deleted AND history_dataset_collection_association.visible ORDER BY history_dataset_collection_association.hid ASC, history_dataset_collection_tag_association_1.id, dataset_collection_element_1.element_index | |
Parameters: {'history_id_1': 600} | |
galaxy.model.orm.engine_factory DEBUG 2018-04-25 10:24:39,390 Request query: 0.008022(s) | |
SELECT galaxy_user.id AS galaxy_user_id, galaxy_user.create_time AS galaxy_user_create_time, galaxy_user.update_time AS galaxy_user_update_time, galaxy_user.email AS galaxy_user_email, galaxy_user.username AS galaxy_user_username, galaxy_user.password AS galaxy_user_password, galaxy_user.last_password_change AS galaxy_user_last_password_change, galaxy_user.external AS galaxy_user_external, galaxy_user.form_values_id AS galaxy_user_form_values_id, galaxy_user.deleted AS galaxy_user_deleted, galaxy_user.purged AS galaxy_user_purged, galaxy_user.disk_usage AS galaxy_user_disk_usage, galaxy_user.active AS galaxy_user_active, galaxy_user.activation_token AS galaxy_user_activation_token, role_1.id AS role_1_id, role_1.create_time AS role_1_create_time, role_1.update_time AS role_1_update_time, role_1.name AS role_1_name, role_1.description AS role_1_description, role_1.type AS role_1_type, role_1.deleted AS role_1_deleted, user_role_association_1.id AS user_role_association_1_id, user_role_association_1.user_id AS user_role_association_1_user_id, user_role_association_1.role_id AS user_role_association_1_role_id, user_role_association_1.create_time AS user_role_association_1_create_time, user_role_association_1.update_time AS user_role_association_1_update_time, galaxy_group_1.id AS galaxy_group_1_id, galaxy_group_1.create_time AS galaxy_group_1_create_time, galaxy_group_1.update_time AS galaxy_group_1_update_time, galaxy_group_1.name AS galaxy_group_1_name, galaxy_group_1.deleted AS galaxy_group_1_deleted, role_2.id AS role_2_id, role_2.create_time AS role_2_create_time, role_2.update_time AS role_2_update_time, role_2.name AS role_2_name, role_2.description AS role_2_description, role_2.type AS role_2_type, role_2.deleted AS role_2_deleted, group_role_association_1.id AS group_role_association_1_id, group_role_association_1.group_id AS group_role_association_1_group_id, group_role_association_1.role_id AS group_role_association_1_role_id, group_role_association_1.create_time AS group_role_association_1_create_time, group_role_association_1.update_time AS group_role_association_1_update_time, user_group_association_1.id AS user_group_association_1_id, user_group_association_1.user_id AS user_group_association_1_user_id, user_group_association_1.group_id AS user_group_association_1_group_id, user_group_association_1.create_time AS user_group_association_1_create_time, user_group_association_1.update_time AS user_group_association_1_update_time | |
FROM galaxy_user LEFT OUTER JOIN user_role_association AS user_role_association_1 ON galaxy_user.id = user_role_association_1.user_id LEFT OUTER JOIN role AS role_1 ON role_1.id = user_role_association_1.role_id LEFT OUTER JOIN user_group_association AS user_group_association_1 ON galaxy_user.id = user_group_association_1.user_id LEFT OUTER JOIN galaxy_group AS galaxy_group_1 ON galaxy_group_1.id = user_group_association_1.group_id LEFT OUTER JOIN group_role_association AS group_role_association_1 ON galaxy_group_1.id = group_role_association_1.group_id LEFT OUTER JOIN role AS role_2 ON role_2.id = group_role_association_1.role_id | |
WHERE galaxy_user.id = %(id_1)s | |
Parameters: {'id_1': 1} | |
galaxy.model.orm.engine_factory DEBUG 2018-04-25 10:24:39,403 Request query: 0.002356(s) | |
SELECT dataset_permissions.id AS dataset_permissions_id, dataset_permissions.create_time AS dataset_permissions_create_time, dataset_permissions.update_time AS dataset_permissions_update_time, dataset_permissions.action AS dataset_permissions_action, dataset_permissions.dataset_id AS dataset_permissions_dataset_id, dataset_permissions.role_id AS dataset_permissions_role_id | |
FROM dataset_permissions | |
WHERE %(param_1)s = dataset_permissions.dataset_id | |
Parameters: {'param_1': 380} | |
galaxy.model INFO 2018-04-25 10:24:39,405 | |
CALCULATING POPULATED... | |
galaxy.model.orm.engine_factory DEBUG 2018-04-25 10:24:39,408 Request query: 0.001822(s) | |
SELECT dataset_collection.id AS dataset_collection_id, dataset_collection.collection_type AS dataset_collection_collection_type, dataset_collection.populated_state AS dataset_collection_populated_state, dataset_collection.populated_state_message AS dataset_collection_populated_state_message, dataset_collection.element_count AS dataset_collection_element_count, dataset_collection.create_time AS dataset_collection_create_time, dataset_collection.update_time AS dataset_collection_update_time | |
FROM dataset_collection | |
WHERE dataset_collection.id = %(param_1)s | |
Parameters: {'param_1': 123} | |
galaxy.model INFO 2018-04-25 10:24:39,409 | |
CALCULATED POPULATED... | |
galaxy.model.orm.engine_factory DEBUG 2018-04-25 10:24:39,412 Request query: 0.002005(s) | |
SELECT dataset_collection_element.id AS dataset_collection_element_id, dataset_collection_element.dataset_collection_id AS dataset_collection_element_dataset_collection_id, dataset_collection_element.hda_id AS dataset_collection_element_hda_id, dataset_collection_element.ldda_id AS dataset_collection_element_ldda_id, dataset_collection_element.child_collection_id AS dataset_collection_element_child_collection_id, dataset_collection_element.element_index AS dataset_collection_element_element_index, dataset_collection_element.element_identifier AS dataset_collection_element_element_identifier | |
FROM dataset_collection_element | |
WHERE %(param_1)s = dataset_collection_element.dataset_collection_id ORDER BY dataset_collection_element.element_index | |
Parameters: {'param_1': 123} | |
galaxy.model.orm.engine_factory DEBUG 2018-04-25 10:24:39,418 Request query: 0.002579(s) | |
SELECT history_dataset_association.id AS history_dataset_association_id, history_dataset_association.history_id AS history_dataset_association_history_id, history_dataset_association.dataset_id AS history_dataset_association_dataset_id, history_dataset_association.create_time AS history_dataset_association_create_time, history_dataset_association.update_time AS history_dataset_association_update_time, history_dataset_association.state AS history_dataset_association_state, history_dataset_association.copied_from_history_dataset_association_id AS history_dataset_association_copied_from_history_dataset_a_1, history_dataset_association.copied_from_library_dataset_dataset_association_id AS history_dataset_association_copied_from_library_dataset_d_2, history_dataset_association.name AS history_dataset_association_name, history_dataset_association.info AS history_dataset_association_info, history_dataset_association.blurb AS history_dataset_association_blurb, history_dataset_association.peek AS history_dataset_association_peek, history_dataset_association.tool_version AS history_dataset_association_tool_version, history_dataset_association.extension AS history_dataset_association_extension, history_dataset_association.parent_id AS history_dataset_association_parent_id, history_dataset_association.designation AS history_dataset_association_designation, history_dataset_association.deleted AS history_dataset_association_deleted, history_dataset_association.visible AS history_dataset_association_visible, history_dataset_association.extended_metadata_id AS history_dataset_association_extended_metadata_id, history_dataset_association.version AS history_dataset_association_version, history_dataset_association.hid AS history_dataset_association_hid, history_dataset_association.purged AS history_dataset_association_purged, history_dataset_association.hidden_beneath_collection_instance_id AS history_dataset_association_hidden_beneath_collection_ins_3, dataset_1.id AS dataset_1_id, dataset_1.create_time AS dataset_1_create_time, dataset_1.update_time AS dataset_1_update_time, dataset_1.state AS dataset_1_state, dataset_1.deleted AS dataset_1_deleted, dataset_1.purged AS dataset_1_purged, dataset_1.purgable AS dataset_1_purgable, dataset_1.object_store_id AS dataset_1_object_store_id, dataset_1.external_filename AS dataset_1_external_filename, dataset_1._extra_files_path AS dataset_1__extra_files_path, dataset_1.file_size AS dataset_1_file_size, dataset_1.total_size AS dataset_1_total_size, dataset_1.uuid AS dataset_1_uuid | |
FROM history_dataset_association LEFT OUTER JOIN dataset AS dataset_1 ON dataset_1.id = history_dataset_association.dataset_id | |
WHERE history_dataset_association.id = %(param_1)s | |
Parameters: {'param_1': 512} | |
galaxy.model.orm.engine_factory DEBUG 2018-04-25 10:24:39,423 Request query: 0.001437(s) | |
SELECT dataset_permissions.id AS dataset_permissions_id, dataset_permissions.create_time AS dataset_permissions_create_time, dataset_permissions.update_time AS dataset_permissions_update_time, dataset_permissions.action AS dataset_permissions_action, dataset_permissions.dataset_id AS dataset_permissions_dataset_id, dataset_permissions.role_id AS dataset_permissions_role_id | |
FROM dataset_permissions | |
WHERE %(param_1)s = dataset_permissions.dataset_id | |
Parameters: {'param_1': 381} | |
galaxy.model INFO 2018-04-25 10:24:39,425 | |
CALCULATING POPULATED... | |
galaxy.model INFO 2018-04-25 10:24:39,425 | |
CALCULATED POPULATED... | |
This file contains 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
galaxy.model.orm.engine_factory DEBUG 2018-04-25 13:32:54,481 Request query: 0.007641(s) | |
SELECT galaxy_session.id AS galaxy_session_id, galaxy_session.create_time AS galaxy_session_create_time, galaxy_session.update_time AS galaxy_session_update_time, galaxy_session.user_id AS galaxy_session_user_id, galaxy_session.remote_host AS galaxy_session_remote_host, galaxy_session.remote_addr AS galaxy_session_remote_addr, galaxy_session.referer AS galaxy_session_referer, galaxy_session.current_history_id AS galaxy_session_current_history_id, galaxy_session.session_key AS galaxy_session_session_key, galaxy_session.is_valid AS galaxy_session_is_valid, galaxy_session.prev_session_id AS galaxy_session_prev_session_id, galaxy_session.disk_usage AS galaxy_session_disk_usage, galaxy_session.last_action AS galaxy_session_last_action, galaxy_user_1.id AS galaxy_user_1_id, galaxy_user_1.create_time AS galaxy_user_1_create_time, galaxy_user_1.update_time AS galaxy_user_1_update_time, galaxy_user_1.email AS galaxy_user_1_email, galaxy_user_1.username AS galaxy_user_1_username, galaxy_user_1.password AS galaxy_user_1_password, galaxy_user_1.last_password_change AS galaxy_user_1_last_password_change, galaxy_user_1.external AS galaxy_user_1_external, galaxy_user_1.form_values_id AS galaxy_user_1_form_values_id, galaxy_user_1.deleted AS galaxy_user_1_deleted, galaxy_user_1.purged AS galaxy_user_1_purged, galaxy_user_1.disk_usage AS galaxy_user_1_disk_usage, galaxy_user_1.active AS galaxy_user_1_active, galaxy_user_1.activation_token AS galaxy_user_1_activation_token | |
FROM galaxy_session LEFT OUTER JOIN galaxy_user AS galaxy_user_1 ON galaxy_user_1.id = galaxy_session.user_id | |
WHERE galaxy_session.session_key = %(session_key_1)s AND galaxy_session.is_valid = true | |
LIMIT %(param_1)s | |
Parameters: {'session_key_1': u'6e4e7382e12b28401e895910bb305148', 'param_1': 1} | |
galaxy.model.orm.engine_factory DEBUG 2018-04-25 13:32:54,499 Request query: 0.004886(s) | |
SELECT history.id AS history_id, history.create_time AS history_create_time, history.update_time AS history_update_time, history.user_id AS history_user_id, history.name AS history_name, history.hid_counter AS history_hid_counter, history.deleted AS history_deleted, history.purged AS history_purged, history.importing AS history_importing, history.genome_build AS history_genome_build, history.importable AS history_importable, history.slug AS history_slug, history.published AS history_published | |
FROM history | |
WHERE history.id = %(param_1)s | |
Parameters: {'param_1': 600} | |
galaxy.model.orm.engine_factory DEBUG 2018-04-25 13:32:54,703 Request query: 0.015824(s) | |
SELECT history_dataset_association.id AS history_dataset_association_id, history_dataset_association.history_id AS history_dataset_association_history_id, history_dataset_association.dataset_id AS history_dataset_association_dataset_id, history_dataset_association.create_time AS history_dataset_association_create_time, history_dataset_association.update_time AS history_dataset_association_update_time, history_dataset_association.state AS history_dataset_association_state, history_dataset_association.copied_from_history_dataset_association_id AS history_dataset_association_copied_from_history_dataset_a_1, history_dataset_association.copied_from_library_dataset_dataset_association_id AS history_dataset_association_copied_from_library_dataset_d_2, history_dataset_association.name AS history_dataset_association_name, history_dataset_association.info AS history_dataset_association_info, history_dataset_association.blurb AS history_dataset_association_blurb, history_dataset_association.peek AS history_dataset_association_peek, history_dataset_association.tool_version AS history_dataset_association_tool_version, history_dataset_association.extension AS history_dataset_association_extension, history_dataset_association.parent_id AS history_dataset_association_parent_id, history_dataset_association.designation AS history_dataset_association_designation, history_dataset_association.deleted AS history_dataset_association_deleted, history_dataset_association.visible AS history_dataset_association_visible, history_dataset_association.extended_metadata_id AS history_dataset_association_extended_metadata_id, history_dataset_association.version AS history_dataset_association_version, history_dataset_association.hid AS history_dataset_association_hid, history_dataset_association.purged AS history_dataset_association_purged, history_dataset_association.hidden_beneath_collection_instance_id AS history_dataset_association_hidden_beneath_collection_ins_3, history_dataset_association_tag_association_1.id AS history_dataset_association_tag_association_1_id, history_dataset_association_tag_association_1.history_dataset_association_id AS history_dataset_association_tag_association_1_history_dat_4, history_dataset_association_tag_association_1.tag_id AS history_dataset_association_tag_association_1_tag_id, history_dataset_association_tag_association_1.user_id AS history_dataset_association_tag_association_1_user_id, history_dataset_association_tag_association_1.user_tname AS history_dataset_association_tag_association_1_user_tname, history_dataset_association_tag_association_1.value AS history_dataset_association_tag_association_1_value, history_dataset_association_tag_association_1.user_value AS history_dataset_association_tag_association_1_user_value, dataset_1.id AS dataset_1_id, dataset_1.create_time AS dataset_1_create_time, dataset_1.update_time AS dataset_1_update_time, dataset_1.state AS dataset_1_state, dataset_1.deleted AS dataset_1_deleted, dataset_1.purged AS dataset_1_purged, dataset_1.purgable AS dataset_1_purgable, dataset_1.object_store_id AS dataset_1_object_store_id, dataset_1.external_filename AS dataset_1_external_filename, dataset_1._extra_files_path AS dataset_1__extra_files_path, dataset_1.file_size AS dataset_1_file_size, dataset_1.total_size AS dataset_1_total_size, dataset_1.uuid AS dataset_1_uuid, role_1.id AS role_1_id, role_1.create_time AS role_1_create_time, role_1.update_time AS role_1_update_time, role_1.name AS role_1_name, role_1.description AS role_1_description, role_1.type AS role_1_type, role_1.deleted AS role_1_deleted, dataset_permissions_1.id AS dataset_permissions_1_id, dataset_permissions_1.create_time AS dataset_permissions_1_create_time, dataset_permissions_1.update_time AS dataset_permissions_1_update_time, dataset_permissions_1.action AS dataset_permissions_1_action, dataset_permissions_1.dataset_id AS dataset_permissions_1_dataset_id, dataset_permissions_1.role_id AS dataset_permissions_1_role_id | |
FROM history_dataset_association LEFT OUTER JOIN history_dataset_association_tag_association AS history_dataset_association_tag_association_1 ON history_dataset_association.id = history_dataset_association_tag_association_1.history_dataset_association_id LEFT OUTER JOIN dataset AS dataset_1 ON dataset_1.id = history_dataset_association.dataset_id LEFT OUTER JOIN dataset_permissions AS dataset_permissions_1 ON dataset_1.id = dataset_permissions_1.dataset_id LEFT OUTER JOIN role AS role_1 ON role_1.id = dataset_permissions_1.role_id | |
WHERE history_dataset_association.history_id = %(history_id_1)s AND NOT history_dataset_association.deleted AND history_dataset_association.visible ORDER BY history_dataset_association.hid ASC, history_dataset_association_tag_association_1.id | |
Parameters: {'history_id_1': 600} | |
galaxy.model.orm.engine_factory DEBUG 2018-04-25 13:32:54,714 Request query: 0.002235(s) | |
SELECT history_dataset_association.metadata AS history_dataset_association_metadata | |
FROM history_dataset_association | |
WHERE history_dataset_association.id = %(param_1)s | |
Parameters: {'param_1': 468} | |
galaxy.model.orm.engine_factory DEBUG 2018-04-25 13:32:54,735 Request query: 0.012158(s) | |
SELECT history_dataset_collection_association.id AS history_dataset_collection_association_id, history_dataset_collection_association.collection_id AS history_dataset_collection_association_collection_id, history_dataset_collection_association.history_id AS history_dataset_collection_association_history_id, history_dataset_collection_association.name AS history_dataset_collection_association_name, history_dataset_collection_association.hid AS history_dataset_collection_association_hid, history_dataset_collection_association.visible AS history_dataset_collection_association_visible, history_dataset_collection_association.deleted AS history_dataset_collection_association_deleted, history_dataset_collection_association.copied_from_history_dataset_collection_association_id AS history_dataset_collection_association_copied_from_histor_1, history_dataset_collection_association.implicit_output_name AS history_dataset_collection_association_implicit_output_na_2, history_dataset_collection_association.job_id AS history_dataset_collection_association_job_id, history_dataset_collection_association.implicit_collection_jobs_id AS history_dataset_collection_association_implicit_collectio_3, history_dataset_collection_tag_association_1.id AS history_dataset_collection_tag_association_1_id, history_dataset_collection_tag_association_1.history_dataset_collection_id AS history_dataset_collection_tag_association_1_history_data_4, history_dataset_collection_tag_association_1.tag_id AS history_dataset_collection_tag_association_1_tag_id, history_dataset_collection_tag_association_1.user_id AS history_dataset_collection_tag_association_1_user_id, history_dataset_collection_tag_association_1.user_tname AS history_dataset_collection_tag_association_1_user_tname, history_dataset_collection_tag_association_1.value AS history_dataset_collection_tag_association_1_value, history_dataset_collection_tag_association_1.user_value AS history_dataset_collection_tag_association_1_user_value, dataset_collection_1.id AS dataset_collection_1_id, dataset_collection_1.collection_type AS dataset_collection_1_collection_type, dataset_collection_1.populated_state AS dataset_collection_1_populated_state, dataset_collection_1.populated_state_message AS dataset_collection_1_populated_state_message, dataset_collection_1.element_count AS dataset_collection_1_element_count, dataset_collection_1.create_time AS dataset_collection_1_create_time, dataset_collection_1.update_time AS dataset_collection_1_update_time | |
FROM dataset_collection, history_dataset_collection_association LEFT OUTER JOIN history_dataset_collection_tag_association AS history_dataset_collection_tag_association_1 ON history_dataset_collection_association.id = history_dataset_collection_tag_association_1.history_dataset_collection_id LEFT OUTER JOIN dataset_collection AS dataset_collection_1 ON dataset_collection_1.id = history_dataset_collection_association.collection_id | |
WHERE history_dataset_collection_association.history_id = %(history_id_1)s AND NOT history_dataset_collection_association.deleted AND history_dataset_collection_association.visible AND dataset_collection.populated_state = %(populated_state_1)s ORDER BY history_dataset_collection_association.hid ASC, history_dataset_collection_tag_association_1.id | |
Parameters: {'history_id_1': 600, 'populated_state_1': 'ok'} | |
galaxy.model.orm.engine_factory DEBUG 2018-04-25 13:32:54,804 Request query: 0.006990(s) | |
SELECT dataset_collection.id AS dataset_collection_id, dataset_collection.collection_type AS dataset_collection_collection_type, dataset_collection.populated_state AS dataset_collection_populated_state, dataset_collection.populated_state_message AS dataset_collection_populated_state_message, dataset_collection.element_count AS dataset_collection_element_count, dataset_collection.create_time AS dataset_collection_create_time, dataset_collection.update_time AS dataset_collection_update_time, dataset_1.id AS dataset_1_id, dataset_1.create_time AS dataset_1_create_time, dataset_1.update_time AS dataset_1_update_time, dataset_1.state AS dataset_1_state, dataset_1.deleted AS dataset_1_deleted, dataset_1.purged AS dataset_1_purged, dataset_1.purgable AS dataset_1_purgable, dataset_1.object_store_id AS dataset_1_object_store_id, dataset_1.external_filename AS dataset_1_external_filename, dataset_1._extra_files_path AS dataset_1__extra_files_path, dataset_1.file_size AS dataset_1_file_size, dataset_1.total_size AS dataset_1_total_size, dataset_1.uuid AS dataset_1_uuid, history_dataset_association_1.id AS history_dataset_association_1_id, history_dataset_association_1.history_id AS history_dataset_association_1_history_id, history_dataset_association_1.dataset_id AS history_dataset_association_1_dataset_id, history_dataset_association_1.create_time AS history_dataset_association_1_create_time, history_dataset_association_1.update_time AS history_dataset_association_1_update_time, history_dataset_association_1.state AS history_dataset_association_1_state, history_dataset_association_1.copied_from_history_dataset_association_id AS history_dataset_association_1_copied_from_history_dataset_1, history_dataset_association_1.copied_from_library_dataset_dataset_association_id AS history_dataset_association_1_copied_from_library_dataset_2, history_dataset_association_1.name AS history_dataset_association_1_name, history_dataset_association_1.info AS history_dataset_association_1_info, history_dataset_association_1.blurb AS history_dataset_association_1_blurb, history_dataset_association_1.peek AS history_dataset_association_1_peek, history_dataset_association_1.tool_version AS history_dataset_association_1_tool_version, history_dataset_association_1.extension AS history_dataset_association_1_extension, history_dataset_association_1.parent_id AS history_dataset_association_1_parent_id, history_dataset_association_1.designation AS history_dataset_association_1_designation, history_dataset_association_1.deleted AS history_dataset_association_1_deleted, history_dataset_association_1.visible AS history_dataset_association_1_visible, history_dataset_association_1.extended_metadata_id AS history_dataset_association_1_extended_metadata_id, history_dataset_association_1.version AS history_dataset_association_1_version, history_dataset_association_1.hid AS history_dataset_association_1_hid, history_dataset_association_1.purged AS history_dataset_association_1_purged, history_dataset_association_1.hidden_beneath_collection_instance_id AS history_dataset_association_1_hidden_beneath_collection_i_3, dataset_collection_element_1.id AS dataset_collection_element_1_id, dataset_collection_element_1.dataset_collection_id AS dataset_collection_element_1_dataset_collection_id, dataset_collection_element_1.hda_id AS dataset_collection_element_1_hda_id, dataset_collection_element_1.ldda_id AS dataset_collection_element_1_ldda_id, dataset_collection_element_1.child_collection_id AS dataset_collection_element_1_child_collection_id, dataset_collection_element_1.element_index AS dataset_collection_element_1_element_index, dataset_collection_element_1.element_identifier AS dataset_collection_element_1_element_identifier | |
FROM dataset_collection LEFT OUTER JOIN dataset_collection_element AS dataset_collection_element_1 ON dataset_collection.id = dataset_collection_element_1.dataset_collection_id LEFT OUTER JOIN history_dataset_association AS history_dataset_association_1 ON dataset_collection_element_1.hda_id = history_dataset_association_1.id LEFT OUTER JOIN dataset AS dataset_1 ON dataset_1.id = history_dataset_association_1.dataset_id | |
WHERE dataset_collection.id = %(id_1)s ORDER BY dataset_collection_element_1.element_index | |
Parameters: {'id_1': 88} | |
galaxy.model.orm.engine_factory DEBUG 2018-04-25 13:32:54,829 Request query: 0.008370(s) | |
SELECT galaxy_user.id AS galaxy_user_id, galaxy_user.create_time AS galaxy_user_create_time, galaxy_user.update_time AS galaxy_user_update_time, galaxy_user.email AS galaxy_user_email, galaxy_user.username AS galaxy_user_username, galaxy_user.password AS galaxy_user_password, galaxy_user.last_password_change AS galaxy_user_last_password_change, galaxy_user.external AS galaxy_user_external, galaxy_user.form_values_id AS galaxy_user_form_values_id, galaxy_user.deleted AS galaxy_user_deleted, galaxy_user.purged AS galaxy_user_purged, galaxy_user.disk_usage AS galaxy_user_disk_usage, galaxy_user.active AS galaxy_user_active, galaxy_user.activation_token AS galaxy_user_activation_token, galaxy_group_1.id AS galaxy_group_1_id, galaxy_group_1.create_time AS galaxy_group_1_create_time, galaxy_group_1.update_time AS galaxy_group_1_update_time, galaxy_group_1.name AS galaxy_group_1_name, galaxy_group_1.deleted AS galaxy_group_1_deleted, role_1.id AS role_1_id, role_1.create_time AS role_1_create_time, role_1.update_time AS role_1_update_time, role_1.name AS role_1_name, role_1.description AS role_1_description, role_1.type AS role_1_type, role_1.deleted AS role_1_deleted, group_role_association_1.id AS group_role_association_1_id, group_role_association_1.group_id AS group_role_association_1_group_id, group_role_association_1.role_id AS group_role_association_1_role_id, group_role_association_1.create_time AS group_role_association_1_create_time, group_role_association_1.update_time AS group_role_association_1_update_time, user_group_association_1.id AS user_group_association_1_id, user_group_association_1.user_id AS user_group_association_1_user_id, user_group_association_1.group_id AS user_group_association_1_group_id, user_group_association_1.create_time AS user_group_association_1_create_time, user_group_association_1.update_time AS user_group_association_1_update_time, role_2.id AS role_2_id, role_2.create_time AS role_2_create_time, role_2.update_time AS role_2_update_time, role_2.name AS role_2_name, role_2.description AS role_2_description, role_2.type AS role_2_type, role_2.deleted AS role_2_deleted, user_role_association_1.id AS user_role_association_1_id, user_role_association_1.user_id AS user_role_association_1_user_id, user_role_association_1.role_id AS user_role_association_1_role_id, user_role_association_1.create_time AS user_role_association_1_create_time, user_role_association_1.update_time AS user_role_association_1_update_time | |
FROM galaxy_user LEFT OUTER JOIN user_group_association AS user_group_association_1 ON galaxy_user.id = user_group_association_1.user_id LEFT OUTER JOIN galaxy_group AS galaxy_group_1 ON galaxy_group_1.id = user_group_association_1.group_id LEFT OUTER JOIN group_role_association AS group_role_association_1 ON galaxy_group_1.id = group_role_association_1.group_id LEFT OUTER JOIN role AS role_1 ON role_1.id = group_role_association_1.role_id LEFT OUTER JOIN user_role_association AS user_role_association_1 ON galaxy_user.id = user_role_association_1.user_id LEFT OUTER JOIN role AS role_2 ON role_2.id = user_role_association_1.role_id | |
WHERE galaxy_user.id = %(id_1)s | |
Parameters: {'id_1': 1} | |
galaxy.model.orm.engine_factory DEBUG 2018-04-25 13:32:54,848 Request query: 0.005142(s) | |
SELECT dataset_collection.id AS dataset_collection_id, dataset_collection.collection_type AS dataset_collection_collection_type, dataset_collection.populated_state AS dataset_collection_populated_state, dataset_collection.populated_state_message AS dataset_collection_populated_state_message, dataset_collection.element_count AS dataset_collection_element_count, dataset_collection.create_time AS dataset_collection_create_time, dataset_collection.update_time AS dataset_collection_update_time, dataset_1.id AS dataset_1_id, dataset_1.create_time AS dataset_1_create_time, dataset_1.update_time AS dataset_1_update_time, dataset_1.state AS dataset_1_state, dataset_1.deleted AS dataset_1_deleted, dataset_1.purged AS dataset_1_purged, dataset_1.purgable AS dataset_1_purgable, dataset_1.object_store_id AS dataset_1_object_store_id, dataset_1.external_filename AS dataset_1_external_filename, dataset_1._extra_files_path AS dataset_1__extra_files_path, dataset_1.file_size AS dataset_1_file_size, dataset_1.total_size AS dataset_1_total_size, dataset_1.uuid AS dataset_1_uuid, history_dataset_association_1.id AS history_dataset_association_1_id, history_dataset_association_1.history_id AS history_dataset_association_1_history_id, history_dataset_association_1.dataset_id AS history_dataset_association_1_dataset_id, history_dataset_association_1.create_time AS history_dataset_association_1_create_time, history_dataset_association_1.update_time AS history_dataset_association_1_update_time, history_dataset_association_1.state AS history_dataset_association_1_state, history_dataset_association_1.copied_from_history_dataset_association_id AS history_dataset_association_1_copied_from_history_dataset_1, history_dataset_association_1.copied_from_library_dataset_dataset_association_id AS history_dataset_association_1_copied_from_library_dataset_2, history_dataset_association_1.name AS history_dataset_association_1_name, history_dataset_association_1.info AS history_dataset_association_1_info, history_dataset_association_1.blurb AS history_dataset_association_1_blurb, history_dataset_association_1.peek AS history_dataset_association_1_peek, history_dataset_association_1.tool_version AS history_dataset_association_1_tool_version, history_dataset_association_1.extension AS history_dataset_association_1_extension, history_dataset_association_1.parent_id AS history_dataset_association_1_parent_id, history_dataset_association_1.designation AS history_dataset_association_1_designation, history_dataset_association_1.deleted AS history_dataset_association_1_deleted, history_dataset_association_1.visible AS history_dataset_association_1_visible, history_dataset_association_1.extended_metadata_id AS history_dataset_association_1_extended_metadata_id, history_dataset_association_1.version AS history_dataset_association_1_version, history_dataset_association_1.hid AS history_dataset_association_1_hid, history_dataset_association_1.purged AS history_dataset_association_1_purged, history_dataset_association_1.hidden_beneath_collection_instance_id AS history_dataset_association_1_hidden_beneath_collection_i_3, dataset_collection_element_1.id AS dataset_collection_element_1_id, dataset_collection_element_1.dataset_collection_id AS dataset_collection_element_1_dataset_collection_id, dataset_collection_element_1.hda_id AS dataset_collection_element_1_hda_id, dataset_collection_element_1.ldda_id AS dataset_collection_element_1_ldda_id, dataset_collection_element_1.child_collection_id AS dataset_collection_element_1_child_collection_id, dataset_collection_element_1.element_index AS dataset_collection_element_1_element_index, dataset_collection_element_1.element_identifier AS dataset_collection_element_1_element_identifier | |
FROM dataset_collection LEFT OUTER JOIN dataset_collection_element AS dataset_collection_element_1 ON dataset_collection.id = dataset_collection_element_1.dataset_collection_id LEFT OUTER JOIN history_dataset_association AS history_dataset_association_1 ON dataset_collection_element_1.hda_id = history_dataset_association_1.id LEFT OUTER JOIN dataset AS dataset_1 ON dataset_1.id = history_dataset_association_1.dataset_id | |
WHERE dataset_collection.id = %(id_1)s ORDER BY dataset_collection_element_1.element_index | |
Parameters: {'id_1': 89} | |
galaxy.model.orm.engine_factory DEBUG 2018-04-25 13:32:54,862 Request query: 0.006307(s) | |
SELECT dataset_collection.id AS dataset_collection_id, dataset_collection.collection_type AS dataset_collection_collection_type, dataset_collection.populated_state AS dataset_collection_populated_state, dataset_collection.populated_state_message AS dataset_collection_populated_state_message, dataset_collection.element_count AS dataset_collection_element_count, dataset_collection.create_time AS dataset_collection_create_time, dataset_collection.update_time AS dataset_collection_update_time, dataset_1.id AS dataset_1_id, dataset_1.create_time AS dataset_1_create_time, dataset_1.update_time AS dataset_1_update_time, dataset_1.state AS dataset_1_state, dataset_1.deleted AS dataset_1_deleted, dataset_1.purged AS dataset_1_purged, dataset_1.purgable AS dataset_1_purgable, dataset_1.object_store_id AS dataset_1_object_store_id, dataset_1.external_filename AS dataset_1_external_filename, dataset_1._extra_files_path AS dataset_1__extra_files_path, dataset_1.file_size AS dataset_1_file_size, dataset_1.total_size AS dataset_1_total_size, dataset_1.uuid AS dataset_1_uuid, history_dataset_association_1.id AS history_dataset_association_1_id, history_dataset_association_1.history_id AS history_dataset_association_1_history_id, history_dataset_association_1.dataset_id AS history_dataset_association_1_dataset_id, history_dataset_association_1.create_time AS history_dataset_association_1_create_time, history_dataset_association_1.update_time AS history_dataset_association_1_update_time, history_dataset_association_1.state AS history_dataset_association_1_state, history_dataset_association_1.copied_from_history_dataset_association_id AS history_dataset_association_1_copied_from_history_dataset_1, history_dataset_association_1.copied_from_library_dataset_dataset_association_id AS history_dataset_association_1_copied_from_library_dataset_2, history_dataset_association_1.name AS history_dataset_association_1_name, history_dataset_association_1.info AS history_dataset_association_1_info, history_dataset_association_1.blurb AS history_dataset_association_1_blurb, history_dataset_association_1.peek AS history_dataset_association_1_peek, history_dataset_association_1.tool_version AS history_dataset_association_1_tool_version, history_dataset_association_1.extension AS history_dataset_association_1_extension, history_dataset_association_1.parent_id AS history_dataset_association_1_parent_id, history_dataset_association_1.designation AS history_dataset_association_1_designation, history_dataset_association_1.deleted AS history_dataset_association_1_deleted, history_dataset_association_1.visible AS history_dataset_association_1_visible, history_dataset_association_1.extended_metadata_id AS history_dataset_association_1_extended_metadata_id, history_dataset_association_1.version AS history_dataset_association_1_version, history_dataset_association_1.hid AS history_dataset_association_1_hid, history_dataset_association_1.purged AS history_dataset_association_1_purged, history_dataset_association_1.hidden_beneath_collection_instance_id AS history_dataset_association_1_hidden_beneath_collection_i_3, dataset_collection_element_1.id AS dataset_collection_element_1_id, dataset_collection_element_1.dataset_collection_id AS dataset_collection_element_1_dataset_collection_id, dataset_collection_element_1.hda_id AS dataset_collection_element_1_hda_id, dataset_collection_element_1.ldda_id AS dataset_collection_element_1_ldda_id, dataset_collection_element_1.child_collection_id AS dataset_collection_element_1_child_collection_id, dataset_collection_element_1.element_index AS dataset_collection_element_1_element_index, dataset_collection_element_1.element_identifier AS dataset_collection_element_1_element_identifier | |
FROM dataset_collection LEFT OUTER JOIN dataset_collection_element AS dataset_collection_element_1 ON dataset_collection.id = dataset_collection_element_1.dataset_collection_id LEFT OUTER JOIN history_dataset_association AS history_dataset_association_1 ON dataset_collection_element_1.hda_id = history_dataset_association_1.id LEFT OUTER JOIN dataset AS dataset_1 ON dataset_1.id = history_dataset_association_1.dataset_id | |
WHERE dataset_collection.id = %(id_1)s ORDER BY dataset_collection_element_1.element_index | |
Parameters: {'id_1': 90} | |
galaxy.model.orm.engine_factory DEBUG 2018-04-25 13:32:54,875 Request query: 0.004087(s) | |
SELECT dataset_collection.id AS dataset_collection_id, dataset_collection.collection_type AS dataset_collection_collection_type, dataset_collection.populated_state AS dataset_collection_populated_state, dataset_collection.populated_state_message AS dataset_collection_populated_state_message, dataset_collection.element_count AS dataset_collection_element_count, dataset_collection.create_time AS dataset_collection_create_time, dataset_collection.update_time AS dataset_collection_update_time, dataset_1.id AS dataset_1_id, dataset_1.create_time AS dataset_1_create_time, dataset_1.update_time AS dataset_1_update_time, dataset_1.state AS dataset_1_state, dataset_1.deleted AS dataset_1_deleted, dataset_1.purged AS dataset_1_purged, dataset_1.purgable AS dataset_1_purgable, dataset_1.object_store_id AS dataset_1_object_store_id, dataset_1.external_filename AS dataset_1_external_filename, dataset_1._extra_files_path AS dataset_1__extra_files_path, dataset_1.file_size AS dataset_1_file_size, dataset_1.total_size AS dataset_1_total_size, dataset_1.uuid AS dataset_1_uuid, history_dataset_association_1.id AS history_dataset_association_1_id, history_dataset_association_1.history_id AS history_dataset_association_1_history_id, history_dataset_association_1.dataset_id AS history_dataset_association_1_dataset_id, history_dataset_association_1.create_time AS history_dataset_association_1_create_time, history_dataset_association_1.update_time AS history_dataset_association_1_update_time, history_dataset_association_1.state AS history_dataset_association_1_state, history_dataset_association_1.copied_from_history_dataset_association_id AS history_dataset_association_1_copied_from_history_dataset_1, history_dataset_association_1.copied_from_library_dataset_dataset_association_id AS history_dataset_association_1_copied_from_library_dataset_2, history_dataset_association_1.name AS history_dataset_association_1_name, history_dataset_association_1.info AS history_dataset_association_1_info, history_dataset_association_1.blurb AS history_dataset_association_1_blurb, history_dataset_association_1.peek AS history_dataset_association_1_peek, history_dataset_association_1.tool_version AS history_dataset_association_1_tool_version, history_dataset_association_1.extension AS history_dataset_association_1_extension, history_dataset_association_1.parent_id AS history_dataset_association_1_parent_id, history_dataset_association_1.designation AS history_dataset_association_1_designation, history_dataset_association_1.deleted AS history_dataset_association_1_deleted, history_dataset_association_1.visible AS history_dataset_association_1_visible, history_dataset_association_1.extended_metadata_id AS history_dataset_association_1_extended_metadata_id, history_dataset_association_1.version AS history_dataset_association_1_version, history_dataset_association_1.hid AS history_dataset_association_1_hid, history_dataset_association_1.purged AS history_dataset_association_1_purged, history_dataset_association_1.hidden_beneath_collection_instance_id AS history_dataset_association_1_hidden_beneath_collection_i_3, dataset_collection_element_1.id AS dataset_collection_element_1_id, dataset_collection_element_1.dataset_collection_id AS dataset_collection_element_1_dataset_collection_id, dataset_collection_element_1.hda_id AS dataset_collection_element_1_hda_id, dataset_collection_element_1.ldda_id AS dataset_collection_element_1_ldda_id, dataset_collection_element_1.child_collection_id AS dataset_collection_element_1_child_collection_id, dataset_collection_element_1.element_index AS dataset_collection_element_1_element_index, dataset_collection_element_1.element_identifier AS dataset_collection_element_1_element_identifier | |
FROM dataset_collection LEFT OUTER JOIN dataset_collection_element AS dataset_collection_element_1 ON dataset_collection.id = dataset_collection_element_1.dataset_collection_id LEFT OUTER JOIN history_dataset_association AS history_dataset_association_1 ON dataset_collection_element_1.hda_id = history_dataset_association_1.id LEFT OUTER JOIN dataset AS dataset_1 ON dataset_1.id = history_dataset_association_1.dataset_id | |
WHERE dataset_collection.id = %(id_1)s ORDER BY dataset_collection_element_1.element_index | |
Parameters: {'id_1': 96} | |
galaxy.model.orm.engine_factory DEBUG 2018-04-25 13:32:54,887 Request query: 0.003809(s) | |
SELECT dataset_collection.id AS dataset_collection_id, dataset_collection.collection_type AS dataset_collection_collection_type, dataset_collection.populated_state AS dataset_collection_populated_state, dataset_collection.populated_state_message AS dataset_collection_populated_state_message, dataset_collection.element_count AS dataset_collection_element_count, dataset_collection.create_time AS dataset_collection_create_time, dataset_collection.update_time AS dataset_collection_update_time, dataset_1.id AS dataset_1_id, dataset_1.create_time AS dataset_1_create_time, dataset_1.update_time AS dataset_1_update_time, dataset_1.state AS dataset_1_state, dataset_1.deleted AS dataset_1_deleted, dataset_1.purged AS dataset_1_purged, dataset_1.purgable AS dataset_1_purgable, dataset_1.object_store_id AS dataset_1_object_store_id, dataset_1.external_filename AS dataset_1_external_filename, dataset_1._extra_files_path AS dataset_1__extra_files_path, dataset_1.file_size AS dataset_1_file_size, dataset_1.total_size AS dataset_1_total_size, dataset_1.uuid AS dataset_1_uuid, history_dataset_association_1.id AS history_dataset_association_1_id, history_dataset_association_1.history_id AS history_dataset_association_1_history_id, history_dataset_association_1.dataset_id AS history_dataset_association_1_dataset_id, history_dataset_association_1.create_time AS history_dataset_association_1_create_time, history_dataset_association_1.update_time AS history_dataset_association_1_update_time, history_dataset_association_1.state AS history_dataset_association_1_state, history_dataset_association_1.copied_from_history_dataset_association_id AS history_dataset_association_1_copied_from_history_dataset_1, history_dataset_association_1.copied_from_library_dataset_dataset_association_id AS history_dataset_association_1_copied_from_library_dataset_2, history_dataset_association_1.name AS history_dataset_association_1_name, history_dataset_association_1.info AS history_dataset_association_1_info, history_dataset_association_1.blurb AS history_dataset_association_1_blurb, history_dataset_association_1.peek AS history_dataset_association_1_peek, history_dataset_association_1.tool_version AS history_dataset_association_1_tool_version, history_dataset_association_1.extension AS history_dataset_association_1_extension, history_dataset_association_1.parent_id AS history_dataset_association_1_parent_id, history_dataset_association_1.designation AS history_dataset_association_1_designation, history_dataset_association_1.deleted AS history_dataset_association_1_deleted, history_dataset_association_1.visible AS history_dataset_association_1_visible, history_dataset_association_1.extended_metadata_id AS history_dataset_association_1_extended_metadata_id, history_dataset_association_1.version AS history_dataset_association_1_version, history_dataset_association_1.hid AS history_dataset_association_1_hid, history_dataset_association_1.purged AS history_dataset_association_1_purged, history_dataset_association_1.hidden_beneath_collection_instance_id AS history_dataset_association_1_hidden_beneath_collection_i_3, dataset_collection_element_1.id AS dataset_collection_element_1_id, dataset_collection_element_1.dataset_collection_id AS dataset_collection_element_1_dataset_collection_id, dataset_collection_element_1.hda_id AS dataset_collection_element_1_hda_id, dataset_collection_element_1.ldda_id AS dataset_collection_element_1_ldda_id, dataset_collection_element_1.child_collection_id AS dataset_collection_element_1_child_collection_id, dataset_collection_element_1.element_index AS dataset_collection_element_1_element_index, dataset_collection_element_1.element_identifier AS dataset_collection_element_1_element_identifier | |
FROM dataset_collection LEFT OUTER JOIN dataset_collection_element AS dataset_collection_element_1 ON dataset_collection.id = dataset_collection_element_1.dataset_collection_id LEFT OUTER JOIN history_dataset_association AS history_dataset_association_1 ON dataset_collection_element_1.hda_id = history_dataset_association_1.id LEFT OUTER JOIN dataset AS dataset_1 ON dataset_1.id = history_dataset_association_1.dataset_id | |
WHERE dataset_collection.id = %(id_1)s ORDER BY dataset_collection_element_1.element_index | |
Parameters: {'id_1': 97} | |
galaxy.model.orm.engine_factory DEBUG 2018-04-25 13:32:54,912 Request query: 0.005061(s) | |
SELECT dataset_collection.id AS dataset_collection_id, dataset_collection.collection_type AS dataset_collection_collection_type, dataset_collection.populated_state AS dataset_collection_populated_state, dataset_collection.populated_state_message AS dataset_collection_populated_state_message, dataset_collection.element_count AS dataset_collection_element_count, dataset_collection.create_time AS dataset_collection_create_time, dataset_collection.update_time AS dataset_collection_update_time, dataset_1.id AS dataset_1_id, dataset_1.create_time AS dataset_1_create_time, dataset_1.update_time AS dataset_1_update_time, dataset_1.state AS dataset_1_state, dataset_1.deleted AS dataset_1_deleted, dataset_1.purged AS dataset_1_purged, dataset_1.purgable AS dataset_1_purgable, dataset_1.object_store_id AS dataset_1_object_store_id, dataset_1.external_filename AS dataset_1_external_filename, dataset_1._extra_files_path AS dataset_1__extra_files_path, dataset_1.file_size AS dataset_1_file_size, dataset_1.total_size AS dataset_1_total_size, dataset_1.uuid AS dataset_1_uuid, history_dataset_association_1.id AS history_dataset_association_1_id, history_dataset_association_1.history_id AS history_dataset_association_1_history_id, history_dataset_association_1.dataset_id AS history_dataset_association_1_dataset_id, history_dataset_association_1.create_time AS history_dataset_association_1_create_time, history_dataset_association_1.update_time AS history_dataset_association_1_update_time, history_dataset_association_1.state AS history_dataset_association_1_state, history_dataset_association_1.copied_from_history_dataset_association_id AS history_dataset_association_1_copied_from_history_dataset_1, history_dataset_association_1.copied_from_library_dataset_dataset_association_id AS history_dataset_association_1_copied_from_library_dataset_2, history_dataset_association_1.name AS history_dataset_association_1_name, history_dataset_association_1.info AS history_dataset_association_1_info, history_dataset_association_1.blurb AS history_dataset_association_1_blurb, history_dataset_association_1.peek AS history_dataset_association_1_peek, history_dataset_association_1.tool_version AS history_dataset_association_1_tool_version, history_dataset_association_1.extension AS history_dataset_association_1_extension, history_dataset_association_1.parent_id AS history_dataset_association_1_parent_id, history_dataset_association_1.designation AS history_dataset_association_1_designation, history_dataset_association_1.deleted AS history_dataset_association_1_deleted, history_dataset_association_1.visible AS history_dataset_association_1_visible, history_dataset_association_1.extended_metadata_id AS history_dataset_association_1_extended_metadata_id, history_dataset_association_1.version AS history_dataset_association_1_version, history_dataset_association_1.hid AS history_dataset_association_1_hid, history_dataset_association_1.purged AS history_dataset_association_1_purged, history_dataset_association_1.hidden_beneath_collection_instance_id AS history_dataset_association_1_hidden_beneath_collection_i_3, dataset_collection_element_1.id AS dataset_collection_element_1_id, dataset_collection_element_1.dataset_collection_id AS dataset_collection_element_1_dataset_collection_id, dataset_collection_element_1.hda_id AS dataset_collection_element_1_hda_id, dataset_collection_element_1.ldda_id AS dataset_collection_element_1_ldda_id, dataset_collection_element_1.child_collection_id AS dataset_collection_element_1_child_collection_id, dataset_collection_element_1.element_index AS dataset_collection_element_1_element_index, dataset_collection_element_1.element_identifier AS dataset_collection_element_1_element_identifier | |
FROM dataset_collection LEFT OUTER JOIN dataset_collection_element AS dataset_collection_element_1 ON dataset_collection.id = dataset_collection_element_1.dataset_collection_id LEFT OUTER JOIN history_dataset_association AS history_dataset_association_1 ON dataset_collection_element_1.hda_id = history_dataset_association_1.id LEFT OUTER JOIN dataset AS dataset_1 ON dataset_1.id = history_dataset_association_1.dataset_id | |
WHERE dataset_collection.id = %(id_1)s ORDER BY dataset_collection_element_1.element_index | |
Parameters: {'id_1': 98} | |
galaxy.model.orm.engine_factory DEBUG 2018-04-25 13:32:54,930 Request query: 0.006252(s) | |
SELECT dataset_collection.id AS dataset_collection_id, dataset_collection.collection_type AS dataset_collection_collection_type, dataset_collection.populated_state AS dataset_collection_populated_state, dataset_collection.populated_state_message AS dataset_collection_populated_state_message, dataset_collection.element_count AS dataset_collection_element_count, dataset_collection.create_time AS dataset_collection_create_time, dataset_collection.update_time AS dataset_collection_update_time, dataset_1.id AS dataset_1_id, dataset_1.create_time AS dataset_1_create_time, dataset_1.update_time AS dataset_1_update_time, dataset_1.state AS dataset_1_state, dataset_1.deleted AS dataset_1_deleted, dataset_1.purged AS dataset_1_purged, dataset_1.purgable AS dataset_1_purgable, dataset_1.object_store_id AS dataset_1_object_store_id, dataset_1.external_filename AS dataset_1_external_filename, dataset_1._extra_files_path AS dataset_1__extra_files_path, dataset_1.file_size AS dataset_1_file_size, dataset_1.total_size AS dataset_1_total_size, dataset_1.uuid AS dataset_1_uuid, history_dataset_association_1.id AS history_dataset_association_1_id, history_dataset_association_1.history_id AS history_dataset_association_1_history_id, history_dataset_association_1.dataset_id AS history_dataset_association_1_dataset_id, history_dataset_association_1.create_time AS history_dataset_association_1_create_time, history_dataset_association_1.update_time AS history_dataset_association_1_update_time, history_dataset_association_1.state AS history_dataset_association_1_state, history_dataset_association_1.copied_from_history_dataset_association_id AS history_dataset_association_1_copied_from_history_dataset_1, history_dataset_association_1.copied_from_library_dataset_dataset_association_id AS history_dataset_association_1_copied_from_library_dataset_2, history_dataset_association_1.name AS history_dataset_association_1_name, history_dataset_association_1.info AS history_dataset_association_1_info, history_dataset_association_1.blurb AS history_dataset_association_1_blurb, history_dataset_association_1.peek AS history_dataset_association_1_peek, history_dataset_association_1.tool_version AS history_dataset_association_1_tool_version, history_dataset_association_1.extension AS history_dataset_association_1_extension, history_dataset_association_1.parent_id AS history_dataset_association_1_parent_id, history_dataset_association_1.designation AS history_dataset_association_1_designation, history_dataset_association_1.deleted AS history_dataset_association_1_deleted, history_dataset_association_1.visible AS history_dataset_association_1_visible, history_dataset_association_1.extended_metadata_id AS history_dataset_association_1_extended_metadata_id, history_dataset_association_1.version AS history_dataset_association_1_version, history_dataset_association_1.hid AS history_dataset_association_1_hid, history_dataset_association_1.purged AS history_dataset_association_1_purged, history_dataset_association_1.hidden_beneath_collection_instance_id AS history_dataset_association_1_hidden_beneath_collection_i_3, dataset_collection_element_1.id AS dataset_collection_element_1_id, dataset_collection_element_1.dataset_collection_id AS dataset_collection_element_1_dataset_collection_id, dataset_collection_element_1.hda_id AS dataset_collection_element_1_hda_id, dataset_collection_element_1.ldda_id AS dataset_collection_element_1_ldda_id, dataset_collection_element_1.child_collection_id AS dataset_collection_element_1_child_collection_id, dataset_collection_element_1.element_index AS dataset_collection_element_1_element_index, dataset_collection_element_1.element_identifier AS dataset_collection_element_1_element_identifier | |
FROM dataset_collection LEFT OUTER JOIN dataset_collection_element AS dataset_collection_element_1 ON dataset_collection.id = dataset_collection_element_1.dataset_collection_id LEFT OUTER JOIN history_dataset_association AS history_dataset_association_1 ON dataset_collection_element_1.hda_id = history_dataset_association_1.id LEFT OUTER JOIN dataset AS dataset_1 ON dataset_1.id = history_dataset_association_1.dataset_id | |
WHERE dataset_collection.id = %(id_1)s ORDER BY dataset_collection_element_1.element_index | |
Parameters: {'id_1': 99} | |
galaxy.model.orm.engine_factory DEBUG 2018-04-25 13:32:54,941 Request query: 0.004270(s) | |
SELECT dataset_collection.id AS dataset_collection_id, dataset_collection.collection_type AS dataset_collection_collection_type, dataset_collection.populated_state AS dataset_collection_populated_state, dataset_collection.populated_state_message AS dataset_collection_populated_state_message, dataset_collection.element_count AS dataset_collection_element_count, dataset_collection.create_time AS dataset_collection_create_time, dataset_collection.update_time AS dataset_collection_update_time, dataset_1.id AS dataset_1_id, dataset_1.create_time AS dataset_1_create_time, dataset_1.update_time AS dataset_1_update_time, dataset_1.state AS dataset_1_state, dataset_1.deleted AS dataset_1_deleted, dataset_1.purged AS dataset_1_purged, dataset_1.purgable AS dataset_1_purgable, dataset_1.object_store_id AS dataset_1_object_store_id, dataset_1.external_filename AS dataset_1_external_filename, dataset_1._extra_files_path AS dataset_1__extra_files_path, dataset_1.file_size AS dataset_1_file_size, dataset_1.total_size AS dataset_1_total_size, dataset_1.uuid AS dataset_1_uuid, history_dataset_association_1.id AS history_dataset_association_1_id, history_dataset_association_1.history_id AS history_dataset_association_1_history_id, history_dataset_association_1.dataset_id AS history_dataset_association_1_dataset_id, history_dataset_association_1.create_time AS history_dataset_association_1_create_time, history_dataset_association_1.update_time AS history_dataset_association_1_update_time, history_dataset_association_1.state AS history_dataset_association_1_state, history_dataset_association_1.copied_from_history_dataset_association_id AS history_dataset_association_1_copied_from_history_dataset_1, history_dataset_association_1.copied_from_library_dataset_dataset_association_id AS history_dataset_association_1_copied_from_library_dataset_2, history_dataset_association_1.name AS history_dataset_association_1_name, history_dataset_association_1.info AS history_dataset_association_1_info, history_dataset_association_1.blurb AS history_dataset_association_1_blurb, history_dataset_association_1.peek AS history_dataset_association_1_peek, history_dataset_association_1.tool_version AS history_dataset_association_1_tool_version, history_dataset_association_1.extension AS history_dataset_association_1_extension, history_dataset_association_1.parent_id AS history_dataset_association_1_parent_id, history_dataset_association_1.designation AS history_dataset_association_1_designation, history_dataset_association_1.deleted AS history_dataset_association_1_deleted, history_dataset_association_1.visible AS history_dataset_association_1_visible, history_dataset_association_1.extended_metadata_id AS history_dataset_association_1_extended_metadata_id, history_dataset_association_1.version AS history_dataset_association_1_version, history_dataset_association_1.hid AS history_dataset_association_1_hid, history_dataset_association_1.purged AS history_dataset_association_1_purged, history_dataset_association_1.hidden_beneath_collection_instance_id AS history_dataset_association_1_hidden_beneath_collection_i_3, dataset_collection_element_1.id AS dataset_collection_element_1_id, dataset_collection_element_1.dataset_collection_id AS dataset_collection_element_1_dataset_collection_id, dataset_collection_element_1.hda_id AS dataset_collection_element_1_hda_id, dataset_collection_element_1.ldda_id AS dataset_collection_element_1_ldda_id, dataset_collection_element_1.child_collection_id AS dataset_collection_element_1_child_collection_id, dataset_collection_element_1.element_index AS dataset_collection_element_1_element_index, dataset_collection_element_1.element_identifier AS dataset_collection_element_1_element_identifier | |
FROM dataset_collection LEFT OUTER JOIN dataset_collection_element AS dataset_collection_element_1 ON dataset_collection.id = dataset_collection_element_1.dataset_collection_id LEFT OUTER JOIN history_dataset_association AS history_dataset_association_1 ON dataset_collection_element_1.hda_id = history_dataset_association_1.id LEFT OUTER JOIN dataset AS dataset_1 ON dataset_1.id = history_dataset_association_1.dataset_id | |
WHERE dataset_collection.id = %(id_1)s ORDER BY dataset_collection_element_1.element_index | |
Parameters: {'id_1': 100} | |
galaxy.model.orm.engine_factory DEBUG 2018-04-25 13:32:54,952 Request query: 0.004207(s) | |
SELECT dataset_collection.id AS dataset_collection_id, dataset_collection.collection_type AS dataset_collection_collection_type, dataset_collection.populated_state AS dataset_collection_populated_state, dataset_collection.populated_state_message AS dataset_collection_populated_state_message, dataset_collection.element_count AS dataset_collection_element_count, dataset_collection.create_time AS dataset_collection_create_time, dataset_collection.update_time AS dataset_collection_update_time, dataset_1.id AS dataset_1_id, dataset_1.create_time AS dataset_1_create_time, dataset_1.update_time AS dataset_1_update_time, dataset_1.state AS dataset_1_state, dataset_1.deleted AS dataset_1_deleted, dataset_1.purged AS dataset_1_purged, dataset_1.purgable AS dataset_1_purgable, dataset_1.object_store_id AS dataset_1_object_store_id, dataset_1.external_filename AS dataset_1_external_filename, dataset_1._extra_files_path AS dataset_1__extra_files_path, dataset_1.file_size AS dataset_1_file_size, dataset_1.total_size AS dataset_1_total_size, dataset_1.uuid AS dataset_1_uuid, history_dataset_association_1.id AS history_dataset_association_1_id, history_dataset_association_1.history_id AS history_dataset_association_1_history_id, history_dataset_association_1.dataset_id AS history_dataset_association_1_dataset_id, history_dataset_association_1.create_time AS history_dataset_association_1_create_time, history_dataset_association_1.update_time AS history_dataset_association_1_update_time, history_dataset_association_1.state AS history_dataset_association_1_state, history_dataset_association_1.copied_from_history_dataset_association_id AS history_dataset_association_1_copied_from_history_dataset_1, history_dataset_association_1.copied_from_library_dataset_dataset_association_id AS history_dataset_association_1_copied_from_library_dataset_2, history_dataset_association_1.name AS history_dataset_association_1_name, history_dataset_association_1.info AS history_dataset_association_1_info, history_dataset_association_1.blurb AS history_dataset_association_1_blurb, history_dataset_association_1.peek AS history_dataset_association_1_peek, history_dataset_association_1.tool_version AS history_dataset_association_1_tool_version, history_dataset_association_1.extension AS history_dataset_association_1_extension, history_dataset_association_1.parent_id AS history_dataset_association_1_parent_id, history_dataset_association_1.designation AS history_dataset_association_1_designation, history_dataset_association_1.deleted AS history_dataset_association_1_deleted, history_dataset_association_1.visible AS history_dataset_association_1_visible, history_dataset_association_1.extended_metadata_id AS history_dataset_association_1_extended_metadata_id, history_dataset_association_1.version AS history_dataset_association_1_version, history_dataset_association_1.hid AS history_dataset_association_1_hid, history_dataset_association_1.purged AS history_dataset_association_1_purged, history_dataset_association_1.hidden_beneath_collection_instance_id AS history_dataset_association_1_hidden_beneath_collection_i_3, dataset_collection_element_1.id AS dataset_collection_element_1_id, dataset_collection_element_1.dataset_collection_id AS dataset_collection_element_1_dataset_collection_id, dataset_collection_element_1.hda_id AS dataset_collection_element_1_hda_id, dataset_collection_element_1.ldda_id AS dataset_collection_element_1_ldda_id, dataset_collection_element_1.child_collection_id AS dataset_collection_element_1_child_collection_id, dataset_collection_element_1.element_index AS dataset_collection_element_1_element_index, dataset_collection_element_1.element_identifier AS dataset_collection_element_1_element_identifier | |
FROM dataset_collection LEFT OUTER JOIN dataset_collection_element AS dataset_collection_element_1 ON dataset_collection.id = dataset_collection_element_1.dataset_collection_id LEFT OUTER JOIN history_dataset_association AS history_dataset_association_1 ON dataset_collection_element_1.hda_id = history_dataset_association_1.id LEFT OUTER JOIN dataset AS dataset_1 ON dataset_1.id = history_dataset_association_1.dataset_id | |
WHERE dataset_collection.id = %(id_1)s ORDER BY dataset_collection_element_1.element_index | |
Parameters: {'id_1': 101} | |
galaxy.model.orm.engine_factory DEBUG 2018-04-25 13:32:54,967 Request query: 0.003891(s) | |
SELECT dataset_collection.id AS dataset_collection_id, dataset_collection.collection_type AS dataset_collection_collection_type, dataset_collection.populated_state AS dataset_collection_populated_state, dataset_collection.populated_state_message AS dataset_collection_populated_state_message, dataset_collection.element_count AS dataset_collection_element_count, dataset_collection.create_time AS dataset_collection_create_time, dataset_collection.update_time AS dataset_collection_update_time, dataset_1.id AS dataset_1_id, dataset_1.create_time AS dataset_1_create_time, dataset_1.update_time AS dataset_1_update_time, dataset_1.state AS dataset_1_state, dataset_1.deleted AS dataset_1_deleted, dataset_1.purged AS dataset_1_purged, dataset_1.purgable AS dataset_1_purgable, dataset_1.object_store_id AS dataset_1_object_store_id, dataset_1.external_filename AS dataset_1_external_filename, dataset_1._extra_files_path AS dataset_1__extra_files_path, dataset_1.file_size AS dataset_1_file_size, dataset_1.total_size AS dataset_1_total_size, dataset_1.uuid AS dataset_1_uuid, history_dataset_association_1.id AS history_dataset_association_1_id, history_dataset_association_1.history_id AS history_dataset_association_1_history_id, history_dataset_association_1.dataset_id AS history_dataset_association_1_dataset_id, history_dataset_association_1.create_time AS history_dataset_association_1_create_time, history_dataset_association_1.update_time AS history_dataset_association_1_update_time, history_dataset_association_1.state AS history_dataset_association_1_state, history_dataset_association_1.copied_from_history_dataset_association_id AS history_dataset_association_1_copied_from_history_dataset_1, history_dataset_association_1.copied_from_library_dataset_dataset_association_id AS history_dataset_association_1_copied_from_library_dataset_2, history_dataset_association_1.name AS history_dataset_association_1_name, history_dataset_association_1.info AS history_dataset_association_1_info, history_dataset_association_1.blurb AS history_dataset_association_1_blurb, history_dataset_association_1.peek AS history_dataset_association_1_peek, history_dataset_association_1.tool_version AS history_dataset_association_1_tool_version, history_dataset_association_1.extension AS history_dataset_association_1_extension, history_dataset_association_1.parent_id AS history_dataset_association_1_parent_id, history_dataset_association_1.designation AS history_dataset_association_1_designation, history_dataset_association_1.deleted AS history_dataset_association_1_deleted, history_dataset_association_1.visible AS history_dataset_association_1_visible, history_dataset_association_1.extended_metadata_id AS history_dataset_association_1_extended_metadata_id, history_dataset_association_1.version AS history_dataset_association_1_version, history_dataset_association_1.hid AS history_dataset_association_1_hid, history_dataset_association_1.purged AS history_dataset_association_1_purged, history_dataset_association_1.hidden_beneath_collection_instance_id AS history_dataset_association_1_hidden_beneath_collection_i_3, dataset_collection_element_1.id AS dataset_collection_element_1_id, dataset_collection_element_1.dataset_collection_id AS dataset_collection_element_1_dataset_collection_id, dataset_collection_element_1.hda_id AS dataset_collection_element_1_hda_id, dataset_collection_element_1.ldda_id AS dataset_collection_element_1_ldda_id, dataset_collection_element_1.child_collection_id AS dataset_collection_element_1_child_collection_id, dataset_collection_element_1.element_index AS dataset_collection_element_1_element_index, dataset_collection_element_1.element_identifier AS dataset_collection_element_1_element_identifier | |
FROM dataset_collection LEFT OUTER JOIN dataset_collection_element AS dataset_collection_element_1 ON dataset_collection.id = dataset_collection_element_1.dataset_collection_id LEFT OUTER JOIN history_dataset_association AS history_dataset_association_1 ON dataset_collection_element_1.hda_id = history_dataset_association_1.id LEFT OUTER JOIN dataset AS dataset_1 ON dataset_1.id = history_dataset_association_1.dataset_id | |
WHERE dataset_collection.id = %(id_1)s ORDER BY dataset_collection_element_1.element_index | |
Parameters: {'id_1': 119} | |
galaxy.model.orm.engine_factory DEBUG 2018-04-25 13:32:54,979 Request query: 0.005307(s) | |
SELECT dataset_collection.id AS dataset_collection_id, dataset_collection.collection_type AS dataset_collection_collection_type, dataset_collection.populated_state AS dataset_collection_populated_state, dataset_collection.populated_state_message AS dataset_collection_populated_state_message, dataset_collection.element_count AS dataset_collection_element_count, dataset_collection.create_time AS dataset_collection_create_time, dataset_collection.update_time AS dataset_collection_update_time, dataset_1.id AS dataset_1_id, dataset_1.create_time AS dataset_1_create_time, dataset_1.update_time AS dataset_1_update_time, dataset_1.state AS dataset_1_state, dataset_1.deleted AS dataset_1_deleted, dataset_1.purged AS dataset_1_purged, dataset_1.purgable AS dataset_1_purgable, dataset_1.object_store_id AS dataset_1_object_store_id, dataset_1.external_filename AS dataset_1_external_filename, dataset_1._extra_files_path AS dataset_1__extra_files_path, dataset_1.file_size AS dataset_1_file_size, dataset_1.total_size AS dataset_1_total_size, dataset_1.uuid AS dataset_1_uuid, history_dataset_association_1.id AS history_dataset_association_1_id, history_dataset_association_1.history_id AS history_dataset_association_1_history_id, history_dataset_association_1.dataset_id AS history_dataset_association_1_dataset_id, history_dataset_association_1.create_time AS history_dataset_association_1_create_time, history_dataset_association_1.update_time AS history_dataset_association_1_update_time, history_dataset_association_1.state AS history_dataset_association_1_state, history_dataset_association_1.copied_from_history_dataset_association_id AS history_dataset_association_1_copied_from_history_dataset_1, history_dataset_association_1.copied_from_library_dataset_dataset_association_id AS history_dataset_association_1_copied_from_library_dataset_2, history_dataset_association_1.name AS history_dataset_association_1_name, history_dataset_association_1.info AS history_dataset_association_1_info, history_dataset_association_1.blurb AS history_dataset_association_1_blurb, history_dataset_association_1.peek AS history_dataset_association_1_peek, history_dataset_association_1.tool_version AS history_dataset_association_1_tool_version, history_dataset_association_1.extension AS history_dataset_association_1_extension, history_dataset_association_1.parent_id AS history_dataset_association_1_parent_id, history_dataset_association_1.designation AS history_dataset_association_1_designation, history_dataset_association_1.deleted AS history_dataset_association_1_deleted, history_dataset_association_1.visible AS history_dataset_association_1_visible, history_dataset_association_1.extended_metadata_id AS history_dataset_association_1_extended_metadata_id, history_dataset_association_1.version AS history_dataset_association_1_version, history_dataset_association_1.hid AS history_dataset_association_1_hid, history_dataset_association_1.purged AS history_dataset_association_1_purged, history_dataset_association_1.hidden_beneath_collection_instance_id AS history_dataset_association_1_hidden_beneath_collection_i_3, dataset_collection_element_1.id AS dataset_collection_element_1_id, dataset_collection_element_1.dataset_collection_id AS dataset_collection_element_1_dataset_collection_id, dataset_collection_element_1.hda_id AS dataset_collection_element_1_hda_id, dataset_collection_element_1.ldda_id AS dataset_collection_element_1_ldda_id, dataset_collection_element_1.child_collection_id AS dataset_collection_element_1_child_collection_id, dataset_collection_element_1.element_index AS dataset_collection_element_1_element_index, dataset_collection_element_1.element_identifier AS dataset_collection_element_1_element_identifier | |
FROM dataset_collection LEFT OUTER JOIN dataset_collection_element AS dataset_collection_element_1 ON dataset_collection.id = dataset_collection_element_1.dataset_collection_id LEFT OUTER JOIN history_dataset_association AS history_dataset_association_1 ON dataset_collection_element_1.hda_id = history_dataset_association_1.id LEFT OUTER JOIN dataset AS dataset_1 ON dataset_1.id = history_dataset_association_1.dataset_id | |
WHERE dataset_collection.id = %(id_1)s ORDER BY dataset_collection_element_1.element_index | |
Parameters: {'id_1': 121} | |
galaxy.model.orm.engine_factory DEBUG 2018-04-25 13:32:54,986 Request query: 0.002093(s) | |
SELECT dataset_permissions.id AS dataset_permissions_id, dataset_permissions.create_time AS dataset_permissions_create_time, dataset_permissions.update_time AS dataset_permissions_update_time, dataset_permissions.action AS dataset_permissions_action, dataset_permissions.dataset_id AS dataset_permissions_dataset_id, dataset_permissions.role_id AS dataset_permissions_role_id | |
FROM dataset_permissions | |
WHERE %(param_1)s = dataset_permissions.dataset_id | |
Parameters: {'param_1': 380} | |
galaxy.model.orm.engine_factory DEBUG 2018-04-25 13:32:55,002 Request query: 0.008289(s) | |
SELECT dataset_collection.id AS dataset_collection_id, dataset_collection.collection_type AS dataset_collection_collection_type, dataset_collection.populated_state AS dataset_collection_populated_state, dataset_collection.populated_state_message AS dataset_collection_populated_state_message, dataset_collection.element_count AS dataset_collection_element_count, dataset_collection.create_time AS dataset_collection_create_time, dataset_collection.update_time AS dataset_collection_update_time, dataset_1.id AS dataset_1_id, dataset_1.create_time AS dataset_1_create_time, dataset_1.update_time AS dataset_1_update_time, dataset_1.state AS dataset_1_state, dataset_1.deleted AS dataset_1_deleted, dataset_1.purged AS dataset_1_purged, dataset_1.purgable AS dataset_1_purgable, dataset_1.object_store_id AS dataset_1_object_store_id, dataset_1.external_filename AS dataset_1_external_filename, dataset_1._extra_files_path AS dataset_1__extra_files_path, dataset_1.file_size AS dataset_1_file_size, dataset_1.total_size AS dataset_1_total_size, dataset_1.uuid AS dataset_1_uuid, history_dataset_association_1.id AS history_dataset_association_1_id, history_dataset_association_1.history_id AS history_dataset_association_1_history_id, history_dataset_association_1.dataset_id AS history_dataset_association_1_dataset_id, history_dataset_association_1.create_time AS history_dataset_association_1_create_time, history_dataset_association_1.update_time AS history_dataset_association_1_update_time, history_dataset_association_1.state AS history_dataset_association_1_state, history_dataset_association_1.copied_from_history_dataset_association_id AS history_dataset_association_1_copied_from_history_dataset_1, history_dataset_association_1.copied_from_library_dataset_dataset_association_id AS history_dataset_association_1_copied_from_library_dataset_2, history_dataset_association_1.name AS history_dataset_association_1_name, history_dataset_association_1.info AS history_dataset_association_1_info, history_dataset_association_1.blurb AS history_dataset_association_1_blurb, history_dataset_association_1.peek AS history_dataset_association_1_peek, history_dataset_association_1.tool_version AS history_dataset_association_1_tool_version, history_dataset_association_1.extension AS history_dataset_association_1_extension, history_dataset_association_1.parent_id AS history_dataset_association_1_parent_id, history_dataset_association_1.designation AS history_dataset_association_1_designation, history_dataset_association_1.deleted AS history_dataset_association_1_deleted, history_dataset_association_1.visible AS history_dataset_association_1_visible, history_dataset_association_1.extended_metadata_id AS history_dataset_association_1_extended_metadata_id, history_dataset_association_1.version AS history_dataset_association_1_version, history_dataset_association_1.hid AS history_dataset_association_1_hid, history_dataset_association_1.purged AS history_dataset_association_1_purged, history_dataset_association_1.hidden_beneath_collection_instance_id AS history_dataset_association_1_hidden_beneath_collection_i_3, dataset_collection_element_1.id AS dataset_collection_element_1_id, dataset_collection_element_1.dataset_collection_id AS dataset_collection_element_1_dataset_collection_id, dataset_collection_element_1.hda_id AS dataset_collection_element_1_hda_id, dataset_collection_element_1.ldda_id AS dataset_collection_element_1_ldda_id, dataset_collection_element_1.child_collection_id AS dataset_collection_element_1_child_collection_id, dataset_collection_element_1.element_index AS dataset_collection_element_1_element_index, dataset_collection_element_1.element_identifier AS dataset_collection_element_1_element_identifier, dataset_collection_1.id AS dataset_collection_1_id, dataset_collection_1.collection_type AS dataset_collection_1_collection_type, dataset_collection_1.populated_state AS dataset_collection_1_populated_state, dataset_collection_1.populated_state_message AS dataset_collection_1_populated_state_message, dataset_collection_1.element_count AS dataset_collection_1_element_count, dataset_collection_1.create_time AS dataset_collection_1_create_time, dataset_collection_1.update_time AS dataset_collection_1_update_time, dataset_collection_element_2.id AS dataset_collection_element_2_id, dataset_collection_element_2.dataset_collection_id AS dataset_collection_element_2_dataset_collection_id, dataset_collection_element_2.hda_id AS dataset_collection_element_2_hda_id, dataset_collection_element_2.ldda_id AS dataset_collection_element_2_ldda_id, dataset_collection_element_2.child_collection_id AS dataset_collection_element_2_child_collection_id, dataset_collection_element_2.element_index AS dataset_collection_element_2_element_index, dataset_collection_element_2.element_identifier AS dataset_collection_element_2_element_identifier | |
FROM dataset_collection LEFT OUTER JOIN dataset_collection_element AS dataset_collection_element_2 ON dataset_collection.id = dataset_collection_element_2.dataset_collection_id LEFT OUTER JOIN dataset_collection AS dataset_collection_1 ON dataset_collection_element_2.child_collection_id = dataset_collection_1.id LEFT OUTER JOIN dataset_collection_element AS dataset_collection_element_1 ON dataset_collection_1.id = dataset_collection_element_1.dataset_collection_id LEFT OUTER JOIN history_dataset_association AS history_dataset_association_1 ON dataset_collection_element_1.hda_id = history_dataset_association_1.id LEFT OUTER JOIN dataset AS dataset_1 ON dataset_1.id = history_dataset_association_1.dataset_id | |
WHERE dataset_collection.id = %(id_1)s ORDER BY dataset_collection_element_2.element_index, dataset_collection_element_1.element_index | |
Parameters: {'id_1': 122} | |
galaxy.model INFO 2018-04-25 13:32:55,005 | |
CALCULATING POPULATED... | |
galaxy.model INFO 2018-04-25 13:32:55,006 | |
CALCULATED POPULATED... | |
galaxy.model.orm.engine_factory DEBUG 2018-04-25 13:32:55,008 Request query: 0.001460(s) | |
SELECT dataset_permissions.id AS dataset_permissions_id, dataset_permissions.create_time AS dataset_permissions_create_time, dataset_permissions.update_time AS dataset_permissions_update_time, dataset_permissions.action AS dataset_permissions_action, dataset_permissions.dataset_id AS dataset_permissions_dataset_id, dataset_permissions.role_id AS dataset_permissions_role_id | |
FROM dataset_permissions | |
WHERE %(param_1)s = dataset_permissions.dataset_id | |
Parameters: {'param_1': 381} | |
galaxy.model INFO 2018-04-25 13:32:55,010 | |
CALCULATING POPULATED... | |
galaxy.model INFO 2018-04-25 13:32:55,010 | |
CALCULATED POPULATED... | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment