Symfony Profiler

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 = ?

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 = 22;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  Role t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM Role t0 WHERE t0.id = 6;

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

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 = 22) 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;

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'
  )