Times Reported Time consuming queries #1

x Hide

[ User: load - Total duration: 7m46s - Times executed: 3 ]

x Hide

SELECT r.ixn_id, edit.get_ixn_prose (r.ixn_id), r.reference_acc_txt, r.taxon_acc_txt, r.internal_note, r.field_cd, edit.get_ixn_xml (r.ixn_id), to_char(r.create_tm, 'mm-dd-yyyy'), r.evidence_cd, i.create_by FROM edit.REFERENCE_IXN r, edit.IXN i where r.ixn_id = i.id and i.ixn_type_id = ( select id from edit.IXN_TYPE where nm = 'PHENOTYPE');

Date: 2024-04-15 14:25:25
Duration: 2m38s
Database: ctddev51
User: load
Bind query: yes

SELECT r.ixn_id, edit.get_ixn_prose (r.ixn_id), r.reference_acc_txt, r.taxon_acc_txt, r.internal_note, r.field_cd, edit.get_ixn_xml (r.ixn_id), to_char(r.create_tm, 'mm-dd-yyyy'), r.evidence_cd, i.create_by FROM edit.REFERENCE_IXN r, edit.IXN i where r.ixn_id = i.id and i.ixn_type_id = ( select id from edit.IXN_TYPE where nm = 'PHENOTYPE');

Date: 2024-04-15 15:30:50
Duration: 2m35s
Database: ctddev51
User: load
Bind query: yes

SELECT r.ixn_id, edit.get_ixn_prose (r.ixn_id), r.reference_acc_txt, r.taxon_acc_txt, r.internal_note, r.field_cd, edit.get_ixn_xml (r.ixn_id), to_char(r.create_tm, 'mm-dd-yyyy'), r.evidence_cd, i.create_by FROM edit.REFERENCE_IXN r, edit.IXN i where r.ixn_id = i.id and i.ixn_type_id = ( select id from edit.IXN_TYPE where nm = 'PHENOTYPE');

Date: 2024-04-15 14:35:11
Duration: 2m32s
Database: ctddev51
User: load
Bind query: yes

x Hide

Times Reported Time consuming queries #2

x Hide

[ User: load - Total duration: 7m19s - Times executed: 3 ]

x Hide

select distinct primaryGeneTerm.acc_txt, taxonTerm.acc_txt, gt.gene_acc_txt from pub1.GENE_TAXON gt, pub1.TERM primaryGeneTerm, pub1.TERM taxonTerm where gt.gene_id = primaryGeneTerm.id and gt.taxon_id = taxonTerm.id;

Date: 2024-04-15 14:28:42
Duration: 2m29s
Database: ctddev51
User: load
Bind query: yes

select distinct primaryGeneTerm.acc_txt, taxonTerm.acc_txt, gt.gene_acc_txt from pub1.GENE_TAXON gt, pub1.TERM primaryGeneTerm, pub1.TERM taxonTerm where gt.gene_id = primaryGeneTerm.id and gt.taxon_id = taxonTerm.id;

Date: 2024-04-15 15:34:07
Duration: 2m26s
Database: ctddev51
User: load
Bind query: yes

select distinct primaryGeneTerm.acc_txt, taxonTerm.acc_txt, gt.gene_acc_txt from pub1.GENE_TAXON gt, pub1.TERM primaryGeneTerm, pub1.TERM taxonTerm where gt.gene_id = primaryGeneTerm.id and gt.taxon_id = taxonTerm.id;

Date: 2024-04-15 14:38:17
Duration: 2m23s
Database: ctddev51
User: load
Bind query: yes

x Hide

Times Reported Time consuming queries #3

x Hide

select ID, OBJECT_TYPE_ID, ACC_TXT, t.ACC_DB_CD, NM, NM_SORT, SECONDARY_NM, DESCRIPTION, NOTE from pub1.term t where object_type_id = 1;

Date: 2024-04-15 14:39:13
Duration: 49s371ms
Bind query: yes

select ID, OBJECT_TYPE_ID, ACC_TXT, t.ACC_DB_CD, NM, NM_SORT, SECONDARY_NM, DESCRIPTION, NOTE from pub1.term t where object_type_id = 1;

