Created
October 7, 2010 00:59
-
-
Save palexander/614375 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [palexand@ncboprod-ridb2 mysql_data]$ sudo mysqldumpslow -s c -t 50 /var/lib/mysql/mysql_data/slowlog | |
| Reading mysql slow query log from /var/lib/mysql/mysql_data/slowlog | |
| Count: 89 Time=489.59s (43573s) Lock=0.00s (0s) Rows=0.9 (79), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT COUNT(*) FROM obr_aers_aggregation IT, obr_aers_element ET, obs_concept AS T1 WHERE IT.element_id=ET.id AND IT.concept_id=T1.id AND T1.local_concept_id='S' | |
| Count: 79 Time=157.57s (12448s) Lock=0.00s (0s) Rows=7.5 (592), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT ET.local_element_id, T1.local_concept_id, IT.score FROM obr_ct_aggregation IT, obr_ct_element ET, obs_concept AS T1 WHERE IT.element_id=ET.id AND IT.concept_id=T1.id AND T1.local_concept_id='S' ORDER BY IT.score DESC LIMIT N,N | |
| Count: 66 Time=234.29s (15463s) Lock=0.00s (0s) Rows=8.0 (530), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT ET.local_element_id, T1.local_concept_id, IT.score FROM obr_aers_aggregation IT, obr_aers_element ET, obs_concept AS T1 WHERE IT.element_id=ET.id AND IT.concept_id=T1.id AND T1.local_concept_id='S' ORDER BY IT.score DESC LIMIT N,N | |
| Count: 66 Time=88.96s (5871s) Lock=0.00s (0s) Rows=8.1 (536), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT ET.local_element_id, T1.local_concept_id, IT.score FROM obr_rxrd_aggregation IT, obr_rxrd_element ET, obs_concept AS T1 WHERE IT.element_id=ET.id AND IT.concept_id=T1.id AND T1.local_concept_id='S' ORDER BY IT.score DESC LIMIT N,N | |
| Count: 56 Time=172.43s (9656s) Lock=0.00s (0s) Rows=0.9 (53), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT COUNT(*) FROM obr_ct_aggregation IT, obr_ct_element ET, obs_concept AS T1 WHERE IT.element_id=ET.id AND IT.concept_id=T1.id AND T1.local_concept_id='S' | |
| Count: 41 Time=107.47s (4406s) Lock=0.00s (0s) Rows=1.0 (41), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT COUNT(*) FROM obr_rxrd_aggregation IT, obr_rxrd_element ET, obs_concept AS T1 WHERE IT.element_id=ET.id AND IT.concept_id=T1.id AND T1.local_concept_id='S' | |
| Count: 40 Time=483.36s (19334s) Lock=0.00s (0s) Rows=1.0 (40), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT COUNT(*) FROM obr_aers_aggregation IT, obr_aers_element ET, obs_concept AS T1 WHERE IT.element_id=ET.id AND IT.concept_id=T1.id AND T1.local_concept_id IN ('S', 'S') AND ET.id IN (SELECT DISTINCT IT1.element_id FROM obr_aers_aggregation AS IT1, obs_concept AS CT1, obr_aers_aggregation AS IT2, obs_concept AS CT2 WHERE IT1.element_id=IT2.element_id AND IT1.concept_id=CT1.id AND CT1.local_concept_id='S' AND IT2.concept_id=CT2.id AND CT2.local_concept_id='S') | |
| Count: 35 Time=216.56s (7579s) Lock=0.00s (0s) Rows=1.0 (35), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT COUNT(*) FROM obr_ct_aggregation IT, obr_ct_element ET, obs_concept AS T1 WHERE IT.element_id=ET.id AND IT.concept_id=T1.id AND T1.local_concept_id IN ('S', 'S') AND ET.id IN (SELECT DISTINCT IT1.element_id FROM obr_ct_aggregation AS IT1, obs_concept AS CT1, obr_ct_aggregation AS IT2, obs_concept AS CT2 WHERE IT1.element_id=IT2.element_id AND IT1.concept_id=CT1.id AND CT1.local_concept_id='S' AND IT2.concept_id=CT2.id AND CT2.local_concept_id='S') | |
| Count: 31 Time=148.72s (4610s) Lock=0.00s (0s) Rows=1.0 (31), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT COUNT(*) FROM obr_rxrd_aggregation IT, obr_rxrd_element ET, obs_concept AS T1 WHERE IT.element_id=ET.id AND IT.concept_id=T1.id AND T1.local_concept_id IN ('S', 'S') AND ET.id IN (SELECT DISTINCT IT1.element_id FROM obr_rxrd_aggregation AS IT1, obs_concept AS CT1, obr_rxrd_aggregation AS IT2, obs_concept AS CT2 WHERE IT1.element_id=IT2.element_id AND IT1.concept_id=CT1.id AND CT1.local_concept_id='S' AND IT2.concept_id=CT2.id AND CT2.local_concept_id='S') | |
| Count: 28 Time=91.66s (2566s) Lock=0.00s (0s) Rows=1.0 (28), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT COUNT(*) FROM obr_ae_aggregation IT, obr_ae_element ET, obs_concept AS T1 WHERE IT.element_id=ET.id AND IT.concept_id=T1.id AND T1.local_concept_id='S' | |
| Count: 25 Time=32.21s (805s) Lock=0.00s (0s) Rows=0.0 (0), ncboadmin[ncboadmin]@bmir-3817483.Stanford.EDU | |
| SHOW INNODB STATUS | |
| Count: 23 Time=500.62s (11514s) Lock=0.00s (0s) Rows=1.0 (23), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT COUNT(*) FROM obr_rxrd_aggregation IT, obr_rxrd_element ET, obs_concept AS T1 WHERE IT.element_id=ET.id AND IT.concept_id=T1.id AND T1.local_concept_id IN ('S', 'S') | |
| Count: 23 Time=62.74s (1442s) Lock=0.00s (0s) Rows=1.0 (23), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT COUNT(*) FROM obr_geo_aggregation IT, obr_geo_element ET, obs_concept AS T1 WHERE IT.element_id=ET.id AND IT.concept_id=T1.id AND T1.local_concept_id='S' | |
| Count: 19 Time=36.10s (685s) Lock=0.00s (0s) Rows=1.0 (19), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT COUNT(*) FROM obr_geo_aggregation IT, obr_geo_element ET, obs_concept AS T1 WHERE IT.element_id=ET.id AND IT.concept_id=T1.id AND T1.local_concept_id IN ('S', 'S') AND ET.id IN (SELECT DISTINCT IT1.element_id FROM obr_geo_aggregation AS IT1, obs_concept AS CT1, obr_geo_aggregation AS IT2, obs_concept AS CT2 WHERE IT1.element_id=IT2.element_id AND IT1.concept_id=CT1.id AND CT1.local_concept_id='S' AND IT2.concept_id=CT2.id AND CT2.local_concept_id='S') | |
| Count: 19 Time=24.88s (472s) Lock=0.00s (0s) Rows=46.5 (884), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT CXT.name, CXT.weight, T2.local_concept_id as childLocalConceptID, EAT.parent_level, EAT.position_from, EAT.position_to FROM obr_ae_isa_annotation EAT, obr_ae_element ET, obs_concept AS T1, obs_concept AS T2, obr_context CXT WHERE EAT.element_id= ET.id AND EAT.concept_id= T1.id AND EAT.context_id= CXT.id AND EAT.child_concept_id= T2.id AND T1.local_concept_id='S' AND ET.local_element_id='S' | |
| Count: 19 Time=42.44s (806s) Lock=0.00s (0s) Rows=221.8 (4215), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT CXT.name, CXT.weight, T2.local_concept_id as childLocalConceptID, EAT.parent_level, EAT.position_from, EAT.position_to FROM obr_canano_isa_annotation EAT, obr_canano_element ET, obs_concept AS T1, obs_concept AS T2, obr_context CXT WHERE EAT.element_id= ET.id AND EAT.concept_id= T1.id AND EAT.context_id= CXT.id AND EAT.child_concept_id= T2.id AND T1.local_concept_id='S' AND ET.local_element_id='S' | |
| Count: 17 Time=39.52s (671s) Lock=0.00s (0s) Rows=1.0 (17), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT COUNT(*) FROM obr_ae_aggregation IT, obr_ae_element ET, obs_concept AS T1 WHERE IT.element_id=ET.id AND IT.concept_id=T1.id AND T1.local_concept_id IN ('S', 'S') AND ET.id IN (SELECT DISTINCT IT1.element_id FROM obr_ae_aggregation AS IT1, obs_concept AS CT1, obr_ae_aggregation AS IT2, obs_concept AS CT2 WHERE IT1.element_id=IT2.element_id AND IT1.concept_id=CT1.id AND CT1.local_concept_id='S' AND IT2.concept_id=CT2.id AND CT2.local_concept_id='S') | |
| Count: 16 Time=44.31s (708s) Lock=0.00s (0s) Rows=10.0 (160), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT ET.local_element_id, T1.local_concept_id, IT.score FROM obr_pcm_aggregation IT, obr_pcm_element ET, obs_concept AS T1 WHERE IT.element_id=ET.id AND IT.concept_id=T1.id AND T1.local_concept_id='S' ORDER BY IT.score DESC LIMIT N,N | |
| Count: 15 Time=21.54s (323s) Lock=0.31s (4s) Rows=16.0 (240), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT ET.local_element_id, T1.local_concept_id, IT.score FROM obr_geo_aggregation IT, obr_geo_element ET, obs_concept AS T1 WHERE IT.element_id=ET.id AND IT.concept_id=T1.id AND T1.local_concept_id='S' ORDER BY IT.score DESC LIMIT N,N | |
| Count: 15 Time=112.25s (1683s) Lock=0.00s (0s) Rows=8.5 (127), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT ET.local_element_id, T1.local_concept_id, IT.score FROM obr_cdd_aggregation IT, obr_cdd_element ET, obs_concept AS T1 WHERE IT.element_id=ET.id AND IT.concept_id=T1.id AND T1.local_concept_id='S' ORDER BY IT.score DESC LIMIT N,N | |
| Count: 15 Time=178.07s (2671s) Lock=0.00s (0s) Rows=1.0 (15), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT COUNT(*) FROM obr_cdd_aggregation IT, obr_cdd_element ET, obs_concept AS T1 WHERE IT.element_id=ET.id AND IT.concept_id=T1.id AND T1.local_concept_id='S' | |
| Count: 14 Time=25.00s (349s) Lock=0.00s (0s) Rows=92.9 (1301), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT ET.local_element_id, T1.local_concept_id, IT.score FROM obr_ae_aggregation IT, obr_ae_element ET, obs_concept AS T1 WHERE IT.element_id=ET.id AND IT.concept_id=T1.id AND ET.local_element_id='S' ORDER BY IT.score DESC LIMIT N,N | |
| Count: 13 Time=25.03s (325s) Lock=0.00s (0s) Rows=132.4 (1721), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT CXT.name, CXT.weight, T2.local_concept_id as mapped_local_concept_id, EAT.mapping_type, EAT.position_from, EAT.position_to FROM obr_ae_map_annotation EAT, obr_ae_element ET, obs_concept AS T1, obs_concept AS T2, obr_context CXT WHERE EAT.element_id= ET.id AND EAT.concept_id= T1.id AND EAT.context_id= CXT.id AND EAT.mapped_concept_id= T2.id AND T1.local_concept_id='S' AND ET.local_element_id='S' | |
| Count: 12 Time=31.09s (373s) Lock=0.00s (0s) Rows=1.0 (12), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT COUNT(*) FROM obr_smd_aggregation IT, obr_smd_element ET, obs_concept AS T1 WHERE IT.element_id=ET.id AND IT.concept_id=T1.id AND T1.local_concept_id IN ('S', 'S') AND ET.id IN (SELECT DISTINCT IT1.element_id FROM obr_smd_aggregation AS IT1, obs_concept AS CT1, obr_smd_aggregation AS IT2, obs_concept AS CT2 WHERE IT1.element_id=IT2.element_id AND IT1.concept_id=CT1.id AND CT1.local_concept_id='S' AND IT2.concept_id=CT2.id AND CT2.local_concept_id='S') | |
| Count: 12 Time=86.70s (1040s) Lock=0.00s (0s) Rows=1.0 (12), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT COUNT(*) FROM obr_smd_aggregation IT, obr_smd_element ET, obs_concept AS T1 WHERE IT.element_id=ET.id AND IT.concept_id=T1.id AND T1.local_concept_id='S' | |
| Count: 12 Time=30.16s (361s) Lock=0.00s (0s) Rows=10.0 (120), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT ET.local_element_id, T1.local_concept_id, IT.score FROM obr_ae_aggregation IT, obr_ae_element ET, obs_concept AS T1 WHERE IT.element_id=ET.id AND IT.concept_id=T1.id AND T1.local_concept_id='S' ORDER BY IT.score DESC LIMIT N,N | |
| Count: 11 Time=236.27s (2598s) Lock=0.00s (0s) Rows=10.0 (110), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT ET.local_element_id, SUM(IT.score) FROM obr_aers_aggregation IT, obr_aers_element ET, obs_concept AS T1 WHERE IT.element_id=ET.id AND IT.concept_id=T1.id AND T1.local_concept_id='S' GROUP BY IT.element_id ORDER BY IT.score DESC LIMIT N,N | |
| Count: 11 Time=72.64s (799s) Lock=0.00s (0s) Rows=10.0 (110), 2users@2hosts | |
| SELECT ET.local_element_id, SUM(IT.score) FROM obr_ct_aggregation IT, obr_ct_element ET, obs_concept AS T1 WHERE IT.element_id=ET.id AND IT.concept_id=T1.id AND T1.local_concept_id='S' GROUP BY IT.element_id ORDER BY IT.score DESC LIMIT N,N | |
| Count: 10 Time=24.83s (248s) Lock=0.00s (0s) Rows=52.3 (523), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT ET.local_element_id, T1.local_concept_id, IT.score FROM obr_rxrd_aggregation IT, obr_rxrd_element ET, obs_concept AS T1 WHERE IT.element_id=ET.id AND IT.concept_id=T1.id AND T1.local_concept_id IN ('S', 'S') ORDER BY IT.score DESC LIMIT N, N | |
| Count: 9 Time=29.87s (268s) Lock=0.00s (0s) Rows=7.8 (70), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT ET.local_element_id, T1.local_concept_id, IT.score FROM obr_bsm_aggregation IT, obr_bsm_element ET, obs_concept AS T1 WHERE IT.element_id=ET.id AND IT.concept_id=T1.id AND T1.local_concept_id='S' ORDER BY IT.score DESC LIMIT N,N | |
| Count: 9 Time=15.33s (137s) Lock=0.00s (0s) Rows=100.0 (900), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT ET.local_element_id, T1.local_concept_id, IT.score FROM obr_aers_aggregation IT, obr_aers_element ET, obs_concept AS T1 WHERE IT.element_id=ET.id AND IT.concept_id=T1.id AND ET.local_element_id='S' ORDER BY IT.score DESC LIMIT N,N | |
| Count: 9 Time=92.45s (832s) Lock=0.00s (0s) Rows=10.0 (90), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT ET.local_element_id, T1.local_concept_id, IT.score FROM obr_smd_aggregation IT, obr_smd_element ET, obs_concept AS T1 WHERE IT.element_id=ET.id AND IT.concept_id=T1.id AND T1.local_concept_id='S' ORDER BY IT.score DESC LIMIT N,N | |
| Count: 8 Time=28.30s (226s) Lock=0.00s (0s) Rows=16.8 (134), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT ET.local_element_id, T1.local_concept_id, IT.score FROM obr_ct_aggregation IT, obr_ct_element ET, obs_concept AS T1 WHERE IT.element_id=ET.id AND IT.concept_id=T1.id AND T1.local_concept_id IN ('S', 'S') ORDER BY IT.score DESC LIMIT N, N | |
| Count: 8 Time=180.60s (1444s) Lock=0.03s (0s) Rows=10.0 (80), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT ET.local_element_id, T1.local_concept_id as local_concept_id, CXT.name, T2.local_concept_id as mapped_local_concept_id, MAPT.mapping_type, EAT.position_from, EAT.position_to, IT.score FROM obr_aers_map_annotation EAT, obr_aers_element ET, obs_concept AS T1, obs_concept AS T2, obr_context CXT , obr_aers_aggregation IT, obs_mapping_type MAPT WHERE EAT.element_id= ET.id AND EAT.concept_id= T1.id AND EAT.context_id= CXT.id AND EAT.mapped_concept_id= T2.id AND EAT.element_id= IT.element_id AND EAT.concept_id=IT.concept_id AND EAT.mapping_type=MAPT.id AND T1.local_concept_id='S' ORDER BY IT.score DESC LIMIT N, N | |
| Count: 7 Time=27.94s (195s) Lock=0.00s (0s) Rows=197.6 (1383), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT CXT.name, CXT.weight, T2.local_concept_id as mapped_local_concept_id, MAPT.mapping_type, EAT.position_from, EAT.position_to FROM obr_ae_map_annotation EAT, obr_ae_element ET, obs_concept AS T1, obs_concept AS T2, obs_mapping_type MAPT, obr_context CXT WHERE EAT.element_id= ET.id AND EAT.concept_id= T1.id AND EAT.context_id= CXT.id AND EAT.mapped_concept_id= T2.id AND EAT.mapping_type=MAPT.id AND T1.local_concept_id='S' AND ET.local_element_id='S' | |
| Count: 7 Time=434.43s (3041s) Lock=0.02s (0s) Rows=10.0 (70), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT ET.local_element_id, T1.local_concept_id as local_concept_id, CXT.name, T2.local_concept_id as mapped_local_concept_id, MAPT.mapping_type, EAT.position_from, EAT.position_to, IT.score FROM obr_ct_map_annotation EAT, obr_ct_element ET, obs_concept AS T1, obs_concept AS T2, obr_context CXT , obr_ct_aggregation IT, obs_mapping_type MAPT WHERE EAT.element_id= ET.id AND EAT.concept_id= T1.id AND EAT.context_id= CXT.id AND EAT.mapped_concept_id= T2.id AND EAT.element_id= IT.element_id AND EAT.concept_id=IT.concept_id AND EAT.mapping_type=MAPT.id AND T1.local_concept_id='S' ORDER BY IT.score DESC LIMIT N, N | |
| Count: 7 Time=670.90s (4696s) Lock=0.00s (0s) Rows=1.0 (7), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT COUNT(*) FROM obr_aers_aggregation IT, obr_aers_element ET, obs_concept AS T1 WHERE IT.element_id=ET.id AND IT.concept_id=T1.id AND T1.local_concept_id IN ('S', 'S') | |
| Count: 7 Time=424.22s (2969s) Lock=0.03s (0s) Rows=10.0 (70), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT ET.local_element_id, T1.local_concept_id, CXT.name, DAT.term_id, TT.name, DAT.position_from, DAT.position_to, IT.score FROM obr_ct_annotation DAT, obr_ct_element ET, obs_concept AS T1, obs_term TT, obr_context CXT, obr_ct_aggregation IT WHERE DAT.element_id=ET.id AND DAT.concept_id=T1.id AND DAT.term_id=TT.id AND DAT.context_id= CXT.id AND DAT.element_id=IT.element_id AND DAT.concept_id=IT.concept_id AND TT.name REGEXP 'S' AND T1.local_concept_id IN ('S') ORDER BY score DESC LIMIT N, N | |
| Count: 7 Time=27.91s (195s) Lock=0.00s (0s) Rows=100.0 (700), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT ET.local_element_id, T1.local_concept_id, IT.score FROM obr_cdd_aggregation IT, obr_cdd_element ET, obs_concept AS T1 WHERE IT.element_id=ET.id AND IT.concept_id=T1.id AND ET.local_element_id='S' ORDER BY IT.score DESC LIMIT N,N | |
| Count: 7 Time=225.44s (1578s) Lock=0.02s (0s) Rows=34.3 (240), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT ET.local_element_id, T1.local_concept_id, CXT.name, DAT.term_id, TT.name, DAT.position_from, DAT.position_to, IT.score FROM obr_aers_annotation DAT, obr_aers_element ET, obs_concept AS T1, obs_term TT, obr_context CXT, obr_aers_aggregation IT WHERE DAT.element_id=ET.id AND DAT.concept_id=T1.id AND DAT.term_id=TT.id AND DAT.context_id= CXT.id AND DAT.element_id=IT.element_id AND DAT.concept_id=IT.concept_id AND TT.name REGEXP 'S' AND T1.local_concept_id IN ('S') ORDER BY score DESC LIMIT N, N | |
| Count: 6 Time=190.34s (1142s) Lock=2.77s (16s) Rows=55.0 (330), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT ET.local_element_id, T1.local_concept_id, CXT.name, DAT.term_id, TT.name, DAT.position_from, DAT.position_to, IT.score FROM obr_geo_annotation DAT, obr_geo_element ET, obs_concept AS T1, obs_term TT, obr_context CXT, obr_geo_aggregation IT WHERE DAT.element_id=ET.id AND DAT.concept_id=T1.id AND DAT.term_id=TT.id AND DAT.context_id= CXT.id AND DAT.element_id=IT.element_id AND DAT.concept_id=IT.concept_id AND TT.name REGEXP 'S' AND T1.local_concept_id IN ('S') ORDER BY score DESC LIMIT N, N | |
| Count: 6 Time=59.45s (356s) Lock=0.00s (0s) Rows=1.0 (6), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT COUNT(*) FROM obr_pcm_aggregation IT, obr_pcm_element ET, obs_concept AS T1 WHERE IT.element_id=ET.id AND IT.concept_id=T1.id AND T1.local_concept_id='S' | |
| Count: 6 Time=77.47s (464s) Lock=0.00s (0s) Rows=10.0 (60), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT ET.local_element_id, SUM(IT.score) FROM obr_ae_aggregation IT, obr_ae_element ET, obs_concept AS T1 WHERE IT.element_id=ET.id AND IT.concept_id=T1.id AND T1.local_concept_id='S' GROUP BY IT.element_id ORDER BY IT.score DESC LIMIT N,N | |
| Count: 6 Time=35.57s (213s) Lock=0.00s (0s) Rows=1.0 (6), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT COUNT(*) FROM obr_geo_aggregation IT, obr_geo_element ET, obs_concept AS T1 WHERE IT.element_id=ET.id AND IT.concept_id=T1.id AND T1.local_concept_id IN ('S', 'S', 'S') AND ET.id IN (SELECT DISTINCT IT1.element_id FROM obr_geo_aggregation AS IT1, obs_concept AS CT1, obr_geo_aggregation AS IT2, obs_concept AS CT2, obr_geo_aggregation AS IT3, obs_concept AS CT3 WHERE IT1.element_id=IT2.element_id AND IT2.element_id=IT3.element_id AND IT1.concept_id=CT1.id AND CT1.local_concept_id='S' AND IT2.concept_id=CT2.id AND CT2.local_concept_id='S' AND IT3.concept_id=CT3.id AND CT3.local_concept_id='S') | |
| Count: 6 Time=19.99s (119s) Lock=0.00s (0s) Rows=100.0 (600), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT ET.local_element_id, T1.local_concept_id, IT.score FROM obr_rxrd_aggregation IT, obr_rxrd_element ET, obs_concept AS T1 WHERE IT.element_id=ET.id AND IT.concept_id=T1.id AND ET.local_element_id='S' ORDER BY IT.score DESC LIMIT N,N | |
| Count: 5 Time=1283.31s (6416s) Lock=0.00s (0s) Rows=1.0 (5), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT COUNT(*) FROM obr_ct_aggregation IT, obr_ct_element ET, obs_concept AS T1 WHERE IT.element_id=ET.id AND IT.concept_id=T1.id AND T1.local_concept_id IN ('S', 'S') | |
| Count: 5 Time=63.00s (314s) Lock=0.00s (0s) Rows=242.2 (1211), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT CXT.name, CXT.weight, T2.local_concept_id as mapped_local_concept_id, EAT.mapping_type, EAT.position_from, EAT.position_to FROM obr_ct_map_annotation EAT, obr_ct_element ET, obs_concept AS T1, obs_concept AS T2, obr_context CXT WHERE EAT.element_id= ET.id AND EAT.concept_id= T1.id AND EAT.context_id= CXT.id AND EAT.mapped_concept_id= T2.id AND T1.local_concept_id='S' AND ET.local_element_id='S' | |
| Count: 5 Time=21.00s (104s) Lock=0.00s (0s) Rows=1.0 (5), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT COUNT(*) FROM obr_ae_aggregation IT, obr_ae_element ET, obs_concept AS T1 WHERE IT.element_id=ET.id AND IT.concept_id=T1.id AND T1.local_concept_id IN ('S', 'S', 'S') AND ET.id IN (SELECT DISTINCT IT1.element_id FROM obr_ae_aggregation AS IT1, obs_concept AS CT1, obr_ae_aggregation AS IT2, obs_concept AS CT2, obr_ae_aggregation AS IT3, obs_concept AS CT3 WHERE IT1.element_id=IT2.element_id AND IT2.element_id=IT3.element_id AND IT1.concept_id=CT1.id AND CT1.local_concept_id='S' AND IT2.concept_id=CT2.id AND CT2.local_concept_id='S' AND IT3.concept_id=CT3.id AND CT3.local_concept_id='S') | |
| Count: 5 Time=85.77s (428s) Lock=0.06s (0s) Rows=10.0 (50), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT ET.local_element_id, T1.local_concept_id, CXT.name, DAT.term_id, TT.name, DAT.position_from, DAT.position_to, IT.score FROM obr_rxrd_annotation DAT, obr_rxrd_element ET, obs_concept AS T1, obs_term TT, obr_context CXT, obr_rxrd_aggregation IT WHERE DAT.element_id=ET.id AND DAT.concept_id=T1.id AND DAT.term_id=TT.id AND DAT.context_id= CXT.id AND DAT.element_id=IT.element_id AND DAT.concept_id=IT.concept_id AND TT.name REGEXP 'S' AND T1.local_concept_id IN ('S') ORDER BY score DESC LIMIT N, N | |
| Count: 5 Time=104.86s (524s) Lock=0.00s (0s) Rows=10.0 (50), ri-api[ri-api]@ncbostage-obr1.Stanford.EDU | |
| SELECT ET.local_element_id, T1.local_concept_id as localConceptID, CXT.name, T2.local_concept_id as child_local_concept_id, EAT.parent_level, EAT.position_from, EAT.position_to, IT.score FROM obr_ct_isa_annotation EAT, obr_ct_element ET, obs_concept AS T1, obs_concept AS T2, obr_context CXT , obr_ct_aggregation IT WHERE EAT.element_id= ET.id AND EAT.concept_id= T1.id AND EAT.context_id= CXT.id AND EAT.child_concept_id= T2.id AND EAT.element_id= IT.element_id AND EAT.concept_id=IT.concept_id AND T1.local_concept_id ='S' AND EAT.parent_level<=N ORDER BY IT.score DESC LIMIT N, N |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment