fix issues with mysql performance when switching genomes with a large number of annotations

[nathandunn]

from this thread:

https://groups.google.com/a/lbl.gov/forum/#!topic/apollo/fvO7vUdGYRc

Note:

We have 10+ genomes and gene models loaded to Apollo 2.5.0. Most species also have something like 30K genes defined on the reference genomes.  
We noticed the slowness for multiple organism/species/reference genomes. We did not see an exception thus far. 

[nathandunn]

200423 16:06:16
# User@Host: apollo2_user[apollo2_user] @ our_apollo_server.net [XX.XX.XXX.XXX]
# Thread_id: 1890016  Schema: apollo2_prod  QC_hit: No
# Query_time: 47.152124  Lock_time: 0.000182  Rows_sent: 17  Rows_examined: 18793282
use apollo2_prod;
SET timestamp=1587650776;
select organism4_.id as col_0_0_, count(distinct feature0_.id) as col_1_0_, organism4_.id as id1_53_, organism4_.version as version2_53_, organism4_.abbreviation as abbrevia3_53_, organism4_.blatdb as blatdb4_53_, organism4_.comment as comment5_53_, organism4_.common_name as common_n6_53_, organism4_.data_added_via_web_services as data_add7_53_, organism4_.directory as director8_53_, organism4_.genome_fasta as genome_f9_53_, organism4_.genome_fasta_index as genome_10_53_, organism4_.genus as genus11_53_, organism4_.metadata as metadat12_53_, organism4_.non_default_translation_table as non_def13_53_, organism4_.obsolete as obsolet14_53_, organism4_.public_mode as public_15_53_, organism4_.species as species16_53_, organism4_.valid as valid17_53_ from feature feature0_ left outer join feature_relationship parentfeat1_ on feature0_.id=parentfeat1_.parent_feature_id inner join feature_location featureloc2_ on feature0_.id=featureloc2_.feature_id inner join sequence sequence3_ on featureloc2_.sequence_id=sequence3_.id inner join organism organism4_ on sequence3_.organism_id=organism4_.id where  not (exists (select childfeatu5_.id from feature_relationship childfeatu5_ where feature0_.id=childfeatu5_.child_feature_id)) and (organism4_.id in (16 , 29 , 18 , 21 , 37 , 15 , 28 , 20 , 8 , 19 , 14 , 13 , 24 , 17 , 6 , 34 , 32 , 4 , 12 , 23 , 25 , 43 , 9 , 26 , 27 , 30 , 11 , 31 , 7 , 39 , 33 , 38 , 10 , 22 , 3)) and (feature0_.class in ('org.bbop.apollo.RepeatRegion' , 'org.bbop.apollo.Terminator' , 'org.bbop.apollo.TransposableElement' , 'org.bbop.apollo.Gene' , 'org.bbop.apollo.Pseudogene' , 'org.bbop.apollo.Deletion' , 'org.bbop.apollo.Insertion' , 'org.bbop.apollo.Substitution' , 'org.bbop.apollo.SNV' , 'org.bbop.apollo.SNP' , 'org.bbop.apollo.MNV' , 'org.bbop.apollo.MNP' , 'org.bbop.apollo.Indel')) group by organism4_.id;
# Time: 200423 16:06:19
# User@Host: apollo2_user[apollo2_user] @ our_apollo_server.net [XX.XX.XXX.XXX]
# Thread_id: 1890016  Schema: apollo2_prod  QC_hit: No
# Query_time: 2.493831  Lock_time: 0.000120  Rows_sent: 1  Rows_examined: 1062868
SET timestamp=1587650779;
select count(distinct sequenceal0_.id) as col_0_0_ from feature sequenceal0_ inner join feature_location featureloc1_ on sequenceal0_.id=featureloc1_.feature_id inner join sequence sequence2_ on featureloc1_.sequence_id=sequence2_.id inner join organism organism3_ on sequence2_.organism_id=organism3_.id inner join feature_property featurepro4_ on sequenceal0_.id=featurepro4_.feature_id where sequenceal0_.class in ('org.bbop.apollo.SequenceAlterationArtifact', 'org.bbop.apollo.DeletionArtifact', 'org.bbop.apollo.SubstitutionArtifact', 'org.bbop.apollo.InsertionArtifact') and featurepro4_.tag='justification' and (featurepro4_.value like 'Effect of %') and organism3_.id=43;
# Time: 200423 16:10:31
# User@Host: apollo2_user[apollo2_user] @ our_apollo_server.net [XX.XX.XXX.XXX]
# Thread_id: 1890016  Schema: apollo2_prod  QC_hit: No
# Query_time: 10.162820  Lock_time: 0.000559  Rows_sent: 198648  Rows_examined: 1825770
SET timestamp=1587651031;
select this_.id as id1_27_22_, this_.version as version2_27_22_, this_.date_created as date_cre3_27_22_, this_.dbxref_id as dbxref_i4_27_22_, this_.description as descript5_27_22_, this_.is_analysis as is_analy6_27_22_, this_.is_obsolete as is_obsol7_27_22_, this_.last_updated as last_upd8_27_22_, this_.md5checksum as md9_27_22_, this_.name as name10_27_22_, this_.sequence_length as sequenc11_27_22_, this_.status_id as status_12_27_22_, this_.symbol as symbol13_27_22_, this_.unique_name as unique_14_27_22_, this_.alternate_cv_term as alterna16_27_22_, this_.class_name as class_n17_27_22_, this_.custom_alternate_cv_term as custom_18_27_22_, this_.custom_class_name as custom_19_27_22_, this_.custom_cv_term as custom_20_27_22_, this_.custom_ontology_id as custom_21_27_22_, this_.cv_term as cv_term22_27_22_, this_.meta_data as meta_da23_27_22_, this_.ontology_id as ontolog24_27_22_, this_.alteration_residue as alterat25_27_22_, this_.reference_allele_id as referen26_27_22_, this_.deletion_length as deletio27_27_22_, this_.analysis_feature_id as analysi28_27_22_, this_.class as class15_27_22_, childfeatu3_.child_feature_id as child_fe3_27_24_, childfeatu3_.id as id1_38_24_, childfeatu3_.id as id1_38_0_, childfeatu3_.version as version2_38_0_, childfeatu3_.child_feature_id as child_fe3_38_0_, childfeatu3_.parent_feature_id as parent_f4_38_0_, childfeatu3_.rank as rank5_38_0_, childfeatu3_.value as value6_38_0_, feature4_.id as id1_27_1_, feature4_.version as version2_27_1_, feature4_.date_created as date_cre3_27_1_, feature4_.dbxref_id as dbxref_i4_27_1_, feature4_.description as descript5_27_1_, feature4_.is_analysis as is_analy6_27_1_, feature4_.is_obsolete as is_obsol7_27_1_, feature4_.last_updated as last_upd8_27_1_, feature4_.md5checksum as md9_27_1_, feature4_.name as name10_27_1_, feature4_.sequence_length as sequenc11_27_1_, feature4_.status_id as status_12_27_1_, feature4_.symbol as symbol13_27_1_, feature4_.unique_name as unique_14_27_1_, feature4_.alternate_cv_term as alterna16_27_1_, feature4_.class_name as class_n17_27_1_, feature4_.custom_alternate_cv_term as custom_18_27_1_, feature4_.custom_class_name as custom_19_27_1_, feature4_.custom_cv_term as custom_20_27_1_, feature4_.custom_ontology_id as custom_21_27_1_, feature4_.cv_term as cv_term22_27_1_, feature4_.meta_data as meta_da23_27_1_, feature4_.ontology_id as ontolog24_27_1_, feature4_.alteration_residue as alterat25_27_1_, feature4_.reference_allele_id as referen26_27_1_, feature4_.deletion_length as deletio27_27_1_, feature4_.analysis_feature_id as analysi28_27_1_, feature4_.class as class15_27_1_, featureloc5_.feature_id as feature_3_27_25_, featureloc5_.id as id1_33_25_, featureloc5_.id as id1_33_2_, featureloc5_.version as version2_33_2_, featureloc5_.feature_id as feature_3_33_2_, featureloc5_.fmax as fmax4_33_2_, featureloc5_.fmin as fmin5_33_2_, featureloc5_.is_fmax_partial as is_fmax_6_33_2_, featureloc5_.is_fmin_partial as is_fmin_7_33_2_, featureloc5_.locgroup as locgroup8_33_2_, featureloc5_.phase as phase9_33_2_, featureloc5_.rank as rank10_33_2_, featureloc5_.residue_info as residue11_33_2_, featureloc5_.sequence_id as sequenc12_33_2_, featureloc5_.strand as strand13_33_2_, featureloc5_.FMAX-featureloc5_.FMIN as formula0_2_, sequence6_.id as id1_76_3_, sequence6_.version as version2_76_3_, sequence6_.sequence_end as sequence3_76_3_, sequence6_.length as length4_76_3_, sequence6_.name as name5_76_3_, sequence6_.organism_id as organism6_76_3_, sequence6_.seq_chunk_size as seq_chun7_76_3_, sequence6_.sequence_start as sequence8_76_3_, featuredbx7_.feature_featuredbxrefs_id as feature_1_27_26_, dbxref8_.id as dbxref_i2_28_26_, dbxref8_.id as id1_23_4_, dbxref8_.accession as accessio3_23_4_, dbxref8_.db_id as db_id4_23_4_, dbxref8_.description as descript5_23_4_, featureloc1_.id as id1_33_5_, featureloc1_.version as version2_33_5_, featureloc1_.feature_id as feature_3_33_5_, featureloc1_.fmax as fmax4_33_5_, featureloc1_.fmin as fmin5_33_5_, featureloc1_.is_fmax_partial as is_fmax_6_33_5_, featureloc1_.is_fmin_partial as is_fmin_7_33_5_, featureloc1_.locgroup as locgroup8_33_5_, featureloc1_.phase as phase9_33_5_, featureloc1_.rank as rank10_33_5_, featureloc1_.residue_info as residue11_33_5_, featureloc1_.sequence_id as sequenc12_33_5_, featureloc1_.strand as strand13_33_5_, featureloc1_.FMAX-featureloc1_.FMIN as formula0_5_, sequence10_.id as id1_76_6_, sequence10_.version as version2_76_6_, sequence10_.sequence_end as sequence3_76_6_, sequence10_.length as length4_76_6_, sequence10_.name as name5_76_6_, sequence10_.organism_id as organism6_76_6_, sequence10_.seq_chunk_size as seq_chun7_76_6_, sequence10_.sequence_start as sequence8_76_6_, featurepro11_.feature_id as feature_3_27_27_, featurepro11_.id as id1_35_27_, featurepro11_.id as id1_35_7_, featurepro11_.version as version2_35_7_, featurepro11_.feature_id as feature_3_35_7_, featurepro11_.rank as rank4_35_7_, featurepro11_.tag as tag5_35_7_, featurepro11_.type_id as type_id6_35_7_, featurepro11_.value as value7_35_7_, featurepro11_.class as class8_35_7_, owners12_.feature_owners_id as feature_1_27_28_, user13_.id as user_id2_32_28_, user13_.id as id1_50_8_, user13_.version as version2_50_8_, user13_.first_name as first_na3_50_8_, user13_.inactive as inactive4_50_8_, user13_.last_name as last_nam5_50_8_, user13_.metadata as metadata6_50_8_, user13_.password_hash as password7_50_8_, user13_.username as username8_50_8_, parentfeat14_.parent_feature_id as parent_f4_27_29_, parentfeat14_.id as id1_38_29_, parentfeat14_.id as id1_38_9_, parentfeat14_.version as version2_38_9_, parentfeat14_.child_feature_id as child_fe3_38_9_, parentfeat14_.parent_feature_id as parent_f4_38_9_, parentfeat14_.rank as rank5_38_9_, parentfeat14_.value as value6_38_9_, feature15_.id as id1_27_10_, feature15_.version as version2_27_10_, feature15_.date_created as date_cre3_27_10_, feature15_.dbxref_id as dbxref_i4_27_10_, feature15_.description as descript5_27_10_, feature15_.is_analysis as is_analy6_27_10_, feature15_.is_obsolete as is_obsol7_27_10_, feature15_.last_updated as last_upd8_27_10_, feature15_.md5checksum as md9_27_10_, feature15_.name as name10_27_10_, feature15_.sequence_length as sequenc11_27_10_, feature15_.status_id as status_12_27_10_, feature15_.symbol as symbol13_27_10_, feature15_.unique_name as unique_14_27_10_, feature15_.alternate_cv_term as alterna16_27_10_, feature15_.class_name as class_n17_27_10_, feature15_.custom_alternate_cv_term as custom_18_27_10_, feature15_.custom_class_name as custom_19_27_10_, feature15_.custom_cv_term as custom_20_27_10_, feature15_.custom_ontology_id as custom_21_27_10_, feature15_.cv_term as cv_term22_27_10_, feature15_.meta_data as meta_da23_27_10_, feature15_.ontology_id as ontolog24_27_10_, feature15_.alteration_residue as alterat25_27_10_, feature15_.reference_allele_id as referen26_27_10_, feature15_.deletion_length as deletio27_27_10_, feature15_.analysis_feature_id as analysi28_27_10_, feature15_.class as class15_27_10_, childfeatu16_.child_feature_id as child_fe3_27_30_, childfeatu16_.id as id1_38_30_, childfeatu16_.id as id1_38_11_, childfeatu16_.version as version2_38_11_, childfeatu16_.child_feature_id as child_fe3_38_11_, childfeatu16_.parent_feature_id as parent_f4_38_11_, childfeatu16_.rank as rank5_38_11_, childfeatu16_.value as value6_38_11_, featuredbx17_.feature_featuredbxrefs_id as feature_1_27_31_, dbxref18_.id as dbxref_i2_28_31_, dbxref18_.id as id1_23_12_, dbxref18_.accession as accessio3_23_12_, dbxref18_.db_id as db_id4_23_12_, dbxref18_.description as descript5_23_12_, featureloc19_.feature_id as feature_3_27_32_, featureloc19_.id as id1_33_32_, featureloc19_.id as id1_33_13_, featureloc19_.version as version2_33_13_, featureloc19_.feature_id as feature_3_33_13_, featureloc19_.fmax as fmax4_33_13_, featureloc19_.fmin as fmin5_33_13_, featureloc19_.is_fmax_partial as is_fmax_6_33_13_, featureloc19_.is_fmin_partial as is_fmin_7_33_13_, featureloc19_.locgroup as locgroup8_33_13_, featureloc19_.phase as phase9_33_13_, featureloc19_.rank as rank10_33_13_, featureloc19_.residue_info as residue11_33_13_, featureloc19_.sequence_id as sequenc12_33_13_, featureloc19_.strand as strand13_33_13_, featureloc19_.FMAX-featureloc19_.FMIN as formula0_13_, sequence20_.id as id1_76_14_, sequence20_.version as version2_76_14_, sequence20_.sequence_end as sequence3_76_14_, sequence20_.length as length4_76_14_, sequence20_.name as name5_76_14_, sequence20_.organism_id as organism6_76_14_, sequence20_.seq_chunk_size as seq_chun7_76_14_, sequence20_.sequence_start as sequence8_76_14_, featurepro21_.feature_id as feature_3_27_33_, featurepro21_.id as id1_35_33_, featurepro21_.id as id1_35_15_, featurepro21_.version as version2_35_15_, featurepro21_.feature_id as feature_3_35_15_, featurepro21_.rank as rank4_35_15_, featurepro21_.tag as tag5_35_15_, featurepro21_.type_id as type_id6_35_15_, featurepro21_.value as value7_35_15_, featurepro21_.class as class8_35_15_, owners22_.feature_owners_id as feature_1_27_34_, user23_.id as user_id2_32_34_, user23_.id as id1_50_16_, user23_.version as version2_50_16_, user23_.first_name as first_na3_50_16_, user23_.inactive as inactive4_50_16_, user23_.last_name as last_nam5_50_16_, user23_.metadata as metadata6_50_16_, user23_.password_hash as password7_50_16_, user23_.username as username8_50_16_, parentfeat24_.parent_feature_id as parent_f4_27_35_, parentfeat24_.id as id1_38_35_, parentfeat24_.id as id1_38_17_, parentfeat24_.version as version2_38_17_, parentfeat24_.child_feature_id as child_fe3_38_17_, parentfeat24_.parent_feature_id as parent_f4_38_17_, parentfeat24_.rank as rank5_38_17_, parentfeat24_.value as value6_38_17_, feature25_.id as id1_27_18_, feature25_.version as version2_27_18_, feature25_.date_created as date_cre3_27_18_, feature25_.dbxref_id as dbxref_i4_27_18_, feature25_.description as descript5_27_18_, feature25_.is_analysis as is_analy6_27_18_, feature25_.is_obsolete as is_obsol7_27_18_, feature25_.last_updated as last_upd8_27_18_, feature25_.md5checksum as md9_27_18_, feature25_.name as name10_27_18_, feature25_.sequence_length as sequenc11_27_18_, feature25_.status_id as status_12_27_18_, feature25_.symbol as symbol13_27_18_, feature25_.unique_name as unique_14_27_18_, feature25_.alternate_cv_term as alterna16_27_18_, feature25_.class_name as class_n17_27_18_, feature25_.custom_alternate_cv_term as custom_18_27_18_, feature25_.custom_class_name as custom_19_27_18_, feature25_.custom_cv_term as custom_20_27_18_, feature25_.custom_ontology_id as custom_21_27_18_, feature25_.cv_term as cv_term22_27_18_, feature25_.meta_data as meta_da23_27_18_, feature25_.ontology_id as ontolog24_27_18_, feature25_.alteration_residue as alterat25_27_18_, feature25_.reference_allele_id as referen26_27_18_, feature25_.deletion_length as deletio27_27_18_, feature25_.analysis_feature_id as analysi28_27_18_, feature25_.class as class15_27_18_, featureloc26_.feature_id as feature_3_27_36_, featureloc26_.id as id1_33_36_, featureloc26_.id as id1_33_19_, featureloc26_.version as version2_33_19_, featureloc26_.feature_id as feature_3_33_19_, featureloc26_.fmax as fmax4_33_19_, featureloc26_.fmin as fmin5_33_19_, featureloc26_.is_fmax_partial as is_fmax_6_33_19_, featureloc26_.is_fmin_partial as is_fmin_7_33_19_, featureloc26_.locgroup as locgroup8_33_19_, featureloc26_.phase as phase9_33_19_, featureloc26_.rank as rank10_33_19_, featureloc26_.residue_info as residue11_33_19_, featureloc26_.sequence_id as sequenc12_33_19_, featureloc26_.strand as strand13_33_19_, featureloc26_.FMAX-featureloc26_.FMIN as formula0_19_, sequence27_.id as id1_76_20_, sequence27_.version as version2_76_20_, sequence27_.sequence_end as sequence3_76_20_, sequence27_.length as length4_76_20_, sequence27_.name as name5_76_20_, sequence27_.organism_id as organism6_76_20_, sequence27_.seq_chunk_size as seq_chun7_76_20_, sequence27_.sequence_start as sequence8_76_20_, status28_.id as id1_35_21_, status28_.version as version2_35_21_, status28_.feature_id as feature_3_35_21_, status28_.rank as rank4_35_21_, status28_.tag as tag5_35_21_, status28_.type_id as type_id6_35_21_, status28_.value as value7_35_21_ from feature this_ left outer join feature_relationship childfeatu3_ on this_.id=childfeatu3_.child_feature_id left outer join feature feature4_ on childfeatu3_.parent_feature_id=feature4_.id left outer join feature_location featureloc5_ on feature4_.id=featureloc5_.feature_id left outer join sequence sequence6_ on featureloc5_.sequence_id=sequence6_.id left outer join feature_dbxref featuredbx7_ on this_.id=featuredbx7_.feature_featuredbxrefs_id left outer join dbxref dbxref8_ on featuredbx7_.dbxref_id=dbxref8_.id inner join feature_location featureloc1_ on this_.id=featureloc1_.feature_id left outer join sequence sequence10_ on featureloc1_.sequence_id=sequence10_.id left outer join feature_property featurepro11_ on this_.id=featurepro11_.feature_id left outer join feature_grails_user owners12_ on this_.id=owners12_.feature_owners_id left outer join grails_user user13_ on owners12_.user_id=user13_.id left outer join feature_relationship parentfeat14_ on this_.id=parentfeat14_.parent_feature_id left outer join feature feature15_ on parentfeat14_.child_feature_id=feature15_.id left outer join feature_relationship childfeatu16_ on feature15_.id=childfeatu16_.child_feature_id left outer join feature_dbxref featuredbx17_ on feature15_.id=featuredbx17_.feature_featuredbxrefs_id left outer join dbxref dbxref18_ on featuredbx17_.dbxref_id=dbxref18_.id left outer join feature_location featureloc19_ on feature15_.id=featureloc19_.feature_id left outer join sequence sequence20_ on featureloc19_.sequence_id=sequence20_.id left outer join feature_property featurepro21_ on feature15_.id=featurepro21_.feature_id left outer join feature_grails_user owners22_ on feature15_.id=owners22_.feature_owners_id left outer join grails_user user23_ on owners22_.user_id=user23_.id left outer join feature_relationship parentfeat24_ on feature15_.id=parentfeat24_.parent_feature_id left outer join feature feature25_ on parentfeat14_.parent_feature_id=feature25_.id left outer join feature_location featureloc26_ on feature25_.id=featureloc26_.feature_id left outer join sequence sequence27_ on featureloc26_.sequence_id=sequence27_.id left outer join feature_property status28_ on this_.status_id=status28_.id where (featureloc1_.sequence_id=36) and this_.class in ('org.bbop.apollo.Transcript', 'org.bbop.apollo.MRNA', 'org.bbop.apollo.TRNA', 'org.bbop.apollo.SnRNA', 'org.bbop.apollo.SnoRNA', 'org.bbop.apollo.NcRNA', 'org.bbop.apollo.RRNA', 'org.bbop.apollo.MiRNA', 'org.bbop.apollo.RepeatRegion', 'org.bbop.apollo.Terminator', 'org.bbop.apollo.TransposableElement', 'org.bbop.apollo.Deletion', 'org.bbop.apollo.Insertion', 'org.bbop.apollo.Substitution', 'org.bbop.apollo.SNV', 'org.bbop.apollo.SNP', 'org.bbop.apollo.MNV', 'org.bbop.apollo.MNP', 'org.bbop.apollo.Indel');
# Time: 200423 16:19:06
# User@Host: apollo2_user[apollo2_user] @ our_apollo_server.net [XX.XX.XXX.XXX]
# Thread_id: 1890196  Schema: apollo2_prod  QC_hit: No
# Query_time: 5.548233  Lock_time: 0.000579  Rows_sent: 112748  Rows_examined: 1039283
SET timestamp=1587651546;
select this_.id as id1_27_22_, this_.version as version2_27_22_, this_.date_created as date_cre3_27_22_, this_.dbxref_id as dbxref_i4_27_22_, this_.description as descript5_27_22_, this_.is_analysis as is_analy6_27_22_, this_.is_obsolete as is_obsol7_27_22_, this_.last_updated as last_upd8_27_22_, this_.md5checksum as md9_27_22_, this_.name as name10_27_22_, this_.sequence_length as sequenc11_27_22_, this_.status_id as status_12_27_22_, this_.symbol as symbol13_27_22_, this_.unique_name as unique_14_27_22_, this_.alternate_cv_term as alterna16_27_22_, this_.class_name as class_n17_27_22_, this_.custom_alternate_cv_term as custom_18_27_22_, this_.custom_class_name as custom_19_27_22_, this_.custom_cv_term as custom_20_27_22_, this_.custom_ontology_id as custom_21_27_22_, this_.cv_term as cv_term22_27_22_, this_.meta_data as meta_da23_27_22_, this_.ontology_id as ontolog24_27_22_, this_.alteration_residue as alterat25_27_22_, this_.reference_allele_id as referen26_27_22_, this_.deletion_length as deletio27_27_22_, this_.analysis_feature_id as analysi28_27_22_, this_.class as class15_27_22_, childfeatu3_.child_feature_id as child_fe3_27_24_, childfeatu3_.id as id1_38_24_, childfeatu3_.id as id1_38_0_, childfeatu3_.version as version2_38_0_, childfeatu3_.child_feature_id as child_fe3_38_0_, childfeatu3_.parent_feature_id as parent_f4_38_0_, childfeatu3_.rank as rank5_38_0_, childfeatu3_.value as value6_38_0_, feature4_.id as id1_27_1_, feature4_.version as version2_27_1_, feature4_.date_created as date_cre3_27_1_, feature4_.dbxref_id as dbxref_i4_27_1_, feature4_.description as descript5_27_1_, feature4_.is_analysis as is_analy6_27_1_, feature4_.is_obsolete as is_obsol7_27_1_, feature4_.last_updated as last_upd8_27_1_, feature4_.md5checksum as md9_27_1_, feature4_.name as name10_27_1_, feature4_.sequence_length as sequenc11_27_1_, feature4_.status_id as status_12_27_1_, feature4_.symbol as symbol13_27_1_, feature4_.unique_name as unique_14_27_1_, feature4_.alternate_cv_term as alterna16_27_1_, feature4_.class_name as class_n17_27_1_, feature4_.custom_alternate_cv_term as custom_18_27_1_, feature4_.custom_class_name as custom_19_27_1_, feature4_.custom_cv_term as custom_20_27_1_, feature4_.custom_ontology_id as custom_21_27_1_, feature4_.cv_term as cv_term22_27_1_, feature4_.meta_data as meta_da23_27_1_, feature4_.ontology_id as ontolog24_27_1_, feature4_.alteration_residue as alterat25_27_1_, feature4_.reference_allele_id as referen26_27_1_, feature4_.deletion_length as deletio27_27_1_, feature4_.analysis_feature_id as analysi28_27_1_, feature4_.class as class15_27_1_, featureloc5_.feature_id as feature_3_27_25_, featureloc5_.id as id1_33_25_, featureloc5_.id as id1_33_2_, featureloc5_.version as version2_33_2_, featureloc5_.feature_id as feature_3_33_2_, featureloc5_.fmax as fmax4_33_2_, featureloc5_.fmin as fmin5_33_2_, featureloc5_.is_fmax_partial as is_fmax_6_33_2_, featureloc5_.is_fmin_partial as is_fmin_7_33_2_, featureloc5_.locgroup as locgroup8_33_2_, featureloc5_.phase as phase9_33_2_, featureloc5_.rank as rank10_33_2_, featureloc5_.residue_info as residue11_33_2_, featureloc5_.sequence_id as sequenc12_33_2_, featureloc5_.strand as strand13_33_2_, featureloc5_.FMAX-featureloc5_.FMIN as formula0_2_, sequence6_.id as id1_76_3_, sequence6_.version as version2_76_3_, sequence6_.sequence_end as sequence3_76_3_, sequence6_.length as length4_76_3_, sequence6_.name as name5_76_3_, sequence6_.organism_id as organism6_76_3_, sequence6_.seq_chunk_size as seq_chun7_76_3_, sequence6_.sequence_start as sequence8_76_3_, featuredbx7_.feature_featuredbxrefs_id as feature_1_27_26_, dbxref8_.id as dbxref_i2_28_26_, dbxref8_.id as id1_23_4_, dbxref8_.accession as accessio3_23_4_, dbxref8_.db_id as db_id4_23_4_, dbxref8_.description as descript5_23_4_, featureloc1_.id as id1_33_5_, featureloc1_.version as version2_33_5_, featureloc1_.feature_id as feature_3_33_5_, featureloc1_.fmax as fmax4_33_5_, featureloc1_.fmin as fmin5_33_5_, featureloc1_.is_fmax_partial as is_fmax_6_33_5_, featureloc1_.is_fmin_partial as is_fmin_7_33_5_, featureloc1_.locgroup as locgroup8_33_5_, featureloc1_.phase as phase9_33_5_, featureloc1_.rank as rank10_33_5_, featureloc1_.residue_info as residue11_33_5_, featureloc1_.sequence_id as sequenc12_33_5_, featureloc1_.strand as strand13_33_5_, featureloc1_.FMAX-featureloc1_.FMIN as formula0_5_, sequence10_.id as id1_76_6_, sequence10_.version as version2_76_6_, sequence10_.sequence_end as sequence3_76_6_, sequence10_.length as length4_76_6_, sequence10_.name as name5_76_6_, sequence10_.organism_id as organism6_76_6_, sequence10_.seq_chunk_size as seq_chun7_76_6_, sequence10_.sequence_start as sequence8_76_6_, featurepro11_.feature_id as feature_3_27_27_, featurepro11_.id as id1_35_27_, featurepro11_.id as id1_35_7_, featurepro11_.version as version2_35_7_, featurepro11_.feature_id as feature_3_35_7_, featurepro11_.rank as rank4_35_7_, featurepro11_.tag as tag5_35_7_, featurepro11_.type_id as type_id6_35_7_, featurepro11_.value as value7_35_7_, featurepro11_.class as class8_35_7_, owners12_.feature_owners_id as feature_1_27_28_, user13_.id as user_id2_32_28_, user13_.id as id1_50_8_, user13_.version as version2_50_8_, user13_.first_name as first_na3_50_8_, user13_.inactive as inactive4_50_8_, user13_.last_name as last_nam5_50_8_, user13_.metadata as metadata6_50_8_, user13_.password_hash as password7_50_8_, user13_.username as username8_50_8_, parentfeat14_.parent_feature_id as parent_f4_27_29_, parentfeat14_.id as id1_38_29_, parentfeat14_.id as id1_38_9_, parentfeat14_.version as version2_38_9_, parentfeat14_.child_feature_id as child_fe3_38_9_, parentfeat14_.parent_feature_id as parent_f4_38_9_, parentfeat14_.rank as rank5_38_9_, parentfeat14_.value as value6_38_9_, feature15_.id as id1_27_10_, feature15_.version as version2_27_10_, feature15_.date_created as date_cre3_27_10_, feature15_.dbxref_id as dbxref_i4_27_10_, feature15_.description as descript5_27_10_, feature15_.is_analysis as is_analy6_27_10_, feature15_.is_obsolete as is_obsol7_27_10_, feature15_.last_updated as last_upd8_27_10_, feature15_.md5checksum as md9_27_10_, feature15_.name as name10_27_10_, feature15_.sequence_length as sequenc11_27_10_, feature15_.status_id as status_12_27_10_, feature15_.symbol as symbol13_27_10_, feature15_.unique_name as unique_14_27_10_, feature15_.alternate_cv_term as alterna16_27_10_, feature15_.class_name as class_n17_27_10_, feature15_.custom_alternate_cv_term as custom_18_27_10_, feature15_.custom_class_name as custom_19_27_10_, feature15_.custom_cv_term as custom_20_27_10_, feature15_.custom_ontology_id as custom_21_27_10_, feature15_.cv_term as cv_term22_27_10_, feature15_.meta_data as meta_da23_27_10_, feature15_.ontology_id as ontolog24_27_10_, feature15_.alteration_residue as alterat25_27_10_, feature15_.reference_allele_id as referen26_27_10_, feature15_.deletion_length as deletio27_27_10_, feature15_.analysis_feature_id as analysi28_27_10_, feature15_.class as class15_27_10_, childfeatu16_.child_feature_id as child_fe3_27_30_, childfeatu16_.id as id1_38_30_, childfeatu16_.id as id1_38_11_, childfeatu16_.version as version2_38_11_, childfeatu16_.child_feature_id as child_fe3_38_11_, childfeatu16_.parent_feature_id as parent_f4_38_11_, childfeatu16_.rank as rank5_38_11_, childfeatu16_.value as value6_38_11_, featuredbx17_.feature_featuredbxrefs_id as feature_1_27_31_, dbxref18_.id as dbxref_i2_28_31_, dbxref18_.id as id1_23_12_, dbxref18_.accession as accessio3_23_12_, dbxref18_.db_id as db_id4_23_12_, dbxref18_.description as descript5_23_12_, featureloc19_.feature_id as feature_3_27_32_, featureloc19_.id as id1_33_32_, featureloc19_.id as id1_33_13_, featureloc19_.version as version2_33_13_, featureloc19_.feature_id as feature_3_33_13_, featureloc19_.fmax as fmax4_33_13_, featureloc19_.fmin as fmin5_33_13_, featureloc19_.is_fmax_partial as is_fmax_6_33_13_, featureloc19_.is_fmin_partial as is_fmin_7_33_13_, featureloc19_.locgroup as locgroup8_33_13_, featureloc19_.phase as phase9_33_13_, featureloc19_.rank as rank10_33_13_, featureloc19_.residue_info as residue11_33_13_, featureloc19_.sequence_id as sequenc12_33_13_, featureloc19_.strand as strand13_33_13_, featureloc19_.FMAX-featureloc19_.FMIN as formula0_13_, sequence20_.id as id1_76_14_, sequence20_.version as version2_76_14_, sequence20_.sequence_end as sequence3_76_14_, sequence20_.length as length4_76_14_, sequence20_.name as name5_76_14_, sequence20_.organism_id as organism6_76_14_, sequence20_.seq_chunk_size as seq_chun7_76_14_, sequence20_.sequence_start as sequence8_76_14_, featurepro21_.feature_id as feature_3_27_33_, featurepro21_.id as id1_35_33_, featurepro21_.id as id1_35_15_, featurepro21_.version as version2_35_15_, featurepro21_.feature_id as feature_3_35_15_, featurepro21_.rank as rank4_35_15_, featurepro21_.tag as tag5_35_15_, featurepro21_.type_id as type_id6_35_15_, featurepro21_.value as value7_35_15_, featurepro21_.class as class8_35_15_, owners22_.feature_owners_id as feature_1_27_34_, user23_.id as user_id2_32_34_, user23_.id as id1_50_16_, user23_.version as version2_50_16_, user23_.first_name as first_na3_50_16_, user23_.inactive as inactive4_50_16_, user23_.last_name as last_nam5_50_16_, user23_.metadata as metadata6_50_16_, user23_.password_hash as password7_50_16_, user23_.username as username8_50_16_, parentfeat24_.parent_feature_id as parent_f4_27_35_, parentfeat24_.id as id1_38_35_, parentfeat24_.id as id1_38_17_, parentfeat24_.version as version2_38_17_, parentfeat24_.child_feature_id as child_fe3_38_17_, parentfeat24_.parent_feature_id as parent_f4_38_17_, parentfeat24_.rank as rank5_38_17_, parentfeat24_.value as value6_38_17_, feature25_.id as id1_27_18_, feature25_.version as version2_27_18_, feature25_.date_created as date_cre3_27_18_, feature25_.dbxref_id as dbxref_i4_27_18_, feature25_.description as descript5_27_18_, feature25_.is_analysis as is_analy6_27_18_, feature25_.is_obsolete as is_obsol7_27_18_, feature25_.last_updated as last_upd8_27_18_, feature25_.md5checksum as md9_27_18_, feature25_.name as name10_27_18_, feature25_.sequence_length as sequenc11_27_18_, feature25_.status_id as status_12_27_18_, feature25_.symbol as symbol13_27_18_, feature25_.unique_name as unique_14_27_18_, feature25_.alternate_cv_term as alterna16_27_18_, feature25_.class_name as class_n17_27_18_, feature25_.custom_alternate_cv_term as custom_18_27_18_, feature25_.custom_class_name as custom_19_27_18_, feature25_.custom_cv_term as custom_20_27_18_, feature25_.custom_ontology_id as custom_21_27_18_, feature25_.cv_term as cv_term22_27_18_, feature25_.meta_data as meta_da23_27_18_, feature25_.ontology_id as ontolog24_27_18_, feature25_.alteration_residue as alterat25_27_18_, feature25_.reference_allele_id as referen26_27_18_, feature25_.deletion_length as deletio27_27_18_, feature25_.analysis_feature_id as analysi28_27_18_, feature25_.class as class15_27_18_, featureloc26_.feature_id as feature_3_27_36_, featureloc26_.id as id1_33_36_, featureloc26_.id as id1_33_19_, featureloc26_.version as version2_33_19_, featureloc26_.feature_id as feature_3_33_19_, featureloc26_.fmax as fmax4_33_19_, featureloc26_.fmin as fmin5_33_19_, featureloc26_.is_fmax_partial as is_fmax_6_33_19_, featureloc26_.is_fmin_partial as is_fmin_7_33_19_, featureloc26_.locgroup as locgroup8_33_19_, featureloc26_.phase as phase9_33_19_, featureloc26_.rank as rank10_33_19_, featureloc26_.residue_info as residue11_33_19_, featureloc26_.sequence_id as sequenc12_33_19_, featureloc26_.strand as strand13_33_19_, featureloc26_.FMAX-featureloc26_.FMIN as formula0_19_, sequence27_.id as id1_76_20_, sequence27_.version as version2_76_20_, sequence27_.sequence_end as sequence3_76_20_, sequence27_.length as length4_76_20_, sequence27_.name as name5_76_20_, sequence27_.organism_id as organism6_76_20_, sequence27_.seq_chunk_size as seq_chun7_76_20_, sequence27_.sequence_start as sequence8_76_20_, status28_.id as id1_35_21_, status28_.version as version2_35_21_, status28_.feature_id as feature_3_35_21_, status28_.rank as rank4_35_21_, status28_.tag as tag5_35_21_, status28_.type_id as type_id6_35_21_, status28_.value as value7_35_21_ from feature this_ left outer join feature_relationship childfeatu3_ on this_.id=childfeatu3_.child_feature_id left outer join feature feature4_ on childfeatu3_.parent_feature_id=feature4_.id left outer join feature_location featureloc5_ on feature4_.id=featureloc5_.feature_id left outer join sequence sequence6_ on featureloc5_.sequence_id=sequence6_.id left outer join feature_dbxref featuredbx7_ on this_.id=featuredbx7_.feature_featuredbxrefs_id left outer join dbxref dbxref8_ on featuredbx7_.dbxref_id=dbxref8_.id inner join feature_location featureloc1_ on this_.id=featureloc1_.feature_id left outer join sequence sequence10_ on featureloc1_.sequence_id=sequence10_.id left outer join feature_property featurepro11_ on this_.id=featurepro11_.feature_id left outer join feature_grails_user owners12_ on this_.id=owners12_.feature_owners_id left outer join grails_user user13_ on owners12_.user_id=user13_.id left outer join feature_relationship parentfeat14_ on this_.id=parentfeat14_.parent_feature_id left outer join feature feature15_ on parentfeat14_.child_feature_id=feature15_.id left outer join feature_relationship childfeatu16_ on feature15_.id=childfeatu16_.child_feature_id left outer join feature_dbxref featuredbx17_ on feature15_.id=featuredbx17_.feature_featuredbxrefs_id left outer join dbxref dbxref18_ on featuredbx17_.dbxref_id=dbxref18_.id left outer join feature_location featureloc19_ on feature15_.id=featureloc19_.feature_id left outer join sequence sequence20_ on featureloc19_.sequence_id=sequence20_.id left outer join feature_property featurepro21_ on feature15_.id=featurepro21_.feature_id left outer join feature_grails_user owners22_ on feature15_.id=owners22_.feature_owners_id left outer join grails_user user23_ on owners22_.user_id=user23_.id left outer join feature_relationship parentfeat24_ on feature15_.id=parentfeat24_.parent_feature_id left outer join feature feature25_ on parentfeat14_.parent_feature_id=feature25_.id left outer join feature_location featureloc26_ on feature25_.id=featureloc26_.feature_id left outer join sequence sequence27_ on featureloc26_.sequence_id=sequence27_.id left outer join feature_property status28_ on this_.status_id=status28_.id where (featureloc1_.sequence_id=43) and this_.class in ('org.bbop.apollo.Transcript', 'org.bbop.apollo.MRNA', 'org.bbop.apollo.TRNA', 'org.bbop.apollo.SnRNA', 'org.bbop.apollo.SnoRNA', 'org.bbop.apollo.NcRNA', 'org.bbop.apollo.RRNA', 'org.bbop.apollo.MiRNA', 'org.bbop.apollo.RepeatRegion', 'org.bbop.apollo.Terminator', 'org.bbop.apollo.TransposableElement', 'org.bbop.apollo.Deletion', 'org.bbop.apollo.Insertion', 'org.bbop.apollo.Substitution', 'org.bbop.apollo.SNV', 'org.bbop.apollo.SNP', 'org.bbop.apollo.MNV', 'org.bbop.apollo.MNP', 'org.bbop.apollo.Indel');
# Time: 200423 16:24:09
# User@Host: apollo2_user[apollo2_user] @ our_apollo_server.net [XX.XX.XXX.XXX]
# Thread_id: 1890214  Schema: apollo2_prod  QC_hit: No
# Query_time: 5.494590  Lock_time: 0.000611  Rows_sent: 108431  Rows_examined: 1009693
SET timestamp=1587651849;
select this_.id as id1_27_22_, this_.version as version2_27_22_, this_.date_created as date_cre3_27_22_, this_.dbxref_id as dbxref_i4_27_22_, this_.description as descript5_27_22_, this_.is_analysis as is_analy6_27_22_, this_.is_obsolete as is_obsol7_27_22_, this_.last_updated as last_upd8_27_22_, this_.md5checksum as md9_27_22_, this_.name as name10_27_22_, this_.sequence_length as sequenc11_27_22_, this_.status_id as status_12_27_22_, this_.symbol as symbol13_27_22_, this_.unique_name as unique_14_27_22_, this_.alternate_cv_term as alterna16_27_22_, this_.class_name as class_n17_27_22_, this_.custom_alternate_cv_term as custom_18_27_22_, this_.custom_class_name as custom_19_27_22_, this_.custom_cv_term as custom_20_27_22_, this_.custom_ontology_id as custom_21_27_22_, this_.cv_term as cv_term22_27_22_, this_.meta_data as meta_da23_27_22_, this_.ontology_id as ontolog24_27_22_, this_.alteration_residue as alterat25_27_22_, this_.reference_allele_id as referen26_27_22_, this_.deletion_length as deletio27_27_22_, this_.analysis_feature_id as analysi28_27_22_, this_.class as class15_27_22_, childfeatu3_.child_feature_id as child_fe3_27_24_, childfeatu3_.id as id1_38_24_, childfeatu3_.id as id1_38_0_, childfeatu3_.version as version2_38_0_, childfeatu3_.child_feature_id as child_fe3_38_0_, childfeatu3_.parent_feature_id as parent_f4_38_0_, childfeatu3_.rank as rank5_38_0_, childfeatu3_.value as value6_38_0_, feature4_.id as id1_27_1_, feature4_.version as version2_27_1_, feature4_.date_created as date_cre3_27_1_, feature4_.dbxref_id as dbxref_i4_27_1_, feature4_.description as descript5_27_1_, feature4_.is_analysis as is_analy6_27_1_, feature4_.is_obsolete as is_obsol7_27_1_, feature4_.last_updated as last_upd8_27_1_, feature4_.md5checksum as md9_27_1_, feature4_.name as name10_27_1_, feature4_.sequence_length as sequenc11_27_1_, feature4_.status_id as status_12_27_1_, feature4_.symbol as symbol13_27_1_, feature4_.unique_name as unique_14_27_1_, feature4_.alternate_cv_term as alterna16_27_1_, feature4_.class_name as class_n17_27_1_, feature4_.custom_alternate_cv_term as custom_18_27_1_, feature4_.custom_class_name as custom_19_27_1_, feature4_.custom_cv_term as custom_20_27_1_, feature4_.custom_ontology_id as custom_21_27_1_, feature4_.cv_term as cv_term22_27_1_, feature4_.meta_data as meta_da23_27_1_, feature4_.ontology_id as ontolog24_27_1_, feature4_.alteration_residue as alterat25_27_1_, feature4_.reference_allele_id as referen26_27_1_, feature4_.deletion_length as deletio27_27_1_, feature4_.analysis_feature_id as analysi28_27_1_, feature4_.class as class15_27_1_, featureloc5_.feature_id as feature_3_27_25_, featureloc5_.id as id1_33_25_, featureloc5_.id as id1_33_2_, featureloc5_.version as version2_33_2_, featureloc5_.feature_id as feature_3_33_2_, featureloc5_.fmax as fmax4_33_2_, featureloc5_.fmin as fmin5_33_2_, featureloc5_.is_fmax_partial as is_fmax_6_33_2_, featureloc5_.is_fmin_partial as is_fmin_7_33_2_, featureloc5_.locgroup as locgroup8_33_2_, featureloc5_.phase as phase9_33_2_, featureloc5_.rank as rank10_33_2_, featureloc5_.residue_info as residue11_33_2_, featureloc5_.sequence_id as sequenc12_33_2_, featureloc5_.strand as strand13_33_2_, featureloc5_.FMAX-featureloc5_.FMIN as formula0_2_, sequence6_.id as id1_76_3_, sequence6_.version as version2_76_3_, sequence6_.sequence_end as sequence3_76_3_, sequence6_.length as length4_76_3_, sequence6_.name as name5_76_3_, sequence6_.organism_id as organism6_76_3_, sequence6_.seq_chunk_size as seq_chun7_76_3_, sequence6_.sequence_start as sequence8_76_3_, featuredbx7_.feature_featuredbxrefs_id as feature_1_27_26_, dbxref8_.id as dbxref_i2_28_26_, dbxref8_.id as id1_23_4_, dbxref8_.accession as accessio3_23_4_, dbxref8_.db_id as db_id4_23_4_, dbxref8_.description as descript5_23_4_, featureloc1_.id as id1_33_5_, featureloc1_.version as version2_33_5_, featureloc1_.feature_id as feature_3_33_5_, featureloc1_.fmax as fmax4_33_5_, featureloc1_.fmin as fmin5_33_5_, featureloc1_.is_fmax_partial as is_fmax_6_33_5_, featureloc1_.is_fmin_partial as is_fmin_7_33_5_, featureloc1_.locgroup as locgroup8_33_5_, featureloc1_.phase as phase9_33_5_, featureloc1_.rank as rank10_33_5_, featureloc1_.residue_info as residue11_33_5_, featureloc1_.sequence_id as sequenc12_33_5_, featureloc1_.strand as strand13_33_5_, featureloc1_.FMAX-featureloc1_.FMIN as formula0_5_, sequence10_.id as id1_76_6_, sequence10_.version as version2_76_6_, sequence10_.sequence_end as sequence3_76_6_, sequence10_.length as length4_76_6_, sequence10_.name as name5_76_6_, sequence10_.organism_id as organism6_76_6_, sequence10_.seq_chunk_size as seq_chun7_76_6_, sequence10_.sequence_start as sequence8_76_6_, featurepro11_.feature_id as feature_3_27_27_, featurepro11_.id as id1_35_27_, featurepro11_.id as id1_35_7_, featurepro11_.version as version2_35_7_, featurepro11_.feature_id as feature_3_35_7_, featurepro11_.rank as rank4_35_7_, featurepro11_.tag as tag5_35_7_, featurepro11_.type_id as type_id6_35_7_, featurepro11_.value as value7_35_7_, featurepro11_.class as class8_35_7_, owners12_.feature_owners_id as feature_1_27_28_, user13_.id as user_id2_32_28_, user13_.id as id1_50_8_, user13_.version as version2_50_8_, user13_.first_name as first_na3_50_8_, user13_.inactive as inactive4_50_8_, user13_.last_name as last_nam5_50_8_, user13_.metadata as metadata6_50_8_, user13_.password_hash as password7_50_8_, user13_.username as username8_50_8_, parentfeat14_.parent_feature_id as parent_f4_27_29_, parentfeat14_.id as id1_38_29_, parentfeat14_.id as id1_38_9_, parentfeat14_.version as version2_38_9_, parentfeat14_.child_feature_id as child_fe3_38_9_, parentfeat14_.parent_feature_id as parent_f4_38_9_, parentfeat14_.rank as rank5_38_9_, parentfeat14_.value as value6_38_9_, feature15_.id as id1_27_10_, feature15_.version as version2_27_10_, feature15_.date_created as date_cre3_27_10_, feature15_.dbxref_id as dbxref_i4_27_10_, feature15_.description as descript5_27_10_, feature15_.is_analysis as is_analy6_27_10_, feature15_.is_obsolete as is_obsol7_27_10_, feature15_.last_updated as last_upd8_27_10_, feature15_.md5checksum as md9_27_10_, feature15_.name as name10_27_10_, feature15_.sequence_length as sequenc11_27_10_, feature15_.status_id as status_12_27_10_, feature15_.symbol as symbol13_27_10_, feature15_.unique_name as unique_14_27_10_, feature15_.alternate_cv_term as alterna16_27_10_, feature15_.class_name as class_n17_27_10_, feature15_.custom_alternate_cv_term as custom_18_27_10_, feature15_.custom_class_name as custom_19_27_10_, feature15_.custom_cv_term as custom_20_27_10_, feature15_.custom_ontology_id as custom_21_27_10_, feature15_.cv_term as cv_term22_27_10_, feature15_.meta_data as meta_da23_27_10_, feature15_.ontology_id as ontolog24_27_10_, feature15_.alteration_residue as alterat25_27_10_, feature15_.reference_allele_id as referen26_27_10_, feature15_.deletion_length as deletio27_27_10_, feature15_.analysis_feature_id as analysi28_27_10_, feature15_.class as class15_27_10_, childfeatu16_.child_feature_id as child_fe3_27_30_, childfeatu16_.id as id1_38_30_, childfeatu16_.id as id1_38_11_, childfeatu16_.version as version2_38_11_, childfeatu16_.child_feature_id as child_fe3_38_11_, childfeatu16_.parent_feature_id as parent_f4_38_11_, childfeatu16_.rank as rank5_38_11_, childfeatu16_.value as value6_38_11_, featuredbx17_.feature_featuredbxrefs_id as feature_1_27_31_, dbxref18_.id as dbxref_i2_28_31_, dbxref18_.id as id1_23_12_, dbxref18_.accession as accessio3_23_12_, dbxref18_.db_id as db_id4_23_12_, dbxref18_.description as descript5_23_12_, featureloc19_.feature_id as feature_3_27_32_, featureloc19_.id as id1_33_32_, featureloc19_.id as id1_33_13_, featureloc19_.version as version2_33_13_, featureloc19_.feature_id as feature_3_33_13_, featureloc19_.fmax as fmax4_33_13_, featureloc19_.fmin as fmin5_33_13_, featureloc19_.is_fmax_partial as is_fmax_6_33_13_, featureloc19_.is_fmin_partial as is_fmin_7_33_13_, featureloc19_.locgroup as locgroup8_33_13_, featureloc19_.phase as phase9_33_13_, featureloc19_.rank as rank10_33_13_, featureloc19_.residue_info as residue11_33_13_, featureloc19_.sequence_id as sequenc12_33_13_, featureloc19_.strand as strand13_33_13_, featureloc19_.FMAX-featureloc19_.FMIN as formula0_13_, sequence20_.id as id1_76_14_, sequence20_.version as version2_76_14_, sequence20_.sequence_end as sequence3_76_14_, sequence20_.length as length4_76_14_, sequence20_.name as name5_76_14_, sequence20_.organism_id as organism6_76_14_, sequence20_.seq_chunk_size as seq_chun7_76_14_, sequence20_.sequence_start as sequence8_76_14_, featurepro21_.feature_id as feature_3_27_33_, featurepro21_.id as id1_35_33_, featurepro21_.id as id1_35_15_, featurepro21_.version as version2_35_15_, featurepro21_.feature_id as feature_3_35_15_, featurepro21_.rank as rank4_35_15_, featurepro21_.tag as tag5_35_15_, featurepro21_.type_id as type_id6_35_15_, featurepro21_.value as value7_35_15_, featurepro21_.class as class8_35_15_, owners22_.feature_owners_id as feature_1_27_34_, user23_.id as user_id2_32_34_, user23_.id as id1_50_16_, user23_.version as version2_50_16_, user23_.first_name as first_na3_50_16_, user23_.inactive as inactive4_50_16_, user23_.last_name as last_nam5_50_16_, user23_.metadata as metadata6_50_16_, user23_.password_hash as password7_50_16_, user23_.username as username8_50_16_, parentfeat24_.parent_feature_id as parent_f4_27_35_, parentfeat24_.id as id1_38_35_, parentfeat24_.id as id1_38_17_, parentfeat24_.version as version2_38_17_, parentfeat24_.child_feature_id as child_fe3_38_17_, parentfeat24_.parent_feature_id as parent_f4_38_17_, parentfeat24_.rank as rank5_38_17_, parentfeat24_.value as value6_38_17_, feature25_.id as id1_27_18_, feature25_.version as version2_27_18_, feature25_.date_created as date_cre3_27_18_, feature25_.dbxref_id as dbxref_i4_27_18_, feature25_.description as descript5_27_18_, feature25_.is_analysis as is_analy6_27_18_, feature25_.is_obsolete as is_obsol7_27_18_, feature25_.last_updated as last_upd8_27_18_, feature25_.md5checksum as md9_27_18_, feature25_.name as name10_27_18_, feature25_.sequence_length as sequenc11_27_18_, feature25_.status_id as status_12_27_18_, feature25_.symbol as symbol13_27_18_, feature25_.unique_name as unique_14_27_18_, feature25_.alternate_cv_term as alterna16_27_18_, feature25_.class_name as class_n17_27_18_, feature25_.custom_alternate_cv_term as custom_18_27_18_, feature25_.custom_class_name as custom_19_27_18_, feature25_.custom_cv_term as custom_20_27_18_, feature25_.custom_ontology_id as custom_21_27_18_, feature25_.cv_term as cv_term22_27_18_, feature25_.meta_data as meta_da23_27_18_, feature25_.ontology_id as ontolog24_27_18_, feature25_.alteration_residue as alterat25_27_18_, feature25_.reference_allele_id as referen26_27_18_, feature25_.deletion_length as deletio27_27_18_, feature25_.analysis_feature_id as analysi28_27_18_, feature25_.class as class15_27_18_, featureloc26_.feature_id as feature_3_27_36_, featureloc26_.id as id1_33_36_, featureloc26_.id as id1_33_19_, featureloc26_.version as version2_33_19_, featureloc26_.feature_id as feature_3_33_19_, featureloc26_.fmax as fmax4_33_19_, featureloc26_.fmin as fmin5_33_19_, featureloc26_.is_fmax_partial as is_fmax_6_33_19_, featureloc26_.is_fmin_partial as is_fmin_7_33_19_, featureloc26_.locgroup as locgroup8_33_19_, featureloc26_.phase as phase9_33_19_, featureloc26_.rank as rank10_33_19_, featureloc26_.residue_info as residue11_33_19_, featureloc26_.sequence_id as sequenc12_33_19_, featureloc26_.strand as strand13_33_19_, featureloc26_.FMAX-featureloc26_.FMIN as formula0_19_, sequence27_.id as id1_76_20_, sequence27_.version as version2_76_20_, sequence27_.sequence_end as sequence3_76_20_, sequence27_.length as length4_76_20_, sequence27_.name as name5_76_20_, sequence27_.organism_id as organism6_76_20_, sequence27_.seq_chunk_size as seq_chun7_76_20_, sequence27_.sequence_start as sequence8_76_20_, status28_.id as id1_35_21_, status28_.version as version2_35_21_, status28_.feature_id as feature_3_35_21_, status28_.rank as rank4_35_21_, status28_.tag as tag5_35_21_, status28_.type_id as type_id6_35_21_, status28_.value as value7_35_21_ from feature this_ left outer join feature_relationship childfeatu3_ on this_.id=childfeatu3_.child_feature_id left outer join feature feature4_ on childfeatu3_.parent_feature_id=feature4_.id left outer join feature_location featureloc5_ on feature4_.id=featureloc5_.feature_id left outer join sequence sequence6_ on featureloc5_.sequence_id=sequence6_.id left outer join feature_dbxref featuredbx7_ on this_.id=featuredbx7_.feature_featuredbxrefs_id left outer join dbxref dbxref8_ on featuredbx7_.dbxref_id=dbxref8_.id inner join feature_location featureloc1_ on this_.id=featureloc1_.feature_id left outer join sequence sequence10_ on featureloc1_.sequence_id=sequence10_.id left outer join feature_property featurepro11_ on this_.id=featurepro11_.feature_id left outer join feature_grails_user owners12_ on this_.id=owners12_.feature_owners_id left outer join grails_user user13_ on owners12_.user_id=user13_.id left outer join feature_relationship parentfeat14_ on this_.id=parentfeat14_.parent_feature_id left outer join feature feature15_ on parentfeat14_.child_feature_id=feature15_.id left outer join feature_relationship childfeatu16_ on feature15_.id=childfeatu16_.child_feature_id left outer join feature_dbxref featuredbx17_ on feature15_.id=featuredbx17_.feature_featuredbxrefs_id left outer join dbxref dbxref18_ on featuredbx17_.dbxref_id=dbxref18_.id left outer join feature_location featureloc19_ on feature15_.id=featureloc19_.feature_id left outer join sequence sequence20_ on featureloc19_.sequence_id=sequence20_.id left outer join feature_property featurepro21_ on feature15_.id=featurepro21_.feature_id left outer join feature_grails_user owners22_ on feature15_.id=owners22_.feature_owners_id left outer join grails_user user23_ on owners22_.user_id=user23_.id left outer join feature_relationship parentfeat24_ on feature15_.id=parentfeat24_.parent_feature_id left outer join feature feature25_ on parentfeat14_.parent_feature_id=feature25_.id left outer join feature_location featureloc26_ on feature25_.id=featureloc26_.feature_id left outer join sequence sequence27_ on featureloc26_.sequence_id=sequence27_.id left outer join feature_property status28_ on this_.status_id=status28_.id where (featureloc1_.sequence_id=45) and this_.class in ('org.bbop.apollo.Transcript', 'org.bbop.apollo.MRNA', 'org.bbop.apollo.TRNA', 'org.bbop.apollo.SnRNA', 'org.bbop.apollo.SnoRNA', 'org.bbop.apollo.NcRNA', 'org.bbop.apollo.RRNA', 'org.bbop.apollo.MiRNA', 'org.bbop.apollo.RepeatRegion', 'org.bbop.apollo.Terminator', 'org.bbop.apollo.TransposableElement', 'org.bbop.apollo.Deletion', 'org.bbop.apollo.Insertion', 'org.bbop.apollo.Substitution', 'org.bbop.apollo.SNV', 'org.bbop.apollo.SNP', 'org.bbop.apollo.MNV', 'org.bbop.apollo.MNP', 'org.bbop.apollo.Indel');
# Time: 200423 16:30:03
# User@Host: apollo2_user[apollo2_user] @ our_apollo_server.net [XX.XX.XXX.XXX]
# Thread_id: 1890270  Schema: apollo2_prod  QC_hit: No
# Query_time: 5.789369  Lock_time: 0.000647  Rows_sent: 114021  Rows_examined: 1052266
SET timestamp=1587652203;
select this_.id as id1_27_22_, this_.version as version2_27_22_, this_.date_created as date_cre3_27_22_, this_.dbxref_id as dbxref_i4_27_22_, this_.description as descript5_27_22_, this_.is_analysis as is_analy6_27_22_, this_.is_obsolete as is_obsol7_27_22_, this_.last_updated as last_upd8_27_22_, this_.md5checksum as md9_27_22_, this_.name as name10_27_22_, this_.sequence_length as sequenc11_27_22_, this_.status_id as status_12_27_22_, this_.symbol as symbol13_27_22_, this_.unique_name as unique_14_27_22_, this_.alternate_cv_term as alterna16_27_22_, this_.class_name as class_n17_27_22_, this_.custom_alternate_cv_term as custom_18_27_22_, this_.custom_class_name as custom_19_27_22_, this_.custom_cv_term as custom_20_27_22_, this_.custom_ontology_id as custom_21_27_22_, this_.cv_term as cv_term22_27_22_, this_.meta_data as meta_da23_27_22_, this_.ontology_id as ontolog24_27_22_, this_.alteration_residue as alterat25_27_22_, this_.reference_allele_id as referen26_27_22_, this_.deletion_length as deletio27_27_22_, this_.analysis_feature_id as analysi28_27_22_, this_.class as class15_27_22_, childfeatu3_.child_feature_id as child_fe3_27_24_, childfeatu3_.id as id1_38_24_, childfeatu3_.id as id1_38_0_, childfeatu3_.version as version2_38_0_, childfeatu3_.child_feature_id as child_fe3_38_0_, childfeatu3_.parent_feature_id as parent_f4_38_0_, childfeatu3_.rank as rank5_38_0_, childfeatu3_.value as value6_38_0_, feature4_.id as id1_27_1_, feature4_.version as version2_27_1_, feature4_.date_created as date_cre3_27_1_, feature4_.dbxref_id as dbxref_i4_27_1_, feature4_.description as descript5_27_1_, feature4_.is_analysis as is_analy6_27_1_, feature4_.is_obsolete as is_obsol7_27_1_, feature4_.last_updated as last_upd8_27_1_, feature4_.md5checksum as md9_27_1_, feature4_.name as name10_27_1_, feature4_.sequence_length as sequenc11_27_1_, feature4_.status_id as status_12_27_1_, feature4_.symbol as symbol13_27_1_, feature4_.unique_name as unique_14_27_1_, feature4_.alternate_cv_term as alterna16_27_1_, feature4_.class_name as class_n17_27_1_, feature4_.custom_alternate_cv_term as custom_18_27_1_, feature4_.custom_class_name as custom_19_27_1_, feature4_.custom_cv_term as custom_20_27_1_, feature4_.custom_ontology_id as custom_21_27_1_, feature4_.cv_term as cv_term22_27_1_, feature4_.meta_data as meta_da23_27_1_, feature4_.ontology_id as ontolog24_27_1_, feature4_.alteration_residue as alterat25_27_1_, feature4_.reference_allele_id as referen26_27_1_, feature4_.deletion_length as deletio27_27_1_, feature4_.analysis_feature_id as analysi28_27_1_, feature4_.class as class15_27_1_, featureloc5_.feature_id as feature_3_27_25_, featureloc5_.id as id1_33_25_, featureloc5_.id as id1_33_2_, featureloc5_.version as version2_33_2_, featureloc5_.feature_id as feature_3_33_2_, featureloc5_.fmax as fmax4_33_2_, featureloc5_.fmin as fmin5_33_2_, featureloc5_.is_fmax_partial as is_fmax_6_33_2_, featureloc5_.is_fmin_partial as is_fmin_7_33_2_, featureloc5_.locgroup as locgroup8_33_2_, featureloc5_.phase as phase9_33_2_, featureloc5_.rank as rank10_33_2_, featureloc5_.residue_info as residue11_33_2_, featureloc5_.sequence_id as sequenc12_33_2_, featureloc5_.strand as strand13_33_2_, featureloc5_.FMAX-featureloc5_.FMIN as formula0_2_, sequence6_.id as id1_76_3_, sequence6_.version as version2_76_3_, sequence6_.sequence_end as sequence3_76_3_, sequence6_.length as length4_76_3_, sequence6_.name as name5_76_3_, sequence6_.organism_id as organism6_76_3_, sequence6_.seq_chunk_size as seq_chun7_76_3_, sequence6_.sequence_start as sequence8_76_3_, featuredbx7_.feature_featuredbxrefs_id as feature_1_27_26_, dbxref8_.id as dbxref_i2_28_26_, dbxref8_.id as id1_23_4_, dbxref8_.accession as accessio3_23_4_, dbxref8_.db_id as db_id4_23_4_, dbxref8_.description as descript5_23_4_, featureloc1_.id as id1_33_5_, featureloc1_.version as version2_33_5_, featureloc1_.feature_id as feature_3_33_5_, featureloc1_.fmax as fmax4_33_5_, featureloc1_.fmin as fmin5_33_5_, featureloc1_.is_fmax_partial as is_fmax_6_33_5_, featureloc1_.is_fmin_partial as is_fmin_7_33_5_, featureloc1_.locgroup as locgroup8_33_5_, featureloc1_.phase as phase9_33_5_, featureloc1_.rank as rank10_33_5_, featureloc1_.residue_info as residue11_33_5_, featureloc1_.sequence_id as sequenc12_33_5_, featureloc1_.strand as strand13_33_5_, featureloc1_.FMAX-featureloc1_.FMIN as formula0_5_, sequence10_.id as id1_76_6_, sequence10_.version as version2_76_6_, sequence10_.sequence_end as sequence3_76_6_, sequence10_.length as length4_76_6_, sequence10_.name as name5_76_6_, sequence10_.organism_id as organism6_76_6_, sequence10_.seq_chunk_size as seq_chun7_76_6_, sequence10_.sequence_start as sequence8_76_6_, featurepro11_.feature_id as feature_3_27_27_, featurepro11_.id as id1_35_27_, featurepro11_.id as id1_35_7_, featurepro11_.version as version2_35_7_, featurepro11_.feature_id as feature_3_35_7_, featurepro11_.rank as rank4_35_7_, featurepro11_.tag as tag5_35_7_, featurepro11_.type_id as type_id6_35_7_, featurepro11_.value as value7_35_7_, featurepro11_.class as class8_35_7_, owners12_.feature_owners_id as feature_1_27_28_, user13_.id as user_id2_32_28_, user13_.id as id1_50_8_, user13_.version as version2_50_8_, user13_.first_name as first_na3_50_8_, user13_.inactive as inactive4_50_8_, user13_.last_name as last_nam5_50_8_, user13_.metadata as metadata6_50_8_, user13_.password_hash as password7_50_8_, user13_.username as username8_50_8_, parentfeat14_.parent_feature_id as parent_f4_27_29_, parentfeat14_.id as id1_38_29_, parentfeat14_.id as id1_38_9_, parentfeat14_.version as version2_38_9_, parentfeat14_.child_feature_id as child_fe3_38_9_, parentfeat14_.parent_feature_id as parent_f4_38_9_, parentfeat14_.rank as rank5_38_9_, parentfeat14_.value as value6_38_9_, feature15_.id as id1_27_10_, feature15_.version as version2_27_10_, feature15_.date_created as date_cre3_27_10_, feature15_.dbxref_id as dbxref_i4_27_10_, feature15_.description as descript5_27_10_, feature15_.is_analysis as is_analy6_27_10_, feature15_.is_obsolete as is_obsol7_27_10_, feature15_.last_updated as last_upd8_27_10_, feature15_.md5checksum as md9_27_10_, feature15_.name as name10_27_10_, feature15_.sequence_length as sequenc11_27_10_, feature15_.status_id as status_12_27_10_, feature15_.symbol as symbol13_27_10_, feature15_.unique_name as unique_14_27_10_, feature15_.alternate_cv_term as alterna16_27_10_, feature15_.class_name as class_n17_27_10_, feature15_.custom_alternate_cv_term as custom_18_27_10_, feature15_.custom_class_name as custom_19_27_10_, feature15_.custom_cv_term as custom_20_27_10_, feature15_.custom_ontology_id as custom_21_27_10_, feature15_.cv_term as cv_term22_27_10_, feature15_.meta_data as meta_da23_27_10_, feature15_.ontology_id as ontolog24_27_10_, feature15_.alteration_residue as alterat25_27_10_, feature15_.reference_allele_id as referen26_27_10_, feature15_.deletion_length as deletio27_27_10_, feature15_.analysis_feature_id as analysi28_27_10_, feature15_.class as class15_27_10_, childfeatu16_.child_feature_id as child_fe3_27_30_, childfeatu16_.id as id1_38_30_, childfeatu16_.id as id1_38_11_, childfeatu16_.version as version2_38_11_, childfeatu16_.child_feature_id as child_fe3_38_11_, childfeatu16_.parent_feature_id as parent_f4_38_11_, childfeatu16_.rank as rank5_38_11_, childfeatu16_.value as value6_38_11_, featuredbx17_.feature_featuredbxrefs_id as feature_1_27_31_, dbxref18_.id as dbxref_i2_28_31_, dbxref18_.id as id1_23_12_, dbxref18_.accession as accessio3_23_12_, dbxref18_.db_id as db_id4_23_12_, dbxref18_.description as descript5_23_12_, featureloc19_.feature_id as feature_3_27_32_, featureloc19_.id as id1_33_32_, featureloc19_.id as id1_33_13_, featureloc19_.version as version2_33_13_, featureloc19_.feature_id as feature_3_33_13_, featureloc19_.fmax as fmax4_33_13_, featureloc19_.fmin as fmin5_33_13_, featureloc19_.is_fmax_partial as is_fmax_6_33_13_, featureloc19_.is_fmin_partial as is_fmin_7_33_13_, featureloc19_.locgroup as locgroup8_33_13_, featureloc19_.phase as phase9_33_13_, featureloc19_.rank as rank10_33_13_, featureloc19_.residue_info as residue11_33_13_, featureloc19_.sequence_id as sequenc12_33_13_, featureloc19_.strand as strand13_33_13_, featureloc19_.FMAX-featureloc19_.FMIN as formula0_13_, sequence20_.id as id1_76_14_, sequence20_.version as version2_76_14_, sequence20_.sequence_end as sequence3_76_14_, sequence20_.length as length4_76_14_, sequence20_.name as name5_76_14_, sequence20_.organism_id as organism6_76_14_, sequence20_.seq_chunk_size as seq_chun7_76_14_, sequence20_.sequence_start as sequence8_76_14_, featurepro21_.feature_id as feature_3_27_33_, featurepro21_.id as id1_35_33_, featurepro21_.id as id1_35_15_, featurepro21_.version as version2_35_15_, featurepro21_.feature_id as feature_3_35_15_, featurepro21_.rank as rank4_35_15_, featurepro21_.tag as tag5_35_15_, featurepro21_.type_id as type_id6_35_15_, featurepro21_.value as value7_35_15_, featurepro21_.class as class8_35_15_, owners22_.feature_owners_id as feature_1_27_34_, user23_.id as user_id2_32_34_, user23_.id as id1_50_16_, user23_.version as version2_50_16_, user23_.first_name as first_na3_50_16_, user23_.inactive as inactive4_50_16_, user23_.last_name as last_nam5_50_16_, user23_.metadata as metadata6_50_16_, user23_.password_hash as password7_50_16_, user23_.username as username8_50_16_, parentfeat24_.parent_feature_id as parent_f4_27_35_, parentfeat24_.id as id1_38_35_, parentfeat24_.id as id1_38_17_, parentfeat24_.version as version2_38_17_, parentfeat24_.child_feature_id as child_fe3_38_17_, parentfeat24_.parent_feature_id as parent_f4_38_17_, parentfeat24_.rank as rank5_38_17_, parentfeat24_.value as value6_38_17_, feature25_.id as id1_27_18_, feature25_.version as version2_27_18_, feature25_.date_created as date_cre3_27_18_, feature25_.dbxref_id as dbxref_i4_27_18_, feature25_.description as descript5_27_18_, feature25_.is_analysis as is_analy6_27_18_, feature25_.is_obsolete as is_obsol7_27_18_, feature25_.last_updated as last_upd8_27_18_, feature25_.md5checksum as md9_27_18_, feature25_.name as name10_27_18_, feature25_.sequence_length as sequenc11_27_18_, feature25_.status_id as status_12_27_18_, feature25_.symbol as symbol13_27_18_, feature25_.unique_name as unique_14_27_18_, feature25_.alternate_cv_term as alterna16_27_18_, feature25_.class_name as class_n17_27_18_, feature25_.custom_alternate_cv_term as custom_18_27_18_, feature25_.custom_class_name as custom_19_27_18_, feature25_.custom_cv_term as custom_20_27_18_, feature25_.custom_ontology_id as custom_21_27_18_, feature25_.cv_term as cv_term22_27_18_, feature25_.meta_data as meta_da23_27_18_, feature25_.ontology_id as ontolog24_27_18_, feature25_.alteration_residue as alterat25_27_18_, feature25_.reference_allele_id as referen26_27_18_, feature25_.deletion_length as deletio27_27_18_, feature25_.analysis_feature_id as analysi28_27_18_, feature25_.class as class15_27_18_, featureloc26_.feature_id as feature_3_27_36_, featureloc26_.id as id1_33_36_, featureloc26_.id as id1_33_19_, featureloc26_.version as version2_33_19_, featureloc26_.feature_id as feature_3_33_19_, featureloc26_.fmax as fmax4_33_19_, featureloc26_.fmin as fmin5_33_19_, featureloc26_.is_fmax_partial as is_fmax_6_33_19_, featureloc26_.is_fmin_partial as is_fmin_7_33_19_, featureloc26_.locgroup as locgroup8_33_19_, featureloc26_.phase as phase9_33_19_, featureloc26_.rank as rank10_33_19_, featureloc26_.residue_info as residue11_33_19_, featureloc26_.sequence_id as sequenc12_33_19_, featureloc26_.strand as strand13_33_19_, featureloc26_.FMAX-featureloc26_.FMIN as formula0_19_, sequence27_.id as id1_76_20_, sequence27_.version as version2_76_20_, sequence27_.sequence_end as sequence3_76_20_, sequence27_.length as length4_76_20_, sequence27_.name as name5_76_20_, sequence27_.organism_id as organism6_76_20_, sequence27_.seq_chunk_size as seq_chun7_76_20_, sequence27_.sequence_start as sequence8_76_20_, status28_.id as id1_35_21_, status28_.version as version2_35_21_, status28_.feature_id as feature_3_35_21_, status28_.rank as rank4_35_21_, status28_.tag as tag5_35_21_, status28_.type_id as type_id6_35_21_, status28_.value as value7_35_21_ from feature this_ left outer join feature_relationship childfeatu3_ on this_.id=childfeatu3_.child_feature_id left outer join feature feature4_ on childfeatu3_.parent_feature_id=feature4_.id left outer join feature_location featureloc5_ on feature4_.id=featureloc5_.feature_id left outer join sequence sequence6_ on featureloc5_.sequence_id=sequence6_.id left outer join feature_dbxref featuredbx7_ on this_.id=featuredbx7_.feature_featuredbxrefs_id left outer join dbxref dbxref8_ on featuredbx7_.dbxref_id=dbxref8_.id inner join feature_location featureloc1_ on this_.id=featureloc1_.feature_id left outer join sequence sequence10_ on featureloc1_.sequence_id=sequence10_.id left outer join feature_property featurepro11_ on this_.id=featurepro11_.feature_id left outer join feature_grails_user owners12_ on this_.id=owners12_.feature_owners_id left outer join grails_user user13_ on owners12_.user_id=user13_.id left outer join feature_relationship parentfeat14_ on this_.id=parentfeat14_.parent_feature_id left outer join feature feature15_ on parentfeat14_.child_feature_id=feature15_.id left outer join feature_relationship childfeatu16_ on feature15_.id=childfeatu16_.child_feature_id left outer join feature_dbxref featuredbx17_ on feature15_.id=featuredbx17_.feature_featuredbxrefs_id left outer join dbxref dbxref18_ on featuredbx17_.dbxref_id=dbxref18_.id left outer join feature_location featureloc19_ on feature15_.id=featureloc19_.feature_id left outer join sequence sequence20_ on featureloc19_.sequence_id=sequence20_.id left outer join feature_property featurepro21_ on feature15_.id=featurepro21_.feature_id left outer join feature_grails_user owners22_ on feature15_.id=owners22_.feature_owners_id left outer join grails_user user23_ on owners22_.user_id=user23_.id left outer join feature_relationship parentfeat24_ on feature15_.id=parentfeat24_.parent_feature_id left outer join feature feature25_ on parentfeat14_.parent_feature_id=feature25_.id left outer join feature_location featureloc26_ on feature25_.id=featureloc26_.feature_id left outer join sequence sequence27_ on featureloc26_.sequence_id=sequence27_.id left outer join feature_property status28_ on this_.status_id=status28_.id where (featureloc1_.sequence_id=47) and this_.class in ('org.bbop.apollo.Transcript', 'org.bbop.apollo.MRNA', 'org.bbop.apollo.TRNA', 'org.bbop.apollo.SnRNA', 'org.bbop.apollo.SnoRNA', 'org.bbop.apollo.NcRNA', 'org.bbop.apollo.RRNA', 'org.bbop.apollo.MiRNA', 'org.bbop.apollo.RepeatRegion', 'org.bbop.apollo.Terminator', 'org.bbop.apollo.TransposableElement', 'org.bbop.apollo.Deletion', 'org.bbop.apollo.Insertion', 'org.bbop.apollo.Substitution', 'org.bbop.apollo.SNV', 'org.bbop.apollo.SNP', 'org.bbop.apollo.MNV', 'org.bbop.apollo.MNP', 'org.bbop.apollo.Indel');

[nathandunn]

likely related to #2415