Date: 2024-04-15 15:35:02
Duration: 48s806ms
Bind query: yes

select ID, OBJECT_TYPE_ID, ACC_TXT, t.ACC_DB_CD, NM, NM_SORT, SECONDARY_NM, DESCRIPTION, NOTE from pub1.term t where object_type_id = 1;

Date: 2024-04-15 14:29:35
Duration: 47s181ms
Bind query: yes

x Hide

Times Reported Time consuming queries #4

x Hide

select i.root_id, iq.nm from edit.REFERENCE_IXN_QUALIFIER riq, edit.IXN_QUALIFIER iq, edit.REFERENCE_IXN ri, edit.IXN i where riq.ixn_qualifier_id = iq.id and ri.id = riq.reference_ixn_id and ri.ixn_id = i.id;

Date: 2024-04-15 15:31:30
Duration: 28s436ms
Bind query: yes

select i.root_id, iq.nm from edit.REFERENCE_IXN_QUALIFIER riq, edit.IXN_QUALIFIER iq, edit.REFERENCE_IXN ri, edit.IXN i where riq.ixn_qualifier_id = iq.id and ri.id = riq.reference_ixn_id and ri.ixn_id = i.id;

Date: 2024-04-15 14:26:01
Duration: 26s586ms
Bind query: yes

select i.root_id, iq.nm from edit.REFERENCE_IXN_QUALIFIER riq, edit.IXN_QUALIFIER iq, edit.REFERENCE_IXN ri, edit.IXN i where riq.ixn_qualifier_id = iq.id and ri.id = riq.reference_ixn_id and ri.ixn_id = i.id;

Date: 2024-04-15 14:35:42
Duration: 21s806ms
Bind query: yes

x Hide

Times Reported Time consuming queries #5

x Hide

SELECT /* AdvancedIxnQueryDAO.getData */ g.nm geneSymbol, g.id geneId, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, c.nm chemNm, c.nm_html chemNmhtml, c.acc_txt chemAcc, c.secondary_nm casRN, c.id chemId, i.id ixnId, i.ixn_prose_txt ixnProse, i.ixn_prose_html ixnProseHtml, i.actions_txt ixnActions, COUNT(DISTINCT gcr.reference_id) refCount, COUNT(DISTINCT gcr.taxon_id) taxonCount, COUNT(*) OVER () fullRowCount FROM gene_chem_reference gcr INNER JOIN ixn i ON gcr.ixn_id = i.id INNER JOIN term g ON gcr.gene_id = g.id INNER JOIN term c ON gcr.chem_id = c.id WHERE /* CIQH.getIxnWhereCore */ gcr.gene_id = ANY (ARRAY (( SELECT /* IQH.getMasterPathwayWhereEquals.Name */ tp.term_id FROM term_pathway tp WHERE UPPER(tp.pathway_nm) LIKE 'METABOLISM' AND tp.object_type_id = 4))) AND gcr.id IN ( SELECT gcra.gene_chem_reference_id FROM gene_chem_reference_axn gcra WHERE (gcra.action_degree_type_nm = 'increases')) GROUP BY g.nm, g.nm_sort, g.acc_txt, g.acc_db_cd, g.id, c.nm, c.nm_html, c.nm_sort, c.acc_txt, c.secondary_nm, c.id, i.ixn_prose_txt, i.ixn_prose_html, i.sort_txt, i.actions_txt, i.id ORDER BY g.nm_sort, c.nm_sort, i.sort_txt LIMIT 50;

Date: 2024-04-15 05:49:05
Duration: 38s748ms
Bind query: yes

x Hide

Times Reported Time consuming queries #6

x Hide

SELECT /* AdvancedGeneQueryDAO.getData */ g.id geneId, g.acc_txt acc, g.nm nm, g.nm nmHtml, g.secondary_nm secondaryNm, g.has_chems hasChems, g.has_diseases hasDiseases, g.has_exposures hasExposures, g.has_phenotypes hasPhenotypes, COUNT(*) OVER () fullRowCount FROM term g WHERE g.id IN (( SELECT /* IQH.getMasterGoWhereEquals.Gene */ ai.gene_id FROM dag_path pi INNER JOIN gene_go_annot ai ON pi.descendant_object_id = ai.go_term_id INNER JOIN term_label li ON li.term_id = pi.ancestor_object_id WHERE UPPER(li.nm) LIKE 'APOPTOSIS' AND li.object_type_id = 5)) ORDER BY g.nm_sort, g.id LIMIT 50;

