GET https://efi-dev.igb.illinois.edu/_fragment?_path=_format%3Dhtml%26_locale%3Den-US%26_controller%3DApp%255CHome%255CController%255CHomeController%253A%253Arender…

Response
200 OK
Browse referrer URL
IP
140.177.152.135
Profiled on
Token
b003f3

Query Metrics

65 Database Queries
5 Different statements
66.62 ms Query time
1 Invalid entities
478 Managed entities

Grouped Statements

Show all queries

default connection

Time▼ Count Info
58.55 ms
(87.88%) 		61 
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.status AS status_3, t0.timeCreated AS timeCreated_4, t0.timeStarted AS timeStarted_5, t0.timeCompleted AS timeCompleted_6, t0.efi_db_version AS efi_db_version_7, t0.jobName AS jobName_8, t0.isPublic AS isPublic_9, t0.isExample AS isExample_10, t0.schedulerJobId AS schedulerJobId_11, t0.user_id AS user_id_12, t0.parentJob_id AS parentJob_id_13, t0.job_type, t0.numBlastUnmatchedIds AS numBlastUnmatchedIds_14, t0.numBlastRetrievedIds AS numBlastRetrievedIds_15, t0.excludeFragments AS excludeFragments_16, t0.numFragmentFiltered AS numFragmentFiltered_17, t0.uploadedFilename AS uploadedFilename_18, t0.jobFilename AS jobFilename_19, t0.updatedAt AS updatedAt_20, t0.taxSearch AS taxSearch_21, t0.taxSearchName AS taxSearchName_22, t0.numTaxonomyFiltered AS numTaxonomyFiltered_23, t0.families AS families_24, t0.fraction AS fraction_25, t0.numFamilyIds AS numFamilyIds_26, t0.numFullFamilyIds AS numFullFamilyIds_27, t0.numFamilyOverlapIds AS numFamilyOverlapIds_28, t0.numFamilyUnirefOverlapIds AS numFamilyUnirefOverlapIds_29, t0.numFractionFiltered AS numFractionFiltered_30, t0.blastEValue AS blastEValue_31, t0.maxBlastSequences AS maxBlastSequences_32, t0.sequence_version AS sequence_version_33, t0.domain AS domain_34, t0.domainRegion AS domainRegion_35, t0.excludeFragments AS excludeFragments_36, t0.numFragmentFiltered AS numFragmentFiltered_37, t0.taxSearch AS taxSearch_38, t0.taxSearchName AS taxSearchName_39, t0.numTaxonomyFiltered AS numTaxonomyFiltered_40, t0.families AS families_41, t0.fraction AS fraction_42, t0.numFamilyIds AS numFamilyIds_43, t0.numFullFamilyIds AS numFullFamilyIds_44, t0.numFamilyOverlapIds AS numFamilyOverlapIds_45, t0.numFamilyUnirefOverlapIds AS numFamilyUnirefOverlapIds_46, t0.numFractionFiltered AS numFractionFiltered_47, t0.sequence_version AS sequence_version_48, t0.numFastaHeaders AS numFastaHeaders_49, t0.uploadedFilename AS uploadedFilename_50, t0.jobFilename AS jobFilename_51, t0.updatedAt AS updatedAt_52, t0.taxSearch AS taxSearch_53, t0.taxSearchName AS taxSearchName_54, t0.numTaxonomyFiltered AS numTaxonomyFiltered_55, t0.families AS families_56, t0.fraction AS fraction_57, t0.numFamilyIds AS numFamilyIds_58, t0.numFullFamilyIds AS numFullFamilyIds_59, t0.numFamilyOverlapIds AS numFamilyOverlapIds_60, t0.numFamilyUnirefOverlapIds AS numFamilyUnirefOverlapIds_61, t0.numFractionFiltered AS numFractionFiltered_62, t0.sequence_version AS sequence_version_63, t0.numMatchedIds AS numMatchedIds_64, t0.numUnmatchedIds AS numUnmatchedIds_65, t0.domainFamily AS domainFamily_66, t0.numForeignIds AS numForeignIds_67, t0.domain AS domain_68, t0.domainRegion AS domainRegion_69, t0.excludeFragments AS excludeFragments_70, t0.numFragmentFiltered AS numFragmentFiltered_71, t0.uploadedFilename AS uploadedFilename_72, t0.jobFilename AS jobFilename_73, t0.updatedAt AS updatedAt_74, t0.filterByFamilies AS filterByFamilies_75, t0.numFamilyFiltered AS numFamilyFiltered_76, t0.taxSearch AS taxSearch_77, t0.taxSearchName AS taxSearchName_78, t0.numTaxonomyFiltered AS numTaxonomyFiltered_79, t0.families AS families_80, t0.fraction AS fraction_81, t0.numFamilyIds AS numFamilyIds_82, t0.numFullFamilyIds AS numFullFamilyIds_83, t0.numFamilyOverlapIds AS numFamilyOverlapIds_84, t0.numFamilyUnirefOverlapIds AS numFamilyUnirefOverlapIds_85, t0.numFractionFiltered AS numFractionFiltered_86, t0.sequence_version AS sequence_version_87, t0.numMatchedIds AS numMatchedIds_88, t0.numUnmatchedIds AS numUnmatchedIds_89, t0.numSsnClusters AS numSsnClusters_90, t0.numSsnSingletons AS numSsnSingletons_91, t0.numSsnMetanodes AS numSsnMetanodes_92, t0.numSsnAccessionIds AS numSsnAccessionIds_93, t0.colorSsnSequenceSource AS colorSsnSequenceSource_94, t0.uploadedFilename AS uploadedFilename_95, t0.jobFilename AS jobFilename_96, t0.updatedAt AS updatedAt_97, t0.resultFileStats AS resultFileStats_98, t0.sourceFileReference AS sourceFileReference_99, t0.uploadedFilename AS uploadedFilename_100, t0.jobFilename AS jobFilename_101, t0.updatedAt AS updatedAt_102, t0.resultFileStats AS resultFileStats_103, t0.sourceFileReference AS sourceFileReference_104, t0.maxNumSequences AS maxNumSequences_105, t0.minNumSequences AS minNumSequences_106, t0.makeWeblogo AS makeWeblogo_107, t0.computeConsensusResidues AS computeConsensusResidues_108, t0.consensusResidues AS consensusResidues_109, t0.pidThresholds AS pidThresholds_110, t0.makeHmms AS makeHmms_111, t0.makeLengthHistograms AS makeLengthHistograms_112, t0.numSsnClusters AS numSsnClusters_113, t0.numSsnSingletons AS numSsnSingletons_114, t0.numSsnMetanodes AS numSsnMetanodes_115, t0.numSsnAccessionIds AS numSsnAccessionIds_116, t0.colorSsnSequenceSource AS colorSsnSequenceSource_117, t0.uploadedFilename AS uploadedFilename_118, t0.jobFilename AS jobFilename_119, t0.updatedAt AS updatedAt_120, t0.resultFileStats AS resultFileStats_121, t0.sourceFileReference AS sourceFileReference_122, t0.uploadedFilename AS uploadedFilename_123, t0.jobFilename AS jobFilename_124, t0.updatedAt AS updatedAt_125, t0.blastEValue AS blastEValue_126, t0.maxBlastSequences AS maxBlastSequences_127, t0.sourceFileReference AS sourceFileReference_128, t0.computeNeighborhoodConnectivity AS computeNeighborhoodConnectivity_129, t0.makeRepnodeNetworks AS makeRepnodeNetworks_130, t0.thresholdValue AS thresholdValue_131, t0.maxSsnEdges AS maxSsnEdges_132, t0.thresholdMetric AS thresholdMetric_133, t0.excludeFragments AS excludeFragments_134, t0.numFragmentFiltered AS numFragmentFiltered_135, t0.taxSearch AS taxSearch_136, t0.taxSearchName AS taxSearchName_137, t0.numTaxonomyFiltered AS numTaxonomyFiltered_138, t0.resultFileStats AS resultFileStats_139, t0.minLength AS minLength_140, t0.maxLength AS maxLength_141, t0.cooccurrence AS cooccurrence_142, t0.numSsnClusters AS numSsnClusters_143, t0.numSsnSingletons AS numSsnSingletons_144, t0.numSsnMetanodes AS numSsnMetanodes_145, t0.numSsnAccessionIds AS numSsnAccessionIds_146, t0.colorSsnSequenceSource AS colorSsnSequenceSource_147, t0.uploadedFilename AS uploadedFilename_148, t0.jobFilename AS jobFilename_149, t0.updatedAt AS updatedAt_150, t0.resultFileStats AS resultFileStats_151, t0.neighborhood_size AS neighborhood_size_152, t0.sourceFileReference AS sourceFileReference_153, t0.excludeFragments AS excludeFragments_154, t0.numFragmentFiltered AS numFragmentFiltered_155, t0.uploadedFilename AS uploadedFilename_156, t0.jobFilename AS jobFilename_157, t0.updatedAt AS updatedAt_158, t0.neighborhood_size AS neighborhood_size_159, t0.blastEValue AS blastEValue_160, t0.maxBlastSequences AS maxBlastSequences_161, t0.sequence_version AS sequence_version_162, t0.uploadedFilename AS uploadedFilename_163, t0.jobFilename AS jobFilename_164, t0.updatedAt AS updatedAt_165, t0.neighborhood_size AS neighborhood_size_166, t0.excludeFragments AS excludeFragments_167, t0.numFragmentFiltered AS numFragmentFiltered_168, t0.uploadedFilename AS uploadedFilename_169, t0.jobFilename AS jobFilename_170, t0.updatedAt AS updatedAt_171, t0.neighborhood_size AS neighborhood_size_172, t0.blastEValue AS blastEValue_173, t0.maxBlastSequences AS maxBlastSequences_174, t0.sequence_version AS sequence_version_175, t0.uploadedFilename AS uploadedFilename_176, t0.jobFilename AS jobFilename_177, t0.updatedAt AS updatedAt_178, t0.referenceDatabase AS referenceDatabase_179, t0.cdhitSequenceIdentity AS cdhitSequenceIdentity_180, t0.searchType AS searchType_181, t0.uploadedFilename AS uploadedFilename_182, t0.jobFilename AS jobFilename_183, t0.updatedAt AS updatedAt_184, t0.minLength AS minLength_185, t0.maxLength AS maxLength_186, t0.sourceFileReference AS sourceFileReference_187, t0.metagenomes AS metagenomes_188, t0.searchType AS searchType_189, t0.numForeignIds AS numForeignIds_190, t0.excludeFragments AS excludeFragments_191, t0.numFragmentFiltered AS numFragmentFiltered_192, t0.uploadedFilename AS uploadedFilename_193, t0.jobFilename AS jobFilename_194, t0.updatedAt AS updatedAt_195, t0.filterByFamilies AS filterByFamilies_196, t0.numFamilyFiltered AS numFamilyFiltered_197, t0.taxSearch AS taxSearch_198, t0.taxSearchName AS taxSearchName_199, t0.numTaxonomyFiltered AS numTaxonomyFiltered_200, t0.numComputedIds AS numComputedIds_201, t0.numImportedIds AS numImportedIds_202, t0.outputConvergenceRatio AS outputConvergenceRatio_203, t0.numBlastEdges AS numBlastEdges_204, t0.sequence_version AS sequence_version_205, t0.numMatchedIds AS numMatchedIds_206, t0.numUnmatchedIds AS numUnmatchedIds_207, t0.excludeFragments AS excludeFragments_208, t0.numFragmentFiltered AS numFragmentFiltered_209, t0.taxSearch AS taxSearch_210, t0.taxSearchName AS taxSearchName_211, t0.numTaxonomyFiltered AS numTaxonomyFiltered_212, t0.families AS families_213, t0.fraction AS fraction_214, t0.numFamilyIds AS numFamilyIds_215, t0.numFullFamilyIds AS numFullFamilyIds_216, t0.numFamilyOverlapIds AS numFamilyOverlapIds_217, t0.numFamilyUnirefOverlapIds AS numFamilyUnirefOverlapIds_218, t0.numFractionFiltered AS numFractionFiltered_219, t0.numComputedIds AS numComputedIds_220, t0.numImportedIds AS numImportedIds_221, t0.outputConvergenceRatio AS outputConvergenceRatio_222, t0.numBlastEdges AS numBlastEdges_223, t0.minLength AS minLength_224, t0.maxLength AS maxLength_225, t0.sequence_version AS sequence_version_226, t0.excludeFragments AS excludeFragments_227, t0.numFragmentFiltered AS numFragmentFiltered_228, t0.numFastaHeaders AS numFastaHeaders_229, t0.uploadedFilename AS uploadedFilename_230, t0.jobFilename AS jobFilename_231, t0.updatedAt AS updatedAt_232, t0.filterByFamilies AS filterByFamilies_233, t0.numFamilyFiltered AS numFamilyFiltered_234, t0.taxSearch AS taxSearch_235, t0.taxSearchName AS taxSearchName_236, t0.numTaxonomyFiltered AS numTaxonomyFiltered_237, t0.numComputedIds AS numComputedIds_238, t0.numImportedIds AS numImportedIds_239, t0.outputConvergenceRatio AS outputConvergenceRatio_240, t0.numBlastEdges AS numBlastEdges_241, t0.numMatchedIds AS numMatchedIds_242, t0.numUnmatchedIds AS numUnmatchedIds_243, t0.allByAllBlastEValue AS allByAllBlastEValue_244, t0.numComputedIds AS numComputedIds_245, t0.numImportedIds AS numImportedIds_246, t0.outputConvergenceRatio AS outputConvergenceRatio_247, t0.numBlastEdges AS numBlastEdges_248 FROM Job t0 WHERE t0.id = ? AND t0.job_type IN ('est_generate_blast', 'est_generate_families', 'est_generate_fasta', 'est_generate_accession', 'est_color_ssn', 'est_neighborhood_connectivity', 'est_cluster_analysis', 'est_convergence_ratio', 'est_ssn_finalization', 'gnt_gnn', 'gnt_diagram_blast', 'gnt_diagram_fasta', 'gnt_diagram_sequence_id', 'gnt_view_diagram', 'cgfp_identify', 'cgfp_quantify', 'taxonomy_accession', 'taxonomy_families', 'taxonomy_fasta')
Parameters: 
[
  827
]
View formatted query    View runnable query    Explain query
6.98 ms
(10.48%) 		1 
SELECT j0_.id AS id_0, j0_.uuid AS uuid_1, j0_.status AS status_2, j0_.timeCreated AS timeCreated_3, j0_.timeStarted AS timeStarted_4, j0_.timeCompleted AS timeCompleted_5, j0_.efi_db_version AS efi_db_version_6, j0_.jobName AS jobName_7, j0_.isPublic AS isPublic_8, j0_.isExample AS isExample_9, j0_.schedulerJobId AS schedulerJobId_10, j0_.numBlastUnmatchedIds AS numBlastUnmatchedIds_11, j0_.numBlastRetrievedIds AS numBlastRetrievedIds_12, j0_.excludeFragments AS excludeFragments_13, j0_.numFragmentFiltered AS numFragmentFiltered_14, j0_.uploadedFilename AS uploadedFilename_15, j0_.jobFilename AS jobFilename_16, j0_.updatedAt AS updatedAt_17, j0_.taxSearch AS taxSearch_18, j0_.taxSearchName AS taxSearchName_19, j0_.numTaxonomyFiltered AS numTaxonomyFiltered_20, j0_.families AS families_21, j0_.fraction AS fraction_22, j0_.numFamilyIds AS numFamilyIds_23, j0_.numFullFamilyIds AS numFullFamilyIds_24, j0_.numFamilyOverlapIds AS numFamilyOverlapIds_25, j0_.numFamilyUnirefOverlapIds AS numFamilyUnirefOverlapIds_26, j0_.numFractionFiltered AS numFractionFiltered_27, j0_.blastEValue AS blastEValue_28, j0_.maxBlastSequences AS maxBlastSequences_29, j0_.sequence_version AS sequence_version_30, j0_.domain AS domain_31, j0_.domainRegion AS domainRegion_32, j0_.excludeFragments AS excludeFragments_33, j0_.numFragmentFiltered AS numFragmentFiltered_34, j0_.taxSearch AS taxSearch_35, j0_.taxSearchName AS taxSearchName_36, j0_.numTaxonomyFiltered AS numTaxonomyFiltered_37, j0_.families AS families_38, j0_.fraction AS fraction_39, j0_.numFamilyIds AS numFamilyIds_40, j0_.numFullFamilyIds AS numFullFamilyIds_41, j0_.numFamilyOverlapIds AS numFamilyOverlapIds_42, j0_.numFamilyUnirefOverlapIds AS numFamilyUnirefOverlapIds_43, j0_.numFractionFiltered AS numFractionFiltered_44, j0_.sequence_version AS sequence_version_45, j0_.numFastaHeaders AS numFastaHeaders_46, j0_.uploadedFilename AS uploadedFilename_47, j0_.jobFilename AS jobFilename_48, j0_.updatedAt AS updatedAt_49, j0_.taxSearch AS taxSearch_50, j0_.taxSearchName AS taxSearchName_51, j0_.numTaxonomyFiltered AS numTaxonomyFiltered_52, j0_.families AS families_53, j0_.fraction AS fraction_54, j0_.numFamilyIds AS numFamilyIds_55, j0_.numFullFamilyIds AS numFullFamilyIds_56, j0_.numFamilyOverlapIds AS numFamilyOverlapIds_57, j0_.numFamilyUnirefOverlapIds AS numFamilyUnirefOverlapIds_58, j0_.numFractionFiltered AS numFractionFiltered_59, j0_.sequence_version AS sequence_version_60, j0_.numMatchedIds AS numMatchedIds_61, j0_.numUnmatchedIds AS numUnmatchedIds_62, j0_.domainFamily AS domainFamily_63, j0_.numForeignIds AS numForeignIds_64, j0_.domain AS domain_65, j0_.domainRegion AS domainRegion_66, j0_.excludeFragments AS excludeFragments_67, j0_.numFragmentFiltered AS numFragmentFiltered_68, j0_.uploadedFilename AS uploadedFilename_69, j0_.jobFilename AS jobFilename_70, j0_.updatedAt AS updatedAt_71, j0_.filterByFamilies AS filterByFamilies_72, j0_.numFamilyFiltered AS numFamilyFiltered_73, j0_.taxSearch AS taxSearch_74, j0_.taxSearchName AS taxSearchName_75, j0_.numTaxonomyFiltered AS numTaxonomyFiltered_76, j0_.families AS families_77, j0_.fraction AS fraction_78, j0_.numFamilyIds AS numFamilyIds_79, j0_.numFullFamilyIds AS numFullFamilyIds_80, j0_.numFamilyOverlapIds AS numFamilyOverlapIds_81, j0_.numFamilyUnirefOverlapIds AS numFamilyUnirefOverlapIds_82, j0_.numFractionFiltered AS numFractionFiltered_83, j0_.sequence_version AS sequence_version_84, j0_.numMatchedIds AS numMatchedIds_85, j0_.numUnmatchedIds AS numUnmatchedIds_86, j0_.numSsnClusters AS numSsnClusters_87, j0_.numSsnSingletons AS numSsnSingletons_88, j0_.numSsnMetanodes AS numSsnMetanodes_89, j0_.numSsnAccessionIds AS numSsnAccessionIds_90, j0_.colorSsnSequenceSource AS colorSsnSequenceSource_91, j0_.uploadedFilename AS uploadedFilename_92, j0_.jobFilename AS jobFilename_93, j0_.updatedAt AS updatedAt_94, j0_.resultFileStats AS resultFileStats_95, j0_.sourceFileReference AS sourceFileReference_96, j0_.uploadedFilename AS uploadedFilename_97, j0_.jobFilename AS jobFilename_98, j0_.updatedAt AS updatedAt_99, j0_.resultFileStats AS resultFileStats_100, j0_.sourceFileReference AS sourceFileReference_101, j0_.maxNumSequences AS maxNumSequences_102, j0_.minNumSequences AS minNumSequences_103, j0_.makeWeblogo AS makeWeblogo_104, j0_.computeConsensusResidues AS computeConsensusResidues_105, j0_.consensusResidues AS consensusResidues_106, j0_.pidThresholds AS pidThresholds_107, j0_.makeHmms AS makeHmms_108, j0_.makeLengthHistograms AS makeLengthHistograms_109, j0_.numSsnClusters AS numSsnClusters_110, j0_.numSsnSingletons AS numSsnSingletons_111, j0_.numSsnMetanodes AS numSsnMetanodes_112, j0_.numSsnAccessionIds AS numSsnAccessionIds_113, j0_.colorSsnSequenceSource AS colorSsnSequenceSource_114, j0_.uploadedFilename AS uploadedFilename_115, j0_.jobFilename AS jobFilename_116, j0_.updatedAt AS updatedAt_117, j0_.resultFileStats AS resultFileStats_118, j0_.sourceFileReference AS sourceFileReference_119, j0_.uploadedFilename AS uploadedFilename_120, j0_.jobFilename AS jobFilename_121, j0_.updatedAt AS updatedAt_122, j0_.blastEValue AS blastEValue_123, j0_.maxBlastSequences AS maxBlastSequences_124, j0_.sourceFileReference AS sourceFileReference_125, j0_.computeNeighborhoodConnectivity AS computeNeighborhoodConnectivity_126, j0_.makeRepnodeNetworks AS makeRepnodeNetworks_127, j0_.thresholdValue AS thresholdValue_128, j0_.maxSsnEdges AS maxSsnEdges_129, j0_.thresholdMetric AS thresholdMetric_130, j0_.excludeFragments AS excludeFragments_131, j0_.numFragmentFiltered AS numFragmentFiltered_132, j0_.taxSearch AS taxSearch_133, j0_.taxSearchName AS taxSearchName_134, j0_.numTaxonomyFiltered AS numTaxonomyFiltered_135, j0_.resultFileStats AS resultFileStats_136, j0_.minLength AS minLength_137, j0_.maxLength AS maxLength_138, j0_.cooccurrence AS cooccurrence_139, j0_.numSsnClusters AS numSsnClusters_140, j0_.numSsnSingletons AS numSsnSingletons_141, j0_.numSsnMetanodes AS numSsnMetanodes_142, j0_.numSsnAccessionIds AS numSsnAccessionIds_143, j0_.colorSsnSequenceSource AS colorSsnSequenceSource_144, j0_.uploadedFilename AS uploadedFilename_145, j0_.jobFilename AS jobFilename_146, j0_.updatedAt AS updatedAt_147, j0_.resultFileStats AS resultFileStats_148, j0_.neighborhood_size AS neighborhood_size_149, j0_.sourceFileReference AS sourceFileReference_150, j0_.excludeFragments AS excludeFragments_151, j0_.numFragmentFiltered AS numFragmentFiltered_152, j0_.uploadedFilename AS uploadedFilename_153, j0_.jobFilename AS jobFilename_154, j0_.updatedAt AS updatedAt_155, j0_.neighborhood_size AS neighborhood_size_156, j0_.blastEValue AS blastEValue_157, j0_.maxBlastSequences AS maxBlastSequences_158, j0_.sequence_version AS sequence_version_159, j0_.uploadedFilename AS uploadedFilename_160, j0_.jobFilename AS jobFilename_161, j0_.updatedAt AS updatedAt_162, j0_.neighborhood_size AS neighborhood_size_163, j0_.excludeFragments AS excludeFragments_164, j0_.numFragmentFiltered AS numFragmentFiltered_165, j0_.uploadedFilename AS uploadedFilename_166, j0_.jobFilename AS jobFilename_167, j0_.updatedAt AS updatedAt_168, j0_.neighborhood_size AS neighborhood_size_169, j0_.blastEValue AS blastEValue_170, j0_.maxBlastSequences AS maxBlastSequences_171, j0_.sequence_version AS sequence_version_172, j0_.uploadedFilename AS uploadedFilename_173, j0_.jobFilename AS jobFilename_174, j0_.updatedAt AS updatedAt_175, j0_.referenceDatabase AS referenceDatabase_176, j0_.cdhitSequenceIdentity AS cdhitSequenceIdentity_177, j0_.searchType AS searchType_178, j0_.uploadedFilename AS uploadedFilename_179, j0_.jobFilename AS jobFilename_180, j0_.updatedAt AS updatedAt_181, j0_.minLength AS minLength_182, j0_.maxLength AS maxLength_183, j0_.sourceFileReference AS sourceFileReference_184, j0_.metagenomes AS metagenomes_185, j0_.searchType AS searchType_186, j0_.numForeignIds AS numForeignIds_187, j0_.excludeFragments AS excludeFragments_188, j0_.numFragmentFiltered AS numFragmentFiltered_189, j0_.uploadedFilename AS uploadedFilename_190, j0_.jobFilename AS jobFilename_191, j0_.updatedAt AS updatedAt_192, j0_.filterByFamilies AS filterByFamilies_193, j0_.numFamilyFiltered AS numFamilyFiltered_194, j0_.taxSearch AS taxSearch_195, j0_.taxSearchName AS taxSearchName_196, j0_.numTaxonomyFiltered AS numTaxonomyFiltered_197, j0_.numComputedIds AS numComputedIds_198, j0_.numImportedIds AS numImportedIds_199, j0_.outputConvergenceRatio AS outputConvergenceRatio_200, j0_.numBlastEdges AS numBlastEdges_201, j0_.sequence_version AS sequence_version_202, j0_.numMatchedIds AS numMatchedIds_203, j0_.numUnmatchedIds AS numUnmatchedIds_204, j0_.excludeFragments AS excludeFragments_205, j0_.numFragmentFiltered AS numFragmentFiltered_206, j0_.taxSearch AS taxSearch_207, j0_.taxSearchName AS taxSearchName_208, j0_.numTaxonomyFiltered AS numTaxonomyFiltered_209, j0_.families AS families_210, j0_.fraction AS fraction_211, j0_.numFamilyIds AS numFamilyIds_212, j0_.numFullFamilyIds AS numFullFamilyIds_213, j0_.numFamilyOverlapIds AS numFamilyOverlapIds_214, j0_.numFamilyUnirefOverlapIds AS numFamilyUnirefOverlapIds_215, j0_.numFractionFiltered AS numFractionFiltered_216, j0_.numComputedIds AS numComputedIds_217, j0_.numImportedIds AS numImportedIds_218, j0_.outputConvergenceRatio AS outputConvergenceRatio_219, j0_.numBlastEdges AS numBlastEdges_220, j0_.minLength AS minLength_221, j0_.maxLength AS maxLength_222, j0_.sequence_version AS sequence_version_223, j0_.excludeFragments AS excludeFragments_224, j0_.numFragmentFiltered AS numFragmentFiltered_225, j0_.numFastaHeaders AS numFastaHeaders_226, j0_.uploadedFilename AS uploadedFilename_227, j0_.jobFilename AS jobFilename_228, j0_.updatedAt AS updatedAt_229, j0_.filterByFamilies AS filterByFamilies_230, j0_.numFamilyFiltered AS numFamilyFiltered_231, j0_.taxSearch AS taxSearch_232, j0_.taxSearchName AS taxSearchName_233, j0_.numTaxonomyFiltered AS numTaxonomyFiltered_234, j0_.numComputedIds AS numComputedIds_235, j0_.numImportedIds AS numImportedIds_236, j0_.outputConvergenceRatio AS outputConvergenceRatio_237, j0_.numBlastEdges AS numBlastEdges_238, j0_.numMatchedIds AS numMatchedIds_239, j0_.numUnmatchedIds AS numUnmatchedIds_240, j0_.allByAllBlastEValue AS allByAllBlastEValue_241, j0_.numComputedIds AS numComputedIds_242, j0_.numImportedIds AS numImportedIds_243, j0_.outputConvergenceRatio AS outputConvergenceRatio_244, j0_.numBlastEdges AS numBlastEdges_245, (CASE j0_.status WHEN 'new' THEN 1 WHEN 'running' THEN 2 WHEN 'finished' THEN 3 WHEN 'failed' THEN 4 ELSE 5 END) AS sclr_246, (CASE WHEN j0_.status = 'finished' THEN j0_.timeCompleted ELSE j0_.timeCreated END) AS sclr_247, j0_.job_type AS job_type_248, j0_.user_id AS user_id_249, j0_.parentJob_id AS parentJob_id_250 FROM Job j0_ WHERE (j0_.user_id = ?) AND j0_.job_type IN ('est_generate_blast', 'est_generate_families', 'est_generate_fasta', 'est_generate_accession', 'est_color_ssn', 'est_neighborhood_connectivity', 'est_cluster_analysis', 'est_convergence_ratio', 'est_ssn_finalization', 'gnt_gnn', 'gnt_diagram_blast', 'gnt_diagram_fasta', 'gnt_diagram_sequence_id', 'gnt_view_diagram', 'cgfp_identify', 'cgfp_quantify', 'taxonomy_accession', 'taxonomy_families', 'taxonomy_fasta') ORDER BY sclr_246 ASC, sclr_247 DESC
Parameters: 
[
  22
]
View formatted query    View runnable query    Explain query
0.43 ms
(0.64%) 		1 
SELECT t0.id AS id_1, t0.fullName AS fullName_2, t0.email AS email_3, t0.password AS password_4, t0.timezone AS timezone_5, t0.isDeleted AS isDeleted_6, t0.mustChangePassword AS mustChangePassword_7, t0.devFeaturesEnabled AS devFeaturesEnabled_8, t0.isPublicGhost AS isPublicGhost_9, t0.isPublicVerified AS isPublicVerified_10, t0.primary_organization_id AS primary_organization_id_11, t0.global_role_id AS global_role_id_12 FROM users t0 WHERE t0.id = ?
Parameters: 
[
  22
]
View formatted query    View runnable query    Explain query
0.37 ms
(0.55%) 		1 
SELECT s0_.id AS id_0, s0_.message AS message_1, s0_.isActive AS isActive_2, s0_.type AS type_3, s0_.createdAt AS createdAt_4, s0_.activatedAt AS activatedAt_5 FROM SiteNotice s0_ WHERE s0_.isActive = ? ORDER BY s0_.activatedAt DESC LIMIT 1
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
0.30 ms
(0.46%) 		1 
SELECT t0.id AS id_1, t0.name AS name_2 FROM Role t0 WHERE t0.id = ?
Parameters: 
[
  6
]
View formatted query    View runnable query    Explain query

