Redirect 302 redirect from POST @est_home (0c20fc)

GET https://efi-dev.igb.illinois.edu/efi-est

Response
200 OK
Browse referrer URL
IP
128.174.126.34
Profiled on
Token
bbfe61

Query Metrics

3 Database Queries
3 Different statements
2.45 ms Query time
1 Invalid entities
4 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.28 ms 
SELECT t0.id AS id_1, t0.fullName AS fullName_2, t0.email AS email_3, t0.password AS password_4, t0.isDeleted AS isDeleted_5, t0.primary_organization_id AS primary_organization_id_6, t0.global_role_id AS global_role_id_7 FROM users t0 WHERE t0.id = ?
Parameters: 
[
  17
]
View formatted query    View runnable query    Explain query
2 0.40 ms 
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
3 1.77 ms 
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_.sequence_version AS sequence_version_22, j0_.fraction AS fraction_23, j0_.numFamilyIds AS numFamilyIds_24, j0_.numFullFamilyIds AS numFullFamilyIds_25, j0_.numFamilyOverlapIds AS numFamilyOverlapIds_26, j0_.numFamilyUnirefOverlapIds AS numFamilyUnirefOverlapIds_27, j0_.numFractionFiltered AS numFractionFiltered_28, j0_.blastEValue AS blastEValue_29, j0_.maxBlastSequences AS maxBlastSequences_30, j0_.sequenceDatabase AS sequenceDatabase_31, j0_.domain AS domain_32, j0_.domainRegion AS domainRegion_33, j0_.excludeFragments AS excludeFragments_34, j0_.numFragmentFiltered AS numFragmentFiltered_35, j0_.taxSearch AS taxSearch_36, j0_.taxSearchName AS taxSearchName_37, j0_.numTaxonomyFiltered AS numTaxonomyFiltered_38, j0_.families AS families_39, j0_.sequence_version AS sequence_version_40, j0_.fraction AS fraction_41, j0_.numFamilyIds AS numFamilyIds_42, j0_.numFullFamilyIds AS numFullFamilyIds_43, j0_.numFamilyOverlapIds AS numFamilyOverlapIds_44, j0_.numFamilyUnirefOverlapIds AS numFamilyUnirefOverlapIds_45, j0_.numFractionFiltered AS numFractionFiltered_46, j0_.numFastaHeaders AS numFastaHeaders_47, j0_.uploadedFilename AS uploadedFilename_48, j0_.jobFilename AS jobFilename_49, j0_.updatedAt AS updatedAt_50, j0_.taxSearch AS taxSearch_51, j0_.taxSearchName AS taxSearchName_52, j0_.numTaxonomyFiltered AS numTaxonomyFiltered_53, j0_.families AS families_54, j0_.sequence_version AS sequence_version_55, j0_.fraction AS fraction_56, j0_.numFamilyIds AS numFamilyIds_57, j0_.numFullFamilyIds AS numFullFamilyIds_58, j0_.numFamilyOverlapIds AS numFamilyOverlapIds_59, j0_.numFamilyUnirefOverlapIds AS numFamilyUnirefOverlapIds_60, j0_.numFractionFiltered AS numFractionFiltered_61, j0_.numMatchedIds AS numMatchedIds_62, j0_.numUnmatchedIds AS numUnmatchedIds_63, j0_.domainFamily AS domainFamily_64, j0_.numForeignIds AS numForeignIds_65, j0_.domain AS domain_66, j0_.domainRegion AS domainRegion_67, j0_.excludeFragments AS excludeFragments_68, j0_.numFragmentFiltered AS numFragmentFiltered_69, j0_.uploadedFilename AS uploadedFilename_70, j0_.jobFilename AS jobFilename_71, j0_.updatedAt AS updatedAt_72, j0_.filterByFamilies AS filterByFamilies_73, j0_.numFamilyFiltered AS numFamilyFiltered_74, j0_.taxSearch AS taxSearch_75, j0_.taxSearchName AS taxSearchName_76, j0_.numTaxonomyFiltered AS numTaxonomyFiltered_77, j0_.families AS families_78, j0_.sequence_version AS sequence_version_79, j0_.fraction AS fraction_80, j0_.numFamilyIds AS numFamilyIds_81, j0_.numFullFamilyIds AS numFullFamilyIds_82, j0_.numFamilyOverlapIds AS numFamilyOverlapIds_83, j0_.numFamilyUnirefOverlapIds AS numFamilyUnirefOverlapIds_84, j0_.numFractionFiltered AS numFractionFiltered_85, j0_.numMatchedIds AS numMatchedIds_86, j0_.numUnmatchedIds AS numUnmatchedIds_87, j0_.numSsnClusters AS numSsnClusters_88, j0_.numSsnSingletons AS numSsnSingletons_89, j0_.numSsnMetanodes AS numSsnMetanodes_90, j0_.numSsnAccessionIds AS numSsnAccessionIds_91, j0_.colorSsnSequenceSource AS colorSsnSequenceSource_92, j0_.uploadedFilename AS uploadedFilename_93, j0_.jobFilename AS jobFilename_94, j0_.updatedAt AS updatedAt_95, j0_.resultFileStats AS resultFileStats_96, j0_.uploadedFilename AS uploadedFilename_97, j0_.jobFilename AS jobFilename_98, j0_.updatedAt AS updatedAt_99, j0_.maxNumSequences AS maxNumSequences_100, j0_.minNumSequences AS minNumSequences_101, j0_.makeWeblogo AS makeWeblogo_102, j0_.computeConsensusResidues AS computeConsensusResidues_103, j0_.consensusResidues AS consensusResidues_104, j0_.pidThresholds AS pidThresholds_105, j0_.makeHmms AS makeHmms_106, j0_.makeLengthHistograms AS makeLengthHistograms_107, j0_.numSsnClusters AS numSsnClusters_108, j0_.numSsnSingletons AS numSsnSingletons_109, j0_.numSsnMetanodes AS numSsnMetanodes_110, j0_.numSsnAccessionIds AS numSsnAccessionIds_111, j0_.colorSsnSequenceSource AS colorSsnSequenceSource_112, j0_.uploadedFilename AS uploadedFilename_113, j0_.jobFilename AS jobFilename_114, j0_.updatedAt AS updatedAt_115, j0_.resultFileStats AS resultFileStats_116, j0_.alignmentScore AS alignmentScore_117, j0_.uploadedFilename AS uploadedFilename_118, j0_.jobFilename AS jobFilename_119, j0_.updatedAt AS updatedAt_120, j0_.computeNeighborhoodConnectivity AS computeNeighborhoodConnectivity_121, j0_.alignmentScore AS alignmentScore_122, j0_.excludeFragments AS excludeFragments_123, j0_.numFragmentFiltered AS numFragmentFiltered_124, j0_.taxSearch AS taxSearch_125, j0_.taxSearchName AS taxSearchName_126, j0_.numTaxonomyFiltered AS numTaxonomyFiltered_127, j0_.resultFileStats AS resultFileStats_128, j0_.minLength AS minLength_129, j0_.maxLength AS maxLength_130, j0_.cooccurrence AS cooccurrence_131, j0_.uploadedFilename AS uploadedFilename_132, j0_.jobFilename AS jobFilename_133, j0_.updatedAt AS updatedAt_134, j0_.resultFileStats AS resultFileStats_135, j0_.neighborhood_size AS neighborhood_size_136, j0_.excludeFragments AS excludeFragments_137, j0_.numFragmentFiltered AS numFragmentFiltered_138, j0_.blastEValue AS blastEValue_139, j0_.maxBlastSequences AS maxBlastSequences_140, j0_.sequenceDatabase AS sequenceDatabase_141, j0_.excludeFragments AS excludeFragments_142, j0_.numFragmentFiltered AS numFragmentFiltered_143, j0_.blastEValue AS blastEValue_144, j0_.maxBlastSequences AS maxBlastSequences_145, j0_.sequenceDatabase AS sequenceDatabase_146, j0_.uploadedFilename AS uploadedFilename_147, j0_.jobFilename AS jobFilename_148, j0_.updatedAt AS updatedAt_149, j0_.referenceDatabase AS referenceDatabase_150, j0_.cdhitSequenceIdentity AS cdhitSequenceIdentity_151, j0_.searchType AS searchType_152, j0_.uploadedFilename AS uploadedFilename_153, j0_.jobFilename AS jobFilename_154, j0_.updatedAt AS updatedAt_155, j0_.minLength AS minLength_156, j0_.maxLength AS maxLength_157, j0_.metagenomes AS metagenomes_158, j0_.searchType AS searchType_159, j0_.sequence_version AS sequence_version_160, j0_.excludeFragments AS excludeFragments_161, j0_.numFragmentFiltered AS numFragmentFiltered_162, j0_.uploadedFilename AS uploadedFilename_163, j0_.jobFilename AS jobFilename_164, j0_.updatedAt AS updatedAt_165, j0_.filterByFamilies AS filterByFamilies_166, j0_.numFamilyFiltered AS numFamilyFiltered_167, j0_.taxSearch AS taxSearch_168, j0_.taxSearchName AS taxSearchName_169, j0_.numTaxonomyFiltered AS numTaxonomyFiltered_170, j0_.excludeFragments AS excludeFragments_171, j0_.numFragmentFiltered AS numFragmentFiltered_172, j0_.taxSearch AS taxSearch_173, j0_.taxSearchName AS taxSearchName_174, j0_.numTaxonomyFiltered AS numTaxonomyFiltered_175, j0_.families AS families_176, j0_.sequence_version AS sequence_version_177, j0_.fraction AS fraction_178, j0_.numFamilyIds AS numFamilyIds_179, j0_.numFullFamilyIds AS numFullFamilyIds_180, j0_.numFamilyOverlapIds AS numFamilyOverlapIds_181, j0_.numFamilyUnirefOverlapIds AS numFamilyUnirefOverlapIds_182, j0_.numFractionFiltered AS numFractionFiltered_183, j0_.minLength AS minLength_184, j0_.maxLength AS maxLength_185, j0_.excludeFragments AS excludeFragments_186, j0_.numFragmentFiltered AS numFragmentFiltered_187, j0_.uploadedFilename AS uploadedFilename_188, j0_.jobFilename AS jobFilename_189, j0_.updatedAt AS updatedAt_190, j0_.allByAllBlastEValue AS allByAllBlastEValue_191, j0_.numComputedIds AS numComputedIds_192, j0_.numImportedIds AS numImportedIds_193, j0_.outputConvergenceRatio AS outputConvergenceRatio_194, j0_.numBlastEdges AS numBlastEdges_195, (CASE j0_.status WHEN 'new' THEN 1 WHEN 'running' THEN 2 WHEN 'finished' THEN 3 WHEN 'failed' THEN 4 ELSE 5 END) AS sclr_196, (CASE WHEN j0_.status = 'finished' THEN j0_.timeCompleted ELSE j0_.timeCreated END) AS sclr_197, j0_.job_type AS job_type_198, j0_.user_id AS user_id_199, j0_.parentJob_id AS parentJob_id_200 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_196 ASC, sclr_197 DESC
Parameters: 
[
  17
]
View formatted query    View runnable query    Explain query

Database Connections

Name Service
default doctrine.dbal.default_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 2
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.