Date: 2024-04-15 05:47:59
Duration: 29s894ms
Bind query: yes

x Hide

Times Reported Time consuming queries #7

x Hide

select t.nm, t.acc_txt, ri.ixn_id from edit.REFERENCE_IXN_ANATOMY a, pub1.TERM t, edit.REFERENCE_IXN ri, edit.IXN i where a.anatomy_acc_txt = t.acc_txt and t.object_type_id = 10 and t.acc_db_cd = 'MESH' and ri.id = a.reference_ixn_id and ri.ixn_id = i.id and i.ixn_type_id = ( select id from edit.IXN_TYPE where nm = 'PHENOTYPE') order by level_seq asc;

Date: 2024-04-15 15:31:00
Duration: 8s616ms
Bind query: yes

select t.nm, t.acc_txt, ri.ixn_id from edit.REFERENCE_IXN_ANATOMY a, pub1.TERM t, edit.REFERENCE_IXN ri, edit.IXN i where a.anatomy_acc_txt = t.acc_txt and t.object_type_id = 10 and t.acc_db_cd = 'MESH' and ri.id = a.reference_ixn_id and ri.ixn_id = i.id and i.ixn_type_id = ( select id from edit.IXN_TYPE where nm = 'PHENOTYPE') order by level_seq asc;

Date: 2024-04-15 14:25:34
Duration: 7s360ms
Bind query: yes

select t.nm, t.acc_txt, ri.ixn_id from edit.REFERENCE_IXN_ANATOMY a, pub1.TERM t, edit.REFERENCE_IXN ri, edit.IXN i where a.anatomy_acc_txt = t.acc_txt and t.object_type_id = 10 and t.acc_db_cd = 'MESH' and ri.id = a.reference_ixn_id and ri.ixn_id = i.id and i.ixn_type_id = ( select id from edit.IXN_TYPE where nm = 'PHENOTYPE') order by level_seq asc;

Date: 2024-04-15 14:35:19
Duration: 6s929ms
Bind query: yes

x Hide

Times Reported Time consuming queries #8

x Hide