Database Connections

Name Service
default doctrine.dbal.default_connection
taxonomy_reference doctrine.dbal.taxonomy_reference_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Job 476
App\Auth\Entity\UserEntity 1
App\Auth\Entity\Role 1

Entities Mapping

Class Mapping errors
App\Auth\Entity\UserEntity No errors.
App\Auth\Entity\OrganizationEntity
  • The field App\Auth\Entity\OrganizationEntity#users is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Auth\Entity\UserEntity#primaryOrganization does not contain the required 'inversedBy: "users"' attribute.
App\Auth\Entity\Role No errors.
App\Entity\Job No errors.
App\Entity\ESTGenerateJob No errors.
App\Entity\ESTGenerateBlastJob No errors.
App\Entity\ESTGenerateFamiliesJob No errors.
App\Entity\ESTGenerateFastaJob No errors.
App\Entity\ESTGenerateAccessionJob No errors.
App\Entity\ESTColorSSNJob No errors.
App\Entity\ESTNeighborhoodConnectivityJob No errors.
App\Entity\ESTClusterAnalysisJob No errors.
App\Entity\ESTConvergenceRatioJob No errors.
App\Entity\ESTSSNFinalizationJob No errors.
App\Entity\GNTGNNJob No errors.
App\Entity\GNTDiagramBlastJob No errors.
App\Entity\GNTDiagramFastaJob No errors.
App\Entity\GNTDiagramSequenceIdJob No errors.
App\Entity\GNTViewDiagramJob No errors.
App\Entity\CGFPIdentifyJob No errors.
App\Entity\CGFPQuantifyJob No errors.
App\Entity\TaxonomyAccessionJob No errors.
App\Entity\TaxonomyFamiliesJob No errors.
App\Entity\TaxonomyFastaJob No errors.
App\Entity\SiteNotice No errors.