select distinct /* ChemPhenotypesAssnsDAO */ associatedTerm.nm || '^' || o.cd || '^' || associatedTerm.nm_html || '^' || associatedTerm.acc_txt || '^' || associatedTerm.acc_db_cd as associatedTerm, associatedTerm.id associatedTermId, ptr.ixn_id ixnId, associatedTerm.object_type_id || '|' || associatedTerm.nm_sort associatedTermNmSort, COALESCE(associatedTerm.secondary_nm, '') casRN, phenotypeTerm.nm || '^' || 'go' || '^' || phenotypeTerm.nm_html || '^' || phenotypeTerm.acc_txt || '^' || phenotypeTerm.acc_db_cd as phenotype, phenotypeTerm.id phenotypeId, ( SELECT STRING_AGG(distinct taxonTerm.nm || '^' || 'taxon' || '^' || taxonTerm.nm_html || '^' || taxonTerm.acc_txt || '^' || taxonTerm.acc_db_cd || '^' || COALESCE(taxonTerm.secondary_nm, ''), '|')) as taxonTerms, ( SELECT STRING_AGG(distinct anatomyTerm.nm_html || '^' || anatomyTerm.acc_txt || '^' || ia.level_seq || '^' || anatomyTerm.acc_db_cd || '^' || anatomyTerm.nm, '|')) as anatomyTerms, COUNT(DISTINCT taxonTerm.nm) taxonCount, i.ixn_prose_html ixnProseHtml, i.ixn_prose_txt ixnProse, i.sort_txt ixnSort, ( SELECT STRING_AGG(distinct r.acc_txt, '|')) as references, COUNT(DISTINCT ptr.reference_id) refCount, pt.indirect_term_qty inferredCount, COUNT(*) OVER () fullRowCount from phenotype_term_reference ptr inner join phenotype_term pt on ptr.term_id = pt.term_id and ptr.phenotype_id = pt.phenotype_id inner join term associatedTerm on ptr.term_id = associatedTerm.id inner join term phenotypeTerm on ptr.phenotype_id = phenotypeTerm.id left outer join term taxonTerm on ptr.taxon_id = taxonTerm.id inner join reference r on ptr.reference_id = r.id inner join ixn i on ptr.ixn_id = i.id inner join object_type o on associatedTerm.object_type_id = o.id left outer join ixn_anatomy ia on ptr.ixn_id = ia.ixn_id left outer join term anatomyTerm on ia.anatomy_id = anatomyTerm.id where ptr.term_id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 2 and upper(baseTerm.nm) LIKE 'ZINC')) and ptr.term_object_type_id = 2 and ptr.phenotype_id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 5 and baseTerm.id in ( select object_id from db_link l where l.acc_txt = 'GO:0006915' AND l.type_cd = 'A' AND l.object_type_id = 5))) and taxonTerm.id in ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 1 and baseTerm.id in ( select object_id from db_link l where l.acc_txt = '9606' AND l.type_cd = 'A' AND l.object_type_id = 1))) and i.id in ( select ixn_id from ixn_axn where action_type_nm = 'phenotype' and action_degree_type_nm in ('increases')) group by associatedTerm, associatedTermNmSort, phenotype, casRN, ixnId, ixnProseHtml, ixnProse, ixnSort, associatedTermId, phenotypeId, inferredCount ORDER BY associatedTermNmSort LIMIT 50;

Date: 2024-04-15 05:51:47
Duration: 15s105ms
Bind query: yes

x Hide

Times Reported Time consuming queries #9

x Hide

[ User: pubeu - Total duration: 11s753ms - Times executed: 1 ]

x Hide

SELECT /* AdvancedGeneQueryDAO.getData */ g.id geneId, g.acc_txt acc, g.nm nm, g.nm nmHtml, g.secondary_nm secondaryNm, g.has_chems hasChems, g.has_diseases hasDiseases, g.has_exposures hasExposures, g.has_phenotypes hasPhenotypes, COUNT(*) OVER () fullRowCount FROM term g WHERE g.id IN (( SELECT /* IQH.getMasterDiseaseWhereEquals.Name.Gene */ gd.gene_id FROM term t INNER JOIN dag_path dp ON t.id = dp.ancestor_object_id INNER JOIN gene_disease gd ON dp.descendant_object_id = gd.disease_id WHERE UPPER(t.nm) LIKE 'ASTHMA' AND t.object_type_id = 3)) ORDER BY g.nm_sort, g.id LIMIT 50;

Date: 2024-04-15 05:48:11
Duration: 11s753ms
Database: ctddev51
User: pubeu
Bind query: yes

x Hide

Times Reported Time consuming queries #10

x Hide

select distinct phenotypeTerm.nm AS goNm, phenotypeTerm.nm_html AS goNmHtml, phenotypeTerm.acc_txt AS goAcc, diseaseTerm.nm AS diseaseNm, diseaseTerm.nm_html AS diseaseNmHtml, diseaseTerm.acc_txt AS diseaseAcc, diseaseTerm.acc_db_cd AS diseaseAccDbCd, chemTerm.nm AS chemNm, chemTerm.nm_html AS chemNmHtml, chemTerm.acc_txt AS chemAcc, geneTerm.nm AS geneSymbol, geneTerm.nm_html AS geneSymbolHtml, geneTerm.acc_txt AS geneAcc, COUNT(*) OVER () fullRowCount from PHENOTYPE_TERM_REFERENCE viaChemPTR, PHENOTYPE_TERM_REFERENCE viaGenePTR, TERM phenotypeTerm, TERM diseaseTerm, TERM geneTerm, TERM chemTerm where viaChemPTR.via_term_id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 2 and upper(baseTerm.nm) LIKE 'ZINC')) and chemTerm.id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 2 and upper(baseTerm.nm) LIKE 'ZINC')) and viaGenePTR.via_term_id IN ( select baseTerm.id from term baseTerm WHERE baseTerm.object_type_id = 4 and upper(baseTerm.nm) LIKE 'BCL2') and geneTerm.id IN ( select baseTerm.id from term baseTerm WHERE baseTerm.object_type_id = 4 and upper(baseTerm.nm) LIKE 'BCL2') and phenotypeTerm.id = ANY (ARRAY ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 5 and baseTerm.id in ( select object_id from db_link l where l.acc_txt = 'GO:0006915' AND l.type_cd = 'A' AND l.object_type_id = 5)))) and diseaseTerm.id = ANY (ARRAY ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 3 and upper(baseTerm.nm) LIKE 'NECROSIS'))) and viaChemPTR.phenotype_id = phenotypeTerm.id and viaChemPTR.term_object_type_id = 3 and viaChemPTR.term_id = diseaseTerm.id and viaChemPTR.via_term_object_type_id = 2 and viaChemPTR.via_term_id = chemTerm.id and viaChemPTR.term_id = viaGenePTR.term_id and viaChemPTR.phenotype_id = viaGenePTR.phenotype_id and viaGenePTR.via_term_object_type_id = 4 and viaGenePTR.via_term_id = geneTerm.id and exists ( select 1 from gene_chem_reference where gene_id = geneTerm.id and chem_id = chemTerm.id) GROUP BY phenotypeTerm.nm, phenotypeTerm.nm_html, phenotypeTerm.acc_txt, diseaseTerm.nm, diseaseTerm.nm_html, diseaseTerm.acc_txt, diseaseTerm.acc_db_cd, chemTerm.nm, chemTerm.nm_html, chemTerm.acc_txt, geneTerm.nm, geneTerm.nm_html, geneTerm.acc_txt order by chemTerm.nm LIMIT 50;

Date: 2024-04-15 05:52:04
Duration: 8s591ms
Bind query: yes

x Hide

Times Reported Time consuming queries #11

x Hide

SELECT /* ReferenceCitedChemsDAO */ c.id, c.nm, c.nm_html nmHtml, c.acc_txt acc, c.has_genes hasGenes, c.has_diseases hasDiseases, c.has_exposures hasExposures, c.has_phenotypes hasPhenotypes FROM term c WHERE c.id IN ( SELECT cdr.chem_id FROM chem_disease_reference cdr WHERE cdr.reference_id = '191528' AND cdr.source_cd = 'C' UNION ALL SELECT gcr.chem_id FROM gene_chem_reference gcr WHERE gcr.reference_id = '191528' UNION ALL select stressor.chem_id from exposure e, exp_stressor stressor where e.reference_id = '191528' and e.exp_stressor_id = stressor.id UNION ALL select event.exp_marker_term_id from exposure e, exp_event event where e.reference_id = '191528' and e.exp_event_id = event.id and event.exp_marker_type_id in ( select id from exp_marker_type where nm like 'chem%') UNION ALL SELECT term_id FROM phenotype_term_reference ptr WHERE ptr.reference_id = '191528' and ptr.term_object_type_id = 2) ORDER BY c.nm_sort;

Date: 2024-04-15 05:49:57
Duration: 8s510ms
Bind query: yes

x Hide

Times Reported Time consuming queries #12

x Hide

[ User: qaeu - Total duration: 3s377ms - Times executed: 1 ]

[ User: pubeu - Total duration: 3s315ms - Times executed: 1 ]

x Hide

WITH recursive sub_node ( object_id, id, path, lvl ) AS ( SELECT n.object_id, n.id, ARRAY[n.nm_sort], 1 FROM dag_node n WHERE n.object_id = '588473' UNION ALL SELECT n.object_id, n.id, CAST(path || n.nm_sort AS varchar(600)[]), sn.lvl + 1 FROM dag_node n INNER JOIN sub_node sn ON (n.parent_id = sn.id)) SELECT /* TreeTermBasicsDAO.getDescendants */ DISTINCT t.nm priNm, t.nm_html priNmHtml, t.secondary_nm secondaryNm, t.acc_db_cd accDbCd, t.acc_txt termAcc, t.is_leaf isLeaf, t.has_chems hasChems, t.has_diseases hasDiseases, t.has_exposures hasExposures, t.has_genes hasGenes, sn.lvl, sn.path, MAX(sn.lvl) OVER () maxLvl, t.has_phenotypes hasPhenotypes FROM sub_node sn INNER JOIN term t ON sn.object_id = t.id WHERE sn.lvl <= 2 ORDER BY sn.path;

Date: 2024-04-15 10:48:07
Duration: 3s377ms
Database: ctddev51
User: qaeu
Bind query: yes

WITH recursive sub_node ( object_id, id, path, lvl ) AS ( SELECT n.object_id, n.id, ARRAY[n.nm_sort], 1 FROM dag_node n WHERE n.object_id = '588473' UNION ALL SELECT n.object_id, n.id, CAST(path || n.nm_sort AS varchar(600)[]), sn.lvl + 1 FROM dag_node n INNER JOIN sub_node sn ON (n.parent_id = sn.id)) SELECT /* TreeTermBasicsDAO.getDescendants */ DISTINCT t.nm priNm, t.nm_html priNmHtml, t.secondary_nm secondaryNm, t.acc_db_cd accDbCd, t.acc_txt termAcc, t.is_leaf isLeaf, t.has_chems hasChems, t.has_diseases hasDiseases, t.has_exposures hasExposures, t.has_genes hasGenes, sn.lvl, sn.path, MAX(sn.lvl) OVER () maxLvl, t.has_phenotypes hasPhenotypes FROM sub_node sn INNER JOIN term t ON sn.object_id = t.id WHERE sn.lvl <= 2 ORDER BY sn.path;

Date: 2024-04-15 05:45:12
Duration: 3s315ms
Database: ctddev51
User: pubeu
Bind query: yes

WITH recursive sub_node ( object_id, id, path, lvl ) AS ( SELECT n.object_id, n.id, ARRAY[n.nm_sort], 1 FROM dag_node n WHERE n.object_id = '1424916' UNION ALL SELECT n.object_id, n.id, CAST(path || n.nm_sort AS varchar(600)[]), sn.lvl + 1 FROM dag_node n INNER JOIN sub_node sn ON (n.parent_id = sn.id)) SELECT /* TreeTermBasicsDAO.getDescendants */ DISTINCT t.nm priNm, t.nm_html priNmHtml, t.secondary_nm secondaryNm, t.acc_db_cd accDbCd, t.acc_txt termAcc, t.is_leaf isLeaf, t.has_chems hasChems, t.has_diseases hasDiseases, t.has_exposures hasExposures, t.has_genes hasGenes, sn.lvl, sn.path, MAX(sn.lvl) OVER () maxLvl, t.has_phenotypes hasPhenotypes FROM sub_node sn INNER JOIN term t ON sn.object_id = t.id WHERE sn.lvl <= 2 ORDER BY sn.path;

Date: 2024-04-15 10:48:09
Duration: 1s53ms
Bind query: yes

x Hide

Times Reported Time consuming queries #13

x Hide

SELECT /* AdvancedGeneQueryDAO.getData */ g.id geneId, g.acc_txt acc, g.nm nm, g.nm nmHtml, g.secondary_nm secondaryNm, g.has_chems hasChems, g.has_diseases hasDiseases, g.has_exposures hasExposures, g.has_phenotypes hasPhenotypes, COUNT(*) OVER () fullRowCount FROM term g WHERE g.id IN (( SELECT /* IQH.getMasterDiseaseWhereEquals.Label.Gene */ gd.gene_id FROM term_label l INNER JOIN dag_path dp ON l.term_id = dp.ancestor_object_id INNER JOIN gene_disease gd ON dp.descendant_object_id = gd.disease_id WHERE UPPER(l.nm) LIKE 'GLAUCOMA' AND l.object_type_id = 3)) ORDER BY g.nm_sort, g.id LIMIT 50;

Date: 2024-04-15 05:47:29
Duration: 5s524ms
Bind query